Just to add twopenneth - the weighted average favours those that are performing well and marginalises those that are performing badly over a long run average. It is not likely to respond materially with an outlier prediction unless that outlier comes from one of those performing well. I'm trying to say it self polices Pat and there isn't a need to be concerned about it. With the Mean, your assertion is certainly true but for the Weighted Average, the existence of an outlier as spoiler is very, very limited.
On another note, I have observed that Pete does v.well during bearish markets (as he is a perma-bear) and it is no surprise to me that Viel has done well as he is a perma-bull and conditions right now are bullish.
Over the weekend, I might take the 2012 results to see where in the bull/bear spectrum regular participants are in their predictions vs actual. Then I'll draw it up as a distribution which will be quite 'blocky' but probably quite entertaining to see.
Quick question; shall I created new spread-sheet for QTR2 or just add columns to existing spread-sheet?
Does anyone have any preferences - bearing in mind any future calculations or stats you may want extract?
It's interesting that the people with a negative bias, which is clearly a lot of the group, tend to predict bigger moves each week.
It is far far easier for me to do this if you leave all the results in a single sheet for the year like we had for 2012
Quick Question 2
For consistency - I think we should carry the WTAverage Sum & WTAverage Points forward?
This will also provide running total in WTAverage Points.
Any ideas, ayes or nayes?
and now a graph demonstrating that your long run predictive bias has little to no bearing in how well you do in the competition annually........
https://docs.google.com/spreadsheet/ccc?key=0AnFF2Rblu36wdGRNQjNXTzVjdldJb2dXdjRVTGs5VVE#gid=9
Discuss........
Also interesting that there was 32 up weeks last year (61.5% positive), yet 7 of the top 10 players were negatively biased. But I'm assuming got the additional podium points regularly.
It should not be that difficult to try out next quarter. That is keeping the competition as is and have a second Weighted Average with top and bottom outliers removed. I'll call it WA2.
In order not to bias the mean average calculation, it will be
entered last after WA1 and will not be included in calculations. So competition rules as before.
I will also be adding two columns for calculating PIPS made + Running Total PIPS alongside medals table. It is easy enough to calculate using excel so should add some P&L to the comp.
Once again really pleased with the development of the WA and keep it up everyone.
Maybe that's a rule change for consideration in future, in that the three closest predictions regardless of direction should get the podium points. But the directional call should be an additional point and not affect the podium places? So you've got 1, 2 and 3 points for three closest picks, and then everyone that gets the direction right gets and 1 additional point.
On the rules subject, I also think we should make all predictions unique, so no one has the same one.
Currently, the rules favour the bears because it is a bullish market and the bias to undershoot a rising market whilst still predicting upwards generates directional points. The converse would be true in a bearish market and the bulls would start to dominate. Think about the effects of changing the rules as there may be an element of short termism about the rule changes. I'm not saying don't, just consider it carefully.
I think the podium should go the nearest forecasts either way.
eg: Week ending 22nd Feb, I got bronze + 1 point for being -17.60 ticks away from Friday close whilst Robster (4.40) and two others got nothing despite being closer because they had direction wrong. That is 4x distance.
It should be about proximity to net result not direction imo and I'm still in favour.
Podium points only goes to nearest forecast in any direction. +1 Point for correct direction?
Also, as we are at the start of a new Qtr2 - so it is an opportune moment.
Anybody else like to vote?