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

User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

sniffer66 wrote:
Tue Aug 04, 2020 1:13 pm
jimibt wrote:
Tue Aug 04, 2020 1:06 pm
sniffer66 wrote:
Tue Aug 04, 2020 12:44 pm
I'm just trying to get my head around the concept of these. So you can reference any existing History list from a rules file. And you can save User Created SV's to that History list - as long as you know the SV name you can reference it's value from another rule ?
History Lists are like global lists that can be accessed from your rules files, the ladder settings etc. you can also take values either directly from History Lists (in rules) OR, you can copy values out from the lists to sV's. the beauty here is that you can populate an sv with a historical value i.e. vwap05, vwap10, vwap30 etc, etc based on pulling them from the History List. the image below shows this (where History List4 contains vwap):
Thanks, that's what I thought.

Are those lists writeable outside of BA ? I'm going somewhere with this ;)
you can Save the SV's (and history lists) to a file for use outsde of BA and perform analysis on them.
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 am

jimibt wrote:
Tue Aug 04, 2020 1:31 pm
sniffer66 wrote:
Tue Aug 04, 2020 1:13 pm
jimibt wrote:
Tue Aug 04, 2020 1:06 pm


History Lists are like global lists that can be accessed from your rules files, the ladder settings etc. you can also take values either directly from History Lists (in rules) OR, you can copy values out from the lists to sV's. the beauty here is that you can populate an sv with a historical value i.e. vwap05, vwap10, vwap30 etc, etc based on pulling them from the History List. the image below shows this (where History List4 contains vwap):
Thanks, that's what I thought.

Are those lists writeable outside of BA ? I'm going somewhere with this ;)
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
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

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


Thanks, that's what I thought.

Are those lists writeable outside of BA ? I'm going somewhere with this ;)
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 ;)
You do not have the required permissions to view the files attached to this post.
sniffer66
Posts: 1666
Joined: Thu May 02, 2019 8:37 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 ;)

Definitely! Think I need to have a long play around. Cheers for the help Jim
User avatar
murdok
Posts: 151
Joined: Sun Apr 02, 2017 7:10 pm

jimibt wrote:
Tue Aug 04, 2020 1:37 pm

save-svs.PNG

I'd say that's pretty useful (for many reasons ;)

i agree with you it is very useful the problem is the data processing (csv file) it is a bit mixed it doesn't make much sense your data already has treatment and it is very good
cemocan70
Posts: 12
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: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

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: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

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: 76
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: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

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: 76
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: 629
Joined: Thu Dec 24, 2009 9:20 am
Location: Surin City, Thailand

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: 2004
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: 629
Joined: Thu Dec 24, 2009 9:20 am
Location: Surin City, Thailand

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

Return to “Bet Angel Automation - General”