Home > Uncategorized > Currency exchange rates in CSV format

Currency exchange rates in CSV format

See http://www.bankofcanada.ca/en/markets/csv/exchange_eng.csv.

From the header of the file:

The daily noon exchange rates for major foreign currencies are published
every business day at about 12:30 p.m. EST. They are obtained from
market or official sources around noon and show the rates for the various
currencies in Canadian dollars converted from US dollars. The rates are
nominal quotations – neither buying nor selling rates – and are intended
for statistical or analytical purposes. Rates available from financial
institutions will differ.

How to do the calculation?

Say, we want to convert 1 Euro (EUR) to Hungarian Forint (HUF). Content of the file:

Date, ISO4217, 2012-11-29, 2012-11-30, 2012-12-03, 2012-12-04, 2012-12-05, 2012-12-06, 2012-12-07
European Euro , EUR, 1.2863, 1.2921, 1.2972, 1.2986, 1.2962, 1.2850, 1.2799
Hungarian forint, HUF, 0.004596, 0.004598, 0.004586, 0.004584, 0.004574, 0.004540, 0.004517

The latest date here is 2012-12-07 (yyyy-mm-dd), which is in the last column. So the answer is: 1 EUR is 1.2799/0.004517 = 283.35 HUF.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

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

%d bloggers like this: