translating-'if today's price is>than previous high price replace with todays' to function

Hi everyone,

Apologies I'm new to this forum and an excel rookie.

I'm trying to find the highest price of a continually updated input.
The function in words is: if today's price is greater than yesterday's price, replace with today's.
The issue I'm having is twofold:
1) While, the input is constantly changing, I need to manually input a starting high price, which can be used as a 'base' to be compared to the continually changing input until the changing input moves beyond this 'base'.
2) While using a simple IF function I can replace this manually inputed 'base' high price when the constantly changing input is greater than the 'base' price; but then I don't know how to lock that new high in before it changes. I need the new high to be locked into a cell until it is usurped by a higher price.

I hope that is sort of clear.

Thank you so much.

Have a great day everyone.

Kind Regards,

Tom

Hi Glenn,

Thank you for replying so fast.
Please find attached, my best go at the above problem with you're instructions implemented.

Thank you

Kind Regards,

Tom

Hi Ali,

Thanks for getting back to me.
The results I want to see totally depend on what the 'constantly changing Price' is. It could be a a year before the 'constantly changing Price' goes above the base high, or it could be a couple of hours before a 'constantly changing price' replaces another 'constantly changing Price' in the highest price of input. I just need whatever the highest price at a given second to remain in a cell until a higher price comes along.

Thank you

Best Wishes

David

Yes, until another higher value comes along.
What's VBA?

Thank you

Hi,

apologies didn't realise VBA meant a Macro. I've been meaning to try and teach myself Macro's for a while so I guess this is a good reason to do so.
I'll have a really good crack at it myself and if you don't mind come back if I get stuck.

Thank you for the help.

Best Wishes,

Tom