Forum Discussion

rollo1002's avatar
rollo1002
Copper Contributor
Jun 28, 2025

StockHistory Formula not working

Starting around the beginning of this year the StockHistory Formula is not pulling information for both DJI and Nasdaq .IXIC. The formula still works for S&P 500. 

 

 

excel

1 Reply

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Jun 30, 2025

    How about trying to use alternative tickers:

    For S&P 500, .INX still works. For NASDAQ, try ^IXIC or NASDAQ Composite Index in the Data Types search — results vary by region and Excel version.