Getting all football markets / runners onto one line per match

[CRMORE]

Hi,

I've been able to build an application that successfully requests marketCatalogue data and MarketBook data. But because each match has multiple markets and "runners" it can run on too many lines and I'd like to get it all on one line. Even just using simple Match Odds as an example.

Basic process is MarketCatalogue request, build data table, build data grid, MarketBook request imports prices

So for example: I'd get the following (columns are event ID, event, market, runner (i.e. selection), selection ID, back price, lay price)

999, Arsenal vs. Leicester, Match Odds, Arsenal Win, (0)123, 1.89, 1.90
999, Arsenal vs. Leicester, Match Odds, Leicester Win, (2)789, 3.50, 3.55
999, Arsenal vs. Leicester, Match Odds, Draw, (1)456, 4.50, 4.55


But what I'd like to do is have the following (columns are event ID, event, back home price, lay home price, back draw price, lay draw price, back away price, lay away price)

999, Arsenal vs. Leicester, 1.89, 1.90, 4.50, 4.55, 3.50, 3.55

I'm sure this must be possible but just cannot work out how to do it. Any suggestions greatly appreciated.

[jabe]

Did you get anywhere with this?

You might manage to get everything on one line for events with few runners (Match Odds, over/unders, etc), but some you won't. Are you restricting the returned markets or getting all of them? Are you interested in all of them?