S&P 500 cash weekly competition for 2018 with PRIZES!

Yeah, I thought you bagged it there CV, Them bl00dy averages have caught me out once or twice, well done though, good prediction...
 
Well done to the pack who have all contributed to nailing the gold medal this week. Yay. :clap::clap::clap:

Just 0.53 of a point away. What a wonderfully talented crowd we have here. (y):cool:(y)


CV manages to take the silver tray and gets sandwiched by Weighted Average taking the bronze. (y)(y)



................................................................Average


..................CV..................................................................................Weighted Average

4354618648_3f939f5cbf_b.jpg




PS. The medal count has gone skewed and I'll need to calculate them again. We should have 42 gold medals in total but only showing 37. ie. 5 medals missing.

.
 

Attachments

  • Wk42_Results.PNG
    Wk42_Results.PNG
    121.1 KB · Views: 108
  • Wk42_LBrd.PNG
    Wk42_LBrd.PNG
    120.8 KB · Views: 83
  • Wk42_RunTotal.PNG
    Wk42_RunTotal.PNG
    122.9 KB · Views: 85
PS. The medal count has gone skewed and I'll need to calculate them again. We should have 42 gold medals in total but only showing 37. ie. 5 medals missing.



Don't worry m8 I'll look after them.

P.S.
Being sandwiched between 2 averages - does that mean he is also average ?


Only kidding.
 
Pat494 said:
PS. The medal count has gone skewed and I'll need to calculate them again. We should have 42 gold medals in total but only showing 37. ie. 5 medals missing.



Don't worry m8 I'll look after them.

P.S.
Being sandwiched between 2 averages - does that mean he is also average ?


Only kidding.
Click to expand...


LOL well, his below average but above weighted average.

So were you thinking, what I'm thinking?

FAB :cheesy:
 
Atilla said:
Well done to the pack who have all contributed to nailing the gold medal this week. Yay. :clap::clap::clap:

Just 0.53 of a point away. What a wonderfully talented crowd we have here. (y):cool:(y)


CV manages to take the silver tray and gets sandwiched by Weighted Average taking the bronze. (y)(y)



................................................................Average


..................CV..................................................................................Weighted Average

4354618648_3f939f5cbf_b.jpg




PS. The medal count has gone skewed and I'll need to calculate them again. We should have 42 gold medals in total but only showing 37. ie. 5 medals missing.

.
Click to expand...



If this spreadsheet isn’t automated, then it should be, would remove all the subhuman mistakes being made [emoji16]
 
Signalcalc said:
If this spreadsheet isn’t automated, then it should be, would remove all the subhuman mistakes being made [emoji16]
Click to expand...

Great!

You volunteering to take over in the new year. :)


Happy to hand over. Sad to see Postman disappear.


If you can automate that'll be great. Open to ideas. :rolleyes:
 
Atilla said:
Great!



You volunteering to take over in the new year. :)





Happy to hand over. Sad to see Postman disappear.





If you can automate that'll be great. Open to ideas. :rolleyes:
Click to expand...



You are doing a fine job att [emoji1360]

Happy to take a look at the spreadsheet to see if it could be improved.
 
Signalcalc said:
You are doing a fine job att [emoji1360]

Happy to take a look at the spreadsheet to see if it could be improved.
Click to expand...

Thanks SC I would appreciate that.

If you can forward an email via pm, I can give you access on google.docs and send link if you don't have it already.

(y)
 
Atilla said:
Well done to the pack who have all contributed to nailing the gold medal this week. Yay. :clap::clap::clap:

Just 0.53 of a point away. What a wonderfully talented crowd we have here. (y):cool:(y)


CV manages to take the silver tray and gets sandwiched by Weighted Average taking the bronze. (y)(y)



................................................................Average


..................CV..................................................................................Weighted Average

4354618648_3f939f5cbf_b.jpg




PS. The medal count has gone skewed and I'll need to calculate them again. We should have 42 gold medals in total but only showing 37. ie. 5 medals missing.

.
Click to expand...

Are they in the walnut jar? :)
 
Atilla said:
Great!

You volunteering to take over in the new year. :)


Happy to hand over. Sad to see Postman disappear.


If you can automate that'll be great. Open to ideas. :rolleyes:
Click to expand...

PM sent. Not volunteering to takeover, but I'll take a look at the spreadsheet :D
 
counter_violent said:
If the medals are missing, will that affect the points?
Click to expand...

Hi CV,

Rule no 5. States

5. Where there is a draw on points, then number of games played will be considered. If still equal then number of medals won in order of gold / silver / bronze will be used in picking out the winners.


So the answer is yes only if both points and number of games played are the same.

Otherwise Non!



Here is the rules tab from Spread-Sheet - FEI :)



Hi Everyone,

The rules stay the same as last year unless otherwise stated as changing by group debate.

Sharky has very kindly upped the prize fund to $500.


Rules of WEEKLY competition for S&P 500 cash are...

1. 1 point for getting direction correct from previous Friday close

2. Having got direction right then:-
a) 3 points for nearest
b) 2 points for second nearest
c) 1 point for third nearest
d) 1 point will be deducted if direction of the forecast is wrong

3. All entries should be in by weekly opening session of US markets

Prizes

1. $100 for Quarterly winners in 1st place for March / June / September / December
a) Points and number of games played will be reset to zero at the start of every quarter.
---------- QTR-1 - $100
---------- QTR-2 - $100
---------- QTR-3 - $100
---------- QTR-4 - $100

2. $100 for the end of year over-all running total points' winners prize money will be distributed in 50:30:20 ratios
---------- 1st place - $50
---------- 2nd place - $30
---------- 3rd place - $20

3. If an average wins any quarter, then prize money will be rolled forward until a human contestant wins in subsequent quarter. ie., If any of the averages win QTR-1 then the prize money in QTR-2 will increase to $200. Similarly, the same principal will apply to QTR-2 and 3.

4. Prizes can only be rolled forward until the end of the year, when if an Average still takes the top podium spot, then built up pot monies will be distributed in the above ratios 50:30:20 to human contestants highest in the league table based on points.

5. Where there is a draw on points, then number of games played will be considered. If still equal then number of medals won in order of gold / silver / bronze will be used in picking out the winners.


I hope that's clear guys, trying to cover all angles to save any issues later. Like to add, this is still a competition run and managed by the members - 'us', and sponsored by T2W with Amazon vouchers as prizes. Will discuss anything of issue in our usual fashion and Pat, competition founder and judge on point rules, can weigh pros & cons and guide us as appropriate.

We hope the prizes will encourage more spritely debate and that people will post charts and comments on their approach & systems.
 
You must log in or register to reply here.

Similar threads

Pat494
S&P 500 cash weekly competition for 2017 with PRIZES!
77 78 79
Replies
2K
Views
206K
Signalcalc
Signalcalc
Atilla
S&P 500 cash weekly competition for 2015 with PRIZES!
55 56 57
Replies
1K
Views
164K
TwinToWin
T
P
S&P 500 cash weekly competition for 2016 with PRIZES!
76 77 78
Replies
2K
Views
197K
postman
P
Pat494
S&P 500 cash weekly competition for 2014 with PRIZES!
44 45 46
Replies
908
Views
113K
MajorMagnuM
M
Signalcalc
S&P 500 free weekly competition for 2019 with PRIZES
42 43 44
Replies
873
Views
322K
lexcorp
lexcorp
Top