How do I get Index Historical Pricing?

Discussion in 'General Questions' started by Al B, Jul 10, 2020.

How do I get Index Historical Pricing?

  1. Al B

    Al B New Member

    Joined:
    Jul 10, 2020
    Messages:
    1
    Likes Received:
    0
    As the Title of my thread says, How do I get Historical Pricing on Indexes?

    I did a search and a couple others have posted similar questions, but when I do as it says I get "NA"

    Here is what I have tried: If, for example I put into C2 =Close_Historical(B2,A2) I will get the correct close, but If I put in C3 =Close_Historical(B3,A3) the Result is NA. What am I doing wrong please?
    A B C
    1 Date Symbol Close
    2 07/09/2020 AMZN 3182.63
    3 07/09/2020 ^SPX NA

    Thanks
    Alan
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Hi Alan,

    This function at the moment does not support Indices. We are working on it.

    Kind Regards
    Ankur for MarketXLS
     

Share This Page