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

Welcome to Live View – Take the tour to learn more
Start Tour
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.
Pause • Switch to Standard View Data: getting gibberish /jibberish...
Show More
Loading...
Report Ghetto Joe • March 9, 2011 9:40 PM GMT
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
Report Ghetto Joe • March 9, 2011 9:42 PM GMT
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.
Report MissingRibOfPrince • March 9, 2011 9:45 PM GMT
Thanks Joe, ho about WinZip, would that help?.
Report MissingRibOfPrince • March 9, 2011 9:45 PM GMT
*how
Report Just Checking • March 10, 2011 12:58 AM GMT
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.
Report Artisan • March 10, 2011 7:06 AM GMT
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.
Report manxy • March 10, 2011 9:01 AM GMT
office 2007 has 1.2 million rows in excel and the files open fully no problem
Report MissingRibOfPrince • March 10, 2011 6:07 PM GMT
Progress!. Can read it with WinZip now, might still be cutting off the end though,but improvement. Thanks all
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com