Percentage trailing stop loss

[saivenkat]

Hi excel coders and experts

I am new both to this forum and to excel.. started learning only a few days ago with the help of the online tutorials available.. finding it very interesting to learn...

To try my hand.. prepared a excel file to use it in my swing trading strategy of stocks and indices..

The problem i face.. i to make a TRAILING STOPLOSS COLUMN..I searched the old threads here.. and could find two of them discussing about it.. In the following mentioned thread i could see TSL being discussed but it is not exactly what i am looking for..
http://www.excelforum.com/excel-gene...ling-stop.html

I am attaching the screenshot of the excel file for reference..
re8e.png
Attachment 272346

When the price moved by GREATER THAN 3% from my ENTRY price, then trailing stoploss (TSL) must be fixed at that price. .. and it TSL must remain in that price only .. till the time price moves more than 3% up.

( Suppose my entry price is 100, and current market price is 104 now TSL must be at 103.. [100*3%=103]

Now 103 must be my TSL till price moves up by another 3%.. until price comes to 106.09[103*3%= 106.09]

Can anyone help me to have a formula.. as described above...

Thanks and regards

Saivenkat

______________

Help Ever, Hurt Never
Love All, Serve All

[shg]

	A	B	C
1	Price	TSL
2	$ 100.00	$ 103.00	B2: =A2*1.03
3	$ 100.36	$ 103.00	B3: =(1+3%*(A3>B2))*B2
4	$ 100.51	$ 103.00
5	$ 101.09	$ 103.00
6	$ 101.16	$ 103.00
7	$ 101.28	$ 103.00
8	$ 101.42	$ 103.00
9	$ 101.87	$ 103.00
10	$ 102.64	$ 103.00
11	$ 103.39	$ 106.09
12	$ 103.94	$ 106.09
13	$ 104.33	$ 106.09
14	$ 104.35	$ 106.09
15	$ 104.37	$ 106.09
16	$ 104.52	$ 106.09
17	$ 104.46	$ 106.09
18	$ 105.04	$ 106.09
19	$ 105.45	$ 106.09
20	$ 105.74	$ 106.09
21	$ 105.91	$ 106.09
22	$ 106.26	$ 109.27
23	$ 106.24	$ 109.27
24	$ 106.41	$ 109.27
25	$ 106.61	$ 109.27

[saivenkat]

OMG!.. that was a lightning fast response.. Shg..
Thanks for the help rendered.. And this is the exact kind of it needed..

Regards
Saivenkat


Edit: Sorry to bother again..

If instead of Fixed TSL 3%.. I am to opt for Trailing SL in a Decreasing one.. i mean.. After Initial TSL of 3%, i decrease the Further TSL to 2%.. and when after Price moves to beyond this 2% TSL.. i again modify my TSL to 1%.

If this is the criteria i am tweaking further... how to modify the above said formula..

______________

Help Ever, Hurt Never
Love All, Serve All

[saivenkat]

OMG!.. that was a lightning fast response.. Shg..
Thanks for the help rendered.. And this is the exact kind of it needed..

Regards
Saivenkat


Edit: Sorry to bother again..

If instead of Fixed TSL 3%.. If i am to opt for Trailing SL in a Decreasing one.3%, 2%, 1%... i mean.. After Initial TSL of 3%, i decrease the Further TSL to 2%.. and when after Price moves to beyond this 2% TSL.. i again modify my TSL to 1%.[COLOR="#000000"]

if this is the criteria i am tweaking further... how to modify the above said formula..

______________

Help Ever, Hurt Never
Love All, Serve All

I request forum experts and Gurus.. to have a look in to my request..

thanks