Forums

General Betting

There is currently 1 person viewing this thread.
kenwood
20 Dec 09 16:58
Joined:
Date Joined: 25 Jul 06
| Topic/replies: 27 | Blogger: kenwood's blog
anyone used this have tried fracsoft this weekend and is a pile of poop!!
just trying to get some histroical in-play data for premier league matches in football...???
help much appreciated.

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 7
By:
Roman.Totale
When: 20 Dec 09 17:10
I've downloaded it but like you i'm having trouble manipulating it into a useable resource.
By:
kenwood
When: 20 Dec 09 17:14
cant even get it started really the opening part where it says opening th cache, just takes forever
By:
JML
When: 20 Dec 09 17:53
It does take a long time the first time you start it.
By:
brendanuk1
When: 20 Dec 09 18:21
cant you just import into db?
By:
Roman.Totale
When: 20 Dec 09 18:31
Are you on about the data from data.betfair?

What's fracsoft?
By:
kenwood
When: 20 Dec 09 18:47
yes the betfair data, fracsoft site offering the same service
By:
dogform
When: 21 Dec 09 10:47
If you open the Betfair Historical data file by double clicking the csv file name or using "file - open" it will probably use excel to try to open the file unless you do not have csv files associated with excel. The issue with excel is that the csv file contains too many records for a single worksheet unless you are using excel 2007 or later.

Another option is to open it with something like ms access or any other database where you can get round the 65536 row limit of excel 2003. However, once you have the csv file into your database then you need to clease the data as there can be some data integrity issues. The bulk of it is OK but it still definitely needs cleansing.

Finally, Betfair changed the delimiter format of the csv file in mid July 2008, it is now enclosed in quotation marks but prior to the change was delimited by commas.

Good Luck !
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com