Last In Market

Please post any questions regarding the program here.

Moderator: 2020vision

Last In Market

Postby macarony » Fri Jul 20, 2018 5:14 pm

Can anyone remember the thread with the formula for finding the last/biggest priced horse in the race?
thank you
macarony
 
Posts: 95
Joined: Sun Jul 19, 2009 10:16 pm

Re: Last In Market

Postby Captain Sensible » Fri Jul 20, 2018 8:23 pm

You can use index to find the MIN and MAX runners

Code: Select all
=INDEX(A5:A100,MATCH(MAX(F5:F100),F5:F100,0))


Obviously change the column from F to whatever column you want to check for the highest value F is just current back odds, but obviously you could use H for lay odds or O for last traded
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Last In Market

Postby macarony » Fri Jul 20, 2018 9:26 pm

Thanks for your help I had a formula on my old pc but I can't seem to find it, sure it was a different to this one but will yours a try once again thanks
macarony
 
Posts: 95
Joined: Sun Jul 19, 2009 10:16 pm

Re: Last In Market

Postby Captain Sensible » Fri Jul 20, 2018 9:48 pm

Probably quite a few ways to do the same thing with Excel, that formula will get the runner with the biggest odds which won't necessarily be the last runner. Was it the last runner you were after?
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Last In Market

Postby Captain Sensible » Fri Jul 20, 2018 9:51 pm

=LOOKUP(2,1/(A:A<>""),A:A)

Should return the last non blank cell in A
User avatar
Captain Sensible
 
Posts: 2883
Joined: Sat Nov 19, 2005 2:29 pm

Re: Last In Market

Postby macarony » Sat Jul 21, 2018 1:57 pm

Yes it is the biggest priced horse in the race I am looking for, I am not betting them all just certain ones
macarony
 
Posts: 95
Joined: Sun Jul 19, 2009 10:16 pm


Return to Help

Who is online

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