A cell's value is automatically linked to the price of X, which is
constantly changing.
How can I capture the highest price of X in a different cell?

For example, if the highest price of X (in cell A1 for example) was 90
and then moved down to 50, cell B1 will show 90. But if the price
moved higher to 100, it will reflect in B1 as well.

Thanks,

AMir