Historical forex data in CSV and Excel: a practical guide
Download historical forex data as CSV or Excel. Start with EURUSD, check UTC timestamps and candle completeness, then calculate price changes in a worksheet.
Category · Forex & Crypto
Forex & Crypto
Real-time and reference data for FX pairs and CEX crypto markets.
Latest in Forex & Crypto
Forex ATR in Python: calculate volatility from OHLCV
Calculate forex ATR in Python from OHLCV bars. Test Wilder smoothing, convert ATR to pips and percentages, and avoid seed and unfinished-candle errors.
Crypto tick data in Python: record a reference-price stream
Record BTCUSD and ETHUSD reference-price updates to Parquet with Python. Includes a tested WebSocket recorder, session reports and clear data limitations.
Forex correlation matrix in Python: use returns, not prices
Build a forex correlation matrix in Python with API data. Compare EURUSD, GBPUSD and USDJPY returns without hiding missing days or reversing quote direction.
Forex API in Grafana: build a EUR/USD price dashboard
Connect the SiftingIO Forex API to Grafana: chart EUR/USD OHLCV, show bid and ask, protect your API key, and choose a refresh rate that fits your plan.
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.
Cryptocurrency API: real-time and historical crypto data aggregated across venues
Cryptocurrency API guide: stream real-time crypto prices over WebSocket and pull 15+ years of historical OHLCV over REST, aggregated across venues.
Multi-currency portfolio valuation: convert every position to one base currency
Convert a multi-currency portfolio to one base currency: mid vs bid, timestamp alignment, triangulated crosses, and weekend FX gaps, with worked numbers.
Forex session overlaps: what happens to spreads, volume, and volatility
The four forex sessions in UTC, their overlaps, why London to New York carries the most volume, and how spreads behave at rollover and in the quiet hours.