If in google sheets I do
=GOOGLEFINANCE("Currency:EURIDR")*GOOGLEFINANCE("Currency:IDREUR")
I get a value close to 1 as expected. (Product of exchange rate and reverse rate should be 1.)
If I do the same for a historic exchange rate, i.e.,
=index(GOOGLEFINANCE("Currency:EURIDR"; "price"; DATE(2022;8;1));2;2)*index(GOOGLEFINANCE("Currency:IDREUR"; "price"; DATE(2022;8;1));2;2)
I get a value of around 0.01 which is off by a factor of 100 which is strange.
What am I missing or is my code incorrect?
