Bet Angel Automation - General : Store a Value to History Lists (Price, Volume, Greening Data)

cemocan70
Posts: 4
Joined: Sun Dec 23, 2018 12:59 am

Thu Aug 27, 2020 12:54 pm

jimibt wrote:
Tue Aug 04, 2020 1:37 pm
sniffer66 wrote:
Tue Aug 04, 2020 1:35 pm
jimibt wrote:
Tue Aug 04, 2020 1:31 pm


you can Save the SV's (and history lists) to a file for use outsde of BA and perform analysis on them.
I was playing around with the concept of overwriting a value in a History list externally as a way of passing\updating an SV used in a rule without reverting to Excel. But I don't think thats possible from the sound of it - the lists don't seem to be held anywhere as a viewable file
no, it's held in memory inside BA's process, so is only accessible if pinged onto Excel. However, don't undervalue what you can *transform* as a result. here's the 1st timeband of the 13:30 Bev race saved and transformed as per the sv's example from earlier:

save-svs.PNG

I'd say that's pretty useful (for many reasons ;)
Hi there, sorry folks newbee here,

trying to understand the subject, storing the values is brilliant but how to transfer them into excel (such in the screenshot)? to analyze them later, i'll be much appreciated for your help. thanks in advance.

User avatar
jimibt
Posts: 2584
Joined: Mon Nov 30, 2015 6:42 pm

Thu Aug 27, 2020 1:04 pm

cemocan70 wrote:
Thu Aug 27, 2020 12:54 pm
jimibt wrote:
Tue Aug 04, 2020 1:37 pm
sniffer66 wrote:
Tue Aug 04, 2020 1:35 pm


I was playing around with the concept of overwriting a value in a History list externally as a way of passing\updating an SV used in a rule without reverting to Excel. But I don't think thats possible from the sound of it - the lists don't seem to be held anywhere as a viewable file
no, it's held in memory inside BA's process, so is only accessible if pinged onto Excel. However, don't undervalue what you can *transform* as a result. here's the 1st timeband of the 13:30 Bev race saved and transformed as per the sv's example from earlier:

save-svs.PNG

I'd say that's pretty useful (for many reasons ;)
Hi there, sorry folks newbee here,

trying to understand the subject, storing the values is brilliant but how to transfer them into excel (such in the screenshot)? to analyze them later, i'll be much appreciated for your help. thanks in advance.
You can save any SV type set of values into a history list and then assign the history list to be save to a csv file after each refresh (this saves each line sequentially). You can then transform the csv to whatever format you need (tho in the case of the screenshot that you mentioned, this is a custom piece of code that i created to transform the csv.

At some point later, I'll put a quick baf file up that shows a very basic example of storing and saving this data, tho of course, there are screenshots in the previous pages here that show the steps, so you should be able to get a feel for it from that.

User avatar
jimibt
Posts: 2584
Joined: Mon Nov 30, 2015 6:42 pm

Thu Aug 27, 2020 1:36 pm

cemocan70 wrote:
Thu Aug 27, 2020 12:54 pm

Hi there, sorry folks newbee here,

trying to understand the subject, storing the values is brilliant but how to transfer them into excel (such in the screenshot)? to analyze them later, i'll be much appreciated for your help. thanks in advance.
ok, here you go - a basic PRE race rule that gathers data items in History Lists, then uses those lists to extract various values into SV's and then saves the data to a csv during the 5 minute PRE window.

enjoy...

[edit] Forget ot mention. once you apply the rule, you'll need to edit the file location of the Save Export CSV rule. just set it to point to your own local folders and keep the final filename as *.PRE.csv :)
You do not have the required permissions to view the files attached to this post.

Post Reply

Return to “Bet Angel Automation - General”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest