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

Hi guys,
sorry for my english.
I'd like to clear the status cells everytime all my bets gets placed.
Is it possible to do with a macro? I don't know Visual Basic language...... :x

Thanks a lot

Daniele
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

We have a spreadsheet we meant to upload recently, we will upload next week. It should help you do this. Please remind us if we forget!
tausen
Posts: 22
Joined: Thu Jun 03, 2010 9:08 am
Location: Italy

Bet Angel wrote:We have a spreadsheet we meant to upload recently, we will upload next week. It should help you do this. Please remind us if we forget!
Thanks for the reply.
I'm waiting anxiously for the upload!
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

Yes, Sorry, we have been very busy in recent weeks with a new release. So hopefully we should be able to upload this early next week. Again, feel free to hit us over the head if we forget.
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

I also join the request ...
I need to automatically clean the cell when an "Error" message appears ...
If it possible to eliminate the "Error" message coming up entirely
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

Is there any progress?
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

Here is a simple version, a more complicated automated trading spreadsheet will follow.
tausen
Posts: 22
Joined: Thu Jun 03, 2010 9:08 am
Location: Italy

Thanks Peter. I'll give it a try!
User avatar
BAP-Admin
Forum Admin
Forum Admin
Posts: 147
Joined: Tue Mar 17, 2009 1:11 pm
Location: UK

Try this one.
BetAngel_CLEAR_STATUS.xls
You do not have the required permissions to view the files attached to this post.
User avatar
Dabbla
Posts: 662
Joined: Wed Apr 15, 2009 1:50 pm

that one is working thanks.
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?
Post Reply

Return to “Bet Angel - Example spreadsheets”