Excel 2007 Power Programming by Walkenback & Mr.Excel forums...all you ever need. The help you get there is amazing. Stuff I would pay for is literally free.
My universe is currently 1000 names, and all that is DDE links and VBA scripts, then sent direct to the platform. If you have a near top of the line computer like I do, it can handle that many with out a problem. I am not sure about 1400, as I havent tried. I have a AMD Phemon 6 core 1090 with 8 gigs. So I suppose if you have a better computer it should be able to handle your whole universe with out any problems.
My universe is currently 1000 names, and all that is DDE links and VBA scripts, then sent direct to the platform. If you have a near top of the line computer like I do, it can handle that many with out a problem. I am not sure about 1400, as I havent tried. I have a AMD Phemon 6 core 1090 with 8 gigs. So I suppose if you have a better computer it should be able to handle your whole universe with out any problems.
My "edge" did not materialize with them and by holding them outside the strat rules, I would be putting myself in "no man's land".
Most of what I have learned has been on my own, by observing price changes on daily charts. I didnât even know what swing trading or rtm trading was in my early years of trading. I think âbuying the dipsâ best describes what I do. I would suggest to someone in order to get a feel for this type of setup is to identify days when a stock price rose significantly and then look at what the price was doing the few days before that, and seeing if any patterns emerge. Do this for a stock over a 10 year period, and then do this for 9999 more stocks, and it will become ingrained in your subconscious as to what a good setup looks like. Come up with indicators, optimizing various parameters through back testing, which will alert you to these setups. And then automate the strategy.