fx_markets

Get CFTC Commitment of Traders (COT) data

Returns weekly CFTC Commitment of Traders report data for the specified currency's futures contract. The default is the Legacy Futures-Only report; report= selects the Legacy combined, Traders in Financial Futures (TFF) futures-only / combined, or Disaggregated futures-only report from the same CFTC public datasets.

Supported currencies: AUD, CAD, CHF, EUR, GBP, JPY, NZD, USD, XAU

Path Parameters:

  • currency: 3-letter currency code (e.g., EUR, GBP, JPY).

Query Parameters:

  • start_date: Optional. Start date YYYY-MM-DD. Defaults to 52 weeks ago.
  • end_date: Optional. End date YYYY-MM-DD. Defaults to today.
  • report: Optional. One of legacy_futures (default), legacy_combined, tff_futures, tff_combined, disaggregated_futures. TFF reports return dealer / asset manager / leveraged funds / other reportable long, short, spreading and net positions for FX contracts and the dollar index; the Disaggregated report (producer/merchant, swap dealer, managed money, other reportable) is published for XAU only. A report the CFTC does not publish for the instrument returns 404 with the available list.

Authentication: USD data is publicly available on the same freemium terms as USD announcements: anonymous callers are limited to the most recent 90 days (an earlier start_date is clamped automatically) and a new report becomes readable 15 minutes after the CFTC publishes it. All other currencies require a professional API key supplied via ?api_key=<key> or the X-API-Key header. Authenticated callers (any valid key) receive the full requested history for every currency.

Data source: CFTC public reporting API — Legacy futures-only https://publicreporting.cftc.gov/resource/6dca-aqww.json; Legacy combined jun7-fc8e; TFF futures-only gpe5-46if; TFF combined yw9f-hn96; Disaggregated futures-only 72hh-3qpy. Non-default reports echo report, report_name, report_dataset_id and available_reports.

get/v1/cot/{currency}

Request

  • Base URL: https://api.fxmacrodata.com
  • URL: https://api.fxmacrodata.com/v1/cot/{currency}
  • Auth: one of:
    • none
    • API key in header X-API-Key
    • HTTP bearer

Path parameters

currency'AUD' | 'CAD' | 'CHF' | 'EUR' | 'GBP' | 'JPY' | 'NZD' | 'USD' | 'XAU' required
Example:AUD

Required path parameter. Allowed values: AUD, CAD, CHF, EUR, GBP, JPY, NZD, USD, XAU.

Query parameters

start_datestring

Start date YYYY-MM-DD

Example:2025-09-01

Optional query parameter. Start date YYYY-MM-DD

end_datestring

End date YYYY-MM-DD

Example:2026-03-01

Optional query parameter. End date YYYY-MM-DD

limitinteger

Maximum rows to return. Defaults to 20. Maximum 100.

Example:20

Optional query parameter. Maximum rows to return. Defaults to 20. Maximum 100.

offsetinteger

Number of rows to skip after most-recent-first ordering.

Optional query parameter. Number of rows to skip after most-recent-first ordering.

pageinteger nullable

One-based page number. When supplied, it takes precedence over offset.

Example:1

Optional query parameter. One-based page number. When supplied, it takes precedence over offset.

report'legacy_futures' | 'legacy_combined' | 'tff_futures' | 'tff_combined' | 'disaggregated_futures' nullable

CFTC report type. legacy_futures (default): Legacy Futures-Only report with commercial / non-commercial / non-reportable positions. legacy_combined: the same categories from the futures-and-options combined report. tff_futures / tff_combined: Traders in Financial Futures report with dealer, asset manager, leveraged funds, other reportable and non-reportable long / short / spreading positions (FX contracts and the dollar index; not gold). disaggregated_futures: producer/merchant, swap dealer, managed money and other reportable positions (COMEX gold only). Each report adds the matching *_net and *_zscore columns.

Example:legacy_futures

Optional query parameter. CFTC report type. legacy_futures (default): Legacy Futures-Only report with commercial / non-commercial / non-reportable positions. legacy_combined: the same categories from the futures-and-options combined report. tff_futures / tff_combined: Traders in Financial Futures report with dealer, asset manager, leveraged funds, other reportable and non-reportable long / short / spreading positions (FX contracts and the dollar index; not gold). disaggregated_futures: producer/merchant, swap dealer, managed money and other reportable positions (COMEX gold only). Each report adds the matching *_net and *_zscore columns.

api_keystring

Your Individual or Business API key

Deprecated: legacy query-string API key. Still accepted so existing integrations keep working, but new integrations must send the key in the X-API-Key header (or Authorization: Bearer). A key is required for non-USD, paid-only, or full-history requests. Responses to requests authenticated this way carry a Deprecation header.

Response

COT report history for the selected futures market.

currencystring required
instrumentstring required
reportstring nullable
report_namestring nullable
report_dataset_idstring nullable
available_reportsstring[] nullable
sourcestring required
source_urlstring required
start_datestring required
end_datestring required
latest_available_datestring nullable
latest_available_announcement_datetimeinteger nullable
expected_next_releasestring nullable
expected_next_release_epochinteger nullable
last_sync_statusstring required
last_sync_datetimestring nullable
data_lag_daysinteger nullable
next_expected_cftc_report_datestring nullable
next_expected_cftc_release_datestring nullable
expected_next_release_holiday_adjustedboolean nullable
expected_next_release_sourcestring nullable
expected_next_release_source_urlstring nullable
expected_next_release_schedule_storagestring nullable
expected_next_release_schedule_last_updatedstring nullable
requested_window_has_databoolean nullable
requested_window_latest_datestring nullable
requested_window_includes_latest_availableboolean nullable
page_includes_latest_availableboolean nullable
last_updatedstring nullable

Changes

No recorded changes to this operation across all 1 revision of this API.