Doh! Due to Pete's comment on last night's post, more about which later, I realised I had had a major calculation fcuk up in my analysis of yesterday's trades! The Summary column for the results, was, as Pete noted, set to calculate an Average result, not the sum of the profit and loss! So a profit of £62 was the reality, not the £10 mentioned. The corrected spreadsheet is pictured below:
Thanks for pointing that out Pete.
That's what comes of writing posts after a hard day's work and an evening's trading! It completely changes all the figures, obvioulsy, and gives a return of over 100% on stakes. Can't be bad, can it?
Therefore please ignore most of last night's post as the ramblings of an idiot!
I also owe an apology to the other Pete, my TF chatroom friend RedImp. You won the competition mate! Your prediction was closer than mine. Unfortuantely Mrs Gun spent the prize money last night on a new kitchen so I'd refer you to condition 7 sub clause iv) of the rules regarding prizes.... which basically says 'tough luck' !
An ill disciplined blogger shares irregular and random trading experiences with anyone who has the patience to read them!
Sunday, 14 August 2011
Saturday, 13 August 2011
It was only a game....
.... but nobody wanted to play!
Below is the screenshot of the result of our little play around with Scatter Gunning the opening fay of the Premiership. As you can see this paper trade would, if played for real, have secured a £10 return on a £54 investment - my simple maths suggests that's nearly 20%.
I certainly didn't have Newcastle v Arsenal down as a 0-0! Fulham v Villa is no great surprise, but the best win of the lot of course was Liverpool. A missed penalty and 1-0 after 15 minutes or so would almost certainly have caused me to at least think about exiting the trade for a loss in the first half had I been actively managing the game. Then again, I made a lot of money last season opposing Liverpool and if I'm honest the gambler in me would almost certainly have talked the trader out of exiting the game at 1-0 - I would almost expect Liverpool to struggle later in the game. It seems to me, for all King Kenny's summer signings, that they are a rudderless ship when a certain Stevie G is on the sidelines.
Interestingly the Strike Rate for these six games was 50% - as was the SR for the 'qualifying' games. But if I had restricted it t 'qualifiers' the £36 invested would have returned £45 or an £11 profit (30%). Six games is obviously far too small a sample to draw any meaningful conclusions from, but it sort of backs up what I expected - i.e. that game selection is more important that getting better odds.
The other thing that strikes me, talking about odds, is how broadly similar the odds on offer are, and the 'Summary' cell at the bottom of the individual columns gives the average odds on offer for the 3 scores. If we take them in turn.... 1-1 Ave Odds 7.8 - implied probability just shy of 13% . For 1-2 its 15.92, 6.25% and finally for 2-1 it's 11.02 with implied probability of 9%.
I've said before that I'm no mathematician and I'm certainly not a statistician but to my simple mind we are betting on three scores with a combined implied probability of 25ish % and getting a return in 50% of trades entered. Does this mean the humble old SG has a 50% edge??? Perhaps some of you more mathematically minded folk could explain (in English, please :-)) if this is the case or am I barking up the wrong tree???
Below is the screenshot of the result of our little play around with Scatter Gunning the opening fay of the Premiership. As you can see this paper trade would, if played for real, have secured a £10 return on a £54 investment - my simple maths suggests that's nearly 20%.
I certainly didn't have Newcastle v Arsenal down as a 0-0! Fulham v Villa is no great surprise, but the best win of the lot of course was Liverpool. A missed penalty and 1-0 after 15 minutes or so would almost certainly have caused me to at least think about exiting the trade for a loss in the first half had I been actively managing the game. Then again, I made a lot of money last season opposing Liverpool and if I'm honest the gambler in me would almost certainly have talked the trader out of exiting the game at 1-0 - I would almost expect Liverpool to struggle later in the game. It seems to me, for all King Kenny's summer signings, that they are a rudderless ship when a certain Stevie G is on the sidelines.
Interestingly the Strike Rate for these six games was 50% - as was the SR for the 'qualifying' games. But if I had restricted it t 'qualifiers' the £36 invested would have returned £45 or an £11 profit (30%). Six games is obviously far too small a sample to draw any meaningful conclusions from, but it sort of backs up what I expected - i.e. that game selection is more important that getting better odds.
The other thing that strikes me, talking about odds, is how broadly similar the odds on offer are, and the 'Summary' cell at the bottom of the individual columns gives the average odds on offer for the 3 scores. If we take them in turn.... 1-1 Ave Odds 7.8 - implied probability just shy of 13% . For 1-2 its 15.92, 6.25% and finally for 2-1 it's 11.02 with implied probability of 9%.
I've said before that I'm no mathematician and I'm certainly not a statistician but to my simple mind we are betting on three scores with a combined implied probability of 25ish % and getting a return in 50% of trades entered. Does this mean the humble old SG has a 50% edge??? Perhaps some of you more mathematically minded folk could explain (in English, please :-)) if this is the case or am I barking up the wrong tree???
Friday, 12 August 2011
A little bit of fun now the 'proper' season is starting...
Fortunately for me Saturday is usually a busy day in a prestige motor dealership. Unfortunately this means I can't trade the opening games of the new Premiership campaign. So, as a bit of fun, I thought I'd paper trade the six games on tomorrow's coupon with a scatter gun on each in a 'set and forget' mode.
The screenshot below shows prices for the six games at twenty to eleven the night before.
I will update the spreadsheet tomorrow night after the gooners have surrendered another 4 goal lead at St James's Park!
As a bit of light relief, no prizes on offer, it would be interesting to see what people think the outcome will be. The outlay is £9 per game, or £54 in total - so if interested please place a comment with your best estimate of the amount I would see back in my Bf account if this were for real.
Mentions in dispatches for the nearest guestimate!
The screenshot below shows prices for the six games at twenty to eleven the night before.
I will update the spreadsheet tomorrow night after the gooners have surrendered another 4 goal lead at St James's Park!
As a bit of light relief, no prizes on offer, it would be interesting to see what people think the outcome will be. The outlay is £9 per game, or £54 in total - so if interested please place a comment with your best estimate of the amount I would see back in my Bf account if this were for real.
Mentions in dispatches for the nearest guestimate!
Subscribe to:
Posts (Atom)