Auto clearing status cells

Example spreadsheets and comments on example spreadsheets.
Post Reply
tausen
Posts: 22
Joined: Thu Jun 03, 2010 9:08 am
Location: Italy

What does "Point at this spreadsheet to function" mean??
I've created a spreadsheet, but I can't copy the "Clear status" sheet into mine.
And I can't even copy mine into this.
It gives me VB errors. But I don't make change to the original....
Rastis
Posts: 44
Joined: Thu Oct 14, 2010 4:15 pm

Folks,

I've just had a crack at downloading this spreadsheet too. However, i got a message saying that it is corrupted and the VBA is deleted...
Rastis
Posts: 44
Joined: Thu Oct 14, 2010 4:15 pm

I've got the spreadsheet working (IE, it clears the cells when I click the Start button) but it doesn't continue to clear every 10 seconds thereafter.

Is this what it is supposed to do? Am I getting something wrong?

Cheers
Asalve01
Posts: 6
Joined: Sun Apr 17, 2011 11:38 am

Hi,

How would I change this to only remove the status when not in-play, ie my system revolves around laying in-play.
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

I would like to clear the status cells just once - after I've matched bets at the prices I want. Does anyone know if it's possible to adapt this to run when the market is suspended or (preferably) when the market is so many seconds in play?
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

I think I've cracked it! Just waiting for racing to start. This repeated update facility is phenemonally useful.
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

How did you crack it?

I would use practice mode to start with. Auto-clearing status cells can result in hundreds of bets being placed in a very short space of time if you are not careful.
Wyndon
Posts: 237
Joined: Sun Nov 13, 2011 10:14 am

I spoke to soon! All sorts of problems appeared on a live test. I'd hoped to embed my own sub-routine into the periodic update macro - but it failed dismally. However, I reproduced a Calculate worksheet that I found on another search of the forum, which did the trick of automatically clearing the status cells once the market has been suspended. Testing went OK yesterday evening.
User avatar
EyePeaSea
Posts: 258
Joined: Sun Jun 12, 2011 11:18 am

TheTub wrote:How did you crack it?

I would use practice mode to start with. Auto-clearing status cells can result in hundreds of bets being placed in a very short space of time if you are not careful.
Whilst I'm still running a system in 'beta' mode (real money, but small stakes), I'm happy to deliberately not clear cells. BetAngel's refusal to let me stake twice if I don't clear the cells has saved me a few times :oops:
alto
Posts: 3
Joined: Fri Jul 19, 2013 11:18 am

Hi.
I've got the spreadsheet working (IE, it clears the cells when I click the Start button) but it doesn't continue to clear every 10 seconds thereafter.

Is this what it is supposed to do? Am I getting something wrong?
I'm having the same issue.
Anyone have come up with an solution?

Thanks
bamthwok
Posts: 10
Joined: Thu Apr 30, 2009 7:14 pm
Location: Manila/ Philippines

Hi,

Can someone please help and advise how to make this idea work for the Betangel multiple spreadsheet.

Any advise is highly appreciated.

Cheers,
bamthwok
tony63
Posts: 22
Joined: Wed Mar 16, 2016 12:14 pm

Hello.

I downloaded the spreadsheet that auto clears the cells yesterday and was planning to trial it today.

I know you are aware of this but is has probably slipped your mind, I am one of, I suspect, many people that are not able to sit and watch the markets but HAVE to rely on automation.

As soon as I open an unrelated worksheet I get "subscript out of range". When I go into the debugger the problem is

Worksheets("Sheet2").Range("a4") = 1

I can muddle my way through visual basic but I don't know enough to correct it. It appears that the routine is applying to the whole of Excel rather that the specific workbook.

Thanks.
tony63
Posts: 22
Joined: Wed Mar 16, 2016 12:14 pm

Sorry - Should have said. I'm working on the latest version of Excel.
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

If you have 2 or more workbooks open vba gets a bit confused as to which workbook you are referring to.

It's likely that the code refers only to its own workbook, which hasn't got a sheet named "Sheet2".

You'll need to fully qualify each reference to each workbook.

If I have 1 workbook open, Twb and Owb will give the same result. If I have 2 workbooks open, and the 2nd is the ACTIVE (the one you are looking at), Owb will return a different name.

Code: Select all

Sub test()


Dim Twb As Workbook, Owb As Workbook

Set Twb = ThisWorkbook
Set Owb = ActiveWorkbook

MsgBox Owb.Name


End Sub
This can refer to either workbook, (but will fail if it can't find a sheet named sheet1.)

Code: Select all

Owb.Sheets("Sheet1").Range("A2") = "1"
This will always refer to the workbook in which the code resides.(Again will fail if no sheet named sheet1).

Code: Select all

Twb.Sheets("Sheet1").Range("A2") = "1"
andrewcichello
Posts: 6
Joined: Tue Nov 22, 2016 10:15 am

Hi Everyone,

The attached file works for me however I'd like to use this with multiple sheets. Does anyone have a worksheet clearing status cells on multiple sheets? Or a work around? I want to bet on many races per day and clear the status cells every 60 seconds.

Any help would be greatly appreciated.

Cheers,

Andrew
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Bet Angel - Example spreadsheets”