Market data in Google Sheets: update forex, gold and crypto prices with Apps Script
A copyable Apps Script recipe that pulls EURUSD, XAUUSD and BTCUSD into Google Sheets, with value time, fetch time and a per-row status. Manual run, then a trigger.
Tag · xauusd
xauusd
8 posts on xauusd from the SiftingIO market data blog, spanning real-time and historical coverage across stocks, forex, crypto, commodities, and on-chain venues.
Posts tagged xauusd
Base currency and quote currency in FX and commodity data: inverse rates, bid and ask, symbols
How base currency and quote currency work in FX and commodity data: direction of a move, inverting bid and ask, EURUSD and XAUUSD symbols, cross rates.
How accurate is real-time market data? A live spread snapshot across crypto, FX, and gold
Consolidated bid/ask spreads measured live on BTCUSD, EURUSD, XAUUSD and more: why one price is really a band, and how to reproduce the numbers yourself.
Commodities data API: coverage, fields, and symbol names for gold, silver, oil, and metals
SiftingIO's commodities data API: real symbols (XAUUSD, XAGUSD, WTIUSD, XCUUSD, NATGAS), OHLCV history, live REST quotes, and WebSocket streaming.
XAUUSD explained: gold price per gram, karat, and local currency math with a market data API
What XAUUSD means, the exact troy ounce to gram conversion, 24k/22k/18k karat math, and lira pricing via USDTRY, computed from real SiftingIO market data.
Streaming gold, silver, and oil prices: a WebSocket commodities price API
Stream live gold, silver, and oil prices over one WebSocket connection instead of polling REST. Subscribe protocol, tick format, and a reconnect-safe client.
Commodities market data API: backfill historical bars, then stream live prices
Pull historical OHLCV bars for gold, crude, and other commodities over REST, stream live prices over WebSocket, and handle the seam where they meet.
How to Get Gold and Oil Spot Prices via API
Gold and oil spot prices from one API call. How SiftingIO symbols commodities (XAUUSD, WTIUSD), how to read a last trade or quote, and how the published price is aggregated across venues.