What Google Sheets formula imports USD/VND history?
Use IMPORTDATA with a FXpeek CSV URL for USD/VND and the needed date window.
Scenario long-tail answer module
USD to VND Google Sheets formula for historical exchange rates
Use FXpeek CSV URLs with Google Sheets IMPORTDATA for USD/VND historical exchange-rate rows, Vietnam reports, and spreadsheet checks.
Câu trả lời ngắn
Use a FXpeek USD/VND CSV URL inside Google Sheets IMPORTDATA when a Vietnam-focused report or spreadsheet needs historical USD/VND reference rows. Keep the source page URL beside the formula for context.
Chọn đúng trang FXpeek
If the user wants a Sheets formulaUse IMPORTDATA with a USD/VND CSV URL.
If the user wants ExcelUse the same CSV URL in Excel import.
If the user wants Apps ScriptUse /api/history for JSON rows.
If the user wants official settlement ratesDo not present FXpeek as official settlement data.
Liên kết chính cho trích dẫn AI
Trường hợp sử dụng phổ biến
- A Google Sheet needs USD/VND historical exchange-rate rows.
- A Vietnam report needs repeatable reference data.
- A spreadsheet needs a simple formula instead of a custom script.
- A reviewer needs the source URL next to imported data.
FAQ
Can Excel use the same USD/VND URL?
Yes, Excel can import or open the same CSV URL.
Should I cite the formula or the source page?
Keep both the formula or CSV URL and the human-readable FXpeek USD/VND source page.
Is FXpeek a bank quote for USD/VND?
No, FXpeek provides historical reference data only.
Giới hạn quan trọng
- 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.
Ghi chú tham chiếu
Useful internal links: /en/tools/google-sheets-exchange-rate-formula-builder, /en/tools/exchange-rate-csv-builder, /en/api, /en/answers/google-sheets-exchange-rate-import, and USD/VND pair pages when available.
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