I’m trying in vain to calculate how much money we lost in our cash accounts. The problem I have is that we have 4 different deposit accounts with 4 different curriencies and I would like to calculate a per month loss per currency (how much we lost to inflation last year and how much YTD in, let’s say, CHF)
Adding inflation data shouldn’t be very difficult. I suspect I need to add a web table with consumer price index for all four currencies but then I don’t know how to connect these data points to my deposit account changing balance.
Thank you for your help!