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

[rain91]

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 ?

[Derek27]

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.

But on a more modern, mid-range spec laptop it's handled 8-10 markets in its stride.

[rain91]

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.

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.......

[Derek27]

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.

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]

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?