Added multiple currency support to dividend portfolio spreadsheet
While not the most exciting of titles, I did just release version 5.1 of the dividend portfolio spreadsheet. Since the loss of the Yahoo Finance API, I had to switch to a combination of IEX and Alpha Vantage to look up stocks.
While I’m still trying to figure out all the exchanges that Alpha Vantage supports, it does appear to have some international support. (I’m going to be compiling an FAQ with a list of the known ones.)
Quite a few people have asked when I’ll be updating the international version of the spreadsheet to support the Alpha Vantage API. I could still do that if desired, but thought it would be easier to just support a single version of the spreadsheet. So, I’ve merged the currency conversion features of the international version into the dividend portfolio spreadsheet.
In cell E4 you’ll choose the currency you want the Totals converted to. In the example above, I picked US Dollars. The calculated market value of all the stocks will be converted into whatever currency you choose. If you don’t desire for any currency conversions, then just pick US Dollars in column E. The spreadsheet should otherwise work as it has always.
1) The Dividend Calendar and Summary page’s dividend tables default to US Dollars. I’m working on a way to remedy this, but it is not yet ready.