Forum Discussion
#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 ...
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.