Can I get the silver price too?

Yes. =cryptotrackproRWA("SILVER") returns the live tokenized silver price. Gold-and-silver ETFs like GLD, SLV and IAU are also available.

What about oil, copper and other commodities?

Direct tokenized commodities currently cover gold and silver. For broader commodity exposure you can price tokenized commodity ETFs such as USO (oil), COPX (copper miners) and DBC (commodity index) with the same formula.

Yes. The free plan includes 50 lookups per day, with no API key or credit card.

How to Get the Gold Price in Google Sheets (Live Gold & Silver)

Q: How do I get the gold price in Google Sheets?

Install the free CryptoTrackPro add-on and type =cryptotrackproRWA("GOLD") for the live tokenized gold price. =cryptotrackproRWA("SILVER") returns silver. No API key required.

Whether you track physical metals, a gold allocation, or gold as a hedge against your crypto, having the live price in your spreadsheet beats checking a separate site. CryptoTrackPro pulls the tokenized gold and silver price straight into Google Sheets.

The live gold price, in one formula

Install the free CryptoTrackPro add-on and type:

=cryptotrackproRWA("GOLD")

That's the live tokenized gold price (per ounce, USD). Silver is just as easy:

=cryptotrackproRWA("SILVER")

Precious-metal & commodity ETFs

Direct tokenized commodities currently cover gold and silver. For broader commodity exposure, price the major tokenized ETFs with the same formula:

=cryptotrackproRWA("GLD") — SPDR Gold Trust
=cryptotrackproRWA("SLV") — iShares Silver Trust
=cryptotrackproRWA("USO") — oil (US Oil Fund)
=cryptotrackproRWA("COPX") — copper miners
=cryptotrackproRWA("DBC") — broad commodity index

Value your holdings

Put your ounces in a cell and multiply:

=A2*cryptotrackproRWA("GOLD")

Add a row for silver, ETFs, even your crypto — one sheet, your whole portfolio. See the portfolio tracker guide.

Put the gold price in your sheet

50 lookups a day, no API key, no card.

Install CryptoTrackPro free

Frequently asked questions

How do I get the gold price in Google Sheets?

Install CryptoTrackPro and type =cryptotrackproRWA("GOLD"). No API key needed.

What about oil and copper?

Direct tokenized commodities are gold and silver today; for oil, copper and others, price commodity ETFs like USO, COPX and DBC.

Is it free?

Yes — 50 lookups a day on the free plan. Base and Pro add more.

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

See also: ETF prices in Google Sheets →

How to get the gold price in Google Sheets