Close_Historical Function

Discussion in 'General Questions' started by Matt, Jul 7, 2017.

Close_Historical Function

  1. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    I am using an function to download closing historical prices over a list of certain dates. The function works well except for on the previous date. In this row it only displays NA. Is there a time of day that the price moves into the data base for the Close_Historical function to work? Subsequently, if I try to use PreviousClose, it is giving me the price from 2 days ago. I am attempting this at 04:30 ET.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Matt,

    I noticed this issue yesterday. It will be fixed today shortly.
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    This should now be fixed.
     
  4. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    I am having this problem also. I cannot get Closing Historical prices for today()-1. I can get it for today()-4, for example
     
  5. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    I am checking it.
     
  6. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    With the exception of VZ, all of the tickers I am trying are currently giving me yesterday's close using Closing_Historical Today()-1. Why would VZ not work?
     
    marketxls likes this.
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Perfect. Yes. We made the fix this evening and all should be fine now. I am checking on VZ.
     
  8. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Again this morning Closing_Historical Today()-1 is working for all my tickers except VZ.
     
    marketxls likes this.
  9. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi I could not get to VZ yet, but I will check shortly.
     
  10. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    I am now having issues with this again on many of my tickers.
     
  11. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Hi Matt,

    Please can you describe which ones? Whats the issue?
     
  12. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    Close Historical is not working for the previous day. Referencing the ticker, and yesterdays date.
     
  13. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Closing_Historical Today()-1 is not working for me this morning for the following tickers: COP, DE, RTN, VZ

    All my other tickers are working
     
  14. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    Currently closehistorical for 7/13/17 for all DJIA tickers are not working.
     
  15. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    Attached is a screenshot of the result I am getting.
    The second is a screenshot of the formulas.

    This formula works on most other dates except the 12th and 13th. It is all 30 DJIA components that display NA for these dates.

    upload_2017-7-16_17-24-30.png
    upload_2017-7-16_17-26-10.png
     
  16. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Closing_Historical Today()-1 is still not working as of today's open for certain tickers. When will the problem be resolved?
     
  17. marketxls

    marketxls Administrator
    Staff Member

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

    I am still working on it. Thanks for your patience. It should fixed shortly.

    Kind Regards
    Ankur
     
  18. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,119
    Likes Received:
    10
    Please can you both clear your caching by going to settings/help menu >> Settings>> Clear Cache

    and try again?
     
  19. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    The quotes seem to be working tonight. Even before I cleared my cache. Is this a data problem?
     
  20. LynxPtnr

    LynxPtnr Member

    Joined:
    Jul 5, 2017
    Messages:
    38
    Likes Received:
    4
    Things appear to be working for me this morning. Thanks for fixing it. When I cleared the cache, I got a pop-up saying "cache has been disabled for this session." Is it supposed to say that?
     

Share This Page