Hi Swingtarder,
I have collected Bhavcopy/closing prices since March 1 2004 in Excel, and now update the daily closing. I am sure you are aware of the problems of doing this daily since scrips get dropped, added on, names change etc. To overcome this I have worked with a friend and written Macros that reconciles the names of scrips via VLOOKUP and so I have an error free copy. At the same time within the same file another page calculates 20, 50, 200 DMA, highlighting the scrips crossing these averages. For easy reference, the preceding 6 day prices are posted against the scrips and their moving averages so one can readily see whether the averages are being crossed from above or below. Another page in the same file calculates the Pivots for all the scrips. I'm quite pleased with the file!! I'm certain you'll figure out the commands.
Hey, but yours seems really cool that auto downloads and updates. Would you explain how buddy? And perhaps send the program?
Thanks.