Historical Currency Exchange Rates

Usually when I need to get a bunch of past exchange rates I use the GOOGLEFINANCE function in Google Spreadsheets. Something like this…

=GOOGLEFINANCE("EUR", "price", DATE(2016,1,1), TODAY(), "DAILY")

It’s quick and easy, but once in a while you’ll run into a currency where this doesn’t return enough precision, compared to the value you get when using Google’s currency converter. Even worse, today it was giving me a bunch of data that was quite different from what Google Finance showed for the current and historical data.

I found a site run by the University of British Columbia that’ll give you whatever data you need. It’s not pretty but it does the job. Those Canadians are always so generous!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s