Football trading : Betfair football trading - Visualising data

Football, Soccer - whatever you call it. It is the beautiful game.
RonObvious
Posts: 191
Joined: Mon Dec 09, 2013 4:12 pm

Wed Apr 23, 2014 2:13 pm

Haven't even used this spreadsheet yet but looks great!

Just wondering is it possible somehow to use this on more than 1 matches that kick off at the same time?

User avatar
Euler
Posts: 16102
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

Wed Apr 23, 2014 3:11 pm

RonObvious wrote:Just wondering is it possible somehow to use this on more than 1 matches that kick off at the same time?
You can have as many as you wish (subject to your computers capacity)

RonObvious
Posts: 191
Joined: Mon Dec 09, 2013 4:12 pm

Wed Apr 23, 2014 3:25 pm

I've connected 2 markets to it and it cycles between them every few seconds.

Was wondering if you could have them one below the other? So you could just scroll down to whichever you wanted to view and you'd be able to look at more than one at the same time then

User avatar
Euler
Posts: 16102
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ
Contact:

Wed Apr 23, 2014 4:22 pm

You can but you will have to customise it yourself to suit.

RonObvious
Posts: 191
Joined: Mon Dec 09, 2013 4:12 pm

Wed Apr 23, 2014 4:50 pm

OK cheers.

I'll get onto youtube and see if I can figure it out

User avatar
doncht
Posts: 74
Joined: Mon May 05, 2014 3:57 pm

Mon Aug 04, 2014 12:41 pm

I'm trying to make this work. Can someone please post a link at youtube yet? Image

bariska
Posts: 2
Joined: Thu Sep 25, 2014 3:54 am

Thu Sep 25, 2014 6:44 am

good one , thx a lot ...

taxbreaks1
Posts: 23
Joined: Thu Apr 16, 2009 12:25 pm

Tue Oct 28, 2014 3:44 pm

I am running 64 bit windows it would appear that the excel spreadsheet is 32 bit and will not work is there a work around?

Poj
Posts: 6
Joined: Sat Feb 07, 2015 9:58 pm

Sat Feb 21, 2015 4:36 pm

Hi all,

I'm a newbie to Bet Angel, I am interested in using excel to automate some trades for me so I am just in the process of playing around with the templates.
I have downloaded the 'Visualising Data' spreadsheet and want to use it to trigger some strategies on the football.
My excel programming is not great but I'm picking it up as I go, so far I have downloaded the spreadsheet and linked the markets.
For my first attempt I want the spreadsheet to lay the outsider in a football game if they score a goal.
I started on the main 'Visualisation' sheet and wrote and AND function: If chance of 0-0 cell <1 AND chance of 1-0 < 1. i.e the outsider is 1 up (If they are the Away team)
Next I wrote a command in the match odds sheet: =If 'AND cell' = True, "LAY","")
(I'm sure this can all be written into one simpler command but I'm keeping it as simple as possible to debug until I get the hang of it)
My question is, where should the 'LAY' command be placed to ensure the 'Outsider' is layed and not the favourite or the draw?
Is it simply a matter of placing the command in the cell adjacent to the 'Outsider' on the sheet or should the cell containing the 'Outsider' be referenced in the formula?
Could someone post a link or a sample excel file which contains an excel file with multiple place bet conditions on the one sheet?

Dinkydid1
Posts: 25
Joined: Sun May 28, 2017 11:47 am

Fri Sep 29, 2017 3:50 pm

I have just watched the video on trading time
Do not laugh i am a newbie at me but could you answer me this question on time why do traders lay £2 00 or a small trade on 1000 what is the advantage or even backing at 1000 both pre-off
:D

Post Reply

Return to “Football trading”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest