fx_forward_trades

Get the raw FX forward and swap transactions disseminated by DTCC, newest first.

Examples

from openbb import obb
obb.cftc.fx_forward_trades(provider='cftc')
# Get the newly executed non-deliverable forward prints.
obb.cftc.fx_forward_trades(product_type='Non-Deliverable Forward', action_type='NEWT', provider='cftc')
# Get the USD-settled non-deliverable forward and swap prints.
obb.cftc.fx_forward_trades(settlement_currency='USD', provider='cftc')
# Get the 20 largest INR forward prints of the day.
obb.cftc.fx_forward_trades(pair='INR', min_notional=50000000, limit=20, provider='cftc')

Parameters

• standard
• cftc

pair: str | None
Filter to a pair or currency, matched against the two reported legs. 'EURUSD', 'EUR/USD' and 'EUR USD' all match EUR/USD; a single code like 'INR' matches every pair with that leg. Default is every pair, deliverable and non-deliverable.

product_type: str | None
Filter by product: Forward (deliverable outright), Non-Deliverable Forward (cash-settled EM outright), FX Swap (near and far legs), Non-Deliverable Swap, or Non-Standard Forward. Default is every product.

date: date | None
Dissemination date (UTC). Default is the most recent day whose file holds forward prints; a file is published every calendar day, but weekends and holidays carry almost none. Files are retained for 366 days.

action_type: str | None
Filter by the action reported: NEWT (new), MODI (modify), CORR (correct), TERM (terminate), EROR (error), or REVI (revive). Default is every action; pass NEWT for newly executed trades only.

settlement_currency: str | None
Filter to trades whose leg-1 settlement currency matches, e.g. 'USD' for the USD-settled trades regardless of pair orientation. Non-deliverable forwards and swaps always carry it - their single cash-settlement currency; deliverable trades carry it only when reported. Default is every settlement.

min_notional: float | None
Drop prints whose larger notional leg is disseminated below this amount. The two legs value the same trade in each currency, so the larger is a currency-agnostic size proxy. Amounts above the reporting cap disseminate at the cap.

ticker: str | None
Filter to the exact UPI ticker, the Unique Product Identifier the source's TICKER report keys on. Default is every product. A ticker query is answered by the source's search API, cached per day, not the daily files.

limit: int | None
Number of prints to return, newest execution first. Default is all matching.

use_cache: bool | None
Default: True
Cache the daily file locally, revalidating it against the source ETag.

---

Returns

results: CftcFxForwardTrades

Serializable results.

provider: str | None

Provider name.

warnings: Optional[list[Warning_]]

List of warnings.

chart: Optional[Chart]

Chart object.

extra: dict[str, Any]

Extra info.

---

Data

• standard
• cftc

event_timestamp: datetime | None
Date and time the reported event occurred, in UTC. The tape is ordered by it, newest first: a termination or correction of an old trade is dated when it is reported now, not when the trade was struck.

execution_timestamp: datetime
Date and time the forward was originally executed, in UTC. It equals the reported time on a new trade, but predates it on an amendment or termination.

pair: str
Currency pair of the forward, its two reported legs.

product_type: str | None
Product, read from the FISN: Forward, Non-Deliverable Forward (settlement_currency is the cash-settled leg), FX Swap, Non-Deliverable Swap, or Non-Standard Forward. Derived, not disseminated.

action_type: str | None
Action reported: NEWT (new), MODI (modify), CORR (correct), TERM (terminate), EROR (error), or REVI (revive). An amendment carries the original trade's identifier in original_trade_key.

exchange_rate: float | None
Agreed forward rate on the trade, oriented as exchange_rate_basis states. For an FX swap it is the rate of the disseminated leg.

exchange_rate_basis: str | None
Quotation the forward rate is expressed in, e.g. 'USD/INR'.

notional_1: float | None
Leg 1 notional, in notional_currency_1.

notional_currency_1: str | None
Currency of the leg 1 notional.

notional_2: float | None
Leg 2 notional, in notional_currency_2.

notional_currency_2: str | None
Currency of the leg 2 notional.

settlement_currency: str | None
Settlement currency of leg 1. For a non-deliverable forward or swap it is the single currency the net cash settles in rather than delivering; a deliverable trade carries the physical settlement currency of leg 1 when reported.

effective_date: date | None
Date the forward comes into effect.

expiration_date: date | None
Date the forward settles.

days_to_expiry: int | None
Calendar days from execution to expiration.

cleared: str | None
Whether the transaction is centrally cleared: Y (cleared), N (not cleared), or I (intent to clear).

venue: str | None
ISO 10383 segment MIC of the trading facility, or BILT when the reporting counterparty could not determine the venue.

event_type: str | None
Reason for the action: TRAD (trade), NOVA (novation), ETRM (early termination), or CLRG (clearing).

block_trade: bool | None
Whether the print is reported as a block trade.

prime_brokerage: bool | None
Whether the transaction is a prime-brokerage transaction.

package_trade: bool | None
Whether the print is one leg of a package transaction - legs negotiated and priced together, such as the near and far legs of a swap booked as a package.

package_id: str | None
Grouping key shared by the legs of one package - its execution time and package price or spread. Group on it to reassemble the package. Derived, not disseminated.

package_price: float | None
Price of the whole package, in the format package_price_notation states; the same on every leg. Present on price-quoted packages, where DTCC's 9.9999999999 not-provided placeholder has been dropped to null.

package_price_currency: str | None
Currency the package price is denominated in, when it is a monetary amount.

package_price_notation: str | None
Format of package_price: 1 (a monetary amount, in package_price_currency) or 3 (a decimal).

package_spread: float | None
Spread of the whole package; the same on every leg. Present on spread-quoted packages instead of a price.

package_spread_notation: str | None
Format of package_spread: 1 (a monetary amount) or 3 (a decimal).

upi_fisn: str | None
ISO 18774 Financial Instrument Short Name, e.g. 'NA/Fwd NDF INR USD'.

underlier: str | None
UPI underlier name, the two legs of the pair as reported.

unique_product_identifier: str | None
ISO 4914 Unique Product Identifier.

dissemination_date: date
Date the SDR publicly disseminated the print, being the report date of the file it was published in.

trade_key: str | None
Asset-class-qualified dissemination identifier, e.g. 'FX:4419882315000000101'. The qualifier keeps the 19-digit identifier out of IEEE-754 double range, which truncates it past its 16th digit.

original_trade_key: str | None
For an action other than 'New', the qualified identifier of the original trade being amended, corrected or terminated. Match it against a trade_key to follow a trade's lifecycle.

is_capped: bool | None
Whether any amount on the print was disseminated at a reporting cap.