Stop loss using Excel formula

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Zecco
Posts: 3
Joined: Mon May 03, 2010 4:27 pm

Hi,

Part of this question been answered somewhere on the forum however the answere is incomplete/not stated.It's a simple one by the way.

Question : I want to BACK if the price is <=1.30 however , I want to set a STOP LOSS as well should the trade go against me for lets say ... 1.80. How do I write this in excel ?

Initial thought : I have tried using : =IF(G9<=1.30,"BACK STOP:50","")

From what I have read on the site , I suspect the stop is not going to work however the BACK order will be triggered. I also gathered I will need to an an OFF SET bet to make it work.

Is anyone able to answer the question by just writing the required formula please ?
User avatar
LeTiss
Posts: 5485
Joined: Fri May 08, 2009 6:04 pm

Do you want greening, offset with batches using fill or kill?
Zecco
Posts: 3
Joined: Mon May 03, 2010 4:27 pm

Perhaps with Greening but nothing else.

Many thanks
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”