Can i calculate a trailing stop without broker?

Quote from golfnutz:

it's not magic, but there is an add-in program for excel which will pretty much automate what you want to do, plus a bunch more.

google "XLQ"

I'm a user but not otherwise affiliated with this product.
More...

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.
 
Quote from minmike:

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.
More...

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
 
Quote from barnetda:

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
More...

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.
 
Quote from minmike:

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.
More...


that looks like it works.

thanks so much for helping me. much appreciated.
 
You must log in or register to reply here.
Back
Top