Stop-loss and take-profit in the same candle: OHLC backtests
Detect same-candle stop-loss and take-profit ambiguity in Python, compare fill assumptions, and see when finer OHLCV data can resolve the sequence.
Tag · forex
forex
23 posts on forex from the SiftingIO market data blog, spanning real-time and historical coverage across stocks, forex, crypto, commodities, and on-chain venues.
Posts tagged forex
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.
Google Sheets market data template: a watchlist you can copy
Copy a Google Sheets market data template to track up to 20 stock, crypto, forex and commodity prices with a SiftingIO API key, plus troubleshooting.
Excel Power Query: forex, gold and stock prices from an API
Pull forex, gold and stock quotes into Excel with Power Query. Keep timestamps and fallback prices visible, protect your API key, and budget refresh calls.
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.
Plotting trades on a price chart: get the exact 1-minute bar at the fill time
How to fetch the exact 1-minute OHLCV bar under each trade fill for stocks, forex, and crypto with one API, with verified page limits, intervals, and pagination.
When does the weekly candle open and close? Weekly bar boundaries by asset class
Weekly candle open and close times for forex, crypto, and US stocks, and how to rebuild either week convention from timestamped SiftingIO bars in pandas.
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.
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.
How to calculate a currency cross rate: EURGBP from EURUSD and GBPUSD
The cross rate formula with worked math: derive EURGBP from EURUSD and GBPUSD, carry bid and ask through the triangulation, and compute it in Python.
What is a pip in forex? Pip size, fractional pips, and pip value math for EURUSD and USDTRY
What a pip is in forex: pip size for four-decimal and JPY pairs, fractional pips, and step-by-step pip value math for EURUSD and USDTRY from live quotes.
Base currency vs quote currency: how to read a forex pair like EURUSD
What base and quote currency mean, why it's EURUSD and never USDEUR, direct vs indirect quoting, and how to read any FX price. With live API examples.
Daily candle open and close times: forex, crypto and US stocks
Compare daily candle open and close times for forex, crypto and US stocks, including UTC vs New York cutoffs, daylight saving and regular trading sessions.
What is a lot in forex? Standard, mini, and micro lot sizes with position value math
What a lot means in forex: standard, mini, micro, and nano lot sizes in one table, plus position value and pip value math computed from a live EURUSD quote.
Market data MCP server: one connector for stocks, forex, crypto, DEX, commodities, and fundamentals
SiftingIO's MCP server gives an AI assistant forex, stock, crypto, commodity, DEX, and fundamentals data through one connector and a single API key.
Golang WebSocket market data: stream real-time forex and crypto prices
Stream real-time forex and crypto prices in Go over WebSocket: authenticate, subscribe, parse tick frames, and handle pings and reconnects with working code.
Forex OHLCV data: how FX candles are built
Forex OHLCV data explained: how FX candles are built from aggregated quotes, why daily bars depend on the day boundary you pick, and how to pull them by API.
Live bid and ask price API: build a correct EURUSD and BTCUSD quote client
How to read live bid and ask prices for EURUSD and BTCUSD over REST and WebSocket: string-typed fields, epoch milliseconds, ping keepalive, and rate limits.
Economic calendar API: handling revisions, timezones, and the bar each release moved
Ingest CPI and NFP releases from an economic calendar API: handle first prints vs revisions, normalize times to UTC, and tag the bar each event moved.
Bid ask spread: how to read a quote and flag a wide or stale one in code
How to read bid and ask from a quote snapshot, compute the bid ask spread in basis points, and flag wide or stale quotes in Python before users see them.
Market data over FIX 4.4 for high-performance trading systems
Pull cross-venue reference prices over a FIX 4.4 market-data session for crypto, forex, and metals, then feed them into MetaTrader. Market data only.
How to get real-time forex prices from SiftingIO
A plain guide to getting live forex prices from SiftingIO: a single request for the current rate, or a live feed that updates on its own as the market moves.
Real-time FX and crypto quotes: REST snapshots and WebSocket streams
How to read real-time FX and crypto quotes from SiftingIO: REST bid/ask snapshots for EURUSD and BTCUSD, WebSocket tick streams, and the pitfalls in between.