Commitment Of Traders COT Analytics
One of the key elements in speculative foreign exchange (forex) trading is identifying the trend of a particular currency pair and trade in that direction. This is easier said than done because ploting trend lines in a trading chart is subjective and will vary amongst different traders especially when considering different timeframes. The best way to identify the trend of a particular currency is gauging the positions held in the currency futures markets by the major participants(asset managers). This is where the Commitment of Traders (COT) data comes into play which is availed by the Commodity Futures Trading Commission (CFTC) weekly on Friday.
Install / Use
npx skills add masakhwe/Commitment-of-Traders-COT-AnalyticsInstalls into whichever agent you are using.
README
Objective
One of the key elements in speculative foreign exchange (forex) trading is identifying the trend of a particular currency pair and trade in that direction. This is easier said than done because ploting trend lines in a trading chart is subjective and will vary amongst different traders especially when considering different timeframes. The best way to identify the trend of a particular currency is gauging the positions held in the currency futures markets by the major participants(asset managers). This is where the Commitment of Traders (COT) data comes into play which is availed by the Commodity Futures Trading Commission (CFTC) weekly on Friday. This project involves development of a data pipeline that will process the commitment of traders data in weekly batches through transformations and creation of tables which will be consumed by our dashboard in Tableau.
Technologies
- Language - Python
- Pipeline Orchestration - Airflow
- Distributed Processing - Spark, Dataproc
- Containerization - Docker, Docker Compose
- Data Visualization - Tableau
- Cloud - Google Cloud Platform
- Data Warehouse - BigQuery
- Data Lake - Google Cloud Storage
Architecture diagram
Final Result
Related Skills
codebase-memory-mcp
38.0kHigh-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 languages, sub-ms queries, 99% fewer tokens. Single static binary, zero dependencies.
codebase-memory-mcp
38.0kHigh-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 languages, sub-ms queries, 99% fewer tokens. Single static binary, zero dependencies.
codebase-memory-mcp
38.1kHigh-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 languages, sub-ms queries, 99% fewer tokens. Single static binary, zero dependencies.
tabularis
4.0kOpen-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, SQLite and 15+ more databases like DuckDB, ClickHouse, Redis and Firestore. Built-in MCP server for Claude, Cursor and Devin, SQL notebooks and visual EXPLAIN.
