Live Exchange Rates OANDA

Hello there!

Please, don't downvote, instead, some feedback would be appreciated.
Before you continue: Will only work on Apple devices because of the API being used.
You can skip this, just some information: Originally, I found a good looking template that comes with Numbers (Apple) but it doesn't work as expected; Basically it will fail to calculate properly based on different currencies.
General idea was to have something quick, clean, setup-free and portable for Apple devices. Most of the spreadsheets out there are Google-tied. There are a lot of other spreadsheets around fully customizable for Android users.
- The spreadsheet works! Per API design, information is updated with PREVIOUS market day closing values.
- Check instructions in "Documentation" to override currency settings.
- When rebalancing mutual funds, it will calculate how much $ (Cash) to invest, but when doing Stocks / ETFs will do the shares to add and cash too.
- For Canadians: TD E-Series values are accurate but with an important delay because of the information not being properly updated by Yahoo.
Some Screenshots:
Link to download (Current version 1.8):
- If you want to contribute please do but share back so everyone can benefit :)
- https://github.com/ezequielfriscia/PortPortfolio/releases/tag/v1.8a
- https://github.com/ezequielfriscia/PortPortfolio (Repository)

v1.8a Modifications: - Fixed: Not every label showing in the "Portfolio". - Modified: Portfolio "% Gain" Graphic now showing values. - 52 W. Low / High Graphic in "Watchlist" replaced by Beta Graphic. - Minor tables corrections.
v1.8 Modifications: - Reported: Major bug fixed when changing regional and currency settings. - Formula fixed when calculating dividends income. - Several elements locked to avoid dragging on mobile devices. - Watchlist "1y Target" columns modified to make sorting possible. - Watchlist % Growth negative values fixed. - Minor tables fix.
v1.7b Modifications: - Fixed formula error in the Watchlist sheet. - Modified tables when scrolling for mobile devices / smaller screens.
v1.7a Modifications: - Fixed cell error in the Dividend sheet. - Replaced Dividend's graphic by 2D Donut instead of 2D Bar.
v1.7 Modifications: - Working as originally intended: * Just one file for any single country/currency. * Base file provided in Numbers never supported multicurrency independently of the formulas. * Will use as a base the ticker's original currency on which this one is traded. * Depending on the country you live in, the spreadsheet will calculate the proper "Cost Basis", "Market Value" and "Gain". * Support for all major countries and currencies. * The previous setting is based on the device's "Language & Region" configuration. Can be overridden, instructions in the "Documentation" sheet.

"Documentation" sheet modified. Added instructions for currency support and override settings.
"Live Forex Rates & Currencies" provided by Yahoo. Any given difference should be based on this and not on the formulas.
Table optimizations, bug fixes, error handling, removed several calculations.

v1.6 Modifications: - Added % Growth in the Portfolio sheet graphic. - Implemented Dividend income calculation per year in a new sheet. - Added some conditional colouring in the "Rebalance" sheet if "Desired %" is not 0% or 100%. - Some bugs fixes and table corrections.
v1.5 Modifications: * Added Multicurrency support and fixed several bugs in the Portfolio page: - "Market Value" and "Cost Basis" per Ticker will be added as in the ticker currency (Do not add a currency format to the cells!) - Total "Market Value" and Total "Cost Basis" will be calculated in the currency you do transactions (Either U.S. or CAD) - Total ticker's gains and the "Gain" total will be displayed in the currency you do transactions (Either U.S. or CAD)
If you find any error or problems and/or you need support for any other currency let me know.

Forex Auto Poster to facebook