I am looking for an excel add-on preferably. Or a stand alone product. Ideally, I want to find a stocks price at 10am, 1030am, 1115 am, etc, etc. Its a little tedious to do this with 50 stocks a day manually. If you know of anything that can do this it would be greatly appreciated.
to be more specific, I just wanted the close of lets says aapl at 940am, aapl at 10am, aapl at noon, 2pm, etc.
http://www.gummy-stuff.org/Yahoo-data.htm all you need is a timer in excel vba something like this- http://en.allexperts.com/q/Excel-1059/Countdown-timer.htm
Hi there, I have a similar problem as I am currently downloading real-time Bloomberg data and I would like to compare the current price with a historical one, i.e as Stockbagger stated where the price was for example 2 minutes ago. I have had a look at the link, but to be honest would not know how to implement it for my own requirements... Not sure if it is asking for too much but could anybody explain to me how I could solve this problem using an example (for example if the price is fed into Cell D7 or so). Either way, many thanks.