How do I update a formula to start a new calulation?

English
#1

Based on the new “date”, how can I update two columns (F and G) at the start of a new day.
I have been copying the status/percentage from the website and I now have that working fine.

I just don’t know how to update based on a new day.

Thanks for any suggestion or help with this.

Enclosed is my sample file.
how to update status-percent.ods (38.3 KB)

#2

So that every new day it took the last stock price of yesterday?
EDIT: Not yesterday, but last day closed.

#3

I replied with a simple “yes” to your question, but it was rejected for to few words.

But I was only answering to your question. Hopefully, this one passes the test.

BTW - thanks for looking at it. Hopefully, it will be a easy solution.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.