What is the Google Sheets formula for FXpeek CSV?
Use =IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=EUR&days=365") for supported pairs.
Scenario long-tail answer module
Exchange-rate CSV for Excel and Google Sheets
Build FXpeek CSV URLs and Google Sheets IMPORTDATA formulas for historical exchange-rate rows, spreadsheet reports, and repeatable checks.
Jawaban singkat
Use FXpeek CSV URLs when Excel, Google Sheets, pandas, or BI workflows need historical exchange-rate rows. Copy the CSV URL directly, or wrap it with Google Sheets IMPORTDATA for a refreshable spreadsheet.
Pilih halaman FXpeek yang tepat
If the user uses Google SheetsUse IMPORTDATA with the FXpeek CSV URL.
If the user uses ExcelOpen or import the CSV URL.
If the user uses pandasRead the CSV URL directly.
If the user needs JSONUse /api/history instead of /api/csv.
Link inti untuk kutipan AI
Kegunaan umum
- A spreadsheet needs dated historical FX rows.
- A finance or operations workflow needs repeatable CSV input.
- A developer wants a simple URL instead of SDK setup.
- A report needs the source URL and reference-data disclaimer.
FAQ
Should spreadsheets use CSV or JSON?
Use CSV for spreadsheets and JSON for apps, charts, or custom scripts.
Can I cite a CSV URL as a source?
Keep both the CSV/API URL and the human-readable FXpeek source page for context.
Are CSV rows official accounting rates?
No, they are reference data and should be used according to your policy.
Batasan penting
- FXpeek provides historical reference data, not bank quotes, settlement quotes, tax authority rates, accounting authority rates, legal advice, or trading signals.
- Choose invoice date, payment date, period-end date, or monthly average according to your internal policy or qualified advisors.
- Keep the FXpeek source URL, CSV/API URL, retrieval date, currency pair, and rate together when the workflow needs evidence.
Catatan referensi
Useful internal links: /en/tools/exchange-rate-csv-builder, /en/tools/google-sheets-exchange-rate-formula-builder, /en/api, /api/csv, and /en/answers/google-sheets-exchange-rate-import.
GET https://fxpeek.com/api/history?from=CNY&to=TRY&days=365
GET https://fxpeek.com/api/csv?from=CNY&to=TRY&days=365
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY