here is my spreadsheet:
for example
A B C D E F
G
1 Date Open High Low Close

if(and(e3<e2),"Sell"," ")
2 11/20 5 15 5 12
3 11/21 11 20 8 18 =if(and(e3>e2),"BUY","
")
4 11/22 17 17 10 10 " "
5 11/23 10 12 6 8 " "
6 11/24 7 10 4 4 " "


So in Column's F and G the word BUY and SELL would appear if it were true.
Now once I got the buy-sell word how can I take that data represented in E
and test a stop price. For example F3 would read buy, the value at that
moment is 18. HOw can I say stop me out if the price goes to 21 before i get
a SELL signal. Thank you for anyone who can help.





"zmr325" wrote:

> Help,
>
> I am going nuts. I need help finding a way to backtest stops for stocks. I
> used an =if(and()) statement to come up with good entry points on the buy and
> sell side. Now I just need to find a way to write stops. The way I wrote
> the if(and()) statements is that I have the logical statement and then for
> the True it would be either "buy" or "sell". How to write a stop loss would
> get me up and running very quickly. I appreciate anybodies time. Kind of
> new so might be over my head.
>
> Thank you
>