I really enjoy the power of stored values. I also know that spreadsheets with data can be imported/exported to and from Bet Angel respectively.
Is there any way I can simply input a stored value to a spreadsheet, manipulate this value(s) using the excel formulae and then output the result back into Bet Angel as another updated Stored Value?
A Question on Stored Values and Spreadsheets
Ah great, thank you for that.
So how and what spreadsheet do I put that formula into? (I pretty much have the baf file ready to go, I just need to tweak the stake by using the spreadsheet)
I have seen various different styles, some have race result templates on them and some have stats etc. I basically just need a little bit of Excel to put the formula into - that will hook up with Bet Angel, but I am not sure of the setup (even after looking at guides etc)
So how and what spreadsheet do I put that formula into? (I pretty much have the baf file ready to go, I just need to tweak the stake by using the spreadsheet)
I have seen various different styles, some have race result templates on them and some have stats etc. I basically just need a little bit of Excel to put the formula into - that will hook up with Bet Angel, but I am not sure of the setup (even after looking at guides etc)
Could I possibly see an example?
I have connected an excel file to BA and put the formula into cell A1 but now what? I don't understand what to do with the formula.???
I assume that formula is setting a value for an SV in the spreadsheet to be used in BA.
I want to get an SV already from BA (a P/L value from a race) manipulate it in the spreadsheet and then assign back to another SV, and do this for each race
I have connected an excel file to BA and put the formula into cell A1 but now what? I don't understand what to do with the formula.???
I assume that formula is setting a value for an SV in the spreadsheet to be used in BA.
I want to get an SV already from BA (a P/L value from a race) manipulate it in the spreadsheet and then assign back to another SV, and do this for each race
You do not have the required permissions to view the files attached to this post.
You can push stored values out to the BA excel template, in BA under settings -> Excel, tick 'Shared Stored Values' which is in the additional columns list
Then in the template you would issue the command in column L.
it could be something like ="SET_SV FOR:SELECTION NAME: MyStoredValue VALUE: 5000"
https://www.betangel.com/user-guide/mic ... ration.htm
Then in the template you would issue the command in column L.
it could be something like ="SET_SV FOR:SELECTION NAME: MyStoredValue VALUE: 5000"
https://www.betangel.com/user-guide/mic ... ration.htm
I have just returned to this and I am getting nowhere with it.
I'll say what I have done so far but nothing seems to connect with one another:
1. I create and store the SVs in the automation rule itself: 2. I then go into Settings and list out the Stored Values here: 3. I add a rule in the file (which is run in the file after the rule in step 1 above) that sets the Parameters to store the same SVs into a CSV file At this point I am lost
When trying to find the CSV file under the Excel tab (the top of Guardian, to the right of the Markets tab), I cannot find the CSV file to connect to
If the CSV is only created when the rule is ran,. how do I use the three SVs to calculate a new SV in a spreadsheet? (which is intended to be fed back into the same file)
I just need those SVs in a spreadsheet, somewhere, anywhere
Then I can do one formula using them in a spreadsheet to then store the output of that formula to a new SV, I guess in a cell in the same spreadsheet I assume using that formula that ODPaul82 kindly provided in the same spreadsheet,
I can't picture how my own formula links up with the command provided by ODPaul82
In my head I want this, as an example
The rule stores the following SVs
Rate Increase = 1.55
Base Stake = 1
Mult_Counter = 1
Then in a step or two later, feed these Svs into the spreadsheet
On the spreadsheet, have a formula somewhere that does the following
=Base Stake1*(Rate Increase1.55)to the power of Mult_Counter - 1 ---- (I added the numbers in here to simply aid my example)
Then that output goes in say B2, then that value in B2 gets assigned to a new SV called Confirmed Stake and then fed back into the file in Guardian to be used as a Bet Angel Shared SV - That must be were Paul's command comes into it, maybe his command would have B2 at the end, I don't know
Then I expect to be able to type Confirmed Stake in a future rule and have a dynamic value calculated from the spreadsheet.
Can anyone help? The guides are just not helping me in the slightest
I'll say what I have done so far but nothing seems to connect with one another:
1. I create and store the SVs in the automation rule itself: 2. I then go into Settings and list out the Stored Values here: 3. I add a rule in the file (which is run in the file after the rule in step 1 above) that sets the Parameters to store the same SVs into a CSV file At this point I am lost
When trying to find the CSV file under the Excel tab (the top of Guardian, to the right of the Markets tab), I cannot find the CSV file to connect to
If the CSV is only created when the rule is ran,. how do I use the three SVs to calculate a new SV in a spreadsheet? (which is intended to be fed back into the same file)
I just need those SVs in a spreadsheet, somewhere, anywhere
Then I can do one formula using them in a spreadsheet to then store the output of that formula to a new SV, I guess in a cell in the same spreadsheet I assume using that formula that ODPaul82 kindly provided in the same spreadsheet,
I can't picture how my own formula links up with the command provided by ODPaul82
In my head I want this, as an example
The rule stores the following SVs
Rate Increase = 1.55
Base Stake = 1
Mult_Counter = 1
Then in a step or two later, feed these Svs into the spreadsheet
On the spreadsheet, have a formula somewhere that does the following
=Base Stake1*(Rate Increase1.55)to the power of Mult_Counter - 1 ---- (I added the numbers in here to simply aid my example)
Then that output goes in say B2, then that value in B2 gets assigned to a new SV called Confirmed Stake and then fed back into the file in Guardian to be used as a Bet Angel Shared SV - That must be were Paul's command comes into it, maybe his command would have B2 at the end, I don't know
Then I expect to be able to type Confirmed Stake in a future rule and have a dynamic value calculated from the spreadsheet.
Can anyone help? The guides are just not helping me in the slightest
You do not have the required permissions to view the files attached to this post.
A much simple alternative would be if I could use a workaround to have an adjustment to a SV whereby I can use "To The power of"
I see we only have the four basic mathematical operations
Does anyone know how to achieve this without having a long list of Stored Value actions that multiply the SV by itself over and over and over and over and over and so on?
I see we only have the four basic mathematical operations
Does anyone know how to achieve this without having a long list of Stored Value actions that multiply the SV by itself over and over and over and over and over and so on?