Can I get the gold price in Google Sheets?

Yes. =cryptotrackproRWA("GOLD") returns the live tokenized gold price. Silver, oil and other commodities work the same way.

Yes. The free plan includes 50 lookups per day across crypto and real-world assets, with no API key or credit card.

Live Stock, Commodity & Real-World Asset Prices in Google Sheets

Q: How do I get stock prices in Google Sheets?

Install the free CryptoTrackPro add-on and type =cryptotrackproRWA("AAPL") in any cell to get Apple's live tokenized price. Change the ticker for Nvidia (NVDA), Tesla (TSLA), Gold (GOLD) and 7,900+ tokenized real-world assets. No API key required.

Q: What are tokenized real-world assets?

Real-world assets (RWAs) are stocks, commodities, ETFs and other traditional assets issued as on-chain tokens. Their tokenized price tracks the underlying asset (e.g. tokenized AAPL tracks Apple stock) and trades 24/7. CryptoTrackPro returns the aggregate tokenized price.

Google Sheets has GOOGLEFINANCE for a handful of major stocks, but it's limited and doesn't touch crypto. CryptoTrackPro now pulls live prices for tokenized real-world assets — stocks, commodities and ETFs issued as on-chain tokens — so you can track Apple, Gold and Bitcoin in one place, with one add-on.

The one-formula method

Install the free CryptoTrackPro add-on and type:

=cryptotrackproRWA("AAPL")

That's Apple's live tokenized price. Swap the ticker for any of 7,900+ assets:

=cryptotrackproRWA("NVDA") — Nvidia
=cryptotrackproRWA("TSLA") — Tesla
=cryptotrackproRWA("GOLD") — Gold
=cryptotrackproRWA("SILVER") — Silver

Want market cap or volume instead of price? Add a second argument:

=cryptotrackproRWA("NVDA", "marketcap")

What are tokenized real-world assets?

Real-world assets (RWAs) are traditional assets — company shares, commodities, ETFs, treasuries — issued as tokens on a blockchain. A tokenized share of Apple tracks the real Apple stock price, but trades on-chain around the clock. CryptoTrackPro returns the aggregate tokenized price across issuers, so =cryptotrackproRWA("AAPL") closely follows Apple's market price. (These are tokenized prices, not an official exchange quote — they can differ slightly, especially outside market hours.)

Build a mixed stock + crypto portfolio

This is the real power: one sheet, both worlds. Put your holdings in a column and price each row — crypto with =cryptotrackpro(), stocks and commodities with =cryptotrackproRWA(), multiply by quantity, and total it. A single dashboard for your entire net worth — see the portfolio tracker guide for the full setup.

Track stocks & crypto together

Free plan, 50 lookups a day. No API key, no card.

Install CryptoTrackPro free

Frequently asked questions

How do I get stock prices in Google Sheets?

Install CryptoTrackPro and type =cryptotrackproRWA("AAPL"). Change the ticker for any of 7,900+ tokenized stocks, commodities and ETFs.

Can I get the gold price?

Yes — =cryptotrackproRWA("GOLD"). Silver and other commodities work too.

Is it free?

Yes — 50 lookups a day on the free plan, shared across crypto and real-world assets. Base and Pro raise or remove the limit.

Disclaimer: CryptoTrackPro returns tokenized real-world-asset prices — the aggregate price of on-chain tokens that track an underlying stock, commodity or ETF. These closely follow the underlying asset but are not official exchange quotes and can differ, especially outside regular market hours or for low-liquidity tokens. Not financial advice.

Live stock & commodity prices in Google Sheets