How to get football scores

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

If I want to get the score of the football game (which is in - In Play) from the betfair site How can I do this?
Robo29
Posts: 2
Joined: Wed Nov 04, 2009 11:21 am

If you select 'live scores and updates' on the Betair website (found on the top menu ribbon once you select football from the main menu/homepage) it will load up live scores and you can configure it to the games you want/need and it will make a sound when a goal is scored etc.

Rob
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

but how do i connect it to excel?
Green Park
Posts: 24
Joined: Fri Aug 06, 2010 7:31 pm

Googled and found this, but don't ask me anything about XML!

http://forums.digitalpoint.com/showthread.php?t=314899
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

I'm sorry for not beinng clear ...
I'm looking to get results directly from the betfair site itself (what is displayed in green over the odds of the game)
I'm currently using another live score site but i have difficulty linking the scores to the game something which I could easily do if I could take the scores from the BETFAIR site ...
User avatar
Saintyboy
Posts: 7
Joined: Wed Mar 10, 2010 12:10 am

luck7, i too would like to get an answer to this; how can we get live match scores into the spreadsheet so that we can program the sheet to respond when goals are scored?

At the moment my simple sheet detects when the game is suspended but this doesn't differentiate between a home goal and an away goal and gets buggered with red cards!

Any ideas anyone?
Bet Angel
Bet Angel
Bet Angel
Posts: 4031
Joined: Tue Apr 14, 2009 3:47 pm

We have responded elsewhere to similar requests, but Betfair have not given us permission to allow Bet Angel to export this data so you will have to find another way to achieve this.
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

I found a solution ...
If someone is interested contact me via [email protected]
Merry Terry
Posts: 49
Joined: Tue Aug 10, 2010 2:37 pm

Why not post it on the forum instead?
User avatar
mctash
Posts: 101
Joined: Wed May 12, 2010 2:11 pm

The only way I found you can sort of discern the score from betfair is if you connect to the api and get the correct score market odds. You can then deduce from the available odds what the score is. Check which runners in that market have odds of 1000 to back. Its not going to be any of those scores. Watch the correct score market during a match you will see what I mean.

I'm not sure if Guardian can connect to Excel. But if you could monitor the correct score market at the same time you could right some basic logic in VBA in Excel to deduce the score.
Bet Angel
Bet Angel
Bet Angel
Posts: 4031
Joined: Tue Apr 14, 2009 3:47 pm

You can connect as many markets as your PC can handle through Guardian, so this is perfectly possible and quite easy to do.
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

I suppose it's possible ... With not much difficulty to do ...
But what happens if we say the result is 4-2 or 5-0??? So you need to transfer to the correct score 2 market (if it even opened )
My method is different ... Much more simple ...
For information: [email protected]
Last edited by luck7 on Mon Sep 06, 2010 3:13 pm, edited 1 time in total.
Exacta
Posts: 151
Joined: Wed Aug 25, 2010 2:57 pm

Just post it up here then!
seale
Posts: 19
Joined: Sat Feb 20, 2010 6:59 am

I was after this same thing and after spending a stupid number of hours I finally got it sorted.

Via data scraping using VBA I have managed to link in all the live scores from Futbol24 into excel.

I can then add the relevant games into Guardian, and then trade based on the score, time of the match etc.
pashulik
Posts: 4
Joined: Sun Jan 16, 2011 9:11 am

2 Seal. I'd like to build trading strategy based on the score and time of the match. I just newbie in VBA so can you explain how exactly do you manage to link it to Excel? Thank you.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”