How to get ETF prices in Google Sheets

Tracking ETFs in a spreadsheet usually means GOOGLEFINANCE, which only covers some funds and nothing crypto. CryptoTrackPro pulls live prices for dozens of major tokenized ETFs — index funds, bond funds, commodity funds, even Bitcoin ETFs — with one formula, and puts them next to your crypto.

The one-formula method

Install the free CryptoTrackPro add-on and type:

=cryptotrackproRWA("SPY")

That's the live SPDR S&P 500 ETF price. Swap the ticker for any supported fund:

• Broad market: SPY, IVV, VTI, QQQ, IWM
• Bonds: TLT, AGG, HYG, SGOV
• Commodities: GLD, SLV, USO, IAU, DBC
• Sectors & more: COPX (copper), EEM (emerging mkts), EFA (intl)

Build a live ETF portfolio

Put your tickers in column A, shares in column B, then price each row:

=cryptotrackproRWA(A2)

Multiply by shares for value, sum for your total. Because these ETFs are tokenized, prices update on weekends too — see the portfolio tracker guide for the full build.

Don't know the ticker? Search by name

In the CryptoTrackPro sidebar, type a fund's name in the search box and it finds the ticker — then inserts the formula for you.

Frequently asked questions

Can I get the SPY price in Google Sheets?

Yes — =cryptotrackproRWA("SPY"). QQQ, VTI, IVV and dozens more work the same way.

Want crypto exposure too?

For crypto, skip the ETF wrapper and price coins directly: =cryptotrackpro("BTC-USD"). See the crypto prices guide.

Is it free?

Yes — 50 lookups a day on the free plan, shared across ETFs, stocks and crypto.

See also: all real-world assets in Google Sheets →