Excel Iddaa Programi Yapma Best Site
=EĞER(I2="Kazandı"; H2*G2-H2; EĞER(I2="Kaybetti"; -H2; 0)) This subtracts stake from gross winning so net profit appears.
| A (Date) | B (League) | C (Bet Type) | D (Odds) | E (Stake) | F (Result) | G (Net Profit) | H (Bankroll) | |----------|------------|--------------|----------|-----------|------------|----------------|---------------| | 10-Mar | Süper Lig | MS1 | 2.10 | 100 | Kazandı | =E2*D2-E2 | =previous + G2 | | 11-Mar | Premier L. | ÜST 2.5 | 1.85 | 100 | Kaybetti | =-E3 | =H2+G3 | excel iddaa programi yapma best
Similarly, highlight 3+ wins in green. Kelly % = (Probability × Odds – 1) / (Odds – 1) excel iddaa programi yapma best