Welcome to the FTS Forum - Read the introduction here

Avatar
Please consider registering
Guest
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Feed
Topic Rating: 0 Topic Rating: 0 (0 votes) 
sp_TopicIcon
Betfair Historical Data
sp_NewTopic Add Topic
Avatar
Beginner
Members
Forum Posts: 12
Member Since:
August 22, 2015
sp_UserOfflineSmall Offline
1
November 19, 2019 - 12:27 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

I downloaded BF historical match odds markets in *.tar format, but can’t get my head around how to open the files, preferably in Excel. Anyone who has been able to solve this?

 

Cheers

 

Jorgen

Avatar
Moderator
Moderators

Members
Forum Posts: 56
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
2
November 19, 2019 - 12:59 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

7-zip (https://www.7-zip.org/) should do the trick

Arthur

Avatar
Beginner
Members
Forum Posts: 12
Member Since:
August 22, 2015
sp_UserOfflineSmall Offline
3
November 19, 2019 - 1:22 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

ArtTest said
7-zip (https://www.7-zip.org/) should do the trick

Arthur

  

Yes, I have it, but I can’t see how it helps open the files in Excel.

Avatar
Moderator
Moderators

Members
Forum Posts: 56
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
4
November 19, 2019 - 1:35 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

extract the data, then use the file>open option in excel to open it. You may have to set the selection filter to “all files”

The following users say thank you to ArtTest for this useful post:

becker
Avatar
Beginner
Members
Forum Posts: 12
Member Since:
August 22, 2015
sp_UserOfflineSmall Offline
5
November 19, 2019 - 1:43 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

Ok, solved it! Thanks for helping 🙂

Avatar
Beginner
Members
Forum Posts: 53
Member Since:
October 23, 2019
sp_UserOfflineSmall Offline
6
November 19, 2019 - 2:21 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

Am I being thick here guys, I’ve downloaded data and its .tar format and “extracted” it to download folder via this 7-zip program but nothing appears and nothing happens. 

Avatar
Beginner
Members
Forum Posts: 53
Member Since:
October 23, 2019
sp_UserOfflineSmall Offline
7
November 19, 2019 - 2:29 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

Winzip is saying the folder ive downloaded from BF is empty. No idea. 

Avatar
Beginner
Members
Forum Posts: 53
Member Since:
October 23, 2019
sp_UserOfflineSmall Offline
8
November 19, 2019 - 4:10 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

Ok it seems I asked for too much data so Betfair literally did just send me a blank zip, haha. 

Avatar
Beginner
Members
Forum Posts: 12
Member Since:
August 22, 2015
sp_UserOfflineSmall Offline
9
November 19, 2019 - 6:12 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

I use the Historical Data Workbook to open the files. https://github.com/betfair/his…..a-workbook
Read the instructions first!

Forum Timezone: Europe/London
Most Users Ever Online: 92
Currently Online: deano12366
7
Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Callum: 34
des911: 27
jamiep: 27
Beeble: 19
Steve: 18
Nick: 16
Forum Stats:
Groups: 4
Forums: 22
Topics: 117
Posts: 773

 

Member Stats:
Guest Posters: 2
Members: 3803
Moderators: 1
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest