Is this sheet still available anywhere?
Running Daily Profit & Loss Total - Guardian Automation Bot
viewtopic.php?p=323823
Yes I saw that Dallas.
I have tried to have a go myself at doing this for a Two Lay Place File (Done over two BAF files) but have come unstuck. Could you have a look to see where I am possibly going wrong please? Please see next message for the second file, for some reason I cannot add the second file to this message
The files are laying the first and second fave in the Place Market
N.B. I have set the Odds Condition up to 13 so I can catch more races in order to just test this out, when fuly working I will set this back to its original "Less than 3.80" for combined odds
I feel like I am close but the final calculations are bringing back invalid values for both the Win and Loss Scenarios:
"Horses Lose (as in don't place), I Win" Scenario on both horses I feel this one is the more problamatic
"Horses Win (as in do place), I Lose" Scenario on both horses This I feel is much closer, in fact I have made changes since these logs which may have fixed this one
The changes I made since these logs were:
1. To store the Stake Values AFTER the lay bets have been placed (not during as it would appear to store zeros to these and then place the lay bet stakes)
2. Changed "P/L One" and "P/L Two" SVs to be stored for the Market rather than the Current Selection, as these need to be used between the two rules to calculate the "Final P/L" SV
I have tried to have a go myself at doing this for a Two Lay Place File (Done over two BAF files) but have come unstuck. Could you have a look to see where I am possibly going wrong please? Please see next message for the second file, for some reason I cannot add the second file to this message
The files are laying the first and second fave in the Place Market
N.B. I have set the Odds Condition up to 13 so I can catch more races in order to just test this out, when fuly working I will set this back to its original "Less than 3.80" for combined odds
I feel like I am close but the final calculations are bringing back invalid values for both the Win and Loss Scenarios:
"Horses Lose (as in don't place), I Win" Scenario on both horses I feel this one is the more problamatic
"Horses Win (as in do place), I Lose" Scenario on both horses This I feel is much closer, in fact I have made changes since these logs which may have fixed this one
The changes I made since these logs were:
1. To store the Stake Values AFTER the lay bets have been placed (not during as it would appear to store zeros to these and then place the lay bet stakes)
2. Changed "P/L One" and "P/L Two" SVs to be stored for the Market rather than the Current Selection, as these need to be used between the two rules to calculate the "Final P/L" SV
You do not have the required permissions to view the files attached to this post.
Last edited by smgreyuk on Wed Jan 22, 2025 8:35 am, edited 3 times in total.
As promised, here they are:
Just a few notes for these, they lay the 1st and 2nd horse in the Place market and end up storing the final P/L (combined P/L for both horses) for each race in a SV called "Final P/L" which can be used in a column view
I will post an updated version of these which has a running total SV
Also if you wanted this for:
1. Just laying the one fave horse - Then just don't use file B. By just using file A, it only lays the fave horse in the race, but in this case the final P/L will be stored in a SV called "P/L one"
2. To back fave and 2nd fave instead of lay them - FOR EACH FILE - Change the rule name and rule type to a back bet, remove the Store Liability rule, change the logic of the Horse wins and horse loses rules by doing the following:- For when the horse wins (you win) have the stake multiplied by the odds in one part of the adjustment and then minus the stake in the next adjustment. For when the horse loses (you lose) have the stake multiplied by -1 in an adjustment
3. Only back one horse - do both of the above
If anybody needs any helps with the 3 requirements above, let me know and I can probably create it for you.
I will post an updated version of these which has a running total SV
Also if you wanted this for:
1. Just laying the one fave horse - Then just don't use file B. By just using file A, it only lays the fave horse in the race, but in this case the final P/L will be stored in a SV called "P/L one"
2. To back fave and 2nd fave instead of lay them - FOR EACH FILE - Change the rule name and rule type to a back bet, remove the Store Liability rule, change the logic of the Horse wins and horse loses rules by doing the following:- For when the horse wins (you win) have the stake multiplied by the odds in one part of the adjustment and then minus the stake in the next adjustment. For when the horse loses (you lose) have the stake multiplied by -1 in an adjustment
3. Only back one horse - do both of the above
If anybody needs any helps with the 3 requirements above, let me know and I can probably create it for you.
You do not have the required permissions to view the files attached to this post.