Betfair Data : Cleaning & Renaming Betfair CSV Files

Post Reply
Posts: 465
Joined: Wed Apr 15, 2009 11:00 pm

Tue Jan 23, 2018 4:57 pm

Works with Uk & Ire Win markets.

1. removes all entries that have no BSP (special markets such as head to head/lengths beaten etc)
2. renames all files to their actual race dates
3. sorts by event ID & Bsp smallest to biggest
4. saves the files as excel worksheets

It checks that each file has 17 columns and does actually contain data. Some files such as 24/12 and 25/12 are undertsandably empty, but there are also some where all racing has been abandoned. These files will not be processed.


1.Create a folder on your c drive and call it CSV Files.
2. Press the blue button and navigate to where you keep your original files. Don't double click on it, just select it and press "confirm"

You'll see a list of all processed files along with their new name and also any that have not been processed.
You do not have the required permissions to view the files attached to this post.

User avatar
Posts: 10177
Joined: Sun Aug 09, 2015 10:57 pm

Tue Jan 23, 2018 5:02 pm

Great work Nigel :)

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest