Excel and Guardian SV's

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
firlandsfarm
Posts: 2686
Joined: Sat May 03, 2014 8:20 am

Hi, I'm just catching up on this and am thinking the next 2 weeks or so may be a good time to develop new approaches to BA and Bf! :? . Having read the Manual re Guardian and Excel sharing SV's am I right in thinking you can only set an SV in Excel for the market and not for each selection. I can only find "SET_SV FOR:<MARKET|EVENT> NAME:<name> VALUE:<value>" which seems to be market specific … is there a similar command for assigning SV's to selections?
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

You can store values for selections. The syntac is probably in the manual but if not its definitely in the version post that introduces stored values in excel
User avatar
firlandsfarm
Posts: 2686
Joined: Sat May 03, 2014 8:20 am

sa7med wrote:
Sun Mar 15, 2020 5:14 pm
You can store values for selections. The syntac is probably in the manual but if not its definitely in the version post that introduces stored values in excel
Thanks sa7med, I could only see syntax for the market in the Manual … I'll have a look in the release papers. :)

Found it "SET_SV FOR:<SELECTION|MARKET|EVENT> NAME:<name> VALUE:<value>" … I didn't notice I was looking in the Global Commands section and that the Selections syntax was elsewhere … silly me :) Thanks for causing me to look again. :)
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

Hope you dont mind me piggybacking on this but it's kind of relevant.

I've been focusing on Guardian automation for a while but was intrigued by the new ability to link to Excel for SV's. One of the abilities I was hoping this might bring to the table would be to use Excel as a kind of lookup table for stats. Thinking specifically about tennis where I might have a season\career stat for service holds\break back etc
Only thing I can't get my head around is that this would need to be selection specific and I dont believe we can address selection names from Guardian.

So set an SV in Excel with the value of all (or current match) players Break Back %. Then in Guardian: IF selection is Player name x AND Service has been broken in 1st set AND Break Back % SV > y THEN Back the selection

I'm guessing this isn't possible currently.
Last edited by sniffer66 on Mon Mar 16, 2020 9:23 am, edited 2 times in total.
User avatar
firlandsfarm
Posts: 2686
Joined: Sat May 03, 2014 8:20 am

I can't comment on the detail of your request Sniffer, I will leave that to the technical guys but we are not a million miles apart. My thinking is to use Excel as the number cruncher for the current market and then pass the crunched outcome to Guardian Automation for bet handling, basically using the advantages of one to overcome the disadvantages of the other. Excel is a far more powerful manipulator of numbers and Guardian Automation is a much better manager of bets. I feel the difficulty in removing the Bet Status from Excel is a bug :evil: Why would you want to exclude placing bets in a new market just because you placed a bet in a previous market? ... they are 99.99% mutually exclusive! I know people will say there are many examples of how to clear the bet Status cell in the forum but none of them work for me! For me the solution is to use Excel to tell Guardian Automation the when to place bets.
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

sniffer66 wrote:
Mon Mar 16, 2020 8:48 am
Hope you dont mind me piggybacking on this but it's kind of relevant.

I've been focusing on Guradian automation for a while but was intrigued by the new ability to link to Excel for SV's. One of the abilities I was hoping this might bring to the table would be to use Excel as a kind of lookup table for stats. Thinking specifically about tennis where I might have a season\career stat for service holds\break back etc
Only thing I can't get my head around is that this would need to be selection specific and I dont believe we can address selection names from Guardian.

So set an SV in Excel with the value of all (or current match) players Break Back %. Then in Guardian: IF selection is Player name x AND Break Back % SV > y THEN Back the selection

I'm guessing this isn't possible currently.
Not sure what the issue is, but if you're looking up some stats for a particular play and you want to back him/her based on certain criteria then just set a stored value for that player (selection) no when criteria is met then make that stored value a condition for placing a rule in guardian automation? You don't need the player name to pass to guardian, just that the selection has a certain stored value.

For example.

You have a table with names and stats. You lookup B9 or B11 using index/match or whatever to find the value you're looking for in that table. Then in your rules section: If value meets criteria then set a stored value for that selection. In guardian, base your rules on that stored value.

Hope I didn't misunderstand your question. Best of luck.
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

sa7med wrote:
Mon Mar 16, 2020 9:16 am
sniffer66 wrote:
Mon Mar 16, 2020 8:48 am
Hope you dont mind me piggybacking on this but it's kind of relevant.

I've been focusing on Guradian automation for a while but was intrigued by the new ability to link to Excel for SV's. One of the abilities I was hoping this might bring to the table would be to use Excel as a kind of lookup table for stats. Thinking specifically about tennis where I might have a season\career stat for service holds\break back etc
Only thing I can't get my head around is that this would need to be selection specific and I dont believe we can address selection names from Guardian.

So set an SV in Excel with the value of all (or current match) players Break Back %. Then in Guardian: IF selection is Player name x AND Break Back % SV > y THEN Back the selection

I'm guessing this isn't possible currently.
Not sure what the issue is, but if you're looking up some stats for a particular play and you want to back him/her based on certain criteria then just set a stored value for that player (selection) no when criteria is met then make that stored value a condition for placing a rule in guardian automation? You don't need the player name to pass to guardian, just that the selection has a certain stored value.

For example.

You have a table with names and stats. You lookup B9 or B11 using index/match or whatever to find the value you're looking for in that table. Then in your rules section: If value meets criteria then set a stored value for that selection. In guardian, base your rules on that stored value.

Hope I didn't misunderstand your question. Best of luck.
Thanks sa7med. To be honest i've not even started playing around with Excel yet. I just wasn't sure if it was possible to do a lookup against the unique player in Excel and Guardian would know the SV was relevant to that player, if I had multiple matches loaded
Ideally I'd be able to deploy the automation to every tennis match for the day, and as each match played out the mix of Guardian rules\conditions plus the SV values for that player in Excel would determine whether a trade was kicked off or not
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

firlandsfarm wrote:
Mon Mar 16, 2020 9:01 am
I can't comment on the detail of your request Sniffer, I will leave that to the technical guys but we are not a million miles apart. My thinking is to use Excel as the number cruncher for the current market and then pass the crunched outcome to Guardian Automation for bet handling, basically using the advantages of one to overcome the disadvantages of the other. Excel is a far more powerful manipulator of numbers and Guardian Automation is a much better manager of bets. I feel the difficulty in removing the Bet Status from Excel is a bug :evil: Why would you want to exclude placing bets in a new market just because you placed a bet in a previous market? ... they are 99.99% mutually exclusive! I know people will say there are many examples of how to clear the bet Status cell in the forum but none of them work for me! For me the solution is to use Excel to tell Guardian Automation the when to place bets.
Defintely thinking along the same lines then. I guess I really need to start playing with Excel and find out what can\can't be done
User avatar
firlandsfarm
Posts: 2686
Joined: Sat May 03, 2014 8:20 am

Excel in itself will enable you to do a lot more than you can with Guardian Automation but if you also venture into VBA coding of Excel your mind will start buzzing! :D
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

firlandsfarm wrote:
Mon Mar 16, 2020 9:41 am
Excel in itself will enable you to do a lot more than you can with Guardian Automation but if you also venture into VBA coding of Excel your mind will start buzzing! :D
Could be a good time to get my head around it. Little sport and stuck at home (self isolating :( )
User avatar
firlandsfarm
Posts: 2686
Joined: Sat May 03, 2014 8:20 am

I wish you all the best both educationally and for health. I'm 69 so just miss out on 4 months not having to socialise!! :lol: :lol: :lol:
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

sa7med wrote:
Mon Mar 16, 2020 9:16 am
sniffer66 wrote:
Mon Mar 16, 2020 8:48 am
Hope you dont mind me piggybacking on this but it's kind of relevant.

I've been focusing on Guradian automation for a while but was intrigued by the new ability to link to Excel for SV's. One of the abilities I was hoping this might bring to the table would be to use Excel as a kind of lookup table for stats. Thinking specifically about tennis where I might have a season\career stat for service holds\break back etc
Only thing I can't get my head around is that this would need to be selection specific and I dont believe we can address selection names from Guardian.

So set an SV in Excel with the value of all (or current match) players Break Back %. Then in Guardian: IF selection is Player name x AND Break Back % SV > y THEN Back the selection

I'm guessing this isn't possible currently.
Not sure what the issue is, but if you're looking up some stats for a particular play and you want to back him/her based on certain criteria then just set a stored value for that player (selection) no when criteria is met then make that stored value a condition for placing a rule in guardian automation? You don't need the player name to pass to guardian, just that the selection has a certain stored value.

For example.

You have a table with names and stats. You lookup B9 or B11 using index/match or whatever to find the value you're looking for in that table. Then in your rules section: If value meets criteria then set a stored value for that selection. In guardian, base your rules on that stored value.

Hope I didn't misunderstand your question. Best of luck.
100% concur. Based on the fact that Excel can handle SV's now, I personally would do all my crucnhing inside Excel and simply return the updated SV values to Guardian to perform the bet placement.

Previously, the only communication was via Global Commands (placing bets, Cancelling bets etc). Using Excel as the strategy engine and continuing to use a fairly bland rule in BA to react to the changing SV's is the way fwd. Great to have the mix of both but I will no longer use the Excel Global Commands to deal with bet placement - horses for courses (and logical progression). In effect, one can use a mix 'n match fo generating SV's inside either BA and/or Excel and processing as required.

Will TRY and setup a small example of an excel template with a companion BA rule that demonstrates how we remove a high degree of friction by adopting this workflow.

[edit] just found a very useful function of the command line to pass SV's. You can pass multiple values for a selection, i.e chained SV's. e.g:

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200

This means that you can send multiple SV values back to Guardian in a single action -very useful for when Guardian has to act when 1 or more SV's have a simultaneous new value. see: https://www.betangel.com/user-guide/v1_ ... 3D&mw=MzIw
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

jimibt wrote:
Mon Mar 16, 2020 10:43 am
sa7med wrote:
Mon Mar 16, 2020 9:16 am
sniffer66 wrote:
Mon Mar 16, 2020 8:48 am
Hope you dont mind me piggybacking on this but it's kind of relevant.

I've been focusing on Guradian automation for a while but was intrigued by the new ability to link to Excel for SV's. One of the abilities I was hoping this might bring to the table would be to use Excel as a kind of lookup table for stats. Thinking specifically about tennis where I might have a season\career stat for service holds\break back etc
Only thing I can't get my head around is that this would need to be selection specific and I dont believe we can address selection names from Guardian.

So set an SV in Excel with the value of all (or current match) players Break Back %. Then in Guardian: IF selection is Player name x AND Break Back % SV > y THEN Back the selection

I'm guessing this isn't possible currently.
Not sure what the issue is, but if you're looking up some stats for a particular play and you want to back him/her based on certain criteria then just set a stored value for that player (selection) no when criteria is met then make that stored value a condition for placing a rule in guardian automation? You don't need the player name to pass to guardian, just that the selection has a certain stored value.

For example.

You have a table with names and stats. You lookup B9 or B11 using index/match or whatever to find the value you're looking for in that table. Then in your rules section: If value meets criteria then set a stored value for that selection. In guardian, base your rules on that stored value.

Hope I didn't misunderstand your question. Best of luck.
100% concur. Based on the fact that Excel can handle SV's now, I personally would do all my crucnhing inside Excel and simply return the updated SV values to Guardian to perform the bet placement.

Previously, the only communication was via Global Commands (placing bets, Cancelling bets etc). Using Excel as the strategy engine and continuing to use a fairly bland rule in BA to react to the changing SV's is the way fwd. Great to have the mix of both but I will no longer use the Excel Global Commands to deal with bet placement - horses for courses (and logical progression). In effect, one can use a mix 'n match fo generating SV's inside either BA and/or Excel and processing as required.

Will TRY and setup a small example of an excel template with a companion BA rule that demonstrates how we remove a high degree of friction by adopting this workflow.

[edit] just found a very useful function of the command line to pass SV's. You can pass multiple values for a selection, i.e chained SV's. e.g:

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200

This means that you can send multiple SV values back to Guardian in a single action -very useful for when Guardian has to act when 1 or more SV's have a simultaneous new value. see: https://www.betangel.com/user-guide/v1_ ... 3D&mw=MzIw
Thanks Jim. An example flow would be appreciated and would be great way for me to get my head around the setup.

One thing did strike me thinking through this and that is that it would be great if we had a command line interface directly in to BA Guardian.
Then it would be possible to use any scripting/coding tool to pass your example commmand below

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200

Then we are not bound solely by Excel but can manipulate the data in any way we like, using Excel from the script if needed.
For instance I use Auto-it a lot and being able to scrape, build arrays from CSV's\ XLXS etc and then do x, y and z with it would be very powerful.

Then again, I'm probably thinking along those lines as I'm crap with Excel lol. Time to get to work on that !
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

sniffer66 wrote:
Mon Mar 16, 2020 11:43 am
Thanks Jim. An example flow would be appreciated and would be great way for me to get my head around the setup.

One thing did strike me thinking through this and that is that it would be great if we had a command line interface directly in to BA Guardian.
Then it would be possible to use any scripting/coding tool to pass your example commmand below

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200

Then we are not bound solely by Excel but can manipulate the data in any way we like, using Excel from the script if needed.
For instance I use Auto-it a lot and being able to scrape, build arrays from CSV's\ XLXS etc and then do x, y and z with it would be very powerful.

Then again, I'm probbaly thinking along those lines as I'm crap with Excel lol. Time to get to work on that !
So, what I have actually done in reality is to run .net code inside Excel and then pass and manipluate the output in Excel to place the bets. By using SV's, I will pretty much simplify my setup by still using .net for the strategy engine. However, I will change the logic of the output in Excel to literally populate the approapiate cell with SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200. I'll then leave the BA rule to do the rest and notify back to Excel if required (i.e. send back a notifiction SV to Excel which would in turn inform the .net code of the next steps -if any).

I actually made a request a few years back to have an interface (i.e. a software contract) exposed by BA that would allow us (as developers) to plugin to the BA code via our dll's. For one reason or another, this was not viable and this is when I adopted the approach of using Excel to place the bets (via the global command) in response to events raised by the .net code. Things just got a degree more frictionfree as a result of the SV integration. I will now use Excel as an adaptor onto my .net code and the SV's as a way to promote the action back up to BA.

Hope this makes sense ;)
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

jimibt wrote:
Mon Mar 16, 2020 11:57 am
sniffer66 wrote:
Mon Mar 16, 2020 11:43 am
Thanks Jim. An example flow would be appreciated and would be great way for me to get my head around the setup.

One thing did strike me thinking through this and that is that it would be great if we had a command line interface directly in to BA Guardian.
Then it would be possible to use any scripting/coding tool to pass your example commmand below

SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200

Then we are not bound solely by Excel but can manipulate the data in any way we like, using Excel from the script if needed.
For instance I use Auto-it a lot and being able to scrape, build arrays from CSV's\ XLXS etc and then do x, y and z with it would be very powerful.

Then again, I'm probbaly thinking along those lines as I'm crap with Excel lol. Time to get to work on that !
So, what I have actually done in reality is to run .net code inside Excel and then pass and manipluate the output in Excel to place the bets. By using SV's, I will pretty much simplify my setup by still using .net for the strategy engine. However, I will change the logic of the output in Excel to literally populate the approapiate cell with SET_SV FOR:SELECTION NAME:Test1 VALUE:42 NAME:Test2 Value:99 NAME:Test3 Value:200. I'll then leave the BA rule to do the rest and notify back to Excel if required (i.e. send back a notifiction SV to Excel which would in turn inform the .net code of the next steps -if any).

I actually made a request a few years back to have an interface (i.e. a software contract) exposed by BA that would allow us (as developers) to plugin to the BA code via our dll's. For one reason or another, this was not viable and this is when I adopted the approach of using Excel to place the bets (via the global command) in response to events raised by the .net code. Things just got a degree more frictionfree as a result of the SV integration. I will now use Excel as an adaptor onto my .net code and the SV's as a way to promote the action back up to BA.

Hope this makes sense ;)
I think that makes sense. You are purely using Excel as a gateway\conduit between your .net code and BA ?

On that basis anything that could write\read from an Excel cell would also be viable to use ?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”