Stock Data Support in Excel: Difference between revisions
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
=Overview= | =Overview= | ||
To turn a cell into a "Stocks" data type: Enter a stock symbol in a cell → Data → 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" | ||
A popup will show up with: | |||
* Price: A1.Price | |||
* P/E: A1.[P/E] | |||
Revision as of 05:53, 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"
A popup will show up with:
- Price: A1.Price
- P/E: A1.[P/E]