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....
NZ Betfair sp historic data
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:
(but you have to match ltp with runners record by id)
or (for BSP markets) "bsp" field of the last record of basic data:
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}]}]}
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"}}]}