Excel - Show the race going

[eduardoneco]

Hello everyone.... Is it possible that the spreadsheet show us the going (good, soft, hard, etc.) of the race??? Another issue that I have is if it possible that in the same spreadsheet I can have the win market and the place market???

I can´t find this options to select them...... This kind of feature is something that I need for my new system (in-play trading).....

Thank in advance.......

[MarkRussell]

Hi,

Sorry the "going" is not available in the Excel data feed because Betfair don't supply it.

Because the Win and Place are separate Betfair markets you need to load them into Excel separately which can be the same Workbook just different Worksheets.
You would then need to do a lookup between the sheets to get the all the data into one sheet.

See my post in the following thread:-
http://www.gruss-software.co.uk/forum/viewtopic.php?f=5&t=8246

Regards,
Mark

[eduardoneco]

Thanks Mark....

So, the betfair can't "show" the going... The only way I see to get this working is a manual input..... I will try, then......

Again, thank you very much.....

[MiniBlueDragon]

You could also scrap the going data from another website in VBA using "createDocumentFromUrl" and then navigating the structure to get to the Going data in the website.