Microsoft Excel · auto-refresh on open · one-time purchase
Every Friday at 3:30 PM ET the U.S. Commodity Futures Trading Commission publishes the Commitments of Traders report — and every Friday traders worldwide spend the next hour copy-pasting numbers from a government archive into their spreadsheet. We did that work for you. Open the Microsoft Excel file and its two data tabs pull the latest CFTC week for every market in the report and about 10 years of history for the market you pick (from a list of 48). Every other tab is yours to build pivots, charts, alerts, custom formulas. No subscription, no API key, no install.
The automated COT report spreadsheet is a download-and-open tool that ships the U.S. CFTC Commitments of Traders weekly dataset directly into your Microsoft Excel workbook. Open the file Friday afternoon, the latest CFTC week is already pulled from the public archive — no copy-paste, no manual import, no API key required. It is a standalone $39 one-time purchase for Excel 2016 or newer on Windows.
=INDEX(tblLatest, MATCH("099741", tblLatest[cftc_code], 0), MATCH("noncomm_long", tblLatest[#Headers], 0))
→ EUR FX · non-commercial long, latest week
=INDEX(tblLatest, MATCH("067651", tblLatest[cftc_code], 0), MATCH("noncomm_net", tblLatest[#Headers], 0))
→ Crude oil · non-commercial net
=INDEX(tblHistory, MATCH(SelectedMarketCode, tblHistory[cftc_code], 0), MATCH("comm_short", tblHistory[#Headers], 0))
→ The market picked on Config · commercial short, recentOpen the COT report spreadsheet Friday afternoon and the new CFTC week is already pulled. No manual download, no re-import, no copy-paste from the CFTC website.
Two tabs hold the CFTC data — the latest week of every market in the report and about 10 years of the market you pick (from a list of 48). Leave them alone and the refresh just works. Every other tab is yours — pivots, charts, alerts, custom formulas built on top of the COT report spreadsheet.
Subscribers to the COT Data API can paste their key into one config cell. The COT report spreadsheet then loads its history tab from our API, in its normalized column names — the same history length; the latest-week tab stays on the CFTC archive.
Buy once, re-download the COT report excel spreadsheet up to 3 times within 30 days. Lost the file? New machine? Just hit Account → Purchases.
One Microsoft Excel workbook, one payment — it refreshes itself every time you open it.
A pre-wired Excel workbook (.xlsm) that auto-refreshes the latest CFTC week every time you open it. Two data tabs, the rest is yours.
One-time payment
We e-mail customers our weekly COT recap, positioning alerts and occasional offers on our products. Don't send me customer emails (Friday positioning alerts, occasional offers on our products). Receipts and downloads always arrive.
Checkout asks you to sign in or create a free COT-Reports account first, then returns you here.
3 downloads within 30 days · Stripe Checkout · instant access
Right here. The Microsoft Excel COT report spreadsheet is a $39 one-time purchase. After Stripe Checkout you get an instant download link to the .xlsm file, and up to 3 downloads within 30 days through your account.
No. The spreadsheet is a Microsoft Excel workbook (.xlsm with Power Query and a macro), so buy it only if you use Excel on Windows. If you work in Google Sheets, the COT Data Dump’s CSV files open there directly.
Seven tabs: README, Config (the market picker and an optional API key), Markets (the 48 markets you can pick for the history), Data_Latest (the latest week for every market in the report), Data_History (about 10 years for the market you pick), Examples (ready formulas) and a blank Playground for your own work.
No. The COT report spreadsheet defaults to the free CFTC public archive — no API key needed. The optional API mode is for buyers who also subscribe to the $9.99/mo COT Data API and want the history in the API’s normalized column names (the same history length either way). Two separate purchases, completely optional.
Microsoft Excel 2016 or newer on Windows, including the Excel that comes with Microsoft 365. It does not work on a Mac or in Excel for the web: the automatic refresh uses Power Query's web connector, which Microsoft does not offer in Excel for Mac (Excel 2016 / 2019 for Mac have no Power Query at all), and Excel for the web does not run the VBA macro. The .xlsm file uses Power Query for the data refresh + a small VBA macro for the market-switcher dropdown.
When you open the workbook, Power Query checks the CFTC public archive (no API key, no auth) and pulls the latest weekly report into the data tabs. The fetch runs under 5 seconds on broadband. Change the market via the Config tab dropdown and a VBA Worksheet_Change handler triggers a fresh refresh — also under 5 seconds. The rest of the workbook is yours: pivots, charts, formulas, conditional formatting, custom market lists.
Yes — every tab is yours to edit. Build pivots, charts, formulas, conditional formatting, market watchlists, anything. Just leave `Data_Latest` and `Data_History` as they are: they hold the raw CFTC pull and the lookup logic, and editing them would break the auto-refresh. If you need to extend the data layer, build a new tab that references those two via formula — that's the supported pattern.
The COT Data Spreadsheet is licensed for personal use only — not for resale or redistribution. Each copy carries a COT-Reports.com mark identifying its source; that's intentional and part of the product.
It's not a trading signals tool, it's not a position-sizing calculator, it's not a backtester. It's the raw CFTC data, structured cleanly, refreshed automatically — your analysis is still yours to build.