How to adjust deposit accounts for inflation in different currencies?

Hey everyone!

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!

You can easily add the harmonized index of consumer prices as published by the European Central Bank:

Bildschirmfoto 2022-07-05 um 21.23.31

What you can do:

  • Add the data series to the performance chart
  • Substrat the consumer indices from the monthly performance (the widget on the dashboard)

What is not possible:

  • somehow calculate the lost purchasing power in Euro or dollar terms (it is always percentages)
  • merge the data series (you’ll have four in the performance chart)

Maybe you export the account data and try to fiddle in Excel?!?