Forum Discussion

24 Replies

Sort By
  • Herman_DB_waregem's avatar
    Herman_DB_waregem
    Copper Contributor
    Jan 26, 2025

    i'm looking for the ticker codes to be used for market indeces in the Stockhistory function.

    i use the ones but the results are not consistent

    .IXIC    Nasdaq composite
    .INX    S&P 500
    SX5E   Euro Stoxx 50

    who can help me

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Jan 27, 2025

      In general they work

      The only after Jan 3 there is no for Nasdaq, have no idea why.

      • Herman_DB_waregem's avatar
        Herman_DB_waregem
        Copper Contributor
        Jan 28, 2025

        Thanks


        1. below i made a comparison of the Stock data type result (Price) and Stockhistory function

         

        (STOCKHISTORY($P21,M$4,,2,0,1))
        As you can see (Red cells) for Nasdaq and S&P 500 the results are not trustable 

        2. is there a list or overview of market indices you can use in the stock data ? eg i'm still looking for 

        FTSE 100 (^FTSE) but i do not found this.

        thanks

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 12, 2022

    Hi Eric9919 

     

    If this can help & assuming you run a Windows version of Excel. Attached is a Power Query based "solution" that downloads history from Yahoo Finance. Put this together a year a ago for this thread (the OP was smart enough not to provide any feedback...) and enhanced it in the meantime

     

    Just checked ==> still work 🙂

    • Eric9919's avatar
      Eric9919
      Copper Contributor
      Jul 13, 2022
      Thanks. It is working for Stock Tickers, but I am actually looking for market indices.
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jul 13, 2022

        Eric9919 

        Re. It is working for Stock Tickers, but I am actually looking for market indices

        Not sure I understand but this might be due to my ignorance in investment terms

         

        Below is what STOCKHISTORY's function downloads for the NASDAQ Composite Index + on the right  what the query downloads from Yahoo finance for symbol ^IXIC. (symbol from page World Indices). With the exception of the [Volume]* not sure I see where the difference is:

         

         

        * Checked a couple other websites but they don't provide volume information

        ==> No idea which of the above ones is right

         

        Attached file contains a few index/indices, inc. HKSE (Hang Seng Index) but this might not be what you expect...

         

         

         

    • Eric9919's avatar
      Eric9919
      Copper Contributor
      Jul 13, 2022
      Thanks. I was able to find below 3 indices using Stock Data Type search, but only NASDAQ. worked. And I can't find Hong Kong Stock Exchange (Hang Seng Index). Any idea?

      S&P 500 INDEX
      NASDAQ Composite Index
      DOW JONES INDU AVERAGE NDX

      Thanks,

Resources