I have a spreadsheet testing trading data for every second in the day. Based on an idicator, I have multiple entry and exit points throughout the day and am trying to create a trailing stop for profitable trades and a fixed exit for losing trades. IE I buy a stock at 700 and set a fixed loss at 695 if price appreciates to 703 my new exit becomes 698 and will never go back down to 695. So if trade goes ot 710 my exit point goes to 705 gaurenteeing me a profit of 5. So on losing side if trade of 700 goes to 695 I exit position. In my spreadsheet i've already created the entry and exit, the fixed stop, trailing buy stops and trailing sell stops I dont know how to make the trailing buy stop stay at the high of that trading period as well as the trailing sell stop stay at the low for a trading period, and then take that info and make that the new exit point.
Enclosed is a sample the spreadsheet I hope someone will take a look at what Ive done already and help with the last portion.
I appreciate any help in this matter.
Tradermike
Bookmarks