Jul 06 2022 01:19 AM
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 STOCKHISTORY formula but won't run the formula. I have to go to each sheet click STOCKHISTORY to get updates for each ticker. Any way to automate the update on each sheet?
Thanks
Jul 06 2022 01:39 AM
Do you mean within STOCKHISTORY formula you have the reference on the cell with date in another sheet?
Jul 06 2022 02:56 AM
@Sergei Baklan yes, the idea is when i change the current, all the sheets will be updated to the latest history
Jul 06 2022 03:02 AM
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.
Jul 06 2022 03:16 AM
Jul 06 2022 03:37 AM
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?
Jul 06 2022 04:51 AM
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,
Jul 06 2022 05:30 AM
It works in my case, please check attached
Jul 06 2022 05:35 AM