Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 16th June 2014, 12:55 PM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Default Triggered Betfair betting using excel

I have an excel spreadsheet fed with a XML feed of Tatts tote prices. I'm looking for software, that when manually triggered (as in I'm watching Sky for when they're about to jump) places a Lay bet with Betfair at SP. The selections are generated purely by the excel spreadsheet acting upon Tatts prices only, at the time of the trigger event.

Any suggestions?
Cheers RP
Reply With Quote
  #2  
Old 16th June 2014, 02:30 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,424
Default

Hey RP, the problem will be matching the xml feed to the event on Betfair.
Also horse's names on betfair do not contain apostrophes.
I'm sure it can be done using Gruss Betting Assistant and getting the xml feed onto the spreadsheet. The Gruss forum has a developer section, you might be able to get someone to code it for a reasonable fee.
__________________
RaceCensus - powerful system testing software.
Now with over 407,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 30/09/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote
  #3  
Old 16th June 2014, 02:50 PM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Default

Quote:
Originally Posted by Rinconpaul
I have an excel spreadsheet fed with a XML feed of Tatts tote prices. I'm looking for software, that when manually triggered (as in I'm watching Sky for when they're about to jump) places a Lay bet with Betfair at SP. The selections are generated purely by the excel spreadsheet acting upon Tatts prices only, at the time of the trigger event.

Any suggestions?
Cheers RP


Cheers for the advice, I'll post on their forum, and see what sort of advice I get?
Reply With Quote
  #4  
Old 16th June 2014, 05:33 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Gruss can do the job, you could feed your prices in to a sheet and and set up different triggers to control races and prices.

You could use a sheet like this to control all the actions, this one is just designed to place bets using runner names but easy to change to do whats needed.
Attached Files
File Type: xlsm Consensus Ratings Betting.xlsm (63.1 KB, 832 views)
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #5  
Old 16th June 2014, 06:02 PM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Wink

Quote:
Originally Posted by Shaun
Gruss can do the job, you could feed your prices in to a sheet and and set up different triggers to control races and prices.

You could use a sheet like this to control all the actions, this one is just designed to place bets using runner names but easy to change to do whats needed.


Wow!, Shaun looks impressive. I've only glanced at it but to give you and idea of what happens on my excel spreadsheet presently. I trigger a snapshot of current tote prices, They are ranked and compared with criteria. Conditional formatting kicks in and colours selections in the race field that meet criteria. now you've got to remember this might be something like 3 minutes after the official start time (race delayed) and I'm watching it on Sky. For the system to achieve optimum results, I need to trigger Lay SP bets as close to the Close as possible. Once my spreadsheet formats the selections, the biggest bugbear is the time to select and place the bets. That's where I need the software to kick in! I'm not sure if your offering suits, but you'd know, being the developer. If you could make it work for me, I'd be happy to talk privately with regard remuneration for your time.

Cheers and thanks again for your post. I'll have a good look at the spreadsheet in the small hours of tomorrow morning.
RP
Reply With Quote
  #6  
Old 16th June 2014, 06:15 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Biggest issue with any automation is it works based on time, the best you could do is place your bets at the off time, unless you have accurate pictures then you could set up a single button to place the best, as long as you get matched all is good, we could even incorporate importing your data based on the current race selected at a specific time before the race.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #7  
Old 16th June 2014, 07:00 PM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Smile

I'm not after automation as much, as I trigger the selection and ideally bet simultaneously. The excel spreadsheet has done all the work selecting the horses. I just need an instrument to bet on those selections Betfair SP, no need to get matched! For me, the time needed to look at the selection then select them on the Betfair page, enter the liability amount,then Place & Confirm bets could take 20 secs. I need that reduced to less than 3 secs. At present probably miss 50% of bets! .....as the betting is closed.
Reply With Quote
  #8  
Old 16th June 2014, 08:28 PM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Yep can be done simply, better to incorporate it to one sheet with a row of your prices then the SP as such and let it calculate automatically, then all you need to do is press one button to send the bets, less than 3 seconds.

You can request a 30 day trial of gruss, once you done that e-mail me shaun2166 at hotmail we can talk about your needs, shouldn't take long to do, will use that sheet as a template and strip out the automation.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
  #9  
Old 20th June 2014, 09:56 AM
Rinconpaul Rinconpaul is offline
Banned
 
Join Date: Feb 2013
Posts: 755
Default

Quote:
Originally Posted by Chrome Prince
Hey RP, the problem will be matching the xml feed to the event on Betfair.
Also horse's names on betfair do not contain apostrophes.
I'm sure it can be done using Gruss Betting Assistant and getting the xml feed onto the spreadsheet. The Gruss forum has a developer section, you might be able to get someone to code it for a reasonable fee.


Yes, you're right about the apostrophes CP, a horse called Sunday's News on Tatts is written as Sundays News on Betfair.

Also a scratching on Tatts remains listed in saddlecloth order but Betfair drop the scratched horse to the bottom of the list.

These sorts of issues seem the biggest obstacle, triggering the bet not so. Will keep working on it.
Reply With Quote
  #10  
Old 20th June 2014, 10:22 AM
Shaun Shaun is offline
Member
 
Join Date: Jan 1970
Location: Western Australia
Posts: 3,456
Default

Not really an issue, a formula like this can be used to manipulate data stripping out what's not needed and formulating it for Gruss to be searched

=AI5&". "&SUBSTITUTE(RIGHT(AC5,LEN(AC5)-FIND(" ",AC5,1)),"'","")

The thing you find is late scratchings are not removed but have a tag of (NR) after the name, still no drama with searching.
__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out."
--moeee
_______________________________________________
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:53 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655