I have accounts in banks from different countries (both supported by Tiller).
I would like to have my account balance in the other currency to be somehow translated to dollars based on an exchange rate that I would manually update over time so I can see my net worth trends in US dollars
Has anybody done something like this?
Thanks for your help
You can use googlefinance to pull an exchange rate, and also have it by date.
For example this code will pull today’s exchange rate for USD:EUR, you can then use that in your calculation.
=GOOGLEFINANCE("CURRENCY:USDEUR", "price")
This will pull a rolling year:
=GOOGLEFINANCE("CURRENCY:USDEUR", "price", TODAY()-365,today(),"DAILY")
For a specific date:
=GOOGLEFINANCE("CURRENCY:USDEUR","price","11/24/2020")
If you haven’t already, you can upvote a feature request to support multiple currencies. Just click here and click on the Vote button, then maybe Tiller will work on an official solution.
https://community.tillerhq.com/t/foreign-exchange-fx-currency-conversion/13078