I'm trying to create a reference cell that always shows the highest parameter from a daily update of numbers.
It is a stockmarket spreadsheet which tracks the movement in the share price. I need one cell to hold the highest price attained over a period of time.
I'm sure that if I simply put a new entry in a new cell each day, that I can have a reference that can looks at this and record the high point but over a long period of time, I'll end up with a spreadsheet hundreds of rows deep. If that's the only way to handle it, then so be it.
However, there must be a better way!
That is, I simply want to show:
1. The original buy price
2. The current price and
3. The highest price achieved to date (from the current price inputs, as the original is also the current price initially)
1 and 2 are inputs and 3 is to be triggered automatically from these inputs.
Can anybody help as I'm a bit of a novice?
Thanks.
It is a stockmarket spreadsheet which tracks the movement in the share price. I need one cell to hold the highest price attained over a period of time.
I'm sure that if I simply put a new entry in a new cell each day, that I can have a reference that can looks at this and record the high point but over a long period of time, I'll end up with a spreadsheet hundreds of rows deep. If that's the only way to handle it, then so be it.
However, there must be a better way!
That is, I simply want to show:
1. The original buy price
2. The current price and
3. The highest price achieved to date (from the current price inputs, as the original is also the current price initially)
1 and 2 are inputs and 3 is to be triggered automatically from these inputs.
Can anybody help as I'm a bit of a novice?
Thanks.