Excel Portion of a Bet Matched - PLEASE HELP!!

[menlolot]

Dear All

Please help, I want to lay say $100 and use the following trigger:

=IF($AB$1=99,IF(S5>0,IF(T5="CANCELLED","CLEAR","LAY-F10"),""),0)

As soon as a portion of the bet is matched, it displays a bet reference and then do nothing else although there is still a value to be layed in S5. The odds column also updates but matched remains the first portion only.

If I delete column T manually the full original bet are fired again.

Please help!!

[GaryRussell]

It cannot put CANCELLED in the bet ref if partially matched because it would not be correct.

You can check column W for matched stake and subtract this from your stake in column S, for example =100-W5
You can also check if the unmatched portion is cancelled yet by checking if "P" is appended.

You could use the following formula. It will also use the CLEAR trigger if the bet is partially matched and the unmatched portion has been cancelled by checking if W5>0 and the bet ref does not have "P" appended.

Code: Select all

=IF($AB$1=99,IF(S5>0,IF(OR(T5="CANCELLED",AND(W5>0,RIGHT(T5)<>"P")),"CLEAR","LAY-F10"),""),0)

[GaryRussell]

Sorry, I've just realised after posting this that the stake will still be the full stake because column S will contain 0 after CLEAR has triggered. I will post a solution to this shortly.

[GaryRussell]

You can untick 'CLEAR' trigger clears matched odds when setting up the link. Forgot about this option

Also I presume you don't want CLEAR to trigger if fully matched so the following should work. I've not tested it so you may need to modify it, but you should get the idea.

Code: Select all

=IF($AB$1=99,IF(S5>0,IF(OR(T5="CANCELLED",AND(W5>0,W5<S5,RIGHT(T5)<>"P")),"CLEAR","LAY-F10"),""),0)

[menlolot]

Thanks Gary

Ive been trying to sort this out with Mark for a while now.

Will try your suggestion. My stake column adjusts to the "new Stake" but there's no action because of the entry into column T and therefore could not cancell the reference or refire the bet. Will let you know if it works.

Thanks

[menlolot]

Hi Gary

I'm still trying to sort this one out and are between two fires.

If I LAY-F10 then as soon as a portion is matched, the bet reference appears and nothing happens after that. If I LAY-SP then the odds stay at the original figure and then have to deal with whatever the SP price is at race start. In Aus thats a huge gamble cause the price could go out dramatically because the liquidity of the markets are so low.

My questions:

a. Is it possible to create a trigger that LAY-F10 and if not matched at the off go LAY-SP

b. If I use LAY-SP currently can I set the maximum lay odds. I have a max price policy but when using this instead of laying 100/10 it might be 100/7 at the off. As you know with BF policy.

Thanks in advance for your time

[GaryRussell]

a. Is it possible to create a trigger that LAY-F10 and if not matched at the off go LAY-SP

There isn't a trigger for this. You would have to check for the bet being cancelled and fire LAY-SP if needed.

b. If I use LAY-SP currently can I set the maximum lay odds. I have a max price policy but when using this instead of laying 100/10 it might be 100/7 at the off. As you know with BF policy.

You can use LAYSP instead of LAY-SP. This places an SP bet immediately instead of only using SP at the off if unmatched. You provide the liability in column S and the maximum odds in column R. When you use this trigger the bet cannot be cancelled and it will only be matched after the off after SP reconciliation.

[menlolot]

Thanks Gary

Any chance that you could write a trigger like that any time soon.

LAY-F10 going to SP on the off.

I know you are busy but will be appreciated.

Cheers

[GaryRussell]

Thanks Gary

Any chance that you could write a trigger like that any time soon.

LAY-F10 going to SP on the off.

I know you are busy but will be appreciated.

Cheers

No more features (only bug fixes and small changes to existing features) are going into the current Beta until it's promoted to the official version. This was supposed to be last month, but is looking like next month now. We will then start looking at suggestions again. I promised that the first new trigger would be a green up trigger so I'm afraid I cannot promise to do this any time soon.

[menlolot]

Yhanks Mate.

Please keep us up to speed!!!

[menlolot]

Hi Gary

Will this trigger work

LAY-F10-SP

Cheers

[GaryRussell]

No. It will cancel the bet after 10 seconds if unmatched. The trigger is valid, but the fill or kill option effectively makes the -SP option useless.