Stock Data Support in Excel
Jump to navigation
Jump to search
External
Internal
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