excel sheet and code to list football games and O/U 2.5 markets

[fatherbilly]

Hello all.

Looking for a way to create an excel file that will display the names of all soccer games on that day sorted by kick-off time and show back and lay prices for O/U 2.5 odds

No need to place bets, see market P/L, check account balance or any other functions.

Can anyone help or offer their services?

Thanks.

[jabe]

There is an example Excel spreadsheet you can look at.

To get the data you require

1. list all Events for the football EventTypeId (= "1") and restrict by start and end time&date. This will bring back the day's soccer games. You might want to add further restrictions.

2. for each one returned, call listMarketCatalogue, specifying the marketType and EventId. That'll get assorted data, such as the team names and kickoff time, and the marketId.

3. with the marketId, call listMarketBook to get the current prices.

There's a bit more to it than that, but that's the basic plan.

And then you have all the fun of putting it in your spreadsheet.