Help Required

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

Moderator: 2020vision

Help Required

Postby banthorpe » Mon Jul 13, 2015 6:40 pm

Hiya All

Im not great on Excel but do have a few simple sheets and one is set up to lay a certain horse when say it hits a price of say 1.7 but I am trying to set it up so that a bet is only triggered say if 2 horses hit a price between say 1.75 and 2.85 then a lay bet at 1.7 will be triggered on both horses. I can do this for 1 horse but dont know how to do this that its a condtion that at least two must be trading at these prices before it triggers a bet. Dont know if that clear but if it is can anyone help Many Thanks

Andrew
banthorpe
 
Posts: 36
Joined: Thu Jul 31, 2014 7:08 pm

Re: Help Required

Postby Captain Sensible » Mon Jul 13, 2015 11:01 pm

If you're not too clued up with excel your simplest method may be just to set up another column to monitor the price range, say column AA. In that column just have a simple IF statement to check the price and enter 1 if it meets your price range

In AA5 =IF(AND(F5<>"",F5>=1.75,F5<=2.85),1,"")
In AA6 =IF(AND(F6<>"",F6>=1.75,F6<=2.85),1,"")

etc down to AA50

Then you can just add another AND criteria to your current trigger only to bet if the SUM of AA5:AA50 is equal to 2 , i.e. two runners meet your criteria
AND(SUM(AA5:AA50)=2, other criteria etc)
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Help Required

Postby rourkem » Tue Jul 14, 2015 6:14 pm

Thank you CS, I'll give this a try and hopefully, that just might be it.
Windows 8 | Framework 2.0 Image
User avatar
rourkem
 
Posts: 166
Joined: Tue Oct 28, 2014 3:20 pm

Re: Help Required

Postby banthorpe » Tue Jul 14, 2015 7:02 pm

Hiya

Thanks for your reply and I think that is the best way for me to do it although cant seem to get it to work, this is the formula I have for the trigger cell at the moment =IF(ISBLANK(A5),"",IF(AB5=2,LAY-F3,"")) and tried various versions of what you have put but just get the error message Dont want to be a pain but any suggestions will be greatly recieved Many Thanks

Andrew
banthorpe
 
Posts: 36
Joined: Thu Jul 31, 2014 7:08 pm

Re: Help Required

Postby Captain Sensible » Tue Jul 14, 2015 7:11 pm

I'm assuming AB5=2 is another part of your trigger criteria so it'd be something like

=IF(ISBLANK(A5),"",IF(AND(AB5=2,SUM($AA$5:$AA$50)=2),"LAY-F4",""))
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm


Return to Discussion

Who is online

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