How to capture data using Bet Angel??

[Brovashift]

Hi all,

Just wondering how I go about capturing market data/information e.g. event details, price, volume, bets, bsp etc.

Is it done using 'history lists', and goes to the extent to whatever is in the history list dropdown?

And can this been either exported into an exel file, or can it be logged straight into an excel file (even better!)

TIA

[Dabbla]

You can use the rule (export all stored values). This will store the data in to Excel as csv file. Theirs a few different options , so have a play and see what’s best for what you want.

If you tick the (limit export to specific SVs) box in the parameters tab. You will be able to add the SVs you want saved.
The saved files can be found here > Bet Angel Professional > SVExports.

You don’t need Excel open for it to save the data

[Brovashift]

You can use the rule (export all stored values). This will store the data in to Excel as csv file. Theirs a few different options , so have a play and see what’s best for what you want.

If you tick the (limit export to specific SVs) box in the parameters tab. You will be able to add the SVs you want saved.
The saved files can be found here > Bet Angel Professional > SVExports.

You don’t need Excel open for it to save the data

Thanks Dabbla, will give this a try...

[Brovashift]

You can use the rule (export all stored values). This will store the data in to Excel as csv file. Theirs a few different options , so have a play and see what’s best for what you want.

If you tick the (limit export to specific SVs) box in the parameters tab. You will be able to add the SVs you want saved.
The saved files can be found here > Bet Angel Professional > SVExports.

You don’t need Excel open for it to save the data

Hi Dabbla (& Everyone...)

Can anyone tell me why I am unable to add data to a csv file??

I have just tried to make something basic to get things working by following this blog post https://www.betfairtradingblog.com/bet- ... ts-arrays/. I'll attach some images but its simply storing 'Last traded price' for every selection and volume of the market from 10mins to post time.

I wasn't sure whether to set the rule to export to csv in the same rule as the history list creation, or create a separate rule to export to csv in the same automation, so I tried both...

The data is recording in the log, but when I uncheck the 'value in markets log' checkbox it still doesn't add/create a csv file in \SVExports.

In that BA blog as well the link to further reading on how to do this takes me to a page that says I don't have permission to view this content, so assume its been removed or moved since the blog was written.
viewtopic.php?f=28&t=21474

Any help appreciated... Thanks

[Dabbla]

The first image shows the rule (save to csv) only triggers once and that triggers 1 second before the (store price history) rule. So no data will be available to save. You would need to tick the (unlimited triggers) option.

Also check the selections are the same, Image 1 shows row 1 and the 2nd image show ANY selection. That could also be causing some conflict.
Personally I would create a separate rule to export.

[Brovashift]

The first image shows the rule (save to csv) only triggers once and that triggers 1 second before the (store price history) rule. So no data will be available to save. You would need to tick the (unlimited triggers) option.

Also check the selections are the same, Image 1 shows row 1 and the 2nd image show ANY selection. That could also be causing some conflict.
Personally I would create a separate rule to export.

Ah, I see what you mean... I had the time the wrong way around, 1sec before instead of 1sec after.

I wanted to capture the price data of Every Selection, but it wont let me do that on the Export all Values rule, so I just set it to row1 on both to try and get things working, but its still not creating anything in SVExports

So I created a rule to store price history as type Set/Modify, armed at 10min before event start time, until 00:00. Unlimited triggers, and waits 5 secs before rearming. Applies to selection row 1.
2 stored values in history lists;
History list1: For a Nominated Selection: row1, with last traded price book % of a selection, Selection used 'Current' row 1. Market Log unchecked.
History list2: For Nominated Selection: row1, with volume of a selection, Selection Used 'Current' row1. market Log unchecked.

Created a 2nd rule "save to csv".
Rule type: Export all stored values.
Armed at event start time: 09:59
Unlimited triggers
Wait 5 seconds before rearming
Selection: row1

In the params tab I just left everything unchanged...

Is anything jumping out at you that I might have done wrong?

TIA

[Dabbla]

You can store the price for (Every), do that in the data rule. Use (Any) to Export, Sorry my mistake in the last post.

If you haven’t changed any of the settings in the parameters tab , its possibly updating the default file called Values without you realizing. Check that file for any changes.

To create new files each race, you need to change to your preferred option in the (Filename options tab).
I would save the values as SV not as history lists, unless you need them for a chart.

These are my parameter settings

para1.PNG

If you see where it says (STRIDE) in the file name, change that if you want a different set of files

[Brovashift]

You can store the price for (Every), do that in the data rule. Use (Any) to Export, Sorry my mistake in the last post.

If you haven’t changed any of the settings in the parameters tab , its possibly updating the default file called Values without you realizing. Check that file for any changes.

To create new files each race, you need to change to your preferred option in the (Filename options tab).
I would save the values as SV not as history lists, unless you need them for a chart.

These are my parameter settings
para1.PNG

If you see where it says (STRIDE) in the file name, change that if you want a different set of files

Cheers Dabbla, thats all working now

I just need to have a play about with what values I need to store.

Re the Excel formatting, is there no way of having the stored value names in the first row, with relevant data in the corresponding column? As it is its a bit of a mish mash init, it's hard to read whats what...

I set my rules to EVERY and the export to ANY like you suggested, but it is only capturing the top 3 in the market. Not much of an issue as thats really all I am interested in, maybe the top 4. Not sure if thats correct, I thought EVERY would capture the whole field (racing markets)?

EDIT: I just added this snipet from my excel (Wincanton 14:25) after changing HL1 from 'last traded price Book %' to 'price of selection' to see if it made things a bit more uniform, and left HL2 as Volume % of a selection. But I cannot make sense of the values stored in the excel as they dont seem to relate to either selections price or volume lol. Am I missing somthing?

[Dabbla]

The only other export option would put all runners on separate rows but will be even more of a mish mash.

I'm not sure why its only storing the top 3/4 , it shouldn’t. It should store them all , maybe you have a condition stopping some of them !

Its possible that some of the excel book needs formatting. Example hl2 should be formatted as a% not a number. You may also want to give it a new file name to see if that straighten things up.

You will probably want to create a separate excel file to put this data in. So that it’s in a more readable state. The reason I don’t store HL, is it’s a bit more messy. Svs only seems to be the better option.

[Brovashift]

The only other export option would put all runners on separate rows but will be even more of a mish mash.

I'm not sure why its only storing the top 3/4 , it shouldn’t. It should store them all , maybe you have a condition stopping some of them !

Its possible that some of the excel book needs formatting. Example hl2 should be formatted as a% not a number. You may also want to give it a new file name to see if that straighten things up.

You will probably want to create a separate excel file to put this data in. So that it’s in a more readable state. The reason I don’t store HL, is it’s a bit more messy. Svs only seems to be the better option.

Cheers Dabbla, I will have to have a play about with it to see if I can make sense of it. I was wondering if I should try one of the example spreedsheets to see if they output things in a more readable format?

From what I can tell this sheet has values for book1, 2, and 3 which I assume is the top three of the book based on the selections names. And there is also 'book tot' which I am guessing is the book total (even though I never asked for it lol). Maybe setting the column data types might make it make more sense.

When you say"SV's" are you referring to 'Servants'?

[Dabbla]

I don’t think the shared sheets have anything to do with the (export Stored Values Rule ) but you can have a look you might find something.

Svs = stored Values

Just to help you understand what’s going on in the sheet.
In your screen shot above Column K is how many SVs are set for each selection = 4.
“book” “book 1” “book 1 and 2” “booktot”
I’m a bit confused why column U is only = 3.

[Brovashift]

I don’t think the shared sheets have anything to do with the (export Stored Values Rule ) but you can have a look you might find something.

Svs = stored Values

Just to help you understand what’s going on in the sheet.
In your screen shot above Column K is how many SVs are set for each selection = 4.
“book” “book 1” “book 1 and 2” “booktot”
I’m a bit confused why column U is only = 3.

Stored values (SV's)... of course

Thanks Dabbla, I haven't had a chance to pay around with this yet, but will get to it over the weekend...

[WillWill]

Hello,
I am closely following this thread as I have just started using Bet Angel to automate data capture (BSP price) for selected markets.
I have also reviewed the following post: https://www.betfairtradingblog.com/bet- ... ts-arrays/. However, I have encountered a few issues and would appreciate some guidance:
1) I have created the same rules as you, but in the "Stored Values" tab, I do not have the option "with: the Back Price of selection." Instead, I only see "the Price of a selection" after selecting "The best Back price of a selection." Is this expected?
2) If I apply this to a football match (Match Odds market), should I be able to store the Back odds for Home, Draw, and Away selections?
3) Over the weekend, I tested my "Save to CSV" rule on a match (Alavés vs. Getafe), but the resulting CSV file was empty the next day. Could you suggest what might have gone wrong?
4) In Peter’s videos, I noticed he has a column for "Automation Rules 2", which does not appear on my interface. Could this be affecting my setup?
Any insights would be greatly appreciated.

Screenshot 2025-02-10 at 8.40.15 PM-min.png

Screenshot 2025-02-09 at 5.44.35 PM-min.png

[ODPaul82]

1) I have created the same rules as you, but in the "Stored Values" tab, I do not have the option "with: the Back Price of selection." Instead, I only see "the Price of a selection" after selecting "The best Back price of a selection." Is this expected?
2) If I apply this to a football match (Match Odds market), should I be able to store the Back odds for Home, Draw, and Away selections?
3) Over the weekend, I tested my "Save to CSV" rule on a match (Alavés vs. Getafe), but the resulting CSV file was empty the next day. Could you suggest what might have gone wrong?
4) In Peter’s videos, I noticed he has a column for "Automation Rules 2", which does not appear on my interface. Could this be affecting my setup?
Any insights would be greatly appreciated.

1) Yes
2) Yes, you just need to create separate stored values for each selection
3) Your timer is set to be absolutely spot on 0 seconds at start time. If your refresh rate of guardian is too slow it won't capture it as the time will have passed
4) In guardian click on List then the icon that appears on far left under list layout, tick the additional automation rules. Remember to save and save screen layout.

[WillWill]

It has worked out perfectly! I still don’t fully understand all the magic behind this, but it’s truly a game-changer for me! It saves an incredible amount of time and opens up new betting opportunities through extended markets. I'm really grateful to all of you for sharing your insights and experiences on this forum and through your videos.

1) Based on my current understanding, I still need to manually select the markets where the rules should be triggered. There’s no way to have them applied automatically each week, for example, to the Match Odds of the EPL? I imagine you guys also take some time off away from screens and data now and then...

2) I tried setting up my first automated rule, but it didn’t trigger due to the confirmation bet requirement. I found that it can be removed in the 'Behaviour' tab." (which can be scary to inactive). I will try again this weekend !

Simply THANK YOU!