A repo to scrape and import Betfair data to SQL Server
Python script to extract Betfair data from https://promo.betfair.com/betfairsp/prices and insert to SQL Server
1: Install Microsoft SQL Server 2019
2: Install SQL Server Management Studio
3: Create Database and table for data
4: Scrape the Betfar Promo files and insert to SQLS
The script is pliable allowing the user to select either UK, IRE, AUS Horse Racing data - both win and place markets
Run the .py script via your favourite IDE or run via the command line
When prompted enter the start / end date of the data you would like to import
-
Returns & Liability Creates a view to show back & lay returns including liability at BSP
-
Traded Volumes Creates a view to analyse traded volumes
-
Group Traded Volumes Breaks down traded volumes by year, month & weekday