'Close all positions'

[brumbie]

If you are using Row 5 in excel as an example which I assume you are then no, the T5 I am using is the cell (I am assuming that the bet ref goes in cell T5 in a greyhound spreadsheet as it does in a horse racing spreadsheet.)
It is unfortunate that the cell T5 is also a ref in "BACK-T5" but they have no connection in what we are talking about....gee you've sobered me up on fathers day..lol.

[posimmo]

gee you've sobered me up on fathers day..lol.

Not wasted then.

But, thanks to your help (and also MollyMoo) I've actually managed to work it out I think. The timer I have in cell Q1 and the following formula in the trigger cell seems to do the trick - hooray!

=IF(AD5=3,"BACK-T5",IF($Q$1<4,"CLOSE"))

Best regards

Polly

[MollyMoo]

Yes, CLOSEC cancels any unmatched bets on the selection before greening up, CLOSE doesn't cancel any unmatched bets and just greens up.

You could use the following formula in your Trigger cells:

Code: Select all

=IF($A5 <> "",IF(AND($AD$5<=3, $Q5 = "BACK-T5"),"CLOSEC",IF(AND($Q5 = "", $AD$5 <= 5), "BACK-T5", "")), "")

Place this in cell Q5 then drag and copy the formula down column Q to copy to all trigger cells.

What this does is to check there is a runner in column A on the same row as the formula. If so, it checks if the timer in cell AD5 has reached 3 seconds, that the BACK trigger has already been sent and that the CLOSEC trigger hasn't already been sent. If that's the case, then it sends the CLOSEC command. Otherwise it checks if the timer has reached 5 seconds and the BACK trigger hasn't yet been sent. If so, it issues the BACK-T5 command.

Obviously, you can change the values of cell AD5 to check to suit your own needs. Just test that formula with small stakes initially to make sure I've written it correctly!!

[brumbie]

=IF(AD5=3,"BACK-T5",IF($Q$1<4,"CLOSE"))

How that works is beyond me , I guess i misunderstood what you wanted..all good . Also, we don't normally help out basic excel on here, rather further problems..good luck.

[MollyMoo]

Yes, CLOSEC cancels any unmatched bets on the selection before greening up, CLOSE doesn't cancel any unmatched bets and just greens up.

You could use the following formula in your Trigger cells:

Code: Select all

=IF($A5 <> "",IF(AND($AD$5<=3, $Q5 = "BACK-T5"),"CLOSEC",IF(AND($Q5 = "", $AD$5 <= 5), "BACK-T5", "")), "")

Place this in cell Q5 then drag and copy the formula down column Q to copy to all trigger cells.

What this does is to check there is a runner in column A on the same row as the formula. If so, it checks if the timer in cell AD5 has reached 3 seconds, that the BACK trigger has already been sent and that the CLOSEC trigger hasn't already been sent. If that's the case, then it sends the CLOSEC command. Otherwise it checks if the timer has reached 5 seconds and the BACK trigger hasn't yet been sent. If so, it issues the BACK-T5 command.

Obviously, you can change the values of cell AD5 to check to suit your own needs. Just test that formula with small stakes initially to make sure I've written it correctly!!

I think I misunderstood where you were holding your timer countdown value. It's not in AD5, is it, but Q1?

So the formula would be:

Code: Select all

=IF($A5 <> "",IF(AND($Q$1 < 4, $Q5 = "BACK-T5"),"CLOSEC", IF(AND($Q5 = "", $AD$5  = 3), "BACK-T5", "")), "")

[brumbie]

Wow, you just have to ask the cell T5 if its populated...why the fuss?

[posimmo]

Thank you both very much, MollyMoo and brumbie.

Best regards

Polly

[MollyMoo]

Wow, you just have to ask the cell T5 if its populated...why the fuss?

Well, brumbie, I always check whether the cell in column A is empty or not in case of a non-runner (I'm used more to horse racing than greyhounds, but I thought there might be an instance in greyhound racing where a trap might be empty).

I also check whether the BACK or CLOSEC triggers have already been issued so that multiple commands aren't sent to Betfair.

If Polly has managed to achieve what she wanted by another formula, then great. Job done.

[brumbie]

"=IF($A5 <> "",IF(AND($Q$1 < 4, $Q5 = "BACK-T5"),"CLOSEC", IF(AND($Q5 = "", $AD$5 = 3), "BACK-T5", "")), "")"

I haven't looked at a greyhound spreadsheet but assume it is the same as a horseracing one which would mean the trigger is actually in Q5. This would mean you are talking to Q5 about itself which would straight away mean you need iterative calculations ticked or it wouldn't understand?
Double checking it I doubt if it would work even then Molly.