Volume_historical (symbol,date)

Discussion in 'Historical Data' started by Carl, Aug 5, 2017.

Volume_historical (symbol,date)

  1. Carl

    Carl New Member

    Joined:
    Aug 5, 2017
    Messages:
    5
    Likes Received:
    0
    While trying to use this function, it displays the volume number briefly and then displays NA in the target cell. When I use volume(symbol) it works fine. What am I doing wrong?
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    Hi Carl

    Try like this...

    =Volume_Historical("MSFT",Today()-1)

    Or give the date in "YYYY-MM-DD" format as a string with double quotes.

    Kind Regards
    Ankur
     
  3. Carl

    Carl New Member

    Joined:
    Aug 5, 2017
    Messages:
    5
    Likes Received:
    0
    Ankur,

    I tried both methods and neither worked. Any more suggestions?

    Carl
     
  4. Carl

    Carl New Member

    Joined:
    Aug 5, 2017
    Messages:
    5
    Likes Received:
    0
    Ankur,

    If this helps, the cell displays 0 (zero) berfore it goes to NA.

    Carl

    PS: I also uploaded the worksheet that shows this issue.
     

    Attached Files:

    #4 Carl, Aug 5, 2017
    Last edited: Aug 5, 2017
  5. mholstius

    mholstius New Member

    Joined:
    Aug 24, 2016
    Messages:
    1
    Likes Received:
    0
    I'm having the same problem with Volume_Historical.
    All the price functions work fine (OHLC), but Volume_Historical gives NA.
    Mark
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    616
    Likes Received:
    5
    Hi Carl,

    Yes, this will be fixed in coming release on around 15th of August.

    Kind regards
    Ankur
     
    Carl likes this.

Share This Page