View Full Version : Form into Excel
evajb001
15th January 2014, 02:49 PM
Hi guys,
I've looked around at a number of form providers to replace the form I was able to import to Excel for free from cyberhorse. It seems there are only 2 that have the detail I'm after to make my ratings and/or systems work however I fear I may have some trouble getting them to import both correctly and smoothly.
I'm hoping/wondering some kind soul out there is able to help me get the form importing into excel in a useable manner much like Shaun's sheets did for cyberhorse or do for sky racing. Any assistance would be greatly appreciated however if nobody has the spare time etc then i'll have to give it a crack myself. I'm just worried my VBA knowledge, or lack of, may mean that it doesn't run as smoothly as it could/should.
I'm not sure I can post the names of these form providers here so i'll post my email address for anyone thats interested.
Cheers
aussielongboat
15th January 2014, 07:05 PM
I'm interested - so please post your email address
evajb001
15th January 2014, 07:37 PM
jbevans @ internode . on . net
will explain more via email once i hear from you aussie, cheers.
aussielongboat
16th January 2014, 12:06 PM
did you get my email
evajb001
16th January 2014, 12:49 PM
certainly did, will reply after work
mattio
17th January 2014, 06:59 AM
I use the Bet Selector data to do my ratings, it has all the form factors I need (plus the pre-post prices and UNITAB ratings if you want to use them) all neatly available in CSV format. $55/month is money well spent.
stugots
17th January 2014, 10:49 AM
I use the Bet Selector data to do my ratings, it has all the form factors I need (plus the pre-post prices and UNITAB ratings if you want to use them) all neatly available in CSV format. $55/month is money well spent.
Mattio, don't suppose there's anywhere to get a sample of a CSV file as I am interested in what detail they provide.
blackdog1
18th January 2014, 08:11 AM
Mattio, don't suppose there's anywhere to get a sample of a CSV file as I am interested in what detail they provide.I asked for a sample csv file but was told I needed BetS to use the form files. There is a free version of BetS available to do that.
The sample files provided were dbf files not csv. still usable in Excel.
I take it they were already processed by BetS which uses dbf data files.
If you are winning, then $55/M is not too bad, if losing, well any additional cost is an added burden.
mattio
18th January 2014, 08:21 AM
stugots,
Email me at mat at sportofkings dot com dot au.
blackdog1,
Correct, you do need their software to get the CSV data but I have a spreadsheet and macro designed to pull the DBF data straight into excel which then feeds my ratings master file. Yes it's $55/month and you have to be winning to make it work for you.
Cheers,
Mat.
Vortech
18th January 2014, 09:02 PM
I use the Bet Selector data to do my ratings, it has all the form factors I need (plus the pre-post prices and UNITAB ratings if you want to use them) all neatly available in CSV format. $55/month is money well spent.
The only problem is the data is incorrect most of the time
mattio
18th January 2014, 09:27 PM
I don't know what data you are referring to but I never have a problem with it being incorrect for the data I use from it. I also don't think Neale would appreciate comments like that either, if you have an issue you should contact him rather than post negative comments on a public forum.
Vortech
18th January 2014, 09:39 PM
From the testing I completed against other databases I found errors with starting prices and final dividends.
If you don't have any issues - that's great.
I've done my own analysis and suggest others to do the same.
If you run the results from Bet S vs CP database you see variances.
Chrome Prince
19th January 2014, 07:35 PM
I won't comment on the other software, but simply point out that RaceCensus is double checked with it's data to ensure accuracy.
There could be a couple of reasons for differences, but usually it's due to errors not picked up in other software which is flagged in RaceCensus.
I always urge clients to contact me if they were to find any errors, this is a very rare occurrence indeed.
lomaca
20th January 2014, 06:13 AM
I've used the software (Neil's) in the past and had no great problems with it. His prices then were from the NSW TAB, that's why there may be a difference?
Form downloads, unless you get it processed from places like CP, the Wizard or others do have errors in them, your software has to be able to identify those.
Lord Greystoke
20th January 2014, 06:11 PM
I use the Bet Selector data to do my ratings, it has all the form factors I need (plus the pre-post prices and UNITAB ratings if you want to use them) all neatly available in CSV format. $55/month is money well spent.what pre-post prices Mattio?
Cheers LG
vBulletin v3.0.3, Copyright ©2000-2025, Jelsoft Enterprises Ltd.