To ensure the accuracy and timeliness of rates, we recommend re-running the job in your ERP system. If manual updates are required, you can use our development page.
Please follow these instructions to obtain the rates manually.
The first PATH PARAMETER on the page is asking for the output format. At the end of the field you can click on csv, json or xml. Most use csv since you can paste the results to Excel easily.
The QUERY-STRING PARAMETERS are:
API Key - your API key goes here
Base - currency converting from
Quote - currency converting to
Date_Time - optional but must be formatted in ISO-8601 format YYYY-MM-DD or YYYY-MM-DDThh:mm:ss±hh:mm if it is used
Fields - averages (provides daily average midpoint) are most common but select 'all' if you are not sure.
data_set - OANDA or you can use one of the other data sets that provides rates from a specific central bank if so required
Once this is all input correctly, please click on 'Try' located on the right. Slightly below that but on the left you'll see three hyper-links:
1) Response - this is where you click to get the rates to be copied to Excel.
2) Response Headers - this is something a developer would need if they are writing automation code with the API
3) Curl - this is where you will see the actual http request