A Historical FX Reference Report for CSV, API, and Spreadsheet Workflows

Most currency tools answer the current-rate question.

For reporting, the harder question is usually historical:

• What was this pair worth on the invoice date?
• Can I export the rows into Excel, Google Sheets, or pandas?
• Is there a simple JSON endpoint for a dashboard or internal report?
• Can a finance blog or spreadsheet template embed a lightweight lookup widget?

FXpeek now has a 2026 Historical FX Reference Report for those workflows.

Report page:

https://fxpeek.com/en/reports/2026-historical-fx-reference?utm_source=devto&utm_medium=article&utm_campaign=fxpeek_wave1_api_csv&utm_content=annual_fx_report

PDF:

https://fxpeek.com/reports/2026-historical-fx-reference-report.pdf?utm_source=devto&utm_medium=article&utm_campaign=fxpeek_wave1_api_csv&utm_content=annual_fx_report_pdf

What the report covers

The report is designed for practical historical FX use cases:

• dated lookup for invoices, travel notes, ecommerce orders, and bookkeeping records
• regional and long-tail currency-pair workflows
• CSV exports for spreadsheet and analysis work
• lightweight JSON endpoints for apps and dashboards
• disclaimers around reference-rate usage

FXpeek keeps the first production batch narrow on purpose. It publishes data-backed pair pages instead of generating a large number of unsupported thin pages.

Example API calls

Latest reference rate:

curl 'https://fxpeek.com/api/rates?from=CNY&to=TRY'

Historical JSON:

curl 'https://fxpeek.com/api/history?from=CNY&to=TRY&days=365'

CSV export:

curl -L 'https://fxpeek.com/api/csv?from=CNY&to=TRY&days=365' \
  -o cny-try-history.csv

API docs:

https://fxpeek.com/en/api?utm_source=devto&utm_medium=article&utm_campaign=fxpeek_wave1_api_csv&utm_content=annual_fx_report_api

Embeddable widget

For blogs, finance pages, spreadsheet templates, or small dashboards, FXpeek also has a copyable widget:

https://fxpeek.com/en/widget?utm_source=devto&utm_medium=article&utm_campaign=fxpeek_wave1_api_csv&utm_content=annual_fx_report_widget

Basic embed:

<div
  data-fxpeek-widget
  data-from="USD"
  data-to="IDR"
  data-amount="100"
  data-locale="en"
></div>
<script async src="https://fxpeek.com/embed/fxpeek-widget.js"></script>

AI and citation file

FXpeek also exposes an AI-friendly discovery file with primary pages, API endpoints, locale entry points, and citation guidance:

https://fxpeek.com/llms.txt?utm_source=devto&utm_medium=article&utm_campaign=fxpeek_wave1_api_csv&utm_content=annual_fx_report_llms

Data note

FXpeek rates are reference data for historical lookup, reporting, spreadsheet workflows, and lightweight API examples. They are not transaction quotes, settlement rates, tax advice, trading signals, or financial advice.