Keep at front of queue using UPDATE trigger

Please submit your spreadsheets by email and I will include them here.

Moderator: 2020vision

Keep at front of queue using UPDATE trigger

Postby GaryRussell » Tue Mar 01, 2011 11:59 am

https://www.gruss-software.co.uk/Excel/Chase_Price.xls

This spreadsheet demonstrates using the UPDATE trigger to keep a lay bet at the front of the queue by beating the best back odds.

Put "1" in the enabled column to activate chasing and the maximum odds you will lay up to in the max odds column.

There is a potential pitfall with this method. For example if your stake is £2. The problem is when there is money below £2 in the queue. If say £1 is at the front of the queue BA won't display it. UPDATE puts you at the front of the queue so it's now £3 at the front. UPDATE will again put you at the front. Because only £1 is at the next best odds it won't be displayed so UPDATE will trigger again to reduce your offer. Your offer will join the £1 again so it will trigger another UPDATE to put you at the front. It can get stuck in this cycle. This could cause a large number of transactions so you may want to modify this example for your needs. It should however give you an idea of how UPDATE can be used.

Please be aware that this is only an example. We cannot accept responsibilty for any transactions charges you encounter as a result of using this spreadsheet.

Note: This example assumes you do not tick "UPDATE trigger appends 'N' to new bet ref" when linking to Excel.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Postby GaryRussell » Wed Apr 06, 2011 1:56 pm

It has come to my attention that some users think that this means your bet goes to the front of the queue at the current best odds regardless of the money already there. It actually offers better odds than the current best odds, it does not offer odds at the current best odds and go to the front of the queue.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK


Return to Sample Triggered Betting Excel Sheets

Who is online

Users browsing this forum: No registered users and 3 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.