Stock Data Support in Excel

External

• https://support.microsoft.com/en-us/office/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

Internal

• Microsoft Excel

Overview

To turn a cell into a "Stocks" data type: Enter a stock symbol in a cell → Data → Stocks. If a corresponding stock is found, the data type will transition to "Stocks".

If it does not find the ETF symbol, try the official ETF name ("Fidelity MSCI Communication Services Index ETF").

A popup will show up with:

• Price: =A1.Price
• P/E: =A1.[P/E]

Conventionally, color them in Plum, Accent 5.

Do not merge cells, it looks like the popup is not available anymore

Refresh All

Control + Option + F5