• Hi Guest Just in case you were not aware I wanted to highlight that you can now get a free 7 day trial of Horseracebase here.
    We have a lot of members who are existing users of Horseracebase so help is always available if needed, as well as dedicated section of the fourm here.
    Best Wishes
    AR

Capturing live "In-Play" data . . .

UK-21 UK-21 .... just downloaded a copy although had no time to study as yet. At this point in time it does look very good and I certainly think that you are blessed with many skills. Must be great to be able to do something like this. I am an ardent admirer and will have a look at my copy when I get a little more time. Great work UK21 and many thanks for your free download. :drinks:
 
No. Just go into the (advanced) file properties and clear the string in the "Hyperlink Base" field. Think I must have had a bad day dropping that in.... 😫
 
..... pardon me if I appear a little slow. Can you advise please where this is and how I get to the mentioned file? I am no excel expert. :crazy:
 
Pleasure . . . . hit the File menu in the top left hand corner of the main window - in the info screen find the "Properties" menu - hit the drop-down - select "Advanced Properties" - in the pop up screen select the "Summary" tab at the top - find the "Hyperlink Base" field at the bottom and then zap the contents. See below . . . a picture paints a thousand words . . . Job done !!👍

SS1.jpg

ss2.jpg

ss3.jpg
 
..... thanks for the info. Got there but there does not appear to be anything in the link. It looks completely empty. ;)
 
All good then? If when you click on one of the match duration times you have a dialogue box pop up asking you about an external link, the bug is still in there (somewhere). Perhaps I added in the string after I'd uploaded the file to the server, in which case the download version won't contain it. It doesn't now. That senile dementia certainly creeps up on one . . . . . . 🤔
 
UK-21 UK-21 .... hi there young fella, I insist on calling you that so don't laugh! I have been having a look at your wonderful sheet and trying to find where things go. Got everything I think but the highlighted area, which I am not sure about. Does it start at line 75 and finish at line 119, I'm not quite clear so some advice would be great. Thanks. ;)
 
You don't need to designate anything - once you've highlighted the contents of the blue rectangle (on the SkyBet match page), hit "copy", and then just switch back to the Excel workbook and hit the UPDATE button. The VBA code will drop the data captured into where it needs to go. Once done, if you click on the snapshot time it links to the raw data and you can see exactly in which cells on the gamesheet each update is dropped.
 
Last edited:
More of my pennies going South . . . . took a punt on the Mirandes -v- Fuenlabrada from the
Spanish Segunda. Here are the starting stats:

Mir-v-Fue.jpg

On the strength of these, and the bookies pricing, I had a couple of quid on an away win and a sneaky
quid on a one-nil home win; on the grounds that the home side might get one before the away side and
then sit on things whilst aiming to hold this score until the final whistle? Mirandes went one-nil up after
nine minutes. Here're the In-Play snapshots for the second half:

Mir-v-Fue(in-Play).jpg

Looking at the trend line, one could be forgiven for thinking that the home side spent most of the second
half playing for the one-nil win, and it was all defence? Despite what the numbers were telling, Mirandes put
in a second one with just eight minutes of normal time to go - with the result that my punt went south. ☹

So another case of a last fifteen minute event throwing things. My wife thinks I should give all of this shit
a miss. I'm beginning to think she's probably right.

Hmmm . . . .
 
Last edited:
UK-21 UK-21 ..... thanks for the info you provided above, I will have a play around with this. I don't think your line of thinking was that far out judging by the stats. Just looks like one of those freak games that so often turn up and prove the stats wrong. I do love your Excel work, it really is great and you must be highly satisfied to be able to carry out such highly skilled strategies. :handgestures-thumbup:
 
You must log in or register to reply here.
Back
Top