Football trading : Betfair football trading - Visualising data

Football, Soccer - whatever you call it. It is the beautiful game.
User avatar
Euler
Posts: 16444
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

Sat Feb 02, 2013 2:01 pm

BetAngel_Multiple_visualisation-inplay.zip
You do not have the required permissions to view the files attached to this post.

DakotaC47
Posts: 7
Joined: Sat Jun 04, 2011 6:29 pm

Wed Feb 06, 2013 2:43 pm

Thank you for uploading the spreadsheet. The more I look at it, the more I realise what an impressive piece of work it is.

Thank you very much.

PeterLe
Posts: 3377
Joined: Wed Apr 15, 2009 3:19 pm

Thu Feb 21, 2013 9:19 am

Hi
I was trading the Barca V Milan game last night.
It involved placing a largish bet on the match odds and one on the 0 - 0 correct score.
By half time, the odds had dropped on the 0 - 0 from around 17's down to 5's. Although I was hoping for a goal as part of the strategy, I found I had a negative figure on the match odds but a much bigger overall green across all selections on the correct score (it was about a £65 + delta overall)
At no time during the first half did my overall position drift into a negative.
The only reason Im mentioning this is because, it shows the power of linking markets and being able to see at a glance whether you are in a net positive position. It would be fairly easy to insert a form button into the front dashboard worksheet to "Green All". (although you may want to close the markets down in a particular sequence)
Worth thinking about and incorporating some form of overall P&L position into the spreadsheet
Regards
Peter

Anka
Posts: 23
Joined: Fri Aug 10, 2012 6:09 pm

Mon Feb 25, 2013 1:12 pm

DaffyDuck19 wrote:Hi all

I really liked the look of the spreadsheet so had a go at creating my own based on the one in the video.

Shared if others want to use/play with/develop as they wish.

Just link Correct Score, Match Odds and 0.5-6.5 goals markets to the appropriate sheets.

Hope its useful.

Any feedback welcomed.

DD19
Nice work. Congratulations !

Scratchy1989
Posts: 1
Joined: Sun Apr 28, 2013 4:09 am

Tue Apr 30, 2013 9:23 am

DaffyDuck19 wrote:Hi all

I really liked the look of the spreadsheet so had a go at creating my own based on the one in the video.

Shared if others want to use/play with/develop as they wish.

Just link Correct Score, Match Odds and 0.5-6.5 goals markets to the appropriate sheets.

Hope its useful.

Any feedback welcomed.

DD19
Hey DD,

New to bet angel, and was really interested in your excel template. I'm having trouble linking the correct score, match odds, and 0.5-6.5 goals markets to the appropriate sheets. I was hoping you could help me out.
Thanks

DaffyDuck19
Posts: 7
Joined: Wed Jul 06, 2011 3:42 pm

Tue Apr 30, 2013 1:15 pm

Scratchy1989 wrote:

Hey DD,

New to bet angel, and was really interested in your excel template. I'm having trouble linking the correct score, match odds, and 0.5-6.5 goals markets to the appropriate sheets. I was hoping you could help me out.
Thanks


Hi Scratchy

I'm not going to try and guess as to your BA or excel knowledge, or guess specifically at what point in linking you are having issues.

It might be worth a quick look at this BA video first as this is an excellent video showing how to link to excel using guardian to multiple sheets.

http://www.youtube.com/watch?v=EF0UQm-w ... 7&index=19

If after seeing this and trying again you are still having issues then give us a shout and I will try and help. Although my instructions on linking are exactly whats highlighted in this video.

Good luck

DD

h4cked
Posts: 1
Joined: Thu Aug 08, 2013 6:59 pm

Thu Aug 08, 2013 9:07 pm

Hi

sorry to ask a newbie question but im having trouble getting this spreadsheet to link to betangel

I have downloaded the sheet to the desktop. then opened up Swansea v Manu for the 17th August and match odds then tried to 'open the workbook' it says does not contain a Bet Angel worksheet.

any advice? many thanks

maxblack
Posts: 5
Joined: Mon Jul 05, 2010 8:13 am

Wed Aug 14, 2013 3:48 pm

Ditto here im afraid - open workbook then 'this does not contain a Bet Angel worksheet'.Most perplexing :shock:

6thSense
Bet Angel
Bet Angel
Posts: 375
Joined: Fri Nov 30, 2012 5:02 pm

Wed Aug 14, 2013 5:30 pm

How are you connecting to this spreadsheet? It is designed to be used with Guardian. Make sure you are connecting using the Excel tab in Guardian rather than the main application as it needs data from multiple markets.

You need to add the following markets to Guardian from a single game:

Match Odds
Correct Score
OU0.5
OU1.5
OU2.5

Then assign each market to the corresponding sheet within the Excel workbook by using the drop down list in the Excel column of Guardian.

See the attached image:
Excel-Visualisation.JPG
Also, remember to tick 'Connect' once the spreadsheet has opened in Excel.
You do not have the required permissions to view the files attached to this post.

maxblack
Posts: 5
Joined: Mon Jul 05, 2010 8:13 am

Thu Aug 15, 2013 1:38 pm

Solved immediately! Thank you very much 6th Sense for taking the time to fix this problem

Post Reply

Return to “Football trading”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 5 guests