NZ Betfair sp historic data

Post Reply
Luke.B
Posts: 100
Joined: Wed Dec 25, 2019 1:28 pm
Location: Australia

Hi. In the usual SP historic data there are only limited locations
Aus
Uk
Ir
RSA
Etc, where can i find New zealand historic data in a csv format.
The betfair exchange historic data formats are driving me mad..I cant convert into excel...and their excel file to convert is 32 bit only....
User avatar
gazuty
Posts: 2547
Joined: Sun Jun 26, 2011 11:03 am
Location: Green land :)

I didn't think there was SP on NZ (makes it hard to find the historic data when it doesn't exist). ;)
triggers
Posts: 3
Joined: Sun May 24, 2020 11:18 am

To have SP market must go in-play. But NZ markets don't.
But you can use last recorded traded price ("ltp" field) for that purpose:

Code: Select all

{"op":"mcm","clk":"4155307112","pt":1630538468955,"mc":[{"id":"1.187081537","marketDefinition":{"bspMarket":false,"turnInPlayEnabled":false,"persistenceEnabled":false,"marketBaseRate":6.0,"eventId":"30853114","eventTypeId":"7","numberOfWinners":3,"bettingType":"ODDS","marketType":"PLACE","marketTime":"2021-09-01T23:20:00.000Z","suspendTime":"2021-09-01T23:20:00.000Z","bspReconciled":false,"complete":true,"inPlay":false,"crossMatching":true,"runnersVoidable":false,"numberOfActiveRunners":12,"betDelay":0,"status":"SUSPENDED","runners":[{"adjustmentFactor":24.85,"status":"ACTIVE","sortPriority":1,"id":37547246,"name":"1. Tannahill"},{"adjustmentFactor":13.94,"status":"ACTIVE","sortPriority":2,"id":35609581,"name":"2. La Casa"},{"adjustmentFactor":10.84,"status":"ACTIVE","sortPriority":3,"id":40522820,"name":"3. Lord Painton"},{"adjustmentFactor":8.01,"status":"ACTIVE","sortPriority":4,"id":39078006,"name":"4. Tellmesomethingboy"},{"adjustmentFactor":18.27,"status":"ACTIVE","sortPriority":5,"id":39077896,"name":"5. Dragon Realm"},{"adjustmentFactor":2.31,"status":"ACTIVE","sortPriority":6,"id":40599394,"name":"6. Millennium Dawn"},{"adjustmentFactor":19.08,"status":"ACTIVE","sortPriority":7,"id":35880421,"name":"8. Pretty Good"},{"adjustmentFactor":11.49,"status":"ACTIVE","sortPriority":8,"id":785793,"name":"9. Solid Contact"},{"adjustmentFactor":4.06,"status":"ACTIVE","sortPriority":9,"id":24716657,"name":"11. Garnet"},{"adjustmentFactor":3.19,"status":"ACTIVE","sortPriority":10,"id":36640079,"name":"12. Marbuzet"},{"adjustmentFactor":17.51,"status":"ACTIVE","sortPriority":11,"id":12576831,"name":"14. Always Sacred"},{"adjustmentFactor":8.01,"status":"ACTIVE","sortPriority":12,"id":27346472,"name":"15. Lucky Shark"}],"regulators":["MR_INT"],"venue":"Cambridge","countryCode":"NZ","discountAllowed":true,"timezone":"NZ","openDate":"2021-09-01T23:20:00.000Z","version":4007268235,"name":"To Be Placed","eventName":"Cambridge (NZL) 2nd Sep"},"rc":[{"ltp":2.1,"id":35880421},{"ltp":13.5,"id":36640079},{"ltp":4.7,"id":785793},{"ltp":2.2,"id":37547246},{"ltp":2.2,"id":35609581},{"ltp":6.8,"id":24716657},{"ltp":5.5,"id":40599394},

{"ltp":5.2,"id":40522820},
________ˆ
{"ltp":6.2,"id":39078006},{"ltp":2.42,"id":12576831}]}]}

(but you have to match ltp with runners record by id)

or (for BSP markets) "bsp" field of the last record of basic data:

Code: Select all

{"op":"mcm","clk":"4130921588","pt":1630454570486,"mc":[{"id":"1.187050052","marketDefinition":{"bspMarket":true,"turnInPlayEnabled":true,"persistenceEnabled":true,"marketBaseRate":6.0,"eventId":"30850893","eventTypeId":"7","numberOfWinners":1,"bettingType":"ODDS","marketType":"WIN","marketTime":"2021-08-31T23:59:00.000Z","suspendTime":"2021-08-31T23:59:00.000Z","bspReconciled":true,"complete":true,"inPlay":true,"crossMatching":false,"runnersVoidable":false,"numberOfActiveRunners":0,"betDelay":1,"status":"CLOSED","settledTime":"2021-09-01T00:02:31.000Z","runners":[{"adjustmentFactor":12.47,"status":"REMOVED","sortPriority":1,"removalDate":"2021-08-31T21:20:38.000Z","id":40689623,"name":"7. Lovettorleaveit"},{"adjustmentFactor":2.64,"status":"REMOVED","sortPriority":2,"removalDate":"2021-08-31T21:20:43.000Z","id":40689625,"name":"13. Banks Road"},{"adjustmentFactor":27.61,"status":"LOSER","sortPriority":3,"bsp":16.5,"id":8471663,"name":"1. Kaharau"},{"adjustmentFactor":16.74,"status":"WINNER","sortPriority":4,"bsp":2.93,"id":20045402,"name":"2. Amazing Az"},

{"adjustmentFactor":9.73,"status":"LOSER","sortPriority":5,"bsp":4.97,"id":3759988,"name":"3. Fantasy Flight"},
_______________________________________________________________ˆ
{"adjustmentFactor":4.4,"status":"LOSER","sortPriority":6,"bsp":43.88,"id":22042012,"name":"4. Rodmar"},{"adjustmentFactor":6.82,"status":"LOSER","sortPriority":7,"bsp":19.42,"id":25178981,"name":"5. Lacustre"},{"adjustmentFactor":10.62,"status":"LOSER","sortPriority":8,"bsp":7.6,"id":1090511,"name":"6. Beau Geste"},{"adjustmentFactor":1.26,"status":"LOSER","sortPriority":9,"bsp":46.11,"id":25388002,"name":"8. Keepella Heights"},{"adjustmentFactor":8.97,"status":"LOSER","sortPriority":10,"bsp":32.0,"id":21484085,"name":"9. Zenntari"},{"adjustmentFactor":5.49,"status":"LOSER","sortPriority":11,"bsp":15.43,"id":11011015,"name":"10. Carnaby"},{"adjustmentFactor":8.32,"status":"LOSER","sortPriority":12,"bsp":25.16,"id":24914846,"name":"12. Tahuroa Height"}],"regulators":["MR_INT"],"venue":"Matamata","countryCode":"NZ","discountAllowed":true,"timezone":"NZ","openDate":"2021-08-31T23:27:00.000Z","version":4005869478,"name":"R2 2600m Hcap","eventName":"Matamata (NZL) 1st Sep"}}]}
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

NZ horses WIN mkt has SP
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

I probably shouldnt have told gazuty that.

Goodbye edge.
User avatar
gazuty
Posts: 2547
Joined: Sun Jun 26, 2011 11:03 am
Location: Green land :)

Anbell wrote:
Thu Oct 21, 2021 10:13 am
I probably shouldnt have told gazuty that.

Goodbye edge.
Thanks, will turn on NZ now. :)
Post Reply

Return to “Betfair Data”