Stock Data Support in Excel: Difference between revisions
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
* Price: =A1.Price | * Price: =A1.Price | ||
* P/E: =A1.[P/E] | * P/E: =A1.[P/E] | ||
Conventionally, color them in Plum, Accent 5. |
Revision as of 05:59, 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]
Conventionally, color them in Plum, Accent 5.