Tag: spreadsheets

Spreadsheets alone can’t win games

Spreadsheets alone can’t win games

When John Henry took over Liverpool football club I was intrigued to see how things would pan out.

I had known for a number of years that Liverpool had net underspent in comparison to their peer group in the Premier league. This meant that they were likely to start slipping down the league as their competitors had much more fire-power when it came to the transfer market. I often detail this knowledge at the start of each season and you

07/10/2015 | By | Reply More
Using Bet Angel to autotrade score-lines in football

Using Bet Angel to autotrade score-lines in football

Last season I knocked up a spreadsheet that did something interesting.

I didn’t realise at the time, but it turned out to be one of my more popular posts and videos. Basically it used Guardian and our spreadsheet integration to create an  imaginative overview on an underlying football match.

I do this sort of stuff all the time to examine all manner of markets. Stepping back from the just the numbers and looking at another representation of the market can …

18/08/2013 | By | Reply More
Visualising sports trading data

Visualising sports trading data

You may have noticed my regular theme of visualising data. Why do I do this?

The reason is simple, it’s easy to pick up patterns when you are looking at them visually. If you have to plough through billions of rows of spreadsheets, pivot tables or outputs from a database, you may find some of the more obvious patterns may elude you due to number blindness. Visualise it and it often leaps right out at you.

Bet Angel contains a …

23/01/2013 | By | Reply More
Champions league is back

Champions league is back

Yippee! Tonight we have the first leg of the knockout phase of the champions league. I am positively moist with excitement! What a horrible clash though, with valentines day! I fear that valentines day will win tonight but the football will win tomorrow.

I’ve been doing a lot of work on pre-off activity on the football recently, I thought I would take a fresh look at things. It’s surprisingly how you uncover new things when you return with fresh eyes. …

14/02/2012 | By More
Internationals

Internationals

I had my own international experiance last night when I met up with Howard Hamilton from Soccermetrics. A dedicated group of stats experts huddled in a pub in Fulham to discuss all things football related. Could have done with a quieter pub!

With so many international matches going off at once, or at best close to each other, you may consider using a generic strategy that you can automate. All this can be done in practice mode as well, …

07/10/2011 | By More
Look, no hands…

Look, no hands…

One upshot of Betfair’s recently decision to increase their rake from more successful users like myself is that I have revisited my love of interacting on the exchanges with spreadsheets.

I have taken some time out from ‘normal’ trading to work on spreadsheets a bit more. This is to see if I can create something that works fully automatically for me where the payoff will now be particularly high as it takes none of my time to execute. When something …

19/08/2011 | By More
Why not be a robotrader?

Why not be a robotrader?

For some time Bet Angel has had the capability to link to Excel. It’s not just a link, you can custom write tools, views of the market and all manner of wonderful things in a spreadsheet and get it to ‘talk’ to Betfair vis Bet Angel.

The Microsoft Excel integration not only allows you to view a market in Excelm but also trigger bets from the spreadsheet through Bet Angel. This isn’t just simple triggered betting however, we also allow …

10/03/2009 | By More
Hypersmash.com