Custom Dates High or Custom Dates Low Function

Discussion in 'Historical Data' started by Jason, Jun 11, 2020.

Custom Dates High or Custom Dates Low Function

  1. Jason

    Jason New Member

    Joined:
    Aug 17, 2017
    Messages:
    3
    Likes Received:
    1
    I've been trying to use the =custom_dates_high() or =custom_dates_low() function. However, the stock seems to return only the closing price for that day instead of high or low of the day. Perhaps I am missing the datafield but couldn't find any information on what needs to be filled in there. Anyone else using this functionality successfully?

    upload_2020-6-11_9-23-6.png
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,153
    Likes Received:
    11
    If you just want the High and low on a specific day in history, I think you want to be using these functions.

    High_Historical and Low_Historical, as shown below.

    =Close_Historical(C2,TODAY()-20)
    =High_Historical(C2,TODAY()-20)
    =Low_Historical(C2,TODAY()-20)

    The date can also be put in as "YYYY-MM-DD"

    Kind Regards
    Ankur for MarketXLS
     
    Jason likes this.
  3. Jason

    Jason New Member

    Joined:
    Aug 17, 2017
    Messages:
    3
    Likes Received:
    1
    Thank you Ankur. Helpful as always!
     

Share This Page