its helpful , thanks.my current formula
=IMPORTXML("https://www.westmetall.com/en/markdaten.php?action=table&field=USD_ozt_London","/html/body/div[2]/div/table[1]/tbody/tr[1]/td[2]")*(0.00023-0.0000000342*(TODAY()-DATEVALUE("1/9/2026")))
not very accurate.![]()
The minor difference could be just bcoz of variable numbers like hedging costs or cash buffer kept for redemptions , etc which may not be fixed % unlike mgmt fee is fixed 0.5%.
So your formula is as accurate as it can get.