One Tuesday, the spreadsheet did something unusual. In the "Hot" column—his proprietary indicator for extreme value—it flagged a match in the Turkish Second Division. The odds were 4.50 for an away win. His program calculated a .
Sub UpdateElo() For each match row homeE = Cells(r, "HomeElo") awayE = Cells(r, "AwayElo") expectedHome = 1/(1+10^((awayE-homeE)/400)) k = 20 result = IIf(homeGoals>awayGoals,1, IIf(homeGoals=awayGoals,0.5,0)) Cells(r, "HomeEloNew") = homeE + k*(result-expectedHome) Cells(r, "AwayEloNew") = awayE + k*((1-result)-(1-expectedHome)) Next End Sub iddaa excel analiz programlar hot
While these are "hot," you must understand their limits: One Tuesday, the spreadsheet did something unusual