Have you typed-in www.betfair.com recently? I have and, over the last couple of days sometimes it comes-up with the exchange site that we all love/hate, - but more often than not it's also directed me to their "lovely" new fixed-odds "sportsbook" site with only a small button on the top-left to allow people to go to the exchange? Today, we seem to have the exchange back at the forefront, but what will appear tomorrow, I don't know.

Look at the screenshot here. Can you see the tiny little "Go to exchange" button?

So, perhaps the exchange is being relegated to only a bit-part player in Betfair's new and improved vision? If so, then it doesn't make a whole lot of sense. Their selling point, their originality and innovation was the exchange. It was ground-breaking at the time and is still the reason that they have so many regular customers betting and trading on their site. So to suddenly plonk that summarily to one side and push the fixed-odds side and start swimming with the throng of other standard bookies out there, well it all seems rather bizarre. How are they going to differentiate themselves from Ladrokes, William Hill and Bet365? What do they have to offer straight punters that aren't being fully serviced by the normal high-street bookies already? And can they really be advertising the "best odds", but then direct people to the fixed odds site where they most certainly do not have the best odds? I don't think so.

Okay the good stuff first. Pinnacle are by far and away the best bookies out there. Winners seem to be welcome, the given odds are good, it's possible to get large amounts on without being restricted or banned, they have really decent Asian offerings and cover a large selection of sports and markets. All excellent stuff and well done to them.

Oh, and by the way, if you're one of those people who often submit straight bets on Betfair, then my advice to you would be to stop doing that immediately. Take away the 5% (or slightly less) commission that you happen to give to Betfair, then the odds really do not compare to those offered by Pinnacle. If you were to transfer all your straight betting to Pinnacle lock, stock and barrel then, over the long run, you will win more money with Pinny than you could ever do with Betfair. Trading is another matter of course, but when comparing straight bet value, then it's not even a competition.

As you may have guessed, there is a "but" in all of this. Pinny themselves I have no bad word to say... but as for their website. Well, that's a different matter altogether. Any of you who have Pinnacle accounts and do any regular betting on there will may well be familiar with this particular page:

It drives me absolutely batty. Select a country and a league, spend fifteen or twenty seconds selecting one or two events and markets on that page, add-in your stake, then click submit. Oh, sorry, the money-line has changed in that time, and consequently the site has silently wiped-out all your stakes and so you're submitting no bets. Aaargh!

Now I do realise that Pinny is extremely price sensitive, but often this "refresh" of the odds doesn't even move the odds at all. It's simply a wipe and start again, but for punters who don't jump on a page, select their markets, enter their odds and submit within a few seconds, then there's a decent chance that they will have to do it all over again as their actions weren't within the designated "window".

This is slightly ironic of course as their website is just about the slowest site I've ever been on. I once saw a snail stuck in super-glue inside a wind-tunnel making more headway than Pinnacle's website. It's shockingly sluggish (or "snailish" should I say?). For all the money that must be passing through the site, I'm sure they could invest a few pennies to get someone to design a site that doesn't piss people off.

The Ultimate Football Database
Like many of you out there, I have a whole raft of spreadsheets and workbooks that I use to help me with my betting and trading. Many of them have been developed over a long period of time and are quite rich in features and heavy with data. However, some of them have now started to creak a little as I'm asking a little bit too much from them and they are not really up to the job.

Thus, I've decided to spend much of my time recently to writing a new all-singing-all-dancing database for all my lovely footy stats. Indeed, I’m finding myself spending every spare minute in the design/redesign and coding of the whole thing – which will at last combine all the usual football data, my prediction algorithms and – more importantly – all my score time data into one huge beast of a database that will surely result in me ending-up a multi-millionaire and driving my yacht around the Caribbean islands. Or perhaps not. We’ll have to wait and see.

For those technical people amongst you, I’ve decided to use MySql for my database and PHP for my access into it – and I have to say it’s great fun. I’ve been spending hours poring over my tables, re-shaping and normalising them, and all the tweaking and honing is going well. I’ve also managed to cobble together a working mechanism to automatically pump all the data from football-data.co.uk plus all my score time data into to one CSV file so that I can load a full and rich data set for each match directly into my database in one go. Once I have five years worth of data for all the major leagues around Europe in place, I will be a happy man indeed, and it will then be a case of maintenance. It's quite a big project but one that I'm sure will be well worth it when it's finally finished.

As a consequence of said database, I haven't been as fully focused on my trading as I perhaps I should. It's wrong, but I find myself already looking forward to next season, where my new database will be ready to unleash and hopefully bear fruit.

Below is the last seven days P/L. Profits are decidedly small but that's the way it goes sometimes.

Football: £203.14  Total P&L:  £203.14

Football Showing 1 - 20 of 27 markets
Market Start time Settled date Profit/loss (£)
Football / Tottenham v Newcastle : Correct Score 09-Feb-13 12:45 09-Feb-13 14:41 32.73
Football / Tottenham v Newcastle : Over/Under 3.5 Goals 09-Feb-13 12:45 09-Feb-13 14:41 4.34
Football / Union Santa Fe v Arsenal FC : Correct Score 08-Feb-13 22:10 09-Feb-13 00:26 2.40
Football / Watford v C Palace : Correct Score 08-Feb-13 19:45 08-Feb-13 21:43 20.33
Football / Watford v C Palace : Over/Under 3.5 Goals 08-Feb-13 19:45 08-Feb-13 21:17 11.23
Football / Watford v C Palace : Over/Under 2.5 Goals 08-Feb-13 19:45 08-Feb-13 21:14 0.00
Football / Monaco v Le Havre : Over/Under 2.5 Goals 08-Feb-13 19:00 08-Feb-13 20:31 2.94
Football / Nimes v Laval : Over/Under 2.5 Goals 08-Feb-13 19:00 08-Feb-13 20:28 0.05
Football / Auxerre v Tours : Over/Under 2.5 Goals 08-Feb-13 19:00 08-Feb-13 19:24 -11.00
Football / France v Germany : Correct Score 06-Feb-13 20:00 06-Feb-13 21:52 16.18
Football / France v Germany : Match Odds 06-Feb-13 20:00 06-Feb-13 21:52 -10.00
Football / England v Brazil : DRAW NO BET 06-Feb-13 19:30 06-Feb-13 21:32 23.85
Football / France v Germany : Over/Under 2.5 Goals 06-Feb-13 20:00 06-Feb-13 21:32 -1.81
Football / England v Brazil : Correct Score 06-Feb-13 19:30 06-Feb-13 21:26 22.90
Football / L Orient v Southend : Correct Score 05-Feb-13 19:45 05-Feb-13 21:44 28.02
Football / L Orient v Southend : Over/Under 1.5 Goals 05-Feb-13 19:45 05-Feb-13 21:44 1.02
Football / Gillingham v Wycombe : Correct Score 04-Feb-13 19:45 04-Feb-13 21:40 13.91
Football / Gillingham v Wycombe : Over/Under 1.5 Goals 04-Feb-13 19:45 04-Feb-13 21:40 15.32
Football / Man City v Liverpool : Correct Score 03-Feb-13 16:00 03-Feb-13 17:55 17.25
Football / Man City v Liverpool : Over/Under 3.5 Goals 03-Feb-13 16:00 03-Feb-13 17:37 15.44
 Pages: 1  2   of 2 Pages