Be really careful when you try and resolve this. I set my sheet to use the timer(countdown) as the trigger to clear but as it keepsresubmitting the data each refreshI had 900 bets attempted every 200 miliseconds and ended up with a £100 charge in one day for failed bets on the betangel API. ( I ran it on a personal VPS and left it running all day)
I have found a sheet that resolves this now by having a one click function for all 30sheets and places bets but I am now working on splitting that up into a one button for each sheet .... I have just given myself a great idea on how to do that lol. My Mum always said I shouldnt talk to myself but I guess typing to myself is ok?
Clearing the status cells in Excel
Hello folks,
I'm interested to know how people stop this bot firing extra bets using Excel formula. I try and stop it by using an IF statement so that no commands are placed in Column L if any of the bet info Columns T to AE are not blank.
However, this bot seems to clear the status cells way quicker than than the bet info columns are updated. So what ends up happening is that my sheet fires off an extra bet before the sheet "sees" the bet info columns filled and ensures that command cells remain blank.
Any advice? Thanks.
TC.
I'm interested to know how people stop this bot firing extra bets using Excel formula. I try and stop it by using an IF statement so that no commands are placed in Column L if any of the bet info Columns T to AE are not blank.
However, this bot seems to clear the status cells way quicker than than the bet info columns are updated. So what ends up happening is that my sheet fires off an extra bet before the sheet "sees" the bet info columns filled and ensures that command cells remain blank.
Any advice? Thanks.
TC.
Is there a formula so when the market is suspended indefinitely, not suspended for a non runner, so the race is over, it clears the status cell, say on re-opening the spreadsheet, or after a certain amount of time has past.6thSense wrote: ↑Thu Dec 20, 2012 3:12 pmClearing The Status Cells
I thought I would post up a spreadsheet that automatically does what a lot of people want - clear the status field once a bet has been placed.
There are a few ways of doing this but I am going to go down the VBA route and tie this with a reset flag.
In a cell somewhere on your worksheet, say sheet 2, cell A1 (never use the Bet Angel worksheet for calculations) type in the following:
This means the cell will display 'RESET REQUIRED' if any cell from O6 through to O67 is populated with anything.Code: Select all
=IF(COUNTIF('Bet Angel'!O6:O67,"")<61,"RESET REQUIRED","")
You can then create a Sub in a module to clear the cells. Use this code:
Then call this code whenever something the reset flag is set. This can be done by entering the following in the Sheet2 ObjectCode: Select all
Sub Reset_Bet() Application.ScreenUpdating = False Sheets("Bet Angel").Select Range("O6,O9,O11,O13,O15,O17,O19,O21,O23,O25,O27,O29,O31,O33,O35,O37,O39,O41,O43,O45,O47,O49,O51,O53,O55,O57,O59,O61,O63,O65,O67").Activate Selection.ClearContents Range("A1").Select Application.ScreenUpdating = True End Sub
This will clear the cells whenever there is a calculation made on the sheet. And when connected to a Bet Angel market, Excel is effectively automatically performing calculations constantly.Code: Select all
Private Sub Worksheet_Calculate() If Range("A1") = "RESET REQUIRED" Then Call Reset_Bet End Sub
The attached sheet has all the above. Connect it to Bet Angel and try it out.