ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Bankroll100,00Marj formula#DIV/0!
2
#DIV/0!
3
#DIV/0!
4
5
The sheet will calculate fair odds, market deformation, stake fraction and advised stake.
6
MarketOutcome
Chance (p)
Fair Odds (1/p)
Bookie Odds
Deformation (Fair-Bookie)/Fair
Signal (>=0)
Advised Stake
Clean Bookie Odds
Top 3 Signals
Clean signal for bet
7
"1-0"Yes #DIV/0!RankMarket
Outcome
SignalStake#DIV/0!
8
"2-0"Yes #DIV/0!1#NUM!#NUM!#NUM!#NUM!#DIV/0!
9
"2-1"Yes #DIV/0!2#NUM!#NUM!#NUM!#NUM!#DIV/0!
10
"0-0"Yes #DIV/0!3#NUM!#NUM!#NUM!#NUM!#DIV/0!
11
"1-1"Yes #DIV/0!#DIV/0!
12
"2-2"Yes #DIV/0!#DIV/0!
13
"0-1"Yes #DIV/0!#DIV/0!
14
"0-2"Yes #DIV/0!#DIV/0!
15
"1-2"Yes #DIV/0!#DIV/0!
16
17
18
19
Overall Stats
20
TeamsMPWDLFA
21
Home Overall8503149
22
Away Overall84041110
23
Input data in above cells manually from: https://www.soccerway.com
24
25
HomeDrawAwayTIPS
26
Poin distribution %44%21%34%1
27
10%
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100