Gruss Forum • View topic

by **tamrood2000** » Tue May 19, 2009 4:10 pm

Hi Gary & All

Is it possible using Excel to put a bet straight into the SP market

If i read the help right

example
Odds 50
Amount £10
Back-SP

Will try to match in normal market and only at off go to SP market

I ask as the SP market settles on time bet placed. Not sure if this is in SP market or just put in.

Also if you use BACK-SP-IP does this put you in at the settled SP market price Inplay or the odds you asked for.

Many Thanks

by **GaryRussell** » Tue May 19, 2009 4:51 pm

You cannot put an SP bet straight in. The best you can do is use the -SP trigger. eg. BACK-SP and request odds that have no chance of being matched. As soon as the market goes in play it will be backed at SP.

BACK-SP-IP is not a valid trigger -SP and -IP are mutually exclusive, it has to be one or the other. BACK-SP will convert to SP if not matched before the off and BACK-IP means don't cancel the bet after the off. ie. they are both actions to be taken after the market turns in play: keep the bet or convert to SP.

by **doris_day** » Mon Jun 15, 2009 1:17 pm

On that score is it possible to place a bet at a price, for instance of SP+10% ?
If not directly, can you suggest a way then I can place a bet IP of as near as damnit, the last matched price before the off plus, say, 10% ?

by **GaryRussell** » Mon Jun 15, 2009 1:31 pm

Make sure you are using version 1.1.0.62, if not download it using the link below.
http://www.gruss-software.co.uk/Betting ... t_Beta.msi

When you set up the link to Excel you have the option to include extra columns, SP is one of them. This column will show the actual SP after the market turns in play so you just need to check the market is in play and use the odds from this column plus 10% or whatever you want.

by **doris_day** » Mon Jun 15, 2009 1:43 pm

Magic....Thx....

by **doris_day** » Mon Jun 15, 2009 2:08 pm

Just one additional thing, can I round my price to the nearest Betfair tick value ?

by **GaryRussell** » Mon Jun 15, 2009 2:13 pm

You would need to write some VBA code to do this if you want to see it in your spreadsheet, but Betting Assistant will automatically round the odds when placing the bet so you don't have to worry about supplying valid odds.

by **doris_day** » Mon Jun 15, 2009 2:22 pm

Thought so but just wanted to check.....thx again....

Using Betfair SP Market from Excel

Using Betfair SP Market from Excel

Who is online

Sports betting software from Gruss Software