Moderator: 2020vision
by tkp » Thu Mar 02, 2006 11:37 am
by Mitch » Fri Mar 03, 2006 12:10 am
nhmaster wrote:Is anyone prepared to offer their spreadsheet version of ladder trading for those of us who have not managed to master it yet, I MUST TRY HARDER
nhmaster2001@yahoo.co.uk
Thanks in advance
Shaun
by Mitch » Fri Mar 03, 2006 12:29 am
tkp wrote:Hi Mitch - see you're a night owl too.
""I was going to use the Selection_Change event to place the bets but I still don't understand the need for a macro for each cell you want to bet from.... am I missing something obvious?
""[/i] - you dont need a macro for each cell....you need to check each cell to see if it has been clicked.....then you can call any routine you want. That's what the code below does:
If Not Application.Intersect(rTarget, Range("L12")) Is Nothing then
doFireABet or some other routine
End If
So this will happily wait for cell L12 to be click - when it is it runs a routine to make a bet....
""Have you populated your ladders using formulae or code?""
Code. How on earth have you managed to do it with a formula ? Perhaps this could be faster than my code - any chance you could let me see your formula....I could then test for speed.
by tkp » Fri Mar 03, 2006 1:21 am
This is my formula, did I mention it wasn't pretty?
=IF(MOD(MATCH(Main!$C13,INDIRECT("'From BA'!"&"R"&scrsel1&"C2:R"&scrsel1&"C6",0),FALSE),2)=1,INDEX('From BA'!$A$1:$M$44,scrsel1,MATCH(Main!$C13,INDIRECT("'From BA'!"&"R"&scrsel1&"C2:R"&scrsel1&"C6",0),FALSE)+2),0)
But do you have a check for each cell? When I got round to it I was going to do the intersect thing with named ranges to see if anywhere in the ladder back or lay sections had been clicked so it would only require 1 line of code. Then use Target.Offset(0,1) to get the odds if the back side is clicked or Offset(0,-1) if it's a lay
by Mitch » Fri Mar 03, 2006 2:54 am
That's a work of art !
sort see what it's doing...so where does this go - in the indexed cells(main) or in the ladder ?
by tkp » Fri Mar 03, 2006 12:59 pm
by a1ehouse » Wed Apr 05, 2006 10:20 pm
by jmorrell » Thu Apr 06, 2006 3:36 am
by Dedes » Thu Apr 06, 2006 3:31 pm
by a1ehouse » Thu Apr 06, 2006 6:25 pm
by Dedes » Thu Apr 06, 2006 6:54 pm
by a1ehouse » Thu Apr 06, 2006 8:52 pm
by a1ehouse » Fri Apr 07, 2006 7:40 am
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.