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?
Store a Value to History Lists (Price, Volume, Greening Data)
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 sectionallanmctrader wrote: ↑Tue Jul 06, 2021 10:09 amHi, 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?
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
- paspuggie48
- Posts: 638
- 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?
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?
You do not have the required permissions to view the files attached to this post.
You need an SV rule which stores the Form to trigger 1 time and to be applied to Every Selectionpaspuggie48 wrote: ↑Thu Jun 30, 2022 8:34 amI 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.
- paspuggie48
- Posts: 638
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Used a Set/Modify Stored Value rule applied to Every selection to store the selections 'form'paspuggie48 wrote: ↑Thu Jun 30, 2022 12:56 pmI must have the wrong rule as it won't let me store for 'Every', so what did you do exactly Dallas?![]()
Then triggered an 'Export Stored Values' rule, that was just left applied to BF row by default as it wasn't using any conditions
- paspuggie48
- Posts: 638
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Brilliant, gotchya Dallas, I've got it working now, thank you.Dallas wrote: ↑Thu Jun 30, 2022 11:01 pmUsed a Set/Modify Stored Value rule applied to Every selection to store the selections 'form'paspuggie48 wrote: ↑Thu Jun 30, 2022 12:56 pmI must have the wrong rule as it won't let me store for 'Every', so what did you do exactly Dallas?![]()
Then triggered an 'Export Stored Values' rule, that was just left applied to BF row by default as it wasn't using any conditions
- paspuggie48
- Posts: 638
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
OMG, I have only just discovered that the data dump adds the information to the end of the existing filename, keeping all previous data.
All this time I have been exporting each Rule and saving it with the specific date, creating loads of files. Although no problem for PQ to combine all the data.
Now I know I only need to add the Rule and just leave it to do update and combine it all by itself, all in 1 file
![Wink ;)](./images/smilies/icon_e_wink.gif)
![Shocked :shock:](./images/smilies/icon_eek.gif)
Live 'n learn every day !!
You do not have the required permissions to view the files attached to this post.
- paspuggie48
- Posts: 638
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
If you're reading this Dallas
After you helped me with the export of SV data I thought I'd add Custom Ranking 2 (Ranks selections by their SP)
Alas, the export of ranks show all horses in each race as " 0 "
Is there something I have not set up correctly?
After you helped me with the export of SV data I thought I'd add Custom Ranking 2 (Ranks selections by their SP)
Alas, the export of ranks show all horses in each race as " 0 "
Is there something I have not set up correctly?
You do not have the required permissions to view the files attached to this post.
You'll need a 'Update Custom Rankings of Selections' rule to first put the selections in Custom rankings 2 (or which ever custom ranking list you want to use) in ascending or descending orderpaspuggie48 wrote: ↑Thu Nov 24, 2022 9:18 amIf you're reading this Dallas
After you helped me with the export of SV data I thought I'd add Custom Ranking 2 (Ranks selections by their SP)
Alas, the export of ranks show all horses in each race as " 0 "
Is there something I have not set up correctly?
Screenshot 2022-11-24 091658.png
- paspuggie48
- Posts: 638
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Thanks Dallas...seems to be working
Just one thing, during set up I had the wrong setting and got an error msg and BA crashed. I wasn't able to take a screenshot but if it happens again I'll log it on the Forum.
Many thanks
Paul
![Wink ;)](./images/smilies/icon_e_wink.gif)
Just one thing, during set up I had the wrong setting and got an error msg and BA crashed. I wasn't able to take a screenshot but if it happens again I'll log it on the Forum.
Many thanks
Paul
You do not have the required permissions to view the files attached to this post.
-
- Posts: 45
- Joined: Sun Feb 28, 2021 11:12 am
Evening all, what is the best way to export and organise data from stored values? i am currently copying the log and sorting it in excel using text to columns. I basically want something that gets the data into excel in a more user friendly way then i can analyse the data in pivot tables to see what the horses price and volume did during the time rules that i set. Any help would be much appreciated. I have managed to set this rule up in the one click screen with no problems but would like to be able to review the data in excel at a later time.
If its a small 'Exception' box that you got if you click 'Detail's and copy/paste the jit log into a notepad then attach that to a post that would be the best waypaspuggie48 wrote: ↑Thu Nov 24, 2022 8:49 pmThanks Dallas...seems to be working![]()
Screenshot 2022-11-24 204712.png
Just one thing, during set up I had the wrong setting and got an error msg and BA crashed. I wasn't able to take a screenshot but if it happens again I'll log it on the Forum.
Many thanks
Paul
Thats pretty much the way I'm doing it when I need to but Paspuggie48 might have a better solution you could tryDanTheMan1 wrote: ↑Thu Nov 24, 2022 10:13 pmEvening all, what is the best way to export and organise data from stored values? i am currently copying the log and sorting it in excel using text to columns. I basically want something that gets the data into excel in a more user friendly way then i can analyse the data in pivot tables to see what the horses price and volume did during the time rules that i set. Any help would be much appreciated. I have managed to set this rule up in the one click screen with no problems but would like to be able to review the data in excel at a later time.