these are my first steps in GOOGLEFINANCE with the following problem in catching historical data:
INDEX(GOOGLEFINANCE(B2;"price";(HEUTE()-1));2;2) this works fine
but if I refere the historcal data to a cell like this (HEUTE()-O2) where in cell O2 = 1 like
it will not work
Any solution ?