After 2 years of research on the NBA and MLB and the NHL, I have come up with a selection method for picking the right games to bet on and taking them in 2 team parlay's.

Now for the next stage which is to be able to bet and make a profit, therefore I need an excel formula to work the amount to stake.

Here's an example parlay.

NHL: Ottawa
MLB: L.A. Dodgers vs NY Yankees

So the bet would be

Ottawa into L.A. Dodgers
Ottawa into NY Yankees

The formula will work out the correct stake.

The problem is if the combined odds of those MLB teams is over 100% then you can't win, if i am understanding your question

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

I reckon you should put half on each parlay.
Then , if you are only half right , you get back twice as much as the average of getting them both half wrong.

Could you explain further using my example

Every price has a percentage chance out of 100 to win say the price of these 2 teams were.

L.A. Dodgers @ $1.60 = 100/$1.60=62.5%
NY Yankees @ $2.20 = 100/$2.20=45.45
Total = $107.95%

If you can get 2 teams to equal less than 100% you can make a profit, don't forget if they offer the draw you need to include this in your workout unless you are sure they won't draw.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________