Bet Angel - Example spreadsheets : Update Spreadsheet with latest scores

Example spreadsheets and comments on example spreadsheets.
Post Reply
User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm
Location: Morden, London

Wed Sep 14, 2011 5:13 pm

Hi All,

Does anyone know how to automatically (with VBA) update a spreadsheet with the latest football scores.

Paul

mikelenard
Posts: 33
Joined: Fri Apr 24, 2009 7:12 pm

Sun Sep 18, 2011 6:07 pm

Through VBA I'm not sure but you could record a Macro and do it that way.

I use Excel 2010. Go to the Data tab and create an external connection "From Web". When the Internet box opens up go to "http://www.xscores.net/soccer/soccer.js ... =sportData" where you'll see the live results. Select the small yellow icon with a tiny arrow in it to the left of the header of the main live scores table, a tick will appear. Then in the bottom right hand corner select "Import". The window will close and Excel will present you with a table updated when you click on "Refresh All". To refresh quicker go through VBA, or every minute go to "Properties" and select the box "Refresh every" and put in 1 minute.

Hope that helps.

Mike

User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm
Location: Morden, London

Sun Sep 18, 2011 6:43 pm

Hi Mike,

Thanks for that - I tried something similar with another website.

Anyway, I have since written some VBA which retrieves the latest scores. However, only once. When I click the button after that I doesn't work.

The attached spreadsheet was used yesterday in a Bet Angel workbook. Maybe, Bet Angel can explain why the button only works once per session....

Paul
You do not have the required permissions to view the files attached to this post.

User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm
Location: Morden, London

Sat Oct 15, 2011 3:55 pm

Here is my latest scores file.

Please can someone check live...now.

Update scores - test by clearing scores when goal is scored, update again.

Doesn't work on my PC. I have to save, quit excel, load again before it works - what is my problem.

Paul
You do not have the required permissions to view the files attached to this post.

User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm
Location: Morden, London

Sun Oct 16, 2011 11:25 pm

OK, if anyone is interested - I have solved the refresh problem.

I have to remove the webpage url from cache - which allows a refresh. So, after a big change in price of say the draw odds I can now force a refresh the score from that football match to keep the scores in the spreadsheet up to date. I'll leave the manual refresh button as well.

If there is a requirement for my solution, then please post here and I will upload another spreadsheet with user guide...

purpletrader
Posts: 12
Joined: Wed Apr 15, 2009 5:16 pm

Mon Oct 17, 2011 10:24 am

I would love to try the new sheet, been trying something similar with vba but my brain exploded :o

Innertube
Posts: 215
Joined: Mon Mar 14, 2011 9:18 am

Mon Oct 17, 2011 10:36 am

I'd be really interested as well.

User avatar
pdupre1961
Posts: 410
Joined: Fri Feb 18, 2011 8:01 pm
Location: Morden, London

Mon Oct 17, 2011 12:52 pm

Scores_18-20Oct2011.xls
Here is another example for this week's midweek matches (includes Champions League, Europa League and English League Matches), with user guide. Manual update button - I will post more examples later, and also update this one with match IDs when available.

Always open to suggestions that other Bet Angel users may require...
You do not have the required permissions to view the files attached to this post.

purpletrader
Posts: 12
Joined: Wed Apr 15, 2009 5:16 pm

Mon Oct 17, 2011 1:11 pm

Thanks pdupre

If the first weekend sheet with prices could be updated It would be ideal, also is possible to adapt it to tennis?

Many thanks

jcp7743
Posts: 13
Joined: Tue Jan 26, 2010 10:32 pm

Mon Oct 17, 2011 4:09 pm

Good work - this could help me with automated strategies that require score lines. Thanks

Post Reply

Return to “Bet Angel - Example spreadsheets”

  • Information
  • Who is online

    Users browsing this forum: Mortal and 1 guest