36 slot 4 pole winding diagram

Arbitrage calculator 2 way excel

Arbitrage betting, often referred to as “arbing,” is a strategy that allows bettors to exploit differences in odds offered by different bookmakers. By placing bets on all possible outcomes of an event, an arbitrage bettor can guarantee a profit regardless of the event’s outcome. This article will guide you through creating a simple 2-way arbitrage calculator in Excel.

What is a 2-Way Arbitrage Bet?

A 2-way arbitrage bet involves betting on two possible outcomes of an event. Common examples include:

• Football (Soccer): Betting on both the Home Win and Away Win (excluding the Draw).
• Tennis: Betting on both Player A and Player B to win.
• Basketball: Betting on both the Over and Under of a specific point total.

Steps to Create a 2-Way Arbitrage Calculator in Excel

Step 1: Set Up Your Excel Sheet

1. Open Excel and create a new workbook.
2. Label Columns:
   • A1: “Outcome 1”
   • B1: “Odds 1”
   • C1: “Outcome 2”
   • D1: “Odds 2”
   • E1: “Total Stake”
   • F1: “Stake 1”
   • G1: “Stake 2”
   • H1: “Profit”

Step 2: Enter the Odds

1. Enter the Odds for Outcome 1 in cell B2.
2. Enter the Odds for Outcome 2 in cell D2.

Step 3: Calculate the Arbitrage Percentage

1. Arbitrage Percentage Formula:
   • In cell I2, enter the formula: =(1/B2 + 1/D2) * 100
   • This formula calculates the total implied probability of both outcomes.

Step 4: Determine if There is an Arbitrage Opportunity

1. Check the Arbitrage Percentage:
   • If the value in cell I2 is less than 100, you have an arbitrage opportunity.

Step 5: Calculate the Stakes

1. Total Stake:

   • Enter the total amount you wish to stake in cell E2.

2. Stake for Outcome 1:

   • In cell F2, enter the formula: =E2 * (1/B2) / (1/B2 + 1/D2)

3. Stake for Outcome 2:

   • In cell G2, enter the formula: =E2 * (1/D2) / (1/B2 + 1/D2)

Step 6: Calculate the Profit

1. Profit Formula:
   • In cell H2, enter the formula: =E2 - (F2 + G2)
   • This formula calculates the guaranteed profit from the arbitrage bet.

Example

Let’s say you find the following odds for a tennis match:

• Player A: 2.10
• Player B: 2.00

Step-by-Step Calculation

1. Enter the Odds:

   • B2: 2.10
   • D2: 2.00

2. Calculate the Arbitrage Percentage:

   • I2: =(1/2.10 + 1/2.00) * 100
   • I2: 97.62% (Arbitrage Opportunity)

3. Enter the Total Stake:

   • E2: 100

4. Calculate the Stakes:

   • F2: =100 * (1/2.10) / (1/2.10 + 1/2.00)
   • F2: 48.81
   • G2: =100 * (1/2.00) / (1/2.10 + 1/2.00)
   • G2: 51.19

5. Calculate the Profit:

   • H2: =100 - (48.81 + 51.19)
   • H2: 0.00 (No profit due to rounding)

Creating a 2-way arbitrage calculator in Excel is a straightforward process that can help you identify and capitalize on arbitrage opportunities. By following the steps outlined in this article, you can quickly and efficiently calculate your stakes and potential profits. Remember to always check for the latest odds and ensure that the bookmakers you use allow arbitrage betting.

ipl 2016 all match

The Indian Premier League (IPL) 2016 was a thrilling season filled with intense matches, unexpected twists, and memorable performances. This article provides a detailed overview of all the matches played during the IPL 2016 season.

Key Highlights of IPL 2016

• Total Matches: 60
• Winning Team: Sunrisers Hyderabad
• Most Valuable Player: Virat Kohli (Royal Challengers Bangalore)
• Orange Cap: Virat Kohli (Royal Challengers Bangalore)
• Purple Cap: Bhuvneshwar Kumar (Sunrisers Hyderabad)

Match-by-Match Summary

Match 1: Mumbai Indians vs. Rising Pune Supergiants

• Date: April 9, 2016
• Venue: Wankhede Stadium, Mumbai
• Result: Mumbai Indians won by 9 wickets
• Key Moments: Ajinkya Rahane’s 66 off 45 balls for Pune.

Match 2: Kolkata Knight Riders vs. Delhi Daredevils

• Date: April 10, 2016
• Venue: Eden Gardens, Kolkata
• Result: Kolkata Knight Riders won by 9 wickets
• Key Moments: Gautam Gambhir’s 90 off 51 balls.

Match 3: Kings XI Punjab vs. Gujarat Lions

• Date: April 11, 2016
• Venue: Punjab Cricket Association IS Bindra Stadium, Mohali
• Result: Gujarat Lions won by 5 wickets
• Key Moments: Brendon McCullum’s 70 off 49 balls.

Match 4: Royal Challengers Bangalore vs. Sunrisers Hyderabad

• Date: April 12, 2016
• Venue: M. Chinnaswamy Stadium, Bangalore
• Result: Royal Challengers Bangalore won by 45 runs
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 5: Rising Pune Supergiants vs. Mumbai Indians

• Date: April 13, 2016
• Venue: Maharashtra Cricket Association Stadium, Pune
• Result: Mumbai Indians won by 8 wickets
• Key Moments: Parthiv Patel’s 45 off 25 balls.

Match 6: Delhi Daredevils vs. Gujarat Lions

• Date: April 14, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Gujarat Lions won by 1 run
• Key Moments: Dwayne Bravo’s ³⁄₂₄.

Match 7: Kolkata Knight Riders vs. Kings XI Punjab

• Date: April 15, 2016
• Venue: Eden Gardens, Kolkata
• Result: Kolkata Knight Riders won by 6 wickets
• Key Moments: Robin Uthappa’s 83 off 58 balls.

Match 8: Sunrisers Hyderabad vs. Royal Challengers Bangalore

• Date: April 16, 2016
• Venue: Rajiv Gandhi International Cricket Stadium, Hyderabad
• Result: Sunrisers Hyderabad won by 15 runs
• Key Moments: David Warner’s 93 off 58 balls.

Match 9: Mumbai Indians vs. Delhi Daredevils

• Date: April 17, 2016
• Venue: Wankhede Stadium, Mumbai
• Result: Mumbai Indians won by 80 runs
• Key Moments: Lendl Simmons’ 81 off 44 balls.

Match 10: Gujarat Lions vs. Kolkata Knight Riders

• Date: April 17, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Gujarat Lions won by 10 wickets
• Key Moments: Dwayne Smith’s 73 off 43 balls.

Match 11: Kings XI Punjab vs. Rising Pune Supergiants

• Date: April 18, 2016
• Venue: Punjab Cricket Association IS Bindra Stadium, Mohali
• Result: Rising Pune Supergiants won by 4 wickets
• Key Moments: Ajinkya Rahane’s 59 off 49 balls.

Match 12: Royal Challengers Bangalore vs. Mumbai Indians

• Date: April 19, 2016
• Venue: M. Chinnaswamy Stadium, Bangalore
• Result: Royal Challengers Bangalore won by 3 wickets
• Key Moments: Virat Kohli’s 82 off 51 balls.

Match 13: Delhi Daredevils vs. Sunrisers Hyderabad

• Date: April 20, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Sunrisers Hyderabad won by 10 runs
• Key Moments: David Warner’s 93 off 58 balls.

Match 14: Gujarat Lions vs. Kings XI Punjab

• Date: April 21, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Gujarat Lions won by 7 wickets
• Key Moments: Brendon McCullum’s 60 off 42 balls.

Match 15: Kolkata Knight Riders vs. Royal Challengers Bangalore

• Date: April 22, 2016
• Venue: Eden Gardens, Kolkata
• Result: Royal Challengers Bangalore won by 9 wickets
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 16: Rising Pune Supergiants vs. Delhi Daredevils

• Date: April 23, 2016
• Venue: Maharashtra Cricket Association Stadium, Pune
• Result: Delhi Daredevils won by 7 wickets
• Key Moments: Quinton de Kock’s 59 off 48 balls.

Match 17: Sunrisers Hyderabad vs. Mumbai Indians

• Date: April 23, 2016
• Venue: Rajiv Gandhi International Cricket Stadium, Hyderabad
• Result: Sunrisers Hyderabad won by 7 wickets
• Key Moments: David Warner’s 90 off 55 balls.

Match 18: Kings XI Punjab vs. Kolkata Knight Riders

• Date: April 24, 2016
• Venue: Punjab Cricket Association IS Bindra Stadium, Mohali
• Result: Kolkata Knight Riders won by 6 wickets
• Key Moments: Robin Uthappa’s 83 off 58 balls.

Match 19: Gujarat Lions vs. Royal Challengers Bangalore

• Date: April 24, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Royal Challengers Bangalore won by 4 wickets
• Key Moments: AB de Villiers’ 64 off 34 balls.

Match 20: Delhi Daredevils vs. Mumbai Indians

• Date: April 25, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Mumbai Indians won by 8 wickets
• Key Moments: Lendl Simmons’ 81 off 44 balls.

Match 21: Rising Pune Supergiants vs. Sunrisers Hyderabad

• Date: April 26, 2016
• Venue: Maharashtra Cricket Association Stadium, Pune
• Result: Sunrisers Hyderabad won by 4 wickets
• Key Moments: David Warner’s 93 off 58 balls.

Match 22: Kolkata Knight Riders vs. Gujarat Lions

• Date: April 27, 2016
• Venue: Eden Gardens, Kolkata
• Result: Gujarat Lions won by 4 wickets
• Key Moments: Dwayne Smith’s 73 off 43 balls.

Match 23: Royal Challengers Bangalore vs. Kings XI Punjab

• Date: April 28, 2016
• Venue: M. Chinnaswamy Stadium, Bangalore
• Result: Royal Challengers Bangalore won by 82 runs
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 24: Mumbai Indians vs. Sunrisers Hyderabad

• Date: April 29, 2016
• Venue: Wankhede Stadium, Mumbai
• Result: Sunrisers Hyderabad won by 7 wickets
• Key Moments: David Warner’s 90 off 55 balls.

Match 25: Delhi Daredevils vs. Kolkata Knight Riders

• Date: April 30, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Kolkata Knight Riders won by 6 wickets
• Key Moments: Robin Uthappa’s 83 off 58 balls.

Match 26: Gujarat Lions vs. Rising Pune Supergiants

• Date: April 30, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Gujarat Lions won by 7 wickets
• Key Moments: Brendon McCullum’s 60 off 42 balls.

Match 27: Kings XI Punjab vs. Royal Challengers Bangalore

• Date: May 1, 2016
• Venue: Punjab Cricket Association IS Bindra Stadium, Mohali
• Result: Royal Challengers Bangalore won by 82 runs
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 28: Sunrisers Hyderabad vs. Kolkata Knight Riders

• Date: May 1, 2016
• Venue: Rajiv Gandhi International Cricket Stadium, Hyderabad
• Result: Sunrisers Hyderabad won by 16 runs
• Key Moments: David Warner’s 93 off 58 balls.

Match 29: Mumbai Indians vs. Gujarat Lions

• Date: May 2, 2016
• Venue: Wankhede Stadium, Mumbai
• Result: Gujarat Lions won by 3 wickets
• Key Moments: Dwayne Smith’s 73 off 43 balls.

Match 30: Delhi Daredevils vs. Rising Pune Supergiants

• Date: May 3, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Delhi Daredevils won by 7 wickets
• Key Moments: Quinton de Kock’s 59 off 48 balls.

Match 31: Royal Challengers Bangalore vs. Kolkata Knight Riders

• Date: May 4, 2016
• Venue: M. Chinnaswamy Stadium, Bangalore
• Result: Royal Challengers Bangalore won by 9 wickets
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 32: Sunrisers Hyderabad vs. Kings XI Punjab

• Date: May 5, 2016
• Venue: Rajiv Gandhi International Cricket Stadium, Hyderabad
• Result: Sunrisers Hyderabad won by 5 wickets
• Key Moments: David Warner’s 90 off 55 balls.

Match 33: Gujarat Lions vs. Delhi Daredevils

• Date: May 6, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Gujarat Lions won by 1 run
• Key Moments: Dwayne Bravo’s ³⁄₂₄.

Match 34: Rising Pune Supergiants vs. Royal Challengers Bangalore

• Date: May 7, 2016
• Venue: Maharashtra Cricket Association Stadium, Pune
• Result: Royal Challengers Bangalore won by 45 runs
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 35: Kolkata Knight Riders vs. Mumbai Indians

• Date: May 7, 2016
• Venue: Eden Gardens, Kolkata
• Result: Mumbai Indians won by 6 wickets
• Key Moments: Lendl Simmons’ 81 off 44 balls.

Match 36: Kings XI Punjab vs. Sunrisers Hyderabad

• Date: May 8, 2016
• Venue: Punjab Cricket Association IS Bindra Stadium, Mohali
• Result: Sunrisers Hyderabad won by 7 wickets
• Key Moments: David Warner’s 93 off 58 balls.

Match 37: Delhi Daredevils vs. Gujarat Lions

• Date: May 8, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Gujarat Lions won by 7 wickets
• Key Moments: Brendon McCullum’s 60 off 42 balls.

Match 38: Royal Challengers Bangalore vs. Mumbai Indians

• Date: May 9, 2016
• Venue: M. Chinnaswamy Stadium, Bangalore
• Result: Royal Challengers Bangalore won by 3 wickets
• Key Moments: Virat Kohli’s 82 off 51 balls.

Match 39: Kolkata Knight Riders vs. Rising Pune Supergiants

• Date: May 10, 2016
• Venue: Eden Gardens, Kolkata
• Result: Kolkata Knight Riders won by 8 wickets
• Key Moments: Robin Uthappa’s 83 off 58 balls.

Match 40: Sunrisers Hyderabad vs. Gujarat Lions

• Date: May 11, 2016
• Venue: Rajiv Gandhi International Cricket Stadium, Hyderabad
• Result: Sunrisers Hyderabad won by 15 runs
• Key Moments: David Warner’s 93 off 58 balls.

Match 41: Delhi Daredevils vs. Royal Challengers Bangalore

• Date: May 12, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Royal Challengers Bangalore won by 10 wickets
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 42: Mumbai Indians vs. Kings XI Punjab

• Date: May 13, 2016
• Venue: Wankhede Stadium, Mumbai
• Result: Mumbai Indians won by 25 runs
• Key Moments: Lendl Simmons’ 81 off 44 balls.

Match 43: Gujarat Lions vs. Kolkata Knight Riders

• Date: May 14, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Gujarat Lions won by 4 wickets
• Key Moments: Dwayne Smith’s 73 off 43 balls.

Match 44: Rising Pune Supergiants vs. Sunrisers Hyderabad

• Date: May 14, 2016
• Venue: Maharashtra Cricket Association Stadium, Pune
• Result: Sunrisers Hyderabad won by 4 wickets
• Key Moments: David Warner’s 93 off 58 balls.

Match 45: Royal Challengers Bangalore vs. Delhi Daredevils

• Date: May 15, 2016
• Venue: M. Chinnaswamy Stadium, Bangalore
• Result: Royal Challengers Bangalore won by 10 wickets
• Key Moments: Virat Kohli’s 50 off 26 balls.

Match 46: Kings XI Punjab vs. Mumbai Indians

• Date: May 15, 2016
• Venue: Punjab Cricket Association IS Bindra Stadium, Mohali
• Result: Mumbai Indians won by 25 runs
• Key Moments: Lendl Simmons’ 81 off 44 balls.

Match 47: Kolkata Knight Riders vs. Sunrisers Hyderabad

• Date: May 16, 2016
• Venue: Eden Gardens, Kolkata
• Result: Sunrisers Hyderabad won by 22 runs
• Key Moments: David Warner’s 93 off 58 balls.

Match 48: Gujarat Lions vs. Royal Challengers Bangalore

• Date: May 17, 2016
• Venue: Saurashtra Cricket Association Stadium, Rajkot
• Result: Royal Challengers Bangalore won by 4 wickets
• Key Moments: AB de Villiers’ 64 off 34 balls.

Match 49: Delhi Daredevils vs. Kings XI Punjab

• Date: May 18, 2016
• Venue: Feroz Shah Kotla, Delhi
• Result: Delhi Daredevils won by 9 wickets
• Key Moments: Quinton de Kock’s 5