Startdate input problem

65 views
Skip to first unread message

Klaus Fink

unread,
Jun 10, 2020, 1:49:14 PM6/10/20
to Google Finance
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


Reply all
Reply to author
Forward
0 new messages