Calculation of P/L in this example.
i am working on a football strategy and need a little clarification on bet totals.
in the screenshot below is a game i placed 3 back bets in test mode.
the trade profit for each bet is in the last column.
the bet information in the other columns.
my question is, how does Betfair calculate the P/L and get those figures when multiple bets
are entered.
If you treat each row as separate bets then my calculations are correct and i don't know how Betfair
gets the final calcs.
Any ideas..
Today's Football
-
MemphisFlash
- Posts: 2335
- Joined: Fri May 16, 2014 10:12 pm
You do not have the required permissions to view the files attached to this post.
https://tr.wikipedia.org/wiki/3_Cisim_Problemi
I follow you from the greyhound section, there is a 17% loss in the total stake in the matchodds market, so it is mathematically impossible to balance all 3 legs. In order to balance all three legs, back+back and lay/back are required.
It is not possible to approach and measure the elliptical Sun-Earth and Moon side by side 100%.
But I did it, I'm sorry. (app picture for another app sory )
Arsenal matchodds green.png
Üç Cisim Problemi.png
I follow you from the greyhound section, there is a 17% loss in the total stake in the matchodds market, so it is mathematically impossible to balance all 3 legs. In order to balance all three legs, back+back and lay/back are required.
It is not possible to approach and measure the elliptical Sun-Earth and Moon side by side 100%.
But I did it, I'm sorry. (app picture for another app sory )
Arsenal matchodds green.png
Üç Cisim Problemi.png
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2335
- Joined: Fri May 16, 2014 10:12 pm
from seeing peter's latest video regarding AI and chatgpt i thought i would give it a go.
So here is the answer direct from chat GPT
from the image can you create a formula whereby the final column is determined from back odds, stake and win columns, then create a further column whereby all the figure are positive
ChatGPT
Sure! I'll break down the steps to create the formula and then calculate a column where all figures are positive.
Step-by-Step Breakdown
Final Column Calculation:
The "Final" column seems to be calculated based on whether the selection wins or loses. Specifically:
If the selection wins, the profit is calculated as: (Back Odds - 1) * Stake - Stake
If the selection loses, the loss is: -Stake
Positive Final Column:
We will adjust the "Final" column so that all values are positive.
Formula for Final Column
For each selection, the formula would be:
Win:
(
Back Odds
−
1
)
×
Stake
−
Stake
(Back Odds−1)×Stake−Stake
Lose:
−
Stake
−Stake
Here is how you can calculate it in Excel:
Win Calculation:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
Lose Calculation:
Lose
=
−
Stake
Lose=−Stake
Final Calculation:
Final
=
Win if win else Lose
Final=Win if win else Lose
In Excel, this can be written as:
Final
=
IF(Win, (Back Odds - 1) * Stake, -Stake)
Final=IF(Win, (Back Odds - 1) * Stake, -Stake)
Adjusting to Positive Final Values
To convert all final values to positive, you can use the absolute value function:
Positive Final
=
ABS(Final)
Positive Final=ABS(Final)
Applying These in Excel:
Final Calculation:
Assuming Back Odds is in column B, Stake is in column D, and Win is in column E:
excel
Copy code
=IF(E2 > 0, (B2 - 1) * D2, -D2)
Positive Final Calculation:
excel
Copy code
=ABS(F2)
Example in Excel Format
Selection Back Odds Lay Odds Stake Win Lose Final Positive Final
Drogheda 1.91 1.92 0.51 0.46 -0.51 -0.64 0.64
Cork City 2.6 2.62 0.31 0.49 -0.31 -0.21 0.21
The Draw 3.35 3.4 0.20 0.48 -0.20 0.68 0.68
Implementing in Excel
Final Column:
For Drogheda (Row 2):
excel
Copy code
=IF(E2 > 0, (B2 - 1) * D2, -D2)
Drag this formula down for all rows.
Positive Final Column:
For Drogheda (Row 2):
excel
Copy code
=ABS(F2)
Drag this formula down for all rows.
This should result in the "Final" and "Positive Final" columns being correctly calculated based on the given conditions.
can you create a formula from the back odds and stake columns that produces the "Final" column from the information of the 3 rows?
ChatGPT
To create a formula that calculates the "Final" column based solely on the "Back Odds" and "Stake" columns, we need to incorporate the given "Win" and "Lose" amounts directly. This calculation assumes the "Win" column represents the profit if the bet wins, and the "Lose" column represents the loss if the bet loses.
Let's derive the formula for each row:
Drogheda:
Back Odds: 1.91
Stake: £0.51
Win: £0.46 (profit if win)
Lose: -£0.51 (loss if lose)
Final: -£0.64
Cork City:
Back Odds: 2.6
Stake: £0.31
Win: £0.49 (profit if win)
Lose: -£0.31 (loss if lose)
Final: -£0.21
The Draw:
Back Odds: 3.35
Stake: £0.20
Win: £0.48 (profit if win)
Lose: -£0.20 (loss if lose)
Final: £0.68
Given the "Back Odds" and "Stake", we can calculate the "Win" amount using:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
For the "Final" column, we can infer the calculation based on the pattern of win and lose values. It seems that the "Final" amount takes into account the net profit or loss based on the stake and the odds.
To create a single formula for the "Final" column, we need to consider the net impact of the win/loss scenario. The "Final" column appears to represent a combined outcome of all scenarios, but since we don't have the exact context, we will base it on the provided values.
Let's define the formula for "Final" as:
Final
=
Win
−
Stake
Final=Win−Stake
where Win is calculated as:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
In Excel terms, this would be:
excel
Copy code
= ((B2 - 1) * D2) - D2
Let's apply this to the given data:
Formula Implementation in Excel:
Final Calculation for Drogheda (Row 2):
excel
Copy code
= ((B2 - 1) * D2) - D2
Final Calculation for Cork City (Row 3):
excel
Copy code
= ((B3 - 1) * D3) - D3
Final Calculation for The Draw (Row 4):
excel
Copy code
= ((B4 - 1) * D4) - D4
Adjusting for Positive Final Values:
To ensure all final values are positive, we can use the absolute value function:
excel
Copy code
= ABS(((B2 - 1) * D2) - D2)
Complete Example:
Selection Back Odds Lay Odds Stake Win Lose Final Positive Final
Drogheda 1.91 1.92 £0.51 £0.46 -£0.51 = ((B2-1)*D2)-D2 = ABS(((B2-1)*D2)-D2)
Cork City 2.6 2.62 £0.31 £0.49 -£0.31 = ((B3-1)*D3)-D3 = ABS(((B3-1)*D3)-D3)
The Draw 3.35 3.4 £0.20 £0.48 -£0.20 = ((B4-1)*D4)-D4 = ABS(((B4-1)*D4)-D4)
In this way, we can consistently calculate the "Final" and "Positive Final" values based on the "Back Odds" and "Stake" columns.
what stakes would i need to obtain the positive final figures?
ChatGPT
To determine the stakes needed to obtain the positive final figures, we need to set up the calculations such that the outcome ensures a positive result regardless of the selection.
The positive final figures in the image are:
Drogheda: £0.64
Cork City: £0.21
The Draw: £0.68
The general approach involves setting the formulas for these positive final figures and solving for the required stake. Given the back odds, we can rearrange the formula for the final profit calculation to find the stake required for a specific profit.
Formula Rearrangement
From the previous formulas, we have:
Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Final=(Back Odds−1)×Stake−Stake
To achieve a specific positive final figure, we can set:
Desired Positive Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Desired Positive Final=(Back Odds−1)×Stake−Stake
Rearranging to solve for Stake:
Desired Positive Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Desired Positive Final=(Back Odds−1)×Stake−Stake
Desired Positive Final
=
(
Back Odds
−
1
−
1
)
×
Stake
Desired Positive Final=(Back Odds−1−1)×Stake
Desired Positive Final
=
(
Back Odds
−
2
)
×
Stake
Desired Positive Final=(Back Odds−2)×Stake
Stake
=
Desired Positive Final
Back Odds
−
2
Stake=
Back Odds−2
Desired Positive Final
Calculations
Using the given positive final figures and back odds:
Drogheda:
Back Odds: 1.91
Desired Positive Final: £0.64
Stake
=
0.64
1.91
−
2
=
0.64
−
0.09
≈
−
£
7.11
Stake=
1.91−2
0.64
=
−0.09
0.64
≈−£7.11
Cork City:
Back Odds: 2.6
Desired Positive Final: £0.21
Stake
=
0.21
2.6
−
2
=
0.21
0.6
≈
£
0.35
Stake=
2.6−2
0.21
=
0.6
0.21
≈£0.35
The Draw:
Back Odds: 3.35
Desired Positive Final: £0.68
Stake
=
0.68
3.35
−
2
=
0.68
1.35
≈
£
0.50
Stake=
3.35−2
0.68
=
1.35
0.68
≈£0.50
Adjustments for Positive Stakes
Note that in the case of Drogheda, the back odds (1.91) make it impossible to achieve a positive final figure with the given method because it implies a negative stake. Thus, an alternative approach would be required for such cases, typically involving a different betting strategy or market.
Practical Implementation:
To avoid negative stakes, a more realistic and practical stake adjustment approach is needed:
Drogheda: Adjust strategy, since traditional positive stake calculation yields impractical negative values.
Cork City: Stake approximately £0.35.
The Draw: Stake approximately £0.50.
By using these calculated stakes, you can adjust your bets to achieve the desired positive final outcomes.
what would i need to do to obtain the same Positive final figure
ChatGPT
To obtain the same positive final figure across all selections, you would need to balance your stakes and the possible outcomes to ensure that the net result is the same regardless of the outcome of the event. This is commonly referred to as "arbitrage betting" or "dutching."
Here’s the approach to achieve a uniform positive final figure for all outcomes:
Identify the Desired Positive Final Figure:
Let's say the desired positive final figure is £0.68 (as in the highest positive final figure from your provided data).
Calculate the Stakes for Each Selection:
Use the back odds to determine the stakes required to achieve the same profit for each possible outcome.
Steps to Calculate the Stakes
Given:
Desired Positive Final
=
£
0.68
Desired Positive Final=£0.68
Formula:
Stake
=
Desired Positive Final
(
Back Odds
−
1
)
Stake=
(Back Odds−1)
Desired Positive Final
Calculations:
Drogheda:
Back Odds: 1.91
Stake:
Stake
=
0.68
1.91
−
1
=
0.68
0.91
≈
£
0.75
Stake=
1.91−1
0.68
=
0.91
0.68
≈£0.75
Cork City:
Back Odds: 2.6
Stake:
Stake
=
0.68
2.6
−
1
=
0.68
1.6
≈
£
0.425
Stake=
2.6−1
0.68
=
1.6
0.68
≈£0.425
The Draw:
Back Odds: 3.35
Stake:
Stake
=
0.68
3.35
−
1
=
0.68
2.35
≈
£
0.289
Stake=
3.35−1
0.68
=
2.35
0.68
≈£0.289
Practical Example in Excel:
Assuming Back Odds are in column B and Desired Positive Final is £0.68:
Selection Back Odds Stake Formula Stake
Drogheda 1.91 = 0.68 / (B2 - 1) £0.75
Cork City 2.6 = 0.68 / (B3 - 1) £0.425
The Draw 3.35 = 0.68 / (B4 - 1) £0.289
In Excel, you can enter the formula in the Stake column:
For Drogheda (Row 2):
excel
Copy code
= 0.68 / (B2 - 1)
For Cork City (Row 3):
excel
Copy code
= 0.68 / (B3 - 1)
For The Draw (Row 4):
excel
Copy code
= 0.68 / (B4 - 1)
Verifying the Calculations:
After calculating the stakes, you can verify by calculating the profit for each scenario to ensure it matches the desired positive final figure (£0.68).
For Drogheda:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
1.91
×
0.75
)
−
0.75
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(1.91×0.75)−0.75=£0.68
For Cork City:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
2.6
×
0.425
)
−
0.425
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(2.6×0.425)−0.425=£0.68
For The Draw:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
3.35
×
0.289
)
−
0.289
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(3.35×0.289)−0.289=£0.68
By adjusting your stakes according to the back odds using the given formula, you can achieve the same positive final figure across all selections.
So here is the answer direct from chat GPT
from the image can you create a formula whereby the final column is determined from back odds, stake and win columns, then create a further column whereby all the figure are positive
ChatGPT
Sure! I'll break down the steps to create the formula and then calculate a column where all figures are positive.
Step-by-Step Breakdown
Final Column Calculation:
The "Final" column seems to be calculated based on whether the selection wins or loses. Specifically:
If the selection wins, the profit is calculated as: (Back Odds - 1) * Stake - Stake
If the selection loses, the loss is: -Stake
Positive Final Column:
We will adjust the "Final" column so that all values are positive.
Formula for Final Column
For each selection, the formula would be:
Win:
(
Back Odds
−
1
)
×
Stake
−
Stake
(Back Odds−1)×Stake−Stake
Lose:
−
Stake
−Stake
Here is how you can calculate it in Excel:
Win Calculation:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
Lose Calculation:
Lose
=
−
Stake
Lose=−Stake
Final Calculation:
Final
=
Win if win else Lose
Final=Win if win else Lose
In Excel, this can be written as:
Final
=
IF(Win, (Back Odds - 1) * Stake, -Stake)
Final=IF(Win, (Back Odds - 1) * Stake, -Stake)
Adjusting to Positive Final Values
To convert all final values to positive, you can use the absolute value function:
Positive Final
=
ABS(Final)
Positive Final=ABS(Final)
Applying These in Excel:
Final Calculation:
Assuming Back Odds is in column B, Stake is in column D, and Win is in column E:
excel
Copy code
=IF(E2 > 0, (B2 - 1) * D2, -D2)
Positive Final Calculation:
excel
Copy code
=ABS(F2)
Example in Excel Format
Selection Back Odds Lay Odds Stake Win Lose Final Positive Final
Drogheda 1.91 1.92 0.51 0.46 -0.51 -0.64 0.64
Cork City 2.6 2.62 0.31 0.49 -0.31 -0.21 0.21
The Draw 3.35 3.4 0.20 0.48 -0.20 0.68 0.68
Implementing in Excel
Final Column:
For Drogheda (Row 2):
excel
Copy code
=IF(E2 > 0, (B2 - 1) * D2, -D2)
Drag this formula down for all rows.
Positive Final Column:
For Drogheda (Row 2):
excel
Copy code
=ABS(F2)
Drag this formula down for all rows.
This should result in the "Final" and "Positive Final" columns being correctly calculated based on the given conditions.
can you create a formula from the back odds and stake columns that produces the "Final" column from the information of the 3 rows?
ChatGPT
To create a formula that calculates the "Final" column based solely on the "Back Odds" and "Stake" columns, we need to incorporate the given "Win" and "Lose" amounts directly. This calculation assumes the "Win" column represents the profit if the bet wins, and the "Lose" column represents the loss if the bet loses.
Let's derive the formula for each row:
Drogheda:
Back Odds: 1.91
Stake: £0.51
Win: £0.46 (profit if win)
Lose: -£0.51 (loss if lose)
Final: -£0.64
Cork City:
Back Odds: 2.6
Stake: £0.31
Win: £0.49 (profit if win)
Lose: -£0.31 (loss if lose)
Final: -£0.21
The Draw:
Back Odds: 3.35
Stake: £0.20
Win: £0.48 (profit if win)
Lose: -£0.20 (loss if lose)
Final: £0.68
Given the "Back Odds" and "Stake", we can calculate the "Win" amount using:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
For the "Final" column, we can infer the calculation based on the pattern of win and lose values. It seems that the "Final" amount takes into account the net profit or loss based on the stake and the odds.
To create a single formula for the "Final" column, we need to consider the net impact of the win/loss scenario. The "Final" column appears to represent a combined outcome of all scenarios, but since we don't have the exact context, we will base it on the provided values.
Let's define the formula for "Final" as:
Final
=
Win
−
Stake
Final=Win−Stake
where Win is calculated as:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
In Excel terms, this would be:
excel
Copy code
= ((B2 - 1) * D2) - D2
Let's apply this to the given data:
Formula Implementation in Excel:
Final Calculation for Drogheda (Row 2):
excel
Copy code
= ((B2 - 1) * D2) - D2
Final Calculation for Cork City (Row 3):
excel
Copy code
= ((B3 - 1) * D3) - D3
Final Calculation for The Draw (Row 4):
excel
Copy code
= ((B4 - 1) * D4) - D4
Adjusting for Positive Final Values:
To ensure all final values are positive, we can use the absolute value function:
excel
Copy code
= ABS(((B2 - 1) * D2) - D2)
Complete Example:
Selection Back Odds Lay Odds Stake Win Lose Final Positive Final
Drogheda 1.91 1.92 £0.51 £0.46 -£0.51 = ((B2-1)*D2)-D2 = ABS(((B2-1)*D2)-D2)
Cork City 2.6 2.62 £0.31 £0.49 -£0.31 = ((B3-1)*D3)-D3 = ABS(((B3-1)*D3)-D3)
The Draw 3.35 3.4 £0.20 £0.48 -£0.20 = ((B4-1)*D4)-D4 = ABS(((B4-1)*D4)-D4)
In this way, we can consistently calculate the "Final" and "Positive Final" values based on the "Back Odds" and "Stake" columns.
what stakes would i need to obtain the positive final figures?
ChatGPT
To determine the stakes needed to obtain the positive final figures, we need to set up the calculations such that the outcome ensures a positive result regardless of the selection.
The positive final figures in the image are:
Drogheda: £0.64
Cork City: £0.21
The Draw: £0.68
The general approach involves setting the formulas for these positive final figures and solving for the required stake. Given the back odds, we can rearrange the formula for the final profit calculation to find the stake required for a specific profit.
Formula Rearrangement
From the previous formulas, we have:
Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Final=(Back Odds−1)×Stake−Stake
To achieve a specific positive final figure, we can set:
Desired Positive Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Desired Positive Final=(Back Odds−1)×Stake−Stake
Rearranging to solve for Stake:
Desired Positive Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Desired Positive Final=(Back Odds−1)×Stake−Stake
Desired Positive Final
=
(
Back Odds
−
1
−
1
)
×
Stake
Desired Positive Final=(Back Odds−1−1)×Stake
Desired Positive Final
=
(
Back Odds
−
2
)
×
Stake
Desired Positive Final=(Back Odds−2)×Stake
Stake
=
Desired Positive Final
Back Odds
−
2
Stake=
Back Odds−2
Desired Positive Final
Calculations
Using the given positive final figures and back odds:
Drogheda:
Back Odds: 1.91
Desired Positive Final: £0.64
Stake
=
0.64
1.91
−
2
=
0.64
−
0.09
≈
−
£
7.11
Stake=
1.91−2
0.64
=
−0.09
0.64
≈−£7.11
Cork City:
Back Odds: 2.6
Desired Positive Final: £0.21
Stake
=
0.21
2.6
−
2
=
0.21
0.6
≈
£
0.35
Stake=
2.6−2
0.21
=
0.6
0.21
≈£0.35
The Draw:
Back Odds: 3.35
Desired Positive Final: £0.68
Stake
=
0.68
3.35
−
2
=
0.68
1.35
≈
£
0.50
Stake=
3.35−2
0.68
=
1.35
0.68
≈£0.50
Adjustments for Positive Stakes
Note that in the case of Drogheda, the back odds (1.91) make it impossible to achieve a positive final figure with the given method because it implies a negative stake. Thus, an alternative approach would be required for such cases, typically involving a different betting strategy or market.
Practical Implementation:
To avoid negative stakes, a more realistic and practical stake adjustment approach is needed:
Drogheda: Adjust strategy, since traditional positive stake calculation yields impractical negative values.
Cork City: Stake approximately £0.35.
The Draw: Stake approximately £0.50.
By using these calculated stakes, you can adjust your bets to achieve the desired positive final outcomes.
what would i need to do to obtain the same Positive final figure
ChatGPT
To obtain the same positive final figure across all selections, you would need to balance your stakes and the possible outcomes to ensure that the net result is the same regardless of the outcome of the event. This is commonly referred to as "arbitrage betting" or "dutching."
Here’s the approach to achieve a uniform positive final figure for all outcomes:
Identify the Desired Positive Final Figure:
Let's say the desired positive final figure is £0.68 (as in the highest positive final figure from your provided data).
Calculate the Stakes for Each Selection:
Use the back odds to determine the stakes required to achieve the same profit for each possible outcome.
Steps to Calculate the Stakes
Given:
Desired Positive Final
=
£
0.68
Desired Positive Final=£0.68
Formula:
Stake
=
Desired Positive Final
(
Back Odds
−
1
)
Stake=
(Back Odds−1)
Desired Positive Final
Calculations:
Drogheda:
Back Odds: 1.91
Stake:
Stake
=
0.68
1.91
−
1
=
0.68
0.91
≈
£
0.75
Stake=
1.91−1
0.68
=
0.91
0.68
≈£0.75
Cork City:
Back Odds: 2.6
Stake:
Stake
=
0.68
2.6
−
1
=
0.68
1.6
≈
£
0.425
Stake=
2.6−1
0.68
=
1.6
0.68
≈£0.425
The Draw:
Back Odds: 3.35
Stake:
Stake
=
0.68
3.35
−
1
=
0.68
2.35
≈
£
0.289
Stake=
3.35−1
0.68
=
2.35
0.68
≈£0.289
Practical Example in Excel:
Assuming Back Odds are in column B and Desired Positive Final is £0.68:
Selection Back Odds Stake Formula Stake
Drogheda 1.91 = 0.68 / (B2 - 1) £0.75
Cork City 2.6 = 0.68 / (B3 - 1) £0.425
The Draw 3.35 = 0.68 / (B4 - 1) £0.289
In Excel, you can enter the formula in the Stake column:
For Drogheda (Row 2):
excel
Copy code
= 0.68 / (B2 - 1)
For Cork City (Row 3):
excel
Copy code
= 0.68 / (B3 - 1)
For The Draw (Row 4):
excel
Copy code
= 0.68 / (B4 - 1)
Verifying the Calculations:
After calculating the stakes, you can verify by calculating the profit for each scenario to ensure it matches the desired positive final figure (£0.68).
For Drogheda:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
1.91
×
0.75
)
−
0.75
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(1.91×0.75)−0.75=£0.68
For Cork City:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
2.6
×
0.425
)
−
0.425
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(2.6×0.425)−0.425=£0.68
For The Draw:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
3.35
×
0.289
)
−
0.289
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(3.35×0.289)−0.289=£0.68
By adjusting your stakes according to the back odds using the given formula, you can achieve the same positive final figure across all selections.
-
sionascaig
- Posts: 1606
- Joined: Fri Nov 20, 2015 9:38 am
https://www.bbc.co.uk/sport/olympics/live/clmy50ryknzt
Play resumes in dramatic Argentina-Morocco men's football match - 4 hours in an still going ...
Play resumes in dramatic Argentina-Morocco men's football match - 4 hours in an still going ...
Thanks, what a farce! I greened up after the third goal, Argentina equalised in the last minute of stoppage time and I think Eurosport moved onto the next match - I didn't hear of a disallowed goal!sionascaig wrote: ↑Wed Jul 24, 2024 6:05 pmhttps://www.bbc.co.uk/sport/olympics/live/clmy50ryknzt
Play resumes in dramatic Argentina-Morocco men's football match - 4 hours in an still going ...
Morocco deserved to win.
Posting this fix here if anyone else needs itMemphisFlash wrote: ↑Sun Jul 21, 2024 9:00 amfrom seeing peter's latest video regarding AI and chatgpt i thought i would give it a go.
So here is the answer direct from chat GPT
from the image can you create a formula whereby the final column is determined from back odds, stake and win columns, then create a further column whereby all the figure are positive
ChatGPT
Sure! I'll break down the steps to create the formula and then calculate a column where all figures are positive.
Step-by-Step Breakdown
Final Column Calculation:
The "Final" column seems to be calculated based on whether the selection wins or loses. Specifically:
If the selection wins, the profit is calculated as: (Back Odds - 1) * Stake - Stake
If the selection loses, the loss is: -Stake
Positive Final Column:
We will adjust the "Final" column so that all values are positive.
Formula for Final Column
For each selection, the formula would be:
Win:
(
Back Odds
−
1
)
×
Stake
−
Stake
(Back Odds−1)×Stake−Stake
Lose:
−
Stake
−Stake
Here is how you can calculate it in Excel:
Win Calculation:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
Lose Calculation:
Lose
=
−
Stake
Lose=−Stake
Final Calculation:
Final
=
Win if win else Lose
Final=Win if win else Lose
In Excel, this can be written as:
Final
=
IF(Win, (Back Odds - 1) * Stake, -Stake)
Final=IF(Win, (Back Odds - 1) * Stake, -Stake)
Adjusting to Positive Final Values
To convert all final values to positive, you can use the absolute value function:
Positive Final
=
ABS(Final)
Positive Final=ABS(Final)
Applying These in Excel:
Final Calculation:
Assuming Back Odds is in column B, Stake is in column D, and Win is in column E:
excel
Copy code
=IF(E2 > 0, (B2 - 1) * D2, -D2)
Positive Final Calculation:
excel
Copy code
=ABS(F2)
Example in Excel Format
Selection Back Odds Lay Odds Stake Win Lose Final Positive Final
Drogheda 1.91 1.92 0.51 0.46 -0.51 -0.64 0.64
Cork City 2.6 2.62 0.31 0.49 -0.31 -0.21 0.21
The Draw 3.35 3.4 0.20 0.48 -0.20 0.68 0.68
Implementing in Excel
Final Column:
For Drogheda (Row 2):
excel
Copy code
=IF(E2 > 0, (B2 - 1) * D2, -D2)
Drag this formula down for all rows.
Positive Final Column:
For Drogheda (Row 2):
excel
Copy code
=ABS(F2)
Drag this formula down for all rows.
This should result in the "Final" and "Positive Final" columns being correctly calculated based on the given conditions.
can you create a formula from the back odds and stake columns that produces the "Final" column from the information of the 3 rows?
ChatGPT
To create a formula that calculates the "Final" column based solely on the "Back Odds" and "Stake" columns, we need to incorporate the given "Win" and "Lose" amounts directly. This calculation assumes the "Win" column represents the profit if the bet wins, and the "Lose" column represents the loss if the bet loses.
Let's derive the formula for each row:
Drogheda:
Back Odds: 1.91
Stake: £0.51
Win: £0.46 (profit if win)
Lose: -£0.51 (loss if lose)
Final: -£0.64
Cork City:
Back Odds: 2.6
Stake: £0.31
Win: £0.49 (profit if win)
Lose: -£0.31 (loss if lose)
Final: -£0.21
The Draw:
Back Odds: 3.35
Stake: £0.20
Win: £0.48 (profit if win)
Lose: -£0.20 (loss if lose)
Final: £0.68
Given the "Back Odds" and "Stake", we can calculate the "Win" amount using:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
For the "Final" column, we can infer the calculation based on the pattern of win and lose values. It seems that the "Final" amount takes into account the net profit or loss based on the stake and the odds.
To create a single formula for the "Final" column, we need to consider the net impact of the win/loss scenario. The "Final" column appears to represent a combined outcome of all scenarios, but since we don't have the exact context, we will base it on the provided values.
Let's define the formula for "Final" as:
Final
=
Win
−
Stake
Final=Win−Stake
where Win is calculated as:
Win
=
(
Back Odds
−
1
)
×
Stake
Win=(Back Odds−1)×Stake
In Excel terms, this would be:
excel
Copy code
= ((B2 - 1) * D2) - D2
Let's apply this to the given data:
Formula Implementation in Excel:
Final Calculation for Drogheda (Row 2):
excel
Copy code
= ((B2 - 1) * D2) - D2
Final Calculation for Cork City (Row 3):
excel
Copy code
= ((B3 - 1) * D3) - D3
Final Calculation for The Draw (Row 4):
excel
Copy code
= ((B4 - 1) * D4) - D4
Adjusting for Positive Final Values:
To ensure all final values are positive, we can use the absolute value function:
excel
Copy code
= ABS(((B2 - 1) * D2) - D2)
Complete Example:
Selection Back Odds Lay Odds Stake Win Lose Final Positive Final
Drogheda 1.91 1.92 £0.51 £0.46 -£0.51 = ((B2-1)*D2)-D2 = ABS(((B2-1)*D2)-D2)
Cork City 2.6 2.62 £0.31 £0.49 -£0.31 = ((B3-1)*D3)-D3 = ABS(((B3-1)*D3)-D3)
The Draw 3.35 3.4 £0.20 £0.48 -£0.20 = ((B4-1)*D4)-D4 = ABS(((B4-1)*D4)-D4)
In this way, we can consistently calculate the "Final" and "Positive Final" values based on the "Back Odds" and "Stake" columns.
what stakes would i need to obtain the positive final figures?
ChatGPT
To determine the stakes needed to obtain the positive final figures, we need to set up the calculations such that the outcome ensures a positive result regardless of the selection.
The positive final figures in the image are:
Drogheda: £0.64
Cork City: £0.21
The Draw: £0.68
The general approach involves setting the formulas for these positive final figures and solving for the required stake. Given the back odds, we can rearrange the formula for the final profit calculation to find the stake required for a specific profit.
Formula Rearrangement
From the previous formulas, we have:
Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Final=(Back Odds−1)×Stake−Stake
To achieve a specific positive final figure, we can set:
Desired Positive Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Desired Positive Final=(Back Odds−1)×Stake−Stake
Rearranging to solve for Stake:
Desired Positive Final
=
(
Back Odds
−
1
)
×
Stake
−
Stake
Desired Positive Final=(Back Odds−1)×Stake−Stake
Desired Positive Final
=
(
Back Odds
−
1
−
1
)
×
Stake
Desired Positive Final=(Back Odds−1−1)×Stake
Desired Positive Final
=
(
Back Odds
−
2
)
×
Stake
Desired Positive Final=(Back Odds−2)×Stake
Stake
=
Desired Positive Final
Back Odds
−
2
Stake=
Back Odds−2
Desired Positive Final
Calculations
Using the given positive final figures and back odds:
Drogheda:
Back Odds: 1.91
Desired Positive Final: £0.64
Stake
=
0.64
1.91
−
2
=
0.64
−
0.09
≈
−
£
7.11
Stake=
1.91−2
0.64
=
−0.09
0.64
≈−£7.11
Cork City:
Back Odds: 2.6
Desired Positive Final: £0.21
Stake
=
0.21
2.6
−
2
=
0.21
0.6
≈
£
0.35
Stake=
2.6−2
0.21
=
0.6
0.21
≈£0.35
The Draw:
Back Odds: 3.35
Desired Positive Final: £0.68
Stake
=
0.68
3.35
−
2
=
0.68
1.35
≈
£
0.50
Stake=
3.35−2
0.68
=
1.35
0.68
≈£0.50
Adjustments for Positive Stakes
Note that in the case of Drogheda, the back odds (1.91) make it impossible to achieve a positive final figure with the given method because it implies a negative stake. Thus, an alternative approach would be required for such cases, typically involving a different betting strategy or market.
Practical Implementation:
To avoid negative stakes, a more realistic and practical stake adjustment approach is needed:
Drogheda: Adjust strategy, since traditional positive stake calculation yields impractical negative values.
Cork City: Stake approximately £0.35.
The Draw: Stake approximately £0.50.
By using these calculated stakes, you can adjust your bets to achieve the desired positive final outcomes.
what would i need to do to obtain the same Positive final figure
ChatGPT
To obtain the same positive final figure across all selections, you would need to balance your stakes and the possible outcomes to ensure that the net result is the same regardless of the outcome of the event. This is commonly referred to as "arbitrage betting" or "dutching."
Here’s the approach to achieve a uniform positive final figure for all outcomes:
Identify the Desired Positive Final Figure:
Let's say the desired positive final figure is £0.68 (as in the highest positive final figure from your provided data).
Calculate the Stakes for Each Selection:
Use the back odds to determine the stakes required to achieve the same profit for each possible outcome.
Steps to Calculate the Stakes
Given:
Desired Positive Final
=
£
0.68
Desired Positive Final=£0.68
Formula:
Stake
=
Desired Positive Final
(
Back Odds
−
1
)
Stake=
(Back Odds−1)
Desired Positive Final
Calculations:
Drogheda:
Back Odds: 1.91
Stake:
Stake
=
0.68
1.91
−
1
=
0.68
0.91
≈
£
0.75
Stake=
1.91−1
0.68
=
0.91
0.68
≈£0.75
Cork City:
Back Odds: 2.6
Stake:
Stake
=
0.68
2.6
−
1
=
0.68
1.6
≈
£
0.425
Stake=
2.6−1
0.68
=
1.6
0.68
≈£0.425
The Draw:
Back Odds: 3.35
Stake:
Stake
=
0.68
3.35
−
1
=
0.68
2.35
≈
£
0.289
Stake=
3.35−1
0.68
=
2.35
0.68
≈£0.289
Practical Example in Excel:
Assuming Back Odds are in column B and Desired Positive Final is £0.68:
Selection Back Odds Stake Formula Stake
Drogheda 1.91 = 0.68 / (B2 - 1) £0.75
Cork City 2.6 = 0.68 / (B3 - 1) £0.425
The Draw 3.35 = 0.68 / (B4 - 1) £0.289
In Excel, you can enter the formula in the Stake column:
For Drogheda (Row 2):
excel
Copy code
= 0.68 / (B2 - 1)
For Cork City (Row 3):
excel
Copy code
= 0.68 / (B3 - 1)
For The Draw (Row 4):
excel
Copy code
= 0.68 / (B4 - 1)
Verifying the Calculations:
After calculating the stakes, you can verify by calculating the profit for each scenario to ensure it matches the desired positive final figure (£0.68).
For Drogheda:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
1.91
×
0.75
)
−
0.75
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(1.91×0.75)−0.75=£0.68
For Cork City:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
2.6
×
0.425
)
−
0.425
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(2.6×0.425)−0.425=£0.68
For The Draw:
Profit
=
(
Back Odds
×
Stake
)
−
Stake
=
(
3.35
×
0.289
)
−
0.289
=
£
0.68
Profit=(Back Odds×Stake)−Stake=(3.35×0.289)−0.289=£0.68
By adjusting your stakes according to the back odds using the given formula, you can achieve the same positive final figure across all selections.
: https://www.youtube.com/watch?v=PabLxFMdkKo
-
Dublin_Flyer
- Posts: 840
- Joined: Sat Feb 11, 2012 10:39 am
Liverpool v Betis kicking off soon, I looked at the team and only recognised Adrian and Fekir....oh that's Betis. Fekir never signed years ago after constant links, he was just a rumour or a shit agent screwed it up 
Van den Berg getting a start at CB, wonder if he want's to stay and fight for his place with a new manager, or he's trying to get in the shop window with some friendly performances. I'm assuming if he's gone on the US tour that he's looking to stay.
Van den Berg getting a start at CB, wonder if he want's to stay and fight for his place with a new manager, or he's trying to get in the shop window with some friendly performances. I'm assuming if he's gone on the US tour that he's looking to stay.