Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save danielkorzekwa/1718398 to your computer and use it in GitHub Desktop.
Save danielkorzekwa/1718398 to your computer and use it in GitHub Desktop.
Getting markets for calculating probabilities
--get markets for calculating probabilities
select event_id,full_description,scheduled_off, selection_id,selection from markets where sports_id=2 and event='Match Odds' and full_description like'%/Mens%' order by event_id
--insert market probabilities to mssql
BULK
INSERT market_prob
FROM 'C:\daniel\betfair_data\tennis_prob_data.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW=2
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment