=Close_Historical() not working for S&P

Discussion in 'General Questions' started by Matt, Nov 21, 2017.

=Close_Historical() not working for S&P

  1. Matt

    Matt New Member

    Joined:
    Jul 7, 2017
    Messages:
    9
    Likes Received:
    0
    =Close_historical() is returning NA with inputs of ^GSPC and 10/3/17. I believe this has worked in past iterations of my spreadsheet.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    Hi Matt,

    i am checking on it.

    Kind regards
    Ankur
     
  3. ankurwuzzzzzzzzzup

    ankurwuzzzzzzzzzup New Member

    Joined:
    Jun 11, 2017
    Messages:
    8
    Likes Received:
    4
    Rather than start a new thread, I had a close_historical question also. I'm having no trouble getting 2017 historicals.. But I get no data or very broken data for 2015. Is it reasonable for us to expect to get 2015 data or has Yahoo deleted it?
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    894
    Likes Received:
    8
    We are working to buy new historical data for indices. I am working on this, we will get this working early next week. Sorry for the inconvenience.
     

Share This Page