Clearing the Status field...Part 2

[hmw]

Following on from PeterLe's question...

I want to clear the Status field, but only after either the offset (or stop loss) has been filled

Can't see anything on the spreadsheet that gives any indication of anything other than the status of the initial bet, is anyone able to give me some idea if the above is possible?

[Nero Tulip]

Maybe create some rule about the book being "square" or close to square in the P/L before being allowed to 'play' again ?

So, clear the cell, but if book isn't square it doesn't place another bet.

[hmw]

Thanks, that would be a good solution if I was trading one horse, but I am often trading 3 or 4 in a race and so there may be other open trades

Think I'll add a few suggestions to the other thread...

[PeterLe]

Hi
Played around with the new guardian yesterday..
Have you tried using the "multiple" spreadsheet...this way you have a clean worksheet for each race...worked like a dream yesterday.
Peter Webb has put three videos on Youtube...if yo have a look at them that might help you...
Thanks
Peter

[Will2403]

Is there a help sheet related to the multiple spreadsheets?

I'm not sure how to activate the additional sheets.

Can I have the same race on multiple sheets?

TIA

[frankclake]

I have a spreadsheet which checks for a status and returns the value. Then every minute it clears the field so it looks again. Its written in VBA and sits behind the spreadsheet. I can let you have a copy if still wanted.

Frank.