Hi,
My question is based on the following values:
Here I am using one of Dallas' Market P/L Stored Values to give me the outcome of each Greyhound Race.
What I would like to do is to set a counter somewhere that counts the amount of negative results and I would then like to determine what stake is placed for the next race based on how many are loses in a row.
Please correct me if I am wrong but I would think along the lines of possibly:
1. Storing each Market P/L value in a history list for when each race is complete and then
2. Using the history list in a csv excel file to make up the counter in one cell (not sure if this can be done in any excel file, or I would need to use the standardized bet angel excel templates, but if so where could I even do that in those templates?),
3. Then storing that dynamic number to another stored value (I have seen a post that is a line in excel to store values from spreadsheets and then this can be used in rules)
4. Editing the file I have to do the exact same thing as it does now (it's a dutching for 2 dog faves based on odds, not every race is selected) however, when that new stored value counter is say 0 (as in 0 loses in a row) then stake £1 for example for the next selected race, when the stored value is 1 (1 loss in a row) then stake £3 again for example on the next selected race and so on, so just multiple rules will be exactly the same apart from the stake being used and a new condition that looks at the new counter stored value
I did try to do step 1 but it didn't seem to let me select the "Market P/L" Stored Value when selecting the history list
Again, not sure if step 2 is do-able in my own potential personal spreadsheet that is just dedicated to using a bit of excel formulae to make up the counter value of loses.
Once I have that counter variable set up, I am fairly confident about setting up step 4
Am I on the right lines? Could someone possibly give me a working step by step way of doing this? History Lists may not be able to be used in this way (even if I did know how to set them up)- There may be an easier way of setting up the list to have a dynamic counter used
N.B.
I imagine I will get users telling me not to bother with progressive betting systems as they are bad idea, but I have looked at the possibilities of getting x amount of loses in a row based on what my rule selects for the odds of the dogs and knowing the appropriate balance to cover eventualities - I know freak outcomes happen (40 reds in a row in roulette etc) and there is no memory from one race to the next but my approach is based on like hood of x amount of loses and mine is rare but not impossible for it to hit 11 in a row (about 1 in a million of it happening, based on the homework I have done, so the wins should outweigh the loses)
Question around using Stored Values to Influence the Stake Placed
Okay maybe I asked too much, I'll keep it to a simple question for now.
Does anyone know where I can access History Lists?
I think I have the file setup to add to "History List 1" but I cannot seem to access this actual list anywhere.
I asked the AI support but it's only telling me how to store values to it, not how to actually see and use the history list...
Does anyone know where I can access History Lists?
I think I have the file setup to add to "History List 1" but I cannot seem to access this actual list anywhere.
I asked the AI support but it's only telling me how to store values to it, not how to actually see and use the history list...
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
People will generally frown upon this request because it's almost always a fallacy to assume a win or loss becomes more likely based on previous results.
But it's relatively easy to achieve by adding a stored value to your existing rulesfile that stores at Bet Angel level keeping a count of wins vs losses. Then you can use this stored value to configure your stake for the next market.
eg:
race 1, if the P&L is >0 then "SV" = "SV" + 1
race 2, if the P&L is <0 then "SV" = "SV" - 1
But it's relatively easy to achieve by adding a stored value to your existing rulesfile that stores at Bet Angel level keeping a count of wins vs losses. Then you can use this stored value to configure your stake for the next market.
eg:
race 1, if the P&L is >0 then "SV" = "SV" + 1
race 2, if the P&L is <0 then "SV" = "SV" - 1
Hi, thank you
Is this the right way to do it?
I first store the P/L like so? But I then don't know where the
"race 1, if the P&L is >0 then "SV" = "SV" + 1 (I'll actually reset to zero in this eventually)
race 2, if the P&L is <0 then "SV" = "SV" - 1"
bit goes ???
Would it be somewhere here:
Is this the right way to do it?
I first store the P/L like so? But I then don't know where the
"race 1, if the P&L is >0 then "SV" = "SV" + 1 (I'll actually reset to zero in this eventually)
race 2, if the P&L is <0 then "SV" = "SV" - 1"
bit goes ???
Would it be somewhere here:
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
If you want to keep a running total of your P&L then you need to first set a new SV at Bet Angel level to 0, perhaps called "Cum_Market_P&L". Then under where you create the "Market_P&L" SV do the following:
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
If you want a count of number of profits - losses then you need to first set a new SV at Bet Angel level to 0, perhaps called "Counter".
Then do the following to increase count, and vice versa to decrease count.
Then do the following to increase count, and vice versa to decrease count.
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
You need to initially set "Counter" to zero somewhere, or the [Counter = Counter + 1] won't work. The best way to do this is create another line that sets "Counter" to 0 on the condition that "Counter" has not been set with a value.
You need to tick the "allow trigger when market suspended" box on the general tab as the "Market_P&L" SV won't become available until the market closes.
Presumably you have another rulefile live that creates the SV "Market_P&L"?
Thank you so much:
I have now done what you said by initialling the counter to zero with the condition you detailed
I have also ticked "allow trigger when market suspended" box on all rules
Yes "Market_P&L" is calculated by another rule running called "Display Name of Winner with P&L"
i have also incldued a rule that puts "Market_P&L" into another SV called "P+L" for when "Market_P&L" is NOT zero and I have then pointed the increment of the counter and the reset of the counter to this new "P+L". The reason being is that "Market_P&L" calculates zeros for when my own rule is not triggered:
so by doing this, my rule then ignores races with 0 "Market_P&L" and won't update the Counter SV .
Hopefully this works. What do you think? (I have put a "Counter" column in the main display to see if the SV Counter is behaving - Hopefully the rule will trigger correctly shown with the desired behaviour)
I can only thank you for your help with all of this
I have now done what you said by initialling the counter to zero with the condition you detailed
I have also ticked "allow trigger when market suspended" box on all rules
Yes "Market_P&L" is calculated by another rule running called "Display Name of Winner with P&L"
i have also incldued a rule that puts "Market_P&L" into another SV called "P+L" for when "Market_P&L" is NOT zero and I have then pointed the increment of the counter and the reset of the counter to this new "P+L". The reason being is that "Market_P&L" calculates zeros for when my own rule is not triggered:
so by doing this, my rule then ignores races with 0 "Market_P&L" and won't update the Counter SV .
Hopefully this works. What do you think? (I have put a "Counter" column in the main display to see if the SV Counter is behaving - Hopefully the rule will trigger correctly shown with the desired behaviour)
I can only thank you for your help with all of this
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
Remove the store P+L line. It's not needed. Keep it as it was before, <£0 will trigger on a loss, >£0 will trigger on a win. £0 won't trigger either of them.
Okay done ( I have set the increment and reset back to the "Market_P&L" SV)
There is a race at Crayford in 4 minutes that should trigger, so if it doesn't trigger, there is still something wrong, I'll keep an eye on it
There is a race at Crayford in 4 minutes that should trigger, so if it doesn't trigger, there is still something wrong, I'll keep an eye on it

You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
This needs to be set to Bet Angel level.
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 3944
- Joined: Wed Nov 21, 2018 6:16 pm
Greyhound races don't ever go into play so it wont ever trigger.
Change the three new lines to trigger once, always armed.
Change the three new lines to trigger once, always armed.