So you have your real-time currency conversion, but what if you want to be able to see a currency conversion for the last month or the last year? This article will show you how to do that.

Note: This does have a couple of limitations. First, you will not be able to make the date ranges dynamic. This means that you will have to set the dates to a specific range (i.e. June 1, 2017 to May 31, 2018).

Second, limits the historical data to 12 months back from the end date. So if I set the end date to April 30 of this year, I could pull data up to May 1st of last year, regardless of today’s date.

To connect to historical rate data, first log in to your Grow account and add a new metric or add a new report inside of another metric. Select Custom REST API Connection as the data source. 


Once you’ve done that, you’ll enter in the URL and Header sections:


After you’ve entered the headers, you’ll enter the parameters. To add multiple parameters, press the white plus button. 

  • Key: `base`
  • Value: `AUD` 
  • This value is the three-letter currency symbol that your data is in.
  • Key: `symbols`
  • Value: `USD`
  • This value is the three-letter currency symbol that you are converting your data into.
  • Key: `end_date`
  • Value: `2018-05-31`
  • The end date is the most recent date for which you want the currency conversion.
  • Key: `start_date`
  • Value: `2017-06-01`
  • The start date is when you want to begin pulling the currency conversions back.

Once you have done all of this, you can press the blue Connect button. This will return the exchange rate between those currencies, with each column representing one day within that date range.

Questions? Chat in on the site and we’ll be happy to help.

Did this answer your question?