Stock Data Support in Excel: Difference between revisions
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
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] |
Revision as of 05:58, 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]