Store a Value to History Lists (Price, Volume, Greening Data)

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

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: 2823
Joined: Mon Nov 30, 2015 6:42 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: 2823
Joined: Mon Nov 30, 2015 6:42 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.
robsmith
Posts: 41
Joined: Wed Aug 25, 2010 12:19 pm

Downloaded 22 times but no “thank yous”?

Thanks Jim this is very helpful.
User avatar
jimibt
Posts: 2823
Joined: Mon Nov 30, 2015 6:42 pm

robsmith wrote:
Thu Nov 26, 2020 10:40 am
Downloaded 22 times but no “thank yous”?

Thanks Jim this is very helpful.
rob - no worries. and tbh, since i don't monitor things too closely, never really expect any thumbs up in any way - but much appreciated that you took the time!! ;)
robsmith
Posts: 41
Joined: Wed Aug 25, 2010 12:19 pm

Hi Jim,

One question: do you know why data is recorded in different columns mid way through the day? Eg the 2.40 yesterday started with the data for Epsom Des Mottes starting in column D then it changed to the data for Ballydonagh Boy being recorded in column D. Bally was originally being recorded in AF onwards.

I don't seem to be able to attach it here so I've uploaded it: https://drive.google.com/file/d/1Zluo79 ... sp=sharing

Thanks
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

jimibt wrote:
Thu Nov 26, 2020 8:42 pm
robsmith wrote:
Thu Nov 26, 2020 10:40 am
Downloaded 22 times but no “thank yous”?

Thanks Jim this is very helpful.
rob - no worries. and tbh, since i don't monitor things too closely, never really expect any thumbs up in any way - but much appreciated that you took the time!! ;)
Guess the forum could do with some kind of 'like' button for things like that as most people don't want to litter a thread with thank yous unless they've been helped directly.
lotora
Posts: 121
Joined: Thu Dec 24, 2009 9:20 am

I'll like to use a condition in which every selection included will have to account for at least 10% of the traded market volume (History List 1 – Volume of a Selection, History List 3 – Volume of the Market).
Correct?, or should I rather use History List 2 – Volume% of a Selection? In that case can anyone show how by posting an image? Anyway, is it necessary to store data in History List 1 in order to be able to store/use data in History List 2?
Capture.PNG
You do not have the required permissions to view the files attached to this post.
Anbell
Posts: 868
Joined: Fri Apr 05, 2019 2:31 am

lotora wrote:
Wed Dec 30, 2020 12:29 am
I'll like to use a condition in which every selection included will have to account for at least 10% of the traded market volume (History List 1 – Volume of a Selection, History List 3 – Volume of the Market).
Correct?, or should I rather use History List 2 – Volume% of a Selection? In that case can anyone show how by posting an image? Anyway, is it necessary to store data in History List 1 in order to be able to store/use data in History List 2?
Capture.PNG
I dont think you need to worry about history lists.

I think it'd work if you just had Value A as Volume %
is greater than
an entered amount
10
lotora
Posts: 121
Joined: Thu Dec 24, 2009 9:20 am

You just made my life much easier! Thank you!
Post Reply

Return to “Bet Angel Automation - General”