Bet Angel Automation - Football : Correct Score Logger

Post Reply
User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Sep 11, 2020 10:09 am

As an Excel trader, this is new to me. I have had a go at creating a Correct Score Logger with the new season starting soon. Could somebody please take a look over it for me to make sure there are no silly mistakes and confirm I have done it the most efficient way possible please?

Once loaded into Guardian, this logger is supposed to capture each of the score's values from the Correct Score market once 5 minutes prior to kick off and then export it to a .csv file.

I am hoping if I load all the 3pm kick offs from the top half a dozen leagues and tick restrict refresh to about 6 minutes before kick off to 0 seconds (start time), this file should be able to capture ALL games?? My only worry is that at 20m/s, I can scan through 50 games a second but what about if there are more than 50 games at i.e. 3pm? How do you automaters make sure nothing is missed without potentially duplicating earlier values?
Correct Score Logger.baf
Cal :)
You do not have the required permissions to view the files attached to this post.

User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Fri Sep 11, 2020 10:10 pm

I tried this on the Championship game this evening and have what is in the attached image. Sorry, again I am an Excel trader rather than Automation user so unfamiliar with this part of the software. Where would the .csv file be located?
Capture.PNG
You do not have the required permissions to view the files attached to this post.

User avatar
Dallas
Posts: 14771
Joined: Sun Aug 09, 2015 10:57 pm
Contact:

Fri Sep 11, 2020 10:26 pm

CallumPerry wrote:
Fri Sep 11, 2020 10:10 pm
I tried this on the Championship game this evening and have what is in the attached image. Sorry, again I am an Excel trader rather than Automation user so unfamiliar with this part of the software. Where would the .csv file be located?

Capture.PNG
If you click on the Advanced Settings tab, then Explore reports folder

That will open a Windows folder, in the address bar step back one page to Bet Angel Profesional
You'll then see a folder named SV Exports

User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Sat Sep 12, 2020 12:53 am

Thank you Dallas. I have just noticed when I clicked on this tab, 'Export Reports on Market Closure' is unticked. Does this need to be ticked for the bot to work? I ask this because my workbook has a blank column where the stored values should be. Could you please give the rules a once over when you get chance? Or is the problem as simple as just needing to tick this one box before the games tomorrow?

Here is what was generated earlier...
Capture2.PNG
You do not have the required permissions to view the files attached to this post.

firlandsfarm
Posts: 1128
Joined: Sat May 03, 2014 8:20 am

Sat Sep 12, 2020 1:48 pm

CallumPerry wrote:
Sat Sep 12, 2020 12:53 am
Thank you Dallas. I have just noticed when I clicked on this tab, 'Export Reports on Market Closure' is unticked. Does this need to be ticked for the bot to work?
Hi Callum, have to say I can't speak for SV's within Excel, never made the link but yes, the BOT will work but it won't export/save the data. However, if BA and the race is still in Guardian you can manually copy the log and rescue your data from there assuming you elected for the SV's to be noted in the log.

User avatar
Dallas
Posts: 14771
Joined: Sun Aug 09, 2015 10:57 pm
Contact:

Sat Sep 12, 2020 3:07 pm

CallumPerry wrote:
Fri Sep 11, 2020 10:10 pm
I tried this on the Championship game this evening and have what is in the attached image. Sorry, again I am an Excel trader rather than Automation user so unfamiliar with this part of the software. Where would the .csv file be located?

Capture.PNG
The 'Export report on market closure' option is just to export your P/L, so isn't applicable to what you are doing so doesn't need ticking

The option below that i suggested you use was just a quick way to get to the SVexport folder, rather than navigate through windows for it.

I'll import the rules file into Guardian later and take a quick look, but from glancing over it in notepad it looks like you've only got rules to export stored value, but no rules storing any values.
ie, you prob need a rule/s to store the value of the back price of each selection at 5min to KO
you'd then run the export rule at 4:55 to KO to export those values

User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Sun Sep 13, 2020 11:11 am

Ahhh I understand what you mean, I did a little reading about the interface and now I see how it works. I've had another go...
Correct Score Logger V2.baf
Captures data at 5 minutes before kick off and writes it to the workbook a minute later. The only thing now is that it looks like this...
Capture3.PNG
For some reason every score shows the score and then a 1 in the first pair of columns and then the next pair correctly shows i.e. 0-0 and then its odds of 11.5? Why the duplication? Any way this can be amended and maybe ever altered to show the LTP AND the volume at each price?

I feel like I grasp the interface now but there are understandably parts I am new to. I don't think I will be changing any of my bots from Excel to here any time soon.
You do not have the required permissions to view the files attached to this post.

humanoid769
Posts: 29
Joined: Fri Nov 09, 2018 11:22 am

Tue Sep 15, 2020 3:16 pm

Hi

This has been what I am going to try and setup so I will be watching with interest ... Thx for sharing the the file

User avatar
CallumPerry
Posts: 483
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

Thu Sep 17, 2020 9:06 am

I'll have another look before the weekend mate. V2 currently works, it just duplicates columns so a bit messy. V3 will hopefully have the price and volume nice and neat on a single row per event.

humanoid769
Posts: 29
Joined: Fri Nov 09, 2018 11:22 am

Thu Sep 17, 2020 9:25 am

Look forward to seeing how you tidy up the out put .. I have also been looking at the store price history which could then be used on any market

Post Reply

Return to “Bet Angel Automation - Football”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest