What do the 'Triggers' in EXCEL do.

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

What do the 'Triggers' in EXCEL do.

Postby thunderfoot » Sat Dec 31, 2005 5:44 pm

My understanding is that to use 'Triggered Betting', in Col. N, O & P you use formulae.

Note: keywords in Bold in the following.

In Col O & P (Odds & Stake) I've set these to be populated only if either BACK or LAY is shown in a cell in Col. N (Trigger). The formulae I have in Col. N is triggered by any 1 of 3 scenarios I have set-up.
Because Col. Q to U are in effect 'Cell Inputs' I can use these without causing any 'Circular References' in EXCEL.

Now, if a cell in Col. N shows BACK, the Odds & Stake (Cols. O & P) will be populated, the bet will be fired-off to Betfair, the cell in Bet Reference (Col. Q) will show PENDING, and when the bet is matched this will will change to, is it MATCHED??!! I've set the formulae in Col. N to change from BACK to HOLD as soon as the bet has been fired-in to Betfair, by using PENDING in Col. Q to change Col. N from BACK to HOLD, to avoid bets being continuously fired-in to Betfair. In effect no further bets will be made until the last bet has been Matched, and Col. Q shows this by changing from PENDING to MATCHED??!!

If you can understand the above :wink: then hopefully you can confirm/answer the following.
1) BACK or LAY in Col. N triggers a bet to be fired-in to Betfair. (Yes/No??)
2) The Odds & Stake entered in Cols. O & P are what is fired-in to Betfair. (Yes/No??)
3) When the bet is received at Betfair the relevant cell in Col. Q is populated with PENDING. (Yes/No??)
4) When the Bet is Matched at Betfair the relevant cell in Col. Q is populated with MATCHED??!!! (Yes/No??) and Cols. R to U are populated with other relevant information. (Yes/No??)
5) If there is an entry in Col. N of CLEAR, then the relevant row in Col. Q to U is cleared. (Yes/No??)

Am I right with all these assumptions?
Is CANCEL, which would appear in Col. N, a keyword? If so what does it do?
Are there any other keywords?
User avatar
thunderfoot
 
Posts: 270
Joined: Sat Nov 19, 2005 2:52 pm
Location: West Country

Postby Mitch » Sat Dec 31, 2005 9:10 pm

Ok, As I understand it...

1. Yes
2. Yes
3. Yes
4. No, the bet reference is returned. & Yes
5. Yes

Yes, CANCEL is a keyword. If used in conjunction with a bet reference in column Q, the unmatched bet will be cancelled.
When the deed is done the bet reference will be cleared and columns S & T will contain matched odds and stake, if any of the bet was matched.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester

Postby thunderfoot » Sun Jan 01, 2006 3:50 pm

If a bet is only partially matched i.e. you place £100 and only £25 gets matched, what is shown in Col. Q to identify £75 of the stake is still waiting to be matched?
User avatar
thunderfoot
 
Posts: 270
Joined: Sat Nov 19, 2005 2:52 pm
Location: West Country

Postby Mitch » Sun Jan 01, 2006 11:34 pm

Column Q shows the bet reference whether all, some or none of the bet is matched. Column T shows how much (if any) was matched.
User avatar
Mitch
 
Posts: 365
Joined: Sat Nov 19, 2005 12:28 am
Location: Leicester


Return to Discussion

Who is online

Users browsing this forum: No registered users and 12 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.