Level Profit

[nhmaster]

Hi all

Does anyone have any idea how to replicate the level profit column from the main betting screen, into the excel sheet??

By that I mean the green up column on extreme right, or what formula may be needed to give the same results??

Cheers Shaun

[Mitch]

To work out the new stake for a level profit trade is (original stake * (original odds / new odds)) so you could use that in a formula, but you would need to have kept details of the original stake and odds matched.

[Tarmac]

Follow on for attention Gary/Mark - Any chance The level profit column with global and individual runner figures can be read in Excel??

NG

[GaryRussell]

I'm afraid it's not going to be added soon, but I have replied to your other message here http://gruss-software.co.uk/forum/viewtopic.php?t=4873 The spreadsheet I provided does work.

[xraymitch]

I'm afraid it's not going to be added soon, but I have replied to your other message here http://gruss-software.co.uk/forum/viewtopic.php?t=4873 The spreadsheet I provided does work.

[GaryRussell]

It's because the links were referring to /phpBB2/ folder. I have updated all posts (604 in total!) to refer to /forum/ instead. Open the post again and the link should be pointing to /forum/ and should work.

[ADDA]

If I may ask a theoretical question.

According to the post above, Level profit = (original stake * (original odds / new odds))

if I can refer you to the thread:
http://www.gruss-software.co.uk/forum/v ... php?t=4920

in this thread we discuss the profit calculations and asked whether the profit obtained would be for a horse winning:
Profit = BackVol *(BackOdds-1) - LayVol *(LayOdds-1)
the reason for the -1 is to remove the amount laid out by the better and only incorporates the profit obtained for horse winning (decimal odds compared to fractional odds)

Now the question is what odds to use in the level profit, is it the odds or the odds -1

See example

volume Back* Odds Back Volume lay Odds Lay
7,705882353 1,7 5 2,62

11,57142857 (1,7-1) 5 (2,62 - 1)

* This volume is calculated by the level profit formula to calculate the Back Odds of 7,7 and 11,5 above

If we use our profit calculation i.e. Profit = BackVol *(BackOdds-1) - LayVol *(LayOdds-1)
Then using the top method of 7,7 you would get a profit of -2,705882353
if you use the 11,57 calculated by our method you get a profit of 0.

Thanks for the help

[ADDA]

Sorry the table did not come out formatted correctly
volume Back*:1) 7,705882353 - 2) 11,57142857
Odds Back: 1) 1,7 - 2) (1,7-1)
Volume lay: 1) 5 - 2) 5
Odds Lay: 1) 2,62 - 2) (2,62-1)