Software to find a stocks price at a specified time?

Discussion in 'Automated Trading' started by StockBagger, Jan 14, 2009.

  1. 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.
  2. Something like this? Prices from yesterday Jan 14th
  3. to be more specific, I just wanted the close of lets says aapl at 940am, aapl at 10am, aapl at noon, 2pm, etc.
  4. Bob111


  5. mapuata


    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.