I need 6 XML data feeds to be put into an Excel 2010 spreadsheet so that various data from each feed can be compared alongside the same data from each of the other feeds.
The data in the feeds is odds from sportsbooks for sporting events. Each feed has its own values for specific fields/elements/attributes. I want to see a side-by-side comparison of the values of matching fields from each of the feeds.
I would like to collate the 6 sports listed below. For each sport, I would like all markets with 2 or 3 outcomes, except for odd/even score or coin toss type bets.
Sports to collate:
Baseball
Cricket
Rugby League
Tennis
Soccer
Australian Rules
The element or attribute names are not the same in each XML feed, so it will require some work to consolidate, match and map the data. In addition, the data needs to refresh itself regularly (every 5 or 10 seconds if possible). It needs to come from the live feed and not be scraped from the website.
The data could appear like the “sample odds” spreadsheet. There are many websites offering variations of the information I want. Two of the websites which offer similar information are:
[login to view URL]
[login to view URL]
The methodology they use might be similar to what I require. Time should be UTC +10.
Some data (markets) may appear in one feed but not in others. In addition, new events or markets will continue be added daily, with new values and new attribute/element names. So, a method of automatically mapping each new field based on the naming conventions for that particular feed, and then matching it to new data in other feeds would be helpful. In other words, I would like a way of automating the process of adding new events and their odds to the spreadsheet.
Sites to obtain XML streams from:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]