So i have transactions in 4 currencies - CHF, EUR, GBP, USD - and i would ultimately want to see everything in CHF.
I would download historical rates into excel, but i would like to know how to automatically make it search for the currency rate and then do the math to convert to the CHF value.
See example excel workbook FX Rates.xlsx
Thanks guys, help is very appreciated!
Bookmarks