Help Required re Triggered Betting To Set Of Criteria

[dogform]

Hi,

Would anybody please be able to advise me if there is an existing excel add on for Gruss that will place bets on a list of selections using the following variable conditions.

1. Market matched bets >= £2500 (variable)
2. Market bet book =< 105% (variable)
3. Time before off =< 30 seconds (variable)
4. Stake calculated by app to return 100% book, ie, £25 on 3/1, £20 on 4/1 etc.
5. Option to bet more than 1 runner per race.
6. Market depth of selections to be within variable selected limits.

Ideally, I would like the application to run unattended from one race to the next, processing the list of selections as it goes at refresh rates just under the data charge level.

I would prefer to stick with a Gruss add on solution but all options considered.

Rdgs
Dog

[Ian]

Have a look at this thread for a spreadsheet Gary has set up for betting specific horses.

http://www.gruss-software.co.uk/forum/v ... php?t=3557

I should think it could be easily adapted for greyhounds and your criteria if they are not already covered.

[dogform]

Ian,

Thanks for the link. I think that it is along the lines of what I hope to get but needs refining.

For example, the stake is pre-determined rather than calculated on a 100% book stake plus some of the other criteria I need are not present. I am sure that it could be used as a starting point but my excel skills are not strong enough for me to try to update it with confidence.

The "Trigger" needs some additional IF and AND statements to get it to meet my conditions or perhaps some extra columns as well as updates to the "Trigger".

I suppose I could put the updates to this workbook as a request to the excel developers sub forum, there should be a few coders there who can update it.

Rgds
Dog

[Ian]

Dog

I'll have a look at it for you over the weekend.

I'm pretty sure your first 5 criteria are pretty simple to implement.

Not sure about what you mean by no 6 though.

Ian.

[dogform]

Ian,

Thx for the kind offer to look at it for me.

Re condition number 6, it refers to the spread between the back and lay price of the selection, apologies for the lack of clarity, I should have phrased it better.

I would like to control the width of the spread between the back and lay price as a condition, for example if the bet price was 3.3 and the lay price was 4.3 that would be 20 units of 0.05. I would like to be able to implement a condition using the minimum and maximum vale for this spread in terms of 0.05 units.


Rgds
Dog

[Ian]

Dog

I'm not sure that will work properly eg 2.1 to back and 3.0 would be less than 20 "units" so would trigger a bet, which I assume you wouldn't want to do.

It would be better to use Betfair "ticks" or have a criteria where the last side must also be greater than, say, 95%.

[Ian]

* lay side > 95%

[dogform]

Ian,

I agree, the Betfair "ticks" scale would be OK.

Rgds
Dog

[Ian]

Dog

I've PM'd you

[dogform]

Ian,

Thx, reply sent.

Rgds
Dog