What do you use ??

[excelhasey]

Good morning all can I ask when creating your own spreadsheets triggered by certain Odds conditions, do you :-

(A) Would you trigger a Back bet using Back Odds 1 or Lay Odds 1 column ??

(B) Would you trigger a Lay bet using Back Odds 1 or Lay Odds 1 column

(C) Or would you trigger bets using the Average Last Priced Matched column ??

(D) Do something else ??

[alrodopial]

Pure logic:

If the difference is 1-2 ticks the market is "mature" so you can use either back/lay odds for your trigger since they are "the same".
If the gap is larger there is no way to know what is it's "fair" price so what ever you use you are "correct".

[excelhasey]

Thanks Alrodopial,

What is the best way to write into my Excel spreadsheet something to ensure there is only a difference of 1 or 2 ticks to get a "mature" market ??

[alrodopial]

Here it is:

http://gruss-software.co.uk/forum/viewtopic.php?t=3016

[doris_day]

I think your answer could be a Yes and No to all those conditions. It really does depend on what relationship your algorithm is looking at. Think through the steps of your conditions in a logical way yourself, trying to imagine each possibility and the answer will come naturally.

[johnnic]

FWIW, my Excel triggers always include a check of which is the "better" bet, ie back or lay. I achieve this by simply testing which provides the higher return at the time of taking the bet. eg If the back and lay prices are in cells F4 and H4 respectively, I would include an IF statement along the lines of IF(F4-1)>1/(H4-1),"BACK","LAY").

The then, else statements (BACK,LAY) are not quite that simple but I hope you get my point. If not, drop me a line and I'll be happy to explain further.

John

[excelhasey]

Just a thought but if you want to Lay and you use the last matched odds as your Laying odds and someone mistakingly offers 1,000 on a short priced favourite, which obviously gets matched, then I too would then automatically offer 1,000 and my Lay would be triggered - correct ??

As that would be a nightmare scenario has anyone got any advise / better ideas ??

Thanks

[johnnic]

If you accept the last price traded then, as you say, you could potentially be offering a bet that you don't really want to make.

A better alternative might be to set the formula such that the odds you are offering to trade are the minimum (in the case of a lay bet) or maximum (for a back bet) of the current price and the last price. For example:

=IF(Q14="BACK",MAX(F14,O14)IF(Q14="LAY",MIN(H14,O14),""))

John

PS Did you get my earlier response to your private email?

[excelhasey]

Thanks John,

Yes I got post mate - What you said makes good sense, everything helps thank you