Level 3Pulling Data InPractice, 3 min
GOOGLEFINANCE: value a portfolio (simulated)
The task
In C2, work out what each holding is worth today: shares times the current price from
GOOGLEFINANCE(ticker, "price"), for every row with one MAP. Prices in this practice sheet are simulated, not live market data.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Ticker | Shares | Value |
| 2 | NASDAQ:GOOG | 40 | |
| 3 | NASDAQ:AAPL | 25 | |
| 4 | NYSE:KO | 120 | |
| 5 | NASDAQ:COST | 6 |