Forum Discussion

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
Diamond Contributor
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

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

    thnaks,
    indeed strange that Nasdaq does not work any longer in 2025

    Where do you find the 'symbol' you used on your line 2 ?
    (is this with the Stock symbols ?)

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 28, 2025

      In B3 is just =B2.[Ticker symbol]

      Steps are: write "Nasdaq" or some into the cell, click on Stock, select proper data

      If not available, try variants. In another cell generate STOCKHISTORY with the reference on the cell with stock data.