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

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!
allanmctrader
Posts: 3
Joined: Thu Dec 02, 2010 4:07 pm

Hi, great thread.

Touching on this subject is it possible to get bet angel to log the odds at certain times of day for individual races?

ie at 9am, 11am etc and for them to be stored and displayed along side the race preoff? to possible correlate the sentiment of the market at different times of day?
User avatar
Dallas
Posts: 22673
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

allanmctrader wrote:
Tue Jul 06, 2021 10:09 am
Hi, great thread.

Touching on this subject is it possible to get bet angel to log the odds at certain times of day for individual races?

ie at 9am, 11am etc and for them to be stored and displayed along side the race preoff? to possible correlate the sentiment of the market at different times of day?
Yes you could do that, there's a few ready-made files including the settings/layouts needed to display them on your one-click and ladder trading screens in the customization section
viewforum.php?f=62

Two examples from the one-click screen area include
viewtopic.php?f=69&t=22652
viewtopic.php?f=69&t=22876

Or there's this example in the tips and tricks section
viewtopic.php?f=61&t=21085
elofan0
Posts: 316
Joined: Fri Jan 13, 2017 4:44 pm

just a thought for me as a novice looking at the history lists just wondering why volume % of the market isnt in there , there is volume of the market but not percentage, thanks
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

I use the Export Market Lists quite effectively from my Column Layout to get a full list of every horse, race type etc for every race. However, what it does not provide is the 'Form' of each horse.

Is there already a Stored Value List somewhere I can use to get all the Form figures, so I can export it for each horse in each market?

I've tried but the Rule I set up to Export All Stored Values is pulling hundreds of columns of data for each race that I don't want e.g. high & low prices, references from other Rules etc. I have not shared it with any other Rule or have any conditions, just one simple Rule, see below.

I simply want the race time, horse and form only. Is this possible?

Screenshot 2022-06-30 083014.png
You do not have the required permissions to view the files attached to this post.
User avatar
Dallas
Posts: 22673
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

paspuggie48 wrote:
Thu Jun 30, 2022 8:34 am
I use the Export Market Lists quite effectively from my Column Layout to get a full list of every horse, race type etc for every race. However, what it does not provide is the 'Form' of each horse.

Is there already a Stored Value List somewhere I can use to get all the Form figures, so I can export it for each horse in each market?

I've tried but the Rule I set up to Export All Stored Values is pulling hundreds of columns of data for each race that I don't want e.g. high & low prices, references from other Rules etc. I have not shared it with any other Rule or have any conditions, just one simple Rule, see below.

I simply want the race time, horse and form only. Is this possible?


Screenshot 2022-06-30 083014.png
You need an SV rule which stores the Form to trigger 1 time and to be applied to Every Selection
SV.JPG
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel Automation - General”