Forum Discussion

Copper Contributor

Dec 12, 2020

Excel Auto Updates Stop Limit

I am sure there is already an answer out there on the forum for this but I am not sure what key words I am missing to find it. I am working on a Stock Tracker that uses lives updates for my "home...

excel

Formulas and Functions

AshishBatra

Copper Contributor

Dec 12, 2020

Hi andrew165

Not sure this will solve the purpose.

Try this one =IF(TODAY()=TODAY(),"True or Insert text whatever you want to do","0")

On the same day it will show the value you want to show and from next day it will show 0

Please do let me know if it solved the purpose

andrew165

Copper Contributor

Dec 12, 2020

AshishBatra

Firstly, thank you for your reply.

The formula you gave did not correct the issue I'm having, I will try to clarify. I would like the Cell on the home page to feed the cell on sheet 2 which is an easy thing to do, however I am trying to have the cell on sheet 2 retain the value from the cell on the home page at a specific date and time. For instance 12/11/2020 4 P.M EST (market close) and maintain that value while the cell on the home page is updating again the next day and feeding the next cell in line.