Recording a highest value ever

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
 
F

Frank Kabel

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?
 
G

Gazman

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
 
F

Frank Kabel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top