I know that we can now pass Stored Values from Guardian to Excel.
Can we do the reverse?
That would be (is?) incredibly powerful.
Create Stored Values in Excel, import into Guardian?
Hi yes, i replied to a similar thread a while back after doing some research on it...
viewtopic.php?f=19&t=20724&p=215231
a pretty powerful way fwd now
omfg!
I'd much rather work in excel where you can visually see how each SV is created. I find that working in BA is 'blind' and it is difficult to find logic errors, and difficult/laborious/time consuming to set rules for each runner, and difficult/annoying to maintain consistency across rules etc.
(e.g. I might have a set of rules with a stake of $50, $100, $500 depending on the market, over 24 animals, but if I want to change one variable, it's a challenge to keep the rules consistent across each stake)
This is amazing.
Thank you.
ETA: How do other people manage this? If you want to change or add a variable and test/compare various strategies, do you literally go through and change it for 24 runners manually? And if you want to change two variables?
I'd much rather work in excel where you can visually see how each SV is created. I find that working in BA is 'blind' and it is difficult to find logic errors, and difficult/laborious/time consuming to set rules for each runner, and difficult/annoying to maintain consistency across rules etc.
(e.g. I might have a set of rules with a stake of $50, $100, $500 depending on the market, over 24 animals, but if I want to change one variable, it's a challenge to keep the rules consistent across each stake)
This is amazing.
Thank you.
ETA: How do other people manage this? If you want to change or add a variable and test/compare various strategies, do you literally go through and change it for 24 runners manually? And if you want to change two variables?
if i understand your question correctly, you are asking how does one change values in existing SV's across different strategies?? if so, then here is how i apporach it (the combo of BA=>Excel and Excel=>BA).
Excel:
1. Collect Interop data from BA and organise it into a class structure (for now, i will simplify it and consider everything in Excel as being purely VBA classes -in reality, i plumb it out to .net code)
2. Store each price in such a way as to be able to compare historical data inside the vba class (assumption -5 minute pre-race timeframe)
3. vba class has a strategy component (i.e. a piece of vba that has a prescribed purpose) -use this class/method to produce an array/list of runners and associated actions
4. Using an event handler, raise an event that contains the runner/action list when the strategy component validates that all conditions have been met
5. Inside the above event handler, produce the SV's and associated values and issue them as global command back to BA Guardian
BA Guardian
1. create a very basic rule that acts on the values of any SV's who's values change
2. if required, set some very basic SV's in Guardian that are sent back to Excel to confirm status of action (optional)
If you consider each BA=>Excel as a self contained instance, it means that you can fire up multiple instances of BA and connect different strategy components in the form of different Excel templates. You could also do this with a single BA/Excel instance by assigning a value to a Market level SV and give it a name such as Market_Strategy_Name. This value would be read inside Excel and the vba code could at this point choose which strategy class it was going to invoke (very useful if you have varying strategies that operate differently on different types of race).
In short by having a very simple rule in BA that performs actions (bet placement, greening up etc) based on the SV's generated by Excel, you can have a very neatly decoupled platform that can be changed very easily, simply by telling Excel which strategy you'd like to use for the given market/event.
Hope i read your request correctly, otherwise, this may read a pure gobbledy gook!!
I've just learned about customerStrategyRef & CustomerOrderRefAnbell wrote: ↑Mon May 04, 2020 10:24 amomfg!
I'd much rather work in excel where you can visually see how each SV is created. I find that working in BA is 'blind' and it is difficult to find logic errors, and difficult/laborious/time consuming to set rules for each runner, and difficult/annoying to maintain consistency across rules etc.
(e.g. I might have a set of rules with a stake of $50, $100, $500 depending on the market, over 24 animals, but if I want to change one variable, it's a challenge to keep the rules consistent across each stake)
This is amazing.
Thank you.
ETA: How do other people manage this? If you want to change or add a variable and test/compare various strategies, do you literally go through and change it for 24 runners manually? And if you want to change two variables?
This should really be a thing on BA!
I can only find one reference to it on the forums from 5 years ago when it was introduced viewtopic.php?p=107658#p107658
At a minimum if we could stamp each bet with the name (ID) of the automation, or even (much) better we could use something like Stored Values to tag each bet with a customerStrategyRef (which I presume can be found / recalled / tracked via BetHistory or somehow else)