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....
Auto clearing status cells
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.
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 timesTheTub 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.

Hi.
Anyone have come up with an solution?
Thanks
I'm having the same issue.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?
Anyone have come up with an solution?
Thanks