DEV Community🇺🇸
Google Sheets market data template: a watchlist you can copy
FX MarketCryptocurrencies
Keeping a short market watchlist should not start with writing an API client. If you want stock, crypto, forex and commodity prices in the same spreadsheet, our Google Sheets template gives you a starting point you can copy and change. Choose a market, type a supported symbol and select SiftingIO → Refresh prices . The sheet fills in the latest available price, its source timestamp and a status for each row. You can track up to 20 symbols in one copy. Copy the Google Sheets market watchlist You will need a Google account and your own SiftingIO API key. The template includes the script, so there is no code to paste or add-on to install. API access and usage follow your SiftingIO plan. What you can put in the watchlist The Market column has four choices: Crypto, Forex, Commodities and US stocks . The Symbol column is editable text. BTCUSD, EURUSD and XAUUSD are starting examples; replace them or add your own supported symbols in the yellow cells. For example, you could follow: Crypto: ETHUSD or BTCEUR.
United States
.webp)
.webp)
