ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Stop Loss Formulas for Stock Trading (https://www.excelbanter.com/excel-worksheet-functions/57524-stop-loss-formulas-stock-trading.html)

zmr325

Stop Loss Formulas for Stock Trading
 
Is there any one out here that thinks they can help me with a formula for
finding a stop price for a stock? I have found an indicator for buying and
selling stocks. Now I just want to write a stop loss somehow so I can limit
my downside. My signals for Buy and Sell are pretty simple. In my
spreadsheet I have the date, open, high, low, and close. Off of those
records I used a =if(and( )) statement to determine my buy and sell points.
I wrote them like this =if(and(a3<a2), "buy", " ")and the same for the sell
side. SO then next to my open, high, low, close I have a column that is a
buy column and one that is a sell column. NOw when I get a buy I would like
to write something like this =when(e4=buy, find the value of the close that
period and had say x factor to it for the stop, if the high reaches that
point the exit the trade. Same for the sell side. DOes anybody have some
tips or suggestions. I been working on this for close to 10 hours now and I
haven't gotten anywhere. I am new to excel so would appreciate any help.
Thank you


David McRitchie

Stop Loss Formulas for Stock Trading
 
Multiple posting warning.
This question was also posted in the microsoft,public.excel.misc newsgroup
which had additional information in another post in that same thread..

http://groups.google.com/groups?thre...0microsoft.com





All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com