Recording a highest value ever

  • Thread starter Thread starter Gazman
  • Start date Start date
G

Gazman

Hi everybody, I am trying to set up a little spreadsheet to help trac
my stocks. I would like to input, price i purchased at, todays pric
and a highest ever price. So that if a stock goes up then stalls an
starts to fall I can set a `trailing stop` percentage to which flags m
to sell when the price comes down. Todays price will constantly chang
and I need to set the trailing stop to the highest ever price. I hav
tried but get a circular referance problem with all my efforts.
Thanks for the time
 
Hi
do you have a list of values or do you want to insert the values in the
same cells? Also what formula have you tried?
 
Well Im open to suggestions but I would like my Current price column t
change each morning.
Example, if my stock bought at $5, and then gradually reache
$10(highest ever), but today is at $8 (a figure which i will manuall
input) then if I have set my trailing stop to 80% then this woul
advise me that it is falling so sell!
I think the problem with my formulas is that I want to take the curren
value in the cell into account.
Ideally:
IF purchace price or current price is greater than highest ever the
overwrite highest ever cell
 
Hi
you somehow have to store the highest value ever. It would be much
easier (and would give you an audit trail as well if you would enter
the current price (maybe together with a date) in a new cell
 
Back
Top