Tuesday, September 11, 2018

Get Historical Monthly Currency Exchange Rates for a Pair of Currency Based on a Date Range

NetSuite's Currency Exchange Rates page provides no option to view pair of currency exchange rates results on a date range. To get the historical monthly currency exchange rates for a pair of currency based on a date range (e.g. USD and EUR from 5/1/2009 to 5/31/2009), consider using Xignite and perform the following:

1. Visit https://preview.xignite.com/product/forex/

2. Look at the bottom link "the previous version's documentation (http://www.xignite.com/product/XigniteCurrencies/api/legacy/v1/)" This will send user to XigniteCurrencies (Legacy).

3. Look for GetHistoricalMonthlyCrossRatesRange and click on the link.
a. If you do not have an account yet, sign up for a free trial
b. If you already have an account, click log in

4. Type the USDEUR on the box provided for Symbol.

5. Click View Results


- Results can be viewed in the following format:
* Grid

- The currencies must be entered on the Symbol field with no space in between (e.g. USD and EUR should be typed as USDEUR).  

No comments:

Post a Comment