EXCEL SL question

[Bucksy]

Howdy y'all;

I am running a simple but working Back-Lay automated system in soccer games.
Now, since my surebets are matched at a time with low danger (pretty firm down trend) I almost never got in jeopardy but I am sure Murphy is waiting when I raise my stakes.

I try to protect Murphy's chaos theory event by a simple stop loss modified trigger.

The back trigger I am using is
=IF(F5=R5;"BACK-TL2-SL3";"")
My prefered odd range is pretty tight (back 1,04/lay 1,02), so 2 ticks.

BA perfectly places the back bets, first pending, then unmatched, followed by matched.
BA not allways places the unmatched lay bets (not even pending) but I guess I can live with that if this happens not too often.

1.
The main issue now is that I can't (never) see my SL indicator when checking the ladder chart after my back bet has been matched. Do I do anything wrong or do I have to set some special preferences to ensure my SL will chatch me up in a reverse trend event?
Is there any indication that my SL has been activated?
I can see the stake at my lay bet odd waiting to be matched - is it different with the SL indication?

2.
If the lay bets that should catch me up are suddenly all above my pre-set SL, will BA SL-me at the best (loss) SL-price being available at the particular time or leave the SL pending until the price comes down to my desired SL odds?

3.
How can I ensure my pending bets will still be active/refreshed (after a suspended market); does the IP modifier extension do it?

I have to add that my refresh rate is set to 0.5 seconds and that I most likely run one workbook with several worksheets simultaneousely because in-play soccer games that I need start often at the same time and are therefore different than horse and greyhound races to be handeled.

Thank you for your support in advance.

Cheers,
Frank

P.S. I somehow love BA's Excel trigger features.

[GaryRussell]

1.
The main issue now is that I can't (never) see my SL indicator when checking the ladder chart after my back bet has been matched. Do I do anything wrong or do I have to set some special preferences to ensure my SL will chatch me up in a reverse trend event?
Is there any indication that my SL has been activated?
I can see the stake at my lay bet odd waiting to be matched - is it different with the SL indication?

I assume you are viewing this on a separate tab page or another instance of Betting Assistant. You wont see the indicator in another tab page or instance because they do not know about the stop loss being active. You would see it if you switched to the ladder on the same tab page that is linked to the spreadsheet, but you would have to close the link first so I do not recommend it. The only way you can see if there is a stop loss active is to select the stop loss options tab in betting options. The cancel stop loss button will have a red background.

2.
If the lay bets that should catch me up are suddenly all above my pre-set SL, will BA SL-me at the best (loss) SL-price being available at the particular time or leave the SL pending until the price comes down to my desired SL odds?

Example: back at 1.1 with a stop loss of 3 ticks.
If the best back odds go straight past the stop loss odds of 1.13 to 1.15 then the stop loss will be placed at 1.16 (1.15 plus 1 tick).
You need to be aware that the stop loss will not be placed at all if the odds go higher than double the back odds. For example if your back bet is matched at 1.04 the stop loss cannot trigger if the odds go higher than 1.07 (1.08 minus 1 tick). If the odds go down again it can still be triggered.

3.
How can I ensure my pending bets will still be active/refreshed (after a suspended market); does the IP modifier extension do it?

I assume because you are backing at low odds that all your bets are placed while the market is in play. The -IP modifier has no effect when the market is already in play, the bets will be cancelled on suspension.
There is no facility for BA to handle this automatically for you so you would need to handle all the bet placement yourself. ie. don't use the -TL and -SL modifiers and just use "BACK" and "LAY" to place the offset and stop loss bets yourself which may require some VBA coding.

BA not allways places the unmatched lay bets (not even pending) but I guess I can live with that if this happens not too often.

Are you a non-UK user? There is a problem with the API affecting international users where some bets are being missed. See http://www.gruss-software.co.uk/forum/v ... php?t=4521

[Bucksy]

Hi Gary;

Thank you so much for your speedy and very helpful response.
Your answers do help me a lot to set-up my trades accordingly.

Regarding 2.
Since in soccer games the trend changes drastically especially after a team scores, the SL may be canceled anyway because the market is suspended during such event and I think I can forget about a SL catching me up at all and I don't need a loss anymore anyway when the trend comes down to my tight operation range because at such time I am close (again) to my desired 2 ticks profit.

Regarding 3.
I would love to do it like this but the only thing I know about is some Excel macros. I am not a pro @ VBA and can only open the VBA editor
In the event some one here has a simple command line for this I appreciate to receive it and I can modify it to my desired parameters.

Finally, yes I am a non-UK user and I operate from Germany.
I never got an error message but "Canceled".
I will watch it closely in the future, even I want a bot for the fact to avoid watching hard attack situations and cut-off emotional reactions, and send you related log files of such error events.

Thank you again for your very professional support.

Cheers,
Frank