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
Avatar
becker
Beginner
Members
Forum Posts: 27
Member Since:
August 22, 2015
sp_UserOfflineSmall Offline
1
November 19, 2019 - 12:27 pm
sp_Permalink sp_Print
0

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
ArtTest
Moderator
Moderators

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

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

Arthur

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

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
ArtTest
Moderator
Moderators

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

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
becker
Beginner
Members
Forum Posts: 27
Member Since:
August 22, 2015
sp_UserOfflineSmall Offline
5
November 19, 2019 - 1:43 pm
sp_Permalink sp_Print
0

Ok, solved it! Thanks for helping 🙂

Avatar
Lord Dio
Ultimate
Members
Forum Posts: 121
Member Since:
October 23, 2019
sp_UserOfflineSmall Offline
6
November 19, 2019 - 2:21 pm
sp_Permalink sp_Print
0

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
Lord Dio
Ultimate
Members
Forum Posts: 121
Member Since:
October 23, 2019
sp_UserOfflineSmall Offline
7
November 19, 2019 - 2:29 pm
sp_Permalink sp_Print
0

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

Avatar
Lord Dio
Ultimate
Members
Forum Posts: 121
Member Since:
October 23, 2019
sp_UserOfflineSmall Offline
8
November 19, 2019 - 4:10 pm
sp_Permalink sp_Print
0

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

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

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: arnoldx, cunningstunts, thomsch, Neil, @capitalchrisw, rhino88, berzaplow
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Lord Dio: 121
leewillo75: 92
@capitalchrisw: 72
des911: 64
Callum: 62
Neil: 50
jamiep: 49
gurds1991: 48
chasanddave: 48
jb8426: 47
Newest Members:
deereckjof
craigash
androidemex
milchgeldmafia
anthonypuppy
norvezhskiydomteert
kenchov
haroldedump
anotherdarkhorse
martin
Forum Stats:
Groups: 5
Forums: 24
Topics: 257
Posts: 2049

 

Member Stats:
Guest Posters: 3
Members: 4662
Moderators: 2
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest, davefts