Sportsbook xml feeds

**jairocon** · 02-02-11, 09:17 AM

Can a person take couple of these xml files and somehow have excel match them up - match for match - comparing /recording odds and their changes? Or is that too much of a headache?

**chachi** · 02-02-11, 09:21 AM

prob too much of a headache ... team naming and whatnot varies so much

**jairocon** · 02-02-11, 10:35 AM

Originally posted by chachi

prob too much of a headache ... team naming and whatnot varies so much

So do you then write a program for it? Or would MS Access be able to do it? (sorry if it's a stupid proposition - I'm a complete noob to this). Is there some public example of how to make use of these xml streams?

**chachi** · 02-02-11, 10:59 AM

total programming job and not really something for a newbie programmer to approach from scratch.

automatic matching off of XML feeds with variance in team names is not an effort for the faint hearted and borderline an art form to get it right.

take the two or three you are interested in, filter out the leagues/sports you dont want, and just cut/paste/sort them by hand

**FreeFall** · 02-02-11, 11:57 AM

Originally posted by chachi

total programming job and not really something for a newbie programmer to approach from scratch.

automatic matching off of XML feeds with variance in team names is not an effort for the faint hearted and borderline an art form to get it right.

take the two or three you are interested in, filter out the leagues/sports you dont want, and just cut/paste/sort them by hand

I think this problem sounds really easy. Gather all your data and store it in structures per book. Then run it through a translator that changes depending on the books formating to your "universal" format that you want to see.

**chachi** · 02-02-11, 12:20 PM

in broad strokes, yes that is the task. auto-matching team names is a bit more of a task than you make it out to be though

**Flight** · 02-02-11, 10:37 PM

The programming idiom you require to solve cross site naming discrepancies is termed different depending on language/environment.

In C++ STL, a map container is what you want to map team names between each other.

In C#, a dictionary is perfect for the task.

In Excel, lookup tables would be used, with each row representing a team and each column representing a different translation of that team's name across sites (eg UND, ND, Notre Dame, Notre Dame Fighting Irish, etc etc). Then you simply lock that sheet up read only and make static lookups from another sheet. Did I mention I hate Excel for this type of thing? Anything above simple calculations quickly becomes mess.

Regardless of method, the solution requires programming experience and skill.

**2Bdown** · 02-02-11, 11:02 PM

nice thread, useful stuff here, thanks

**2Bdown** · 02-03-11, 11:54 AM

Originally posted by SportsInsights

SportsInsights.com now provides another way to get real-time line updates. We offer packages that allow you to tap into our platform and receive odds in XML format of any of the sportsbooks we offer on the site. You can also gain access to an XML feed of our comprehensive injury database. Please visit the site or contact us for details.

please stop pimping your $200/month service on here

**FreeFall** · 02-03-11, 12:42 PM

Originally posted by Flight

The programming idiom you require to solve cross site naming discrepancies is termed different depending on language/environment.

In C++ STL, a map container is what you want to map team names between each other.

In C#, a dictionary is perfect for the task.

In Excel, lookup tables would be used, with each row representing a team and each column representing a different translation of that team's name across sites (eg UND, ND, Notre Dame, Notre Dame Fighting Irish, etc etc). Then you simply lock that sheet up read only and make static lookups from another sheet. Did I mention I hate Excel for this type of thing? Anything above simple calculations quickly becomes mess.

Regardless of method, the solution requires programming experience and skill.

I'd prefer to use a scripting language with regular expressions.

**chachi** · 02-03-11, 12:46 PM

that does help freefall, but depending upon the sports involved there are massive differences which a loose-enough regex causes too many false positives, especially in euro football where some may be "man utd", some "manchester united", some "man u", etc

**Flight** · 02-03-11, 01:28 PM

In a scripting language, the concept of a dictionary still applies. Anything that supports key/value pairs. In perl you would use a hash table.
$hash{'key'** = 'value';

**Flight** · 02-03-11, 01:31 PM

For some reason SBR converts right curly brace to ** ??

**splash** · 02-08-11, 01:17 PM

Originally posted by Flight

But how did you find the URL for lines.bookmaker.com?

No one has mentioned an XML feed for that site before

That helps me out a lot, thank you

I emailed bookmaker and asked them if they have an xml feed, hahah. Only problem is that I couldn't figure out what some of their abbreviations stand for and support won't tell me.

**jgilmartin** · 02-08-11, 01:39 PM

Originally posted by splash

Only problem is that I couldn't figure out what some of their abbreviations stand for and support won't tell me.

I have a pretty good handle on it now; what are you having trouble with?

**splash** · 02-08-11, 02:00 PM

Originally posted by jgilmartin

I have a pretty good handle on it now; what are you having trouble with?

Well I actually haven't looked at the feed in a long time but just taking the first item on the list right now.

voddst= visitor moneyline
hoddst= home moneyline
ovt= over line
ovoddst= over odds
unt= under line
unoddst= under odds
vsprdt= visitor spread
vsprdoddst= visitor spread odds
hsprdt= home spread
hsprdoddst= home spread odds
vspt= ??
vspoddst= ??
hspt= ??
hspoddst= ??
voddsh= visitor decimal moneyline?
hoddsh= home decimal moneyline?
vsprdh= visitor decimal spread odds?
hsprdh= home decimal spread odds?
ovh= over decimal odds?
unh= under decimal odds?
vsph= ??
hsph= ??
voddshr= ??
vsprdhr= ??
ovhr= ??
vsphr= ??
btot= ??
bsprd= ??
bml= ??
haschild= ??
related= ??

**jgilmartin** · 02-08-11, 02:14 PM

Originally posted by splash

voddsh= visitor decimal moneyline?
hoddsh= home decimal moneyline?
vsprdh= visitor decimal spread odds?
hsprdh= home decimal spread odds?
ovh= over decimal odds?
unh= under decimal odds?

Correct. For the decimal spread and total, they combine the handicap and the odds in one value, unlike the way they output American odds. Strange.

The rest of them, though - I don't know. They are either True/False values or (from every game I've gone through so far) blank/"0".

btot / bspread / bml - Clearly referring to a total, spread, and moneyline, but what could the 'b' stand for? So far they've always been 'False' from every game I've looked at.

**jimmythehand** · 06-22-11, 02:10 AM

hi guys, i'm from sportspunter.com. We sell xml feeds, and can also provide look-up facilities which will convert any variation of a team or player into a common format.

**rsigley** · 07-24-11, 10:41 PM

related = "True" means you can't parlay it
hasChild = "True" means they offer alternate bets (1h, 5i, etc.) for it. sets it up so you can't parlay 1h with fg line

i've never seen a true on bml etc so no idea what it means. i even set it up so if its ever true tto store the info into a database but it hasn't happened since their original domain got seized

**dr_wolf** · 07-24-11, 11:07 PM

An example something to run can be shown?

**himeshforex** · 07-25-11, 04:35 PM

nice publicity it has become for sports punter, my experience with them is crap

**Frogger** · 01-04-12, 09:56 PM

awesome info

**rushhh** · 12-12-12, 05:08 PM

I would like to know if there is still available odds feeds out there for less than 450€/month like people are selling them.

I am specially interested just for Bwin or Interwetten.

Pinnacle has them for free, which is awesome, but they are very late.

**HUY** · 12-13-12, 08:39 AM

Originally posted by rushhh

Pinnacle has them for free, which is awesome, but they are very late.

What do you mean "late"?

**chachi** · 12-14-12, 02:32 AM

interwetten does as well ...

**rushhh** · 12-14-12, 07:11 AM

@Chachi: I wrote to interwetten, but they said they don't offer xml odds feeds. Could you tell me on private how to get them. I was looking bet-at-home would also we awesome. Still waiting for answer from them.

@HUY: Pinnacle doesn't put odds out until market is built from other bookmakers. Moreover, they don't have moneyline for every sport.

**rushhh** · 12-14-12, 07:11 PM

Chachi can you send me your contact(skype) or something, because i can't send you PM. Please. And delete this post when you see it too.

Thanks.

**rushhh** · 12-15-12, 12:13 PM

I found unibet(loads really slow), bet-at-home, nordic-bet odds feeds. I can exchange them for bwin or maybe tipico. I need coverage for one specific bookie sports and only those cover all. Thats why i need one of them so bad.

Thanks in advance.

Best regards

**RonPaul2008** · 12-15-12, 01:19 PM

In DonBest there is a an option for 'private feeds' and you put in a URL. What is a private feed and is it possible to get this for any well known books out there that are not on don best (yeah, I have one in mind)?

**rdgarza** · 12-26-12, 01:00 AM

Originally posted by BetWeather

Even hosts like a Go Daddy $4.99 account supports ASP and MS-Access Databases.

Maybe this is a stupid question but, you can use a web hosting service to store your databases, but also to have the web scraping scripts to automatically fill the database?

**jgilmartin** · 12-26-12, 02:35 AM

Originally posted by rdgarza

Maybe this is a stupid question but, you can use a web hosting service to store your databases, but also to have the web scraping scripts to automatically fill the database?

Yes. For example, you could write a PHP script that scrapes a web page and writes the data to a mySQL database. Then you could create a cron job that runs the PHP script automatically at a time interval you set.

**danger** · 12-29-12, 08:16 AM

XML feed issues

The gamebookers XML feed seems to have gone away. Was anyone else using this? Is there a new url? Here is the old one I had.

http://xml.gamebookers.com/activeodds.xml

Also, pinnacle seems to be much more aggressive at blocking IP addresses. I have been doing a partial fetch once/minute for years with no issues, then in the last month I keep getting blocked. Their support has been surprisingly unhelpful and telling me why I am blocked or what the rate limit is.

Is anyone else seeing this? Any keys to not getting rate limited?

Here are other XML feeds I have had good success with

http://smarkets.s3.amazonaws.com/oddsfeed.xml

bet-at-home Slots

http://www.bet-at-home.com/oddxml.aspx?lang=en

bet-at-home Slots has the greatest selection of casino games from all the popular categories: Video Slots, Classic Slots, Jackpot Games and more!

2025 March Madness Betting Lines | BOOKMAKER SPORTSBOOK

http://lines.bookmaker.eu/

JOIN BOOKMAKER get $500 CASH welcome bonus.

Any other updates to the list posted two years ago?

**jgilmartin** · 12-29-12, 02:11 PM

Are you sure you are being blocked? I have had issues with the Pinny feeds timing out over the last month. This goes for the XML feed as well as the API (which you can make calls to every 5 seconds). Pinny is notorious for server problems.

**danger** · 12-29-12, 02:36 PM

Yes, I have multiple IP addresses in several countries. Once one gets blocked, it stays blocked until I either ask pinnacle to unblock it, or if I stop making requests, it unblocks itself after about a week. It is happening sporadically to all of my IPs, except one which has escaped so far.

This fails on IPs that are being blocked.
telnet xml.pinnaclesports.com 80

**strixee** · 10-29-14, 09:26 PM

Is it possible to get bet365 feed somewhere? Or is becoming an affiliate the only way to obtain it?