| Matches | 1X2 or Under/Over 2.5 goals | Double chance and Under/Over 2.5 goals |
| CA Osasuna - Elche CF | 1.66 | 2.4 |
| Real Sociedad - FC Sevilla | 1.53 | 2.77 |
| Atletico Madrid - SD Eibar | 1.64 | 2.44 |
| Deportivo Alaves - SD Huesca | 1.65 | 2.42 |
| Real Betis - Valencia CF | 1.43 | 3.15 |
| Cadiz CF - Celta de Vigo | 1.58 | 2.59 |
| Getafe CF - Real Madrid | 1.59 | 2.58 |
Simply put, I need a dutching calculator Excel sheet with 128 entries. I’ll elaborate using an example from the table above. As you can see, there are 7 matches with 2 possible outcomes per match which I intend to accumulate to see if there are any arbitrage opportunities.
There will be 128 tickets in all which I intend to run with the dutching calculator to know how much the individual stake will be but there is a special request. I want a markup of each 30% added to the total odds of each 7 game ticket. Hence, a ticket with all outcomes of 1X2 or Under/Over 2.5 goals will have the Effective Total Odds as (1.66*1.53*1.64*1.65*1.43*1.58*1.59) + 30% = 24.69 + 7.41 = 32.10.
Basically, I just want to enter 14 inputs in 14 cells somewhere on top of the excel sheet and the total stake in one cell, then I get all the total effective odds in 128 rows, and the amounts I’d be required to stake per ticket in a corresponding manner.
I don’t know if anyone here can help me with this. I can clarify or provide further info if needed.
Thanks
