Forum Discussion

MarlboroNoir's avatar
MarlboroNoir
Copper Contributor
Feb 26, 2026

#Connect Error in Excel for StockHistory Function

Evening, 

I am an O365 subscriber and am trying to set up an Excel sheet as a VAR template, and I wanted to populate my workbook with some historical data without uploading a CSV. Figured I would try out the StockHistory function. 

I keep getting "#connect" for my cells, and I am not sure why. 

I am not in developer mode, do not have any crazy add-ins, I am signed in, and connected to the internet. Do I need to be connected to a source? I am fairly new to learning about the StockHistory Function.

 

Any thoughts on the matter are welcome.

 

I tried all that I could from this site below:

https://support.microsoft.com/en-us/office/how-to-correct-a-connect-error-584f7de9-b238-480c-8e8f-de0ba2c1aac9

community
excel
Formulas and Functions
office 365

1 Reply

  • Olufemi7's avatar
    Olufemi7
    Iron Contributor
    Feb 28, 2026

    Hello MarlboroNoir​,

    The #CONNECT error in STOCKHISTORY occurs when Excel cannot retrieve data from the stock data service. Common causes are incorrect ticker symbols or missing exchange codes, invalid start or end dates, using a version of Excel that does not support STOCKHISTORY (only Microsoft 365 Excel supports it), regional or temporary service limitations, or network/firewall issues blocking the connection. Test with a known ticker like =STOCKHISTORY("MSFT", TODAY()-30, TODAY()) to confirm. If this works, the issue is with your original ticker, dates, or network.