Hi,
these are my first steps in GOOGLEFINANCE with the following problem in catching historical data:
Stockprice yestereday:
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
INDEX(GOOGLEFINANCE(B2;"price";(HEUTE()-O2));2;2)
it will not work
Any solution ?
Thanks
Klaus