Share via

Stock data link not working

Hans Beier 0 Reputation points
2026-05-16T14:52:06.88+00:00

My PC appears to have been infiltrated by someone that deleted everything since Dec 2023. You are invited to conduct research, however, after reinstalling Microsoft 365, I cannot get my Excel to use the Data-stock import function to download historical ticker pricing and volume data. Can you please help me set this back up? I have followed online instructions, but with no success, but also did not see "data types" after going into to File Options.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-16T14:52:19.56+00:00

    To use Excel’s Stocks data type and pull stock prices or historical data after reinstalling Microsoft 365, the environment must meet the linked data type requirements and the feature must be used in the supported way.

    1. Confirm requirements for Stocks data type Make sure all of the following are true:
      1. An active Microsoft 365 subscription or a free Microsoft account is signed in.
      2. Excel is up to date and using the current Excel app or Excel for the web.
      3. One of these editing languages is added in Office Language Preferences: English, French, German, Italian, Spanish, or Portuguese.
      These are required specifically for the Stocks and Geography data types.
    2. Check that Stocks data type is available In Excel:
      1. Type a ticker symbol or company name (for example, MSFT or Microsoft) in a cell.
      2. Select the cell.
      3. Go to the Data tab on the ribbon and look for the Stocks button in the Data Types group.
      4. Click Stocks.
      If Excel finds a match, the cell converts to a Stocks data type and shows a small stock icon. If instead a generic error icon appears, correct any spelling or use the selector pane to pick the correct security.
    3. Use the Insert Data button to pull fields Once the cell is converted to the Stocks data type:
      1. Select the converted cell.
      2. Click the Insert Data button that appears next to it.
      3. Choose fields such as Price, Change, etc. Excel inserts those values into adjacent columns.
      To see all fields available for that company or fund, click the stock icon in the cell or select the cell and press Ctrl+Shift+F5.
    4. Get historical prices with STOCKHISTORY For historical pricing and volume, use the STOCKHISTORY function, which works with the same finance data source as the Stocks data type:
      • Insert a formula like: 
             =STOCKHISTORY("MSFT", "2024-01-01", "2024-01-31")
      • This returns historical data for the specified date range.
      STOCKHISTORY is documented in the same set of features as Stocks data types and uses the same provider.
    5. Refreshing and reliability
      • To refresh linked stock data, right‑click a cell with the Stocks data type and choose Data Type > Refresh.
      • Stock information is delayed, provided “as‑is”, and not for trading or advice.

    If the Stocks button does not appear on the Data tab, or data types do not convert even after confirming subscription, sign‑in, language, and updates, the installation may not be meeting the linked data type requirements and would need to be aligned with those prerequisites first.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.