Colombian Peso to US Dollar Official Exchange Rate

TRM is the official weighted average exchange rate for US dollar purchases and sales in Colombian pesos. The dataset is published by the Colombian government's open data portal, www.datos.gov.co, and was last updated in April 2026.

Use Cases

• Analyze trends in the VALOR column to model Colombian peso volatility against the US dollar.
• Join other Colombian economic time-series data using the VIGENCIADESDE and VIGENCIAHASTA date columns as a temporal key.
• Calculate the effective exchange rate for a specific period by querying records where a target date falls between VIGENCIADESDE and VIGENCIAHASTA.
• Verify the official UNIDAD (currency unit) for financial reporting or regulatory compliance in Colombia.

Strengths

• Provides the official government-mandated exchange rate (TRM) for Colombia.
• Data is available in multiple machine-readable formats including CSV, JSON, and XML.

Limitations

• Sample data is unavailable, preventing assessment of data structure and completeness prior to download.
• Key metadata such as total row count, historical time range, and update frequency is unknown.

Provenance

Source

Colombian government open data portal (www.datos.gov.co).

Collection Method

Calculated as the weighted average of spot market transactions for US dollars in Colombian pesos.

Freshness

Last updated on 2026-04-01, indicating potentially regular maintenance.

Geography

Colombia.