[EN] Collect the data of the Exchange Rates Archive

[ansakoy]

Goal

The goal is to collect historical data on exchange rates.

Tasks

The entry point for this task is this: https://www.cba.am/en/sitepages/exchangearchive.aspx. There is a further option to filter the data by day using the URL parameters. Although there are only two columns in the HTML table (ISO code and Rate), it may be a good idea to single out an additional value in the output (by extracting the value in the <em> tags into a separate field). Supposedly, this <em>value</em> means the measure, like USD 1 -> 1 US dollar; IRR 100 -> 100 Iranian rials. We suggest that you should collect all the available exchange rate data and store them in a machine readable format, such as JSON, or XML, or CSV in a flat structure. For example:

{
	"date": STRING,
	"iso_code": STRING,
	"measure": NUMBER,
	"rate": NUMBER
}

Context

The Central Bank of Armenia publishes a considerable archive on exchange rates. The web interface provides an opportunity to choose a specific date and get exchange rates for a number of currencies for this particular date. Unfortunately, there is no way to download these data in bulk or to access them via an API. However, these data may be a very helpful source of information for all kinds of analysts.

Requirements

A public GitHub repository should be created to store and publish the code and the data under one of the free and open licenses, such as Creative Commons or MIT.

Wishes

It would be best if your code is reusable, that is can be launch again by anyone who might want to update the dataset at a later point. For the same reason, we encourage you to comment your code, supplement it with at least a very brief README description, and specify the requirements and dependencies necessary to use the code.

Resources

https://www.cba.am/en/sitepages/exchangearchive.aspx

Prepared by

The Open Data Armenia team prepared this task

[vlivyur]

There is API: http://api.cba.am/exchangerates.asmx
Currencies: ISOCodesDetailed (historical) and ISOCodes (latest)
Rates: ExchangeRatesByDate
Data available from 2000-01-01
But somewhere in the 00s there were couple typos like 2 letters in currency code in rates: 22.05.2013 TM for TMT

[ivbeg]

@vlivyur Thanks! It's very helpful!

[vlivyur]

Here are code and downloaded data