# FeaturedS&P500 - Weekly Forecasting Competition for 2023

4261.2

4162

Working on the results so far, will be published before end of day, then once a week. Thanks for your patience!

Just to confirm on the scoring, my understanding is:

STEP 1
- If you pick the right directon then you get 1 point
- If you pick the wrong direction you get -1 points
- If you pick the same close as previous week (the world explodes?!)

STEP 2
- If you picked the right direction then the entry closest gets gold (3 points), next closest gets silver (2 points) and third closest gets bronze (1 point)
- note if you picked the wrong direction you can't get a medal and the extra points, even if you're prediction is closer than any of the medalists

Just to confirm on the scoring, my understanding is:

STEP 1
- If you pick the right directon then you get 1 point
- If you pick the wrong direction you get -1 points
- If you pick the same close as previous week (the world explodes?!)

STEP 2
- If you picked the right direction then the entry closest gets gold (3 points), next closest gets silver (2 points) and third closest gets bronze (1 point)
- note if you picked the wrong direction you can't get a medal and the extra points, even if you're prediction is closer than any of the medalists
Step 1:
If the market has the same close as last week including all digits after the decimal point, then I would say 1 point for everybody so there is no need to change the rules for step 2.
What is picked is compared only with the weekly market close, not any pick before.

Step 2:
Correct. Only the distance counts for rank 1-3.
And no points if the direction of Step 1 was wrong.

Yep I agree with all that and so would papa Pat, to remember his spirit.

Working on the results so far, will be published before end of day, then once a week. Thanks for your patience!
Thanks for the confirmation. I've got all the entries, weekly closes plugged in - I've just got to finish calculating the averages before I can determine who wins the medals and get those points. I'll publish it all tomorrow, no ifs or buts!

Here is the leaderboard so far for Q2, 2023:
1. BigDeal (13 pts)
2. counter_violet (12 pts)
3. lexcorp (5 pts)
4. {simple average} (4 points)
5. IlIlIlIlI (2 points)
6. Atila (-1 point)
7. Oscar Reed (-3 points)
Please note I've removed the weighted average, whilst I like the idea, I found it too time consuming to calculate for multiple weeks, so in the spirit of KISS I'll stick with just the simple average for now, at least whilst we continue to use a manual excel spreadsheet to manage it all.

#### Attachments

• Screenshot 2023-05-23 at 14.14.48.png
400.1 KB · Views: 25
Here is the leaderboard so far for Q2, 2023:
1. BigDeal (13 pts)
2. counter_violet (12 pts)
3. lexcorp (5 pts)
4. {simple average} (4 points)
5. IlIlIlIlI (2 points)
6. Atila (-1 point)
7. Oscar Reed (-3 points)
Please note I've removed the weighted average, whilst I like the idea, I found it too time consuming to calculate for multiple weeks, so in the spirit of KISS I'll stick with just the simple average for now, at least whilst we continue to use a manual excel spreadsheet to manage it all.
I just wonder why there is no forecast difference and direction shown for me and lexcorp.
Ist that really correct?

Yes, those numbers don't change any of the points or medals calculations, they're a hangover from Atila's original spreadsheet, as I've simplified things a bit, but here's the corrected version...

#### Attachments

• Screenshot 2023-05-23 at 14.31.09.png
418.2 KB · Views: 24
Let me know if the removal of the weighted average is a deal breaker. The problem I found is the weightings are cumulative over time, so every week they need to be recalculated and then applied, I'm not an excel pro so the formulas were starting to get a bit convoluted esp as you need to process everything weekly, I just didn't think it was worth the effort when a simple average gives a good ballpark.

Think there should be a prize for last there is a skill in getting that place.

Think there should be a prize for last there is a skill in getting that place.

Coming last is more of a condition imo. There should be some ointment or tablets one can take for it surely...

4242.4 ta

4262.1

Replies
509
Views
144K
Replies
451
Views
401K
Replies
873
Views
307K
Replies
64
Views
565K
Replies
1K
Views
150K