Stock Data Support in Excel: Difference between revisions
Jump to navigation
Jump to search
Line 16: | Line 16: | ||
Do not merge cells, it looks like the popup is not available anymore | Do not merge cells, it looks like the popup is not available anymore | ||
=Refresh All= | |||
Control + Option + F5 |
Latest revision as of 06:29, 20 February 2024
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