Stock Data Support in Excel

From NovaOrdis Knowledge Base
Revision as of 06:29, 20 February 2024 by Ovidiu (talk | contribs) (→‎Overview)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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