you can Save the SV's (and history lists) to a file for use outsde of BA and perform analysis on them.sniffer66 wrote: ↑Tue Aug 04, 2020 1:13 pmThanks, that's what I thought.jimibt wrote: ↑Tue Aug 04, 2020 1:06 pmHistory 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):sniffer66 wrote: ↑Tue Aug 04, 2020 12:44 pmI'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 ?
Are those lists writeable outside of BA ? I'm going somewhere with this
Store a Value to History Lists (Price, Volume, Greening Data)
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 filejimibt wrote: ↑Tue Aug 04, 2020 1:31 pmyou can Save the SV's (and history lists) to a file for use outsde of BA and perform analysis on them.sniffer66 wrote: ↑Tue Aug 04, 2020 1:13 pmThanks, that's what I thought.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):
Are those lists writeable outside of BA ? I'm going somewhere with this
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:sniffer66 wrote: ↑Tue Aug 04, 2020 1:35 pmI 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
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.
jimibt wrote: ↑Tue Aug 04, 2020 1:37 pmno, 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:sniffer66 wrote: ↑Tue Aug 04, 2020 1:35 pmI 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
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
Hi there, sorry folks newbee here,jimibt wrote: ↑Tue Aug 04, 2020 1:37 pmno, 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:sniffer66 wrote: ↑Tue Aug 04, 2020 1:35 pmI 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
save-svs.PNG
I'd say that's pretty useful (for many reasons
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.cemocan70 wrote: ↑Thu Aug 27, 2020 12:54 pmHi there, sorry folks newbee here,jimibt wrote: ↑Tue Aug 04, 2020 1:37 pmno, 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: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
save-svs.PNG
I'd say that's pretty useful (for many reasons
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.
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.
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.
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
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
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
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.
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?
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?
You do not have the required permissions to view the files attached to this post.
I dont think you need to worry about history lists.lotora wrote: ↑Wed Dec 30, 2020 12:29 amI'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 think it'd work if you just had Value A as Volume %
is greater than
an entered amount
10