for big days with lot of race - excel... automation better?

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
rain91
Posts: 124
Joined: Tue Feb 07, 2017 7:11 pm

I have a profitable working excel if i set it after 1race finish just the can start the next one....
BUT i want to bet on all race maybe automation is better for that?
When i try to run the same spreadsheet on both races which are both In play , always do big error lot of multi bet on same time ... f e:
3.jpg
I deleted satus cell only after the cell is not placing.....
SO.... maybe my PC too slow? :O
with automation should be better ?
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 24487
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

rain91 wrote:
Mon Jun 19, 2023 1:49 pm
I have a profitable working excel if i set it after 1race finish just the can start the next one....
BUT i want to bet on all race maybe automation is better for that?
When i try to run the same spreadsheet on both races which are both In play , always do big error lot of multi bet on same time ... f e:
3.jpg
I deleted satus cell only after the cell is not placing.....
SO.... maybe my PC too slow? :O
with automation should be better ?
You need to use the multi spreadsheet. Or you can just duplicate the sheets in the BA workbook. Each sheet has to begin with Bet Angel but you can add numbers to the end of the worksheet name. Then select a different worksheet for each market in Guardian or check the box at automatically assigns them.

Automation is much faster than Excel and I always use if I can, but Excel has substantially more control and the features you can implement are almost unlimited.

I have an old laptop that runs BA automation fine, but when I try to run 2-3 markets in Excel it doesn't just struggle. It overheats and shuts down. :lol:

But on a more modern, mid-range spec laptop it's handled 8-10 markets in its stride.
rain91
Posts: 124
Joined: Tue Feb 07, 2017 7:11 pm

Derek27 wrote:
Mon Jun 19, 2023 2:21 pm
rain91 wrote:
Mon Jun 19, 2023 1:49 pm
I have a profitable working excel if i set it after 1race finish just the can start the next one....
BUT i want to bet on all race maybe automation is better for that?
When i try to run the same spreadsheet on both races which are both In play , always do big error lot of multi bet on same time ... f e:
3.jpg
I deleted satus cell only after the cell is not placing.....
SO.... maybe my PC too slow? :O
with automation should be better ?
You need to use the multi spreadsheet. Or you can just duplicate the sheets in the BA workbook. Each sheet has to begin with Bet Angel but you can add numbers to the end of the worksheet name. Then select a different worksheet for each market in Guardian or check the box at automatically assigns them.

Automation is much faster than Excel and I always use if I can, but Excel has substantially more control and the features you can implement are almost unlimited.

I have an old laptop that runs BA automation fine, but when I try to run 2-3 markets in Excel it doesn't just struggle. It overheats and shuts down. :lol:

But on a more modern, mid-range spec laptop it's handled 8-10 markets in its stride.
Thanks the help
I used like this , but often do duplicated bet (back or lay......) in same time as you can see previously.
2.PNG
Maybe deleting of the status cells is the problem?
I use for it vba code.
my refresh is 200 or 500 ms but same problem , sometimes its work, but in few markets made big mistakes.......
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 24487
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

rain91 wrote:
Mon Jun 19, 2023 3:19 pm
Derek27 wrote:
Mon Jun 19, 2023 2:21 pm
rain91 wrote:
Mon Jun 19, 2023 1:49 pm
I have a profitable working excel if i set it after 1race finish just the can start the next one....
BUT i want to bet on all race maybe automation is better for that?
When i try to run the same spreadsheet on both races which are both In play , always do big error lot of multi bet on same time ... f e:
3.jpg
I deleted satus cell only after the cell is not placing.....
SO.... maybe my PC too slow? :O
with automation should be better ?
You need to use the multi spreadsheet. Or you can just duplicate the sheets in the BA workbook. Each sheet has to begin with Bet Angel but you can add numbers to the end of the worksheet name. Then select a different worksheet for each market in Guardian or check the box at automatically assigns them.

Automation is much faster than Excel and I always use if I can, but Excel has substantially more control and the features you can implement are almost unlimited.

I have an old laptop that runs BA automation fine, but when I try to run 2-3 markets in Excel it doesn't just struggle. It overheats and shuts down. :lol:

But on a more modern, mid-range spec laptop it's handled 8-10 markets in its stride.
Thanks the help
I used like this , but often do duplicated bet (back or lay......) in same time as you can see previously.
2.PNG
Maybe deleting of the status cells is the problem?
I use for it vba code.
my refresh is 200 or 500 ms but same problem , sometimes its work, but in few markets made big mistakes.......
I've encountered the problem of multiple bets being placed and concluded editing the sheet while VBA code was executing caused the problem. It may be okay to press the Del button but I think placing the cursor in a cell causes problems.
rain91
Posts: 124
Joined: Tue Feb 07, 2017 7:11 pm

So i think my problem was with the status cell clearing.... or..... sometime the multiple bets coming sometimes not.....
Can somebody help?
my delete parameters in vba:

The main key in my excel is that until there is in status cell "PLACING" nothing can come out to the bet rules cells. If status clear the can come (BACK, LAY, CANCEL_B, etc). multiple bet can come in same horse (so if i start with BACK, until it not closed with lay, cant come next back-or something like this ).

and after the bet placed or cancelled (OK to status cell) i clear the status cells with this:

If Range("O" & 9) = "PLACED" Or Range("O" & 9) = "OK" Then
Range("O" & 9).ClearContents
End If
etcetc

Thanks if you help.
cant attached my log, microsoft word format .... what kind of format i can use?
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel - Automation”