The “Fixing the Stock Quote Data Connection” issue in Excel 2013 typically stems from Microsoft deprecating the legacy MSN MoneyCentral Investor web query (.iqy) files, or old Yahoo Finance APIs shutting down. Because Excel 2013 lacks the modern, native “Stocks” data type button found in Microsoft 365, users must rely on alternative data connections, add-ins, or web-scraping to pull real-time prices.
The options below outline how the connection breaks and the best methods to fix or replace it. Why the Excel 2013 Stock Connection Fails
Missing IQY Files: Older versions of Excel relied on built-in MSN MoneyCentral scripts. When upgrading or reinstalling Excel 2013, these underlying .iqy connection files often go missing.
API Discontinuations: Many legacy add-ins used back-end servers (like Yahoo Finance) that have permanently altered or terminated their free data streams.
Incompatible Functions: Functions like =STOCKHISTORY or direct data-type conversions are restricted to newer cloud versions of Office and will throw errors in Excel 2013. Solution 1: Use the WEBSERVICE Function (Easiest Fix)
Excel 2013 introduced the =WEBSERVICE function, which allows you to pull data directly from public, free financial APIs without an external connection manager. Place your stock ticker (e.g., AAPL) in cell A1.
In an adjacent cell, enter a formula pulling from a free API (such as IEX Cloud or another open provider):=WEBSERVICE(”https://api.iextrading.com/1.0/stock/” & A1 & “/quote/latestPrice”) Press Ctrl + Alt + F9 to force-refresh the data. Solution 2: Replace with the “Stock Connector” Add-In
If your old data connection completely stopped responding, replacing it with a modern task pane add-in is the most stable workaround.
Leave a Reply