Stock Data Support in Excel: Difference between revisions
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 5: | Line 5: | ||
=Overview= | =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" | 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: | A popup will show up with: | ||
Line 12: | Line 14: | ||
Conventionally, color them in Plum, Accent 5. | 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 |
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