I've got a problem. I run my criteria screens every night and put the results into an excel spreadsheet by hand. When I go on vacation or out of town for work, the only way I can reconstruct the past is to change each of my criteria formulae to back up in time.For example, as simple test is:C > C1This tests to see if today's closing price is greater than yesterday's closing price. So, if I went out of town for five days, I'd have to run the criteria for these cases:C5 > C6C4 > C5C3 > C4C2 > C3C1 > C2C > C1Obviously, it wouldn't be too bad if this was the only formula I have to change, but I have to change at least 5 formulae. PLUS, doing this is prone to error. SO,if Worden had the ability to set TODAY to Today - 5, etc. It would simplify the whole process immensely. Does anyone know if there is some capability I've missed that allows one to do this ?
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar