Green coefficient and Z'Hello. In your archive of coefficave

[obtim]

Hello. In your archive of coefficients on the https://www.newhavensoft.net/oddsarchive.htm page in the files is used the gradation of green when filling the cells. I can determine the gradation code of the green in the cell. How can I figure out which Z'ave corresponds to the gradation code in the cell?

[Alex]

The same gradation you can check and see in Stake Wizard bet optimizer (SW) as follows. For the green cell in XLS file, take two values: fair odds in the columns E..V, and market (line) odds in the columns DH..DY. Fill in these values in the SW columns Fair and Line, respectively (other columns may be left blank). Click green arrow button to start calculations. Now the column Z ave% becomes green with the same gradation as you see in Excel, and it contains calculated value of Zave in %. Gradation extent is proportional to the value Ln(Zave) from the theorem which is available on the homepage: https://www.newhavensoft.net:

Ln(Zave) = p*ln(p/q) + (1-p)*ln[(1-p)/(1-q)], where p = 1/F, q = 1/L; F - fair odds (computed by OW); L - line (market) odds.

There is no summation over events for the single event. Gradation extent is always calculated for the single event.

Zave % (in SW) = 100*(exp(Ln(Zave))-1)

I hope I answered your question.