Greyhounds @ Betfair SP via Excel/Gruss - Is It Possible?

[dogform]

Hi,

Is it possible to place back and lay transactions on greyhounds at Betfair SP using an excel template linked to Gruss?

I have downloaded the "place bets" template and hope to be able to use a modified version of it to place SP bets on a selection list of greyhounds.

Is it just a question of getting the excel template to trigger the bet with submitted odds that will not be matched in conjunction with some type of setting to convert unmatched bets to SP? Or, is it just not possible via Gruss/Excel

The web interface on Betfair has the SP back and SP lay columns available in the greyhound win markets so hopefully there is a Gruss/Excel solution to implement this?


Rgds
dog

[gavind]

Is it possible to place back and lay transactions on greyhounds at Betfair SP using an excel template linked to Gruss?

I think this is not possible yet. Looks like a custom job. May a nice feature to request too by the way.

[Captain Sensible]

All you'd need to do is amend the trigger formula so it'll either back directly into the SP pool or convert to SP at the off if not matched.

I've never used the placebets template so no idea how it's setup but shouldn't be hard at all to amend for SP betting using odds limits or not

[Captain Sensible]

It's just another BSP market so just amend the current trigger to use either LAY-SP/BACK-SP or LAYSP/BACKSP if you want to take advantage of the upper and lower SP limits.

[dogform]

Thanks for the replies.

Sounds promising, would anyone please be able to explain the difference between BACK-SP and BACKSP and the upper and lower trigger limits?


Rgds

[Captain Sensible]

The BACK-SP and LAY-SP triggers send the bet to the SP pool if they are still unmatched at the off. If there are non runners the reduction factor is applied to lay bets and they'll convert to SP bets. Back bets will remain at the odds you submitted regardless of any withdrawals. You can cancel/amend these bets up to the off time.

The BACKSP and LAYSP send the bet directly into the SP pool but you have the option to set parameters as to what [rice you'll accept, if the bet is outside your limit it won't be matched and will lapse. i.e. you set a minimum limit of 10 for a back bet it goes off at 9.8 so won't be matched, you set an upper lay price of 6 it goes off 6.2 you don't get matched.

So both methods have advantages and disadvantages.

[dogform]

The BACK-SP and LAY-SP triggers send the bet to the SP pool if they are still unmatched at the off. If there are non runners the reduction factor is applied to lay bets and they'll convert to SP bets. Back bets will remain at the odds you submitted regardless of any withdrawals. You can cancel/amend these bets up to the off time.

The BACKSP and LAYSP send the bet directly into the SP pool but you have the option to set parameters as to what [rice you'll accept, if the bet is outside your limit it won't be matched and will lapse. i.e. you set a minimum limit of 10 for a back bet it goes off at 9.8 so won't be matched, you set an upper lay price of 6 it goes off 6.2 you don't get matched.

So both methods have advantages and disadvantages.

Thx for the explanation, very useful.

One last point if I may, are there any restrictions on staking amounts when using Gruss/Excel. I think that the Betfair web interface has SP minimum staking limits imposed, do these SP limits apply when using Gruss/Excel?


Rgds
dog

[Captain Sensible]

SP staking limits are at least £10 liability(not payout) when laying and at least £2 when backing or equivalent in your currency, think it slightly higher for Aus users.