Can i calculate a trailing stop without broker?

thanks for the info. I actually have live feeds to excel via TOS .

Just want to manipulate the info some way.

 

IF you want excel to do it, go into

tools options calculations

Check max iterations and set it to 1


Than have price feed in one cell.

In the next cell have the formula

=max(pricefeed/ "cell you are in")

This will store the high price for you.

Hope that helps.

 

hi

i have followed your instructions but i seem to have missed something.
i get An error in the cell.

My data is in cell AQ100 . i have typed in cell AR100 =max(pricefeed/aq100) is that right?

thanks

 

No. If you made the changes in settings, you would need

in cell ar100 = max(ar100,aq100)

It makes a cicular refernce, but with those settings changes, it won't come back an error. That way when the price hits a new high, AR100 will increase to teh new high and stay there.

 

that looks like it works.

thanks so much for helping me. much appreciated.

 

My pleasure.