Colombia TRM Exchange Rate API: Official USD/COP Rates as JSON

The Superintendencia Financiera de Colombia publishes the official exchange rates that accounting, tax, and customs rules in Colombia reference — published official rates, not moving market prices. This guide shows how to pull them as JSON: via a REST endpoint or the zero-dependency colombia-trm-exchange-rate npm package.

What the Superfinanciera publishes

• The TRM — Tasa Representativa del Mercado — the single USD/COP rate the Superintendencia Financiera certifies each business day for the following day.
• One pair by design: the TRM is the legally binding rate for Colombian tax, customs, and financial reporting, so this source is deliberately USD/COP only.
• History back to December 2, 1991 — roughly 8,300 daily certified rates, queryable by exact date or as a time series.
• The certification date on every response, so a rate is always citable.

There is no anchor pair to pick — the TRM is the anchor. DIAN, Colombian customs, contracts, and financial statements all settle against the certified TRM, and the certification-for-the-following-day mechanism means the rate for any given date was fixed before that date began.

Why official rates, not market rates

A live mid-market feed answers "what is USD/COP trading at right now?" — the right tool for checkouts and dashboards. But accountants, auditors, and tax authorities ask a different question: "which rate were you required to use for this date?" That answer comes from the Superintendencia Financiera de Colombia's published rates, and it never changes after publication.

Get the latest rates (REST)

curl "https://allratestoday.com/api/v1/central-bank/sfc/latest" \
  -H "Authorization: Bearer YOUR_API_KEY"

The response is the bank's most recent published data — every rate and the publication date. The latest rates are available on every plan, including the free tier (300 requests/month, no credit card).

The npm SDK

npm install colombia-trm-exchange-rate

import { getRate, getLatestRates } from 'colombia-trm-exchange-rate';

// One pair at the official Superfinanciera rate
const pair = await getRate('USD', 'COP', { apiKey: 'art_live_...' });
console.log(pair.rate, pair.rate_date);

// The bank's full published table
const table = await getLatestRates({ apiKey: 'art_live_...' });
console.log(table.rate_date, table.rates.length);

Zero dependencies, TypeScript types included, and it runs anywhere fetch exists — Node 18+, Bun, Deno, and edge runtimes.

Historical rates for an invoice date

import { getRatesForDate, getHistory } from 'colombia-trm-exchange-rate';

// The official rates for an invoice date — non-publication days return
// the most recent published date, flagged via published_on_requested_date.
const day = await getRatesForDate('2026-06-30', { apiKey: 'art_live_...' });

// Time series for one pair
const series = await getHistory(
  { source: 'USD', target: 'COP', from: '2026-01-01' },
  { apiKey: 'art_live_...' }
);

Historical dates and time series need a paid plan; the latest rates stay free.

Published vs derived pairs

If the Superfinanciera does not print a pair directly, the API resolves it from the bank's published rates — an inverse, or a cross rate via COP — and flags it derived: true with the method used. Official and computed values are never silently mixed, which is exactly the distinction an auditor will ask about.

Thirty-five years of certified peso history

The series starts on December 2, 1991 at around 630 pesos per dollar and runs unbroken through the 1999 float, the commodity cycles, and the move past 4,000 in the 2020s. Every one of those ~8,300 daily rates was legally certified — which is exactly what makes this series the audit-grade record for Colombian invoice-date lookups.

FAQ

Does the Superintendencia Financiera de Colombia have an official exchange rate API?

The Superfinanciera publishes its official rates on its own site, and AllRatesToday serves the same published rates as clean JSON via REST or the colombia-trm-exchange-rate npm package. The latest table is free.

How often do Superintendencia Financiera de Colombia rates update?

Each business day the Superintendencia Financiera certifies the TRM for the following day, computed from the previous day's interbank USD/COP trading. It is a certified legal rate, not a moving market price — every API response carries the certification date so you can cite it.

Can I get the Superfinanciera rate for a past date, like an invoice date?

Yes. The /central-bank/sfc/rates-for-date endpoint returns the official rates for any archived date. Non-publication days resolve to the most recent published date and are flagged, so your audit trail stays honest. Historical dates require a paid plan; latest rates are free.