Forum Discussion
how to auto update STOCKHISTORY on multiple sheets?
Hi Insiders, I'm trying to use STOCKHISTORY for different stock on different sheet, and get ticker and date from a single "home" sheet. When I change the date on "home" sheet, it updates the STOCKHI...
SergeiBaklan yes, the idea is when i change the current, all the sheets will be updated to the latest history
When I misunderstood what "it updates the STOCKHISTORY formula" means. With reference on another cell formula will be exactly the same if you change only the value in referenced cell.
- i believe the STOCKHISTORY cell formula got updated, but the sheet won't get updated until i manually go click each STOCKHISTORY cell and execute.
Let me clarify. In Sheet1 we have something like
In Sheet2
If I change Sheet1!B4 on any other date formula immediately shows another dates range.
If to change the ticker
it also updates
Or you mean something else?
From 6/7/2021 To 5/7/2022 Ticker AA AAPL ABBV ADM sheet 1
sheet 2
sheet 3
=STOCKHISTORY(A1,Home!B1,Home!D1,0,1,0,2,3,4,1,5)
this formula is somehow in the "Date" cell.
Hope this is clear.
Thanks,