Specific Time Closing Price

Discussion in 'Historical Data' started by Derrek Hennessy, May 7, 2018.

Specific Time Closing Price

  1. Derrek Hennessy

    Derrek Hennessy New Member

    Joined:
    Mar 6, 2018
    Messages:
    1
    Likes Received:
    0
    How do you pull the stock closing price for a specific day and time. You mentioned in an email to me a few months ago that this would be available very very soon. Example of what I want to do is below.

    Pull the closing price of AAPL for May 1st, 2018 at 9:40AM EST.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,090
    Likes Received:
    10
    Hi Derrek,

    The new data set from Quotemedia with minute updates took way longer than I expected. Sorry for the delay on this. We are still waiting for us to be moved to a production environment form a UAT.

    One way to get this at the moment is by using the "Daily Minute Data" button on the menu. So, essentially you can type a symbol in the cell click the "Daily Minute Data" button and download the minute data. I am afraid at the moment its not possible with a function. But we have this in our list and we think it will be useful. We will try and sort this out at the earliest.

    Kind regards
    Ankur for MarketXLS
     

Share This Page