Stock Data Support in Excel: Difference between revisions
Jump to navigation
Jump to search
| (3 intermediate revisions 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: | ||
* Price: A1.Price | * Price: =A1.Price | ||
* P/E: A1.[P/E] | * 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 | |||
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