This is a different issue. I have just published a small project to get exchange rates and I would like to comment it with you.

If you hate/like the format, let me know by hitting the reply button or via twitter @sdelamo.

Sergio del Amo

The problem

Most of my income/expenses are in USD. However, I pay taxes and keep my books in EUR. Whenever I get payments/charges, I add them to my books in EUR.

As of today, I have a keep Excel file with two sheets. First sheet, Transferwise movements - more about my integration with Transferwise in a different email. Second sheet contains exchange rates. First sheet populates a column by using Excel Lookup with the exchange rate which applies to any payment/charge.

I wanted to automate obtaining the exchange rates.

Enter Foreign exchange rates API. Created by @madisvain, exchange rates API is a free service for current and historical foreign exchange rates published by the European Central Bank.

Sergio del Amo