Hi all,
I just wanted to give something back to the Propun forums, albeit a token gesture. I have gleaned so much knowledge and information off here in the last 12 months, I figured I should offer my little contribution, a web query import/form splitter for Excel 2000-2007.
OK, what does it do? Well, I always wondered how screen scraping works. Then I discovered Web Queries.....they allow you get the form and DFS for free (this one is for UniTAB) rather than having to copy and paste it into the spreadsheet manually. Once your used to it, the process takes only a few seconds to load a whole race's information in including the most recent prices.
I've haven't investigated the other TABs but I imagine that with a little reformatting of the cells you can do it easily enough.
The real beauty is that as once you load a race, you can simply right click on the race and click 'Refresh Data!'...and it does....all the prices as they change right up until they jump.
I can tell you how to build the formula to work out what percent is on what horse as you refresh the race details, but that info is already on here...you just need to convert it to a formula....I have and it helps a lot with dutch betting.
Warning for UniTAB punters....the UniTAB site changes format once a race jump time gets within 5 minutes.....as a rule, remember to re-import the race information once the '5 mins to go' message pops up on the web page, or do what I do, and only load races running in the next five minutes.....If it does go pear-shaped, simply shut the spreadsheet down (WITHOUT SAVING) and re-open it.
Give it a crack and if you need any help, e-mail me on
suntzu4@hotmail.com
Good luck,
Neurokahuna