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