Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

General Betting

There is currently 1 person viewing this thread.
MissingRibOfPrince
09 Mar 11 21:08
Joined:
Date Joined: 19 Mar 06
| Topic/replies: 1,506 | Blogger: MissingRibOfPrince's blog
Does anyone here use the BF data site?. I am trying to look up a few football prices from a couple of weeks ago. I have Excel. When i clicked download the relevant link on the data site, it opens in Excel, but all i get is Greek/weird letters. I figure this might be because Excel has only 65,000 or so lines, but i remember being able to read the data a few years ago when i last tried (trying to see the prices matched before the event going in play). Is there any quick fix to this?.  I know there is a fracsoft thing where you can view markets in running, but this isnt what im really looking for, its the long table of prices matched on the various football markets.
Any ideas?. I'm not the most computer-savvy person around. thanks.

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 8
By:
Ghetto Joe
When: 09 Mar 11 21:40
Are you sure the files downloaded correctly and weren't corrupt? As far as I can remember the files are csv files so basically just a big text file. There are programs out there that'll split the large csv files into more manageable csv chunks if the file is too big. google csv splitter or download from http://www.fxfisherman.com/downloads/csv-splitter-1.1.zip
By:
Ghetto Joe
When: 09 Mar 11 21:42
here's the instructions for it

To run the exe, you will need .Net Framework Version 1.1 installed in prior.

Instructions:

1. Fill in necessary information:
CSV file: the path to the CSV that you wanted to split.
Number of lines: the maximum number of lines/rows in each splitted piece.
Max Pieces: limit the number of output files. '0' is unlimited.

2. Click "Split Now!", and that's it. You can find the splitted pieces in the a new folder of the same directory of the CSV file.
By:
MissingRibOfPrince
When: 09 Mar 11 21:45
Thanks Joe, ho about WinZip, would that help?.
By:
MissingRibOfPrince
When: 09 Mar 11 21:45
*how
By:
Just Checking
When: 10 Mar 11 00:58
A CSV is a text file, you could split manually or look at it yourself to see if it looks rubbish or just too big.

Also if there is a limit in an OLD excel version you run you might want to look at the open office equivalent for free, it might (I don't know) support > 65000 for nothing. All excel would be doing anyway with a CSV it converting the text to excel format.
By:
Artisan
When: 10 Mar 11 07:06
I import into Access and then export/import to Excel the stuff I want(after some Access filtering) to play with.  That deals with the size of the file issue, but as said above, if you're getting gibberish that may imply something else, because if I try and load a large file directly to Excel, I just get the first 64,000 rows; so although it's missing data, it's not gibberish.
By:
manxy
When: 10 Mar 11 09:01
office 2007 has 1.2 million rows in excel and the files open fully no problem
By:
MissingRibOfPrince
When: 10 Mar 11 18:07
Progress!. Can read it with WinZip now, might still be cutting off the end though,but improvement. Thanks all
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