Hi
Is there an easy way to not display non-runners in a horse racing market market, either in the Gruss market window or at least on the excel page that it links to?
I'm trying to set up triggered betting and need a way to get the correct number of runners in my algorithm that's robust against horses being withdrawn. I'm pretty sure I can code a macro to do it, but wondered if there was a Gruss option I could just tick instead?
Thanks!
Non-runners
Moderator: 2020vision
4 posts
• Page 1 of 1
Non-runners
by superhans » Fri Sep 10, 2010 11:43 am
- superhans
- Posts: 11
- Joined: Thu Sep 09, 2010 7:15 pm
by osknows » Fri Sep 10, 2010 12:11 pm
A possible excel solution...
=COUNTIF(A5:A55,"*(NR)*") will count the occurences of (NR) in the range A5:A55
So number of runners could be calculated as
=COUNTA(A5:A55)-COUNTIF(A5:A55,"*(NR)*")
=COUNTIF(A5:A55,"*(NR)*") will count the occurences of (NR) in the range A5:A55
So number of runners could be calculated as
=COUNTA(A5:A55)-COUNTIF(A5:A55,"*(NR)*")
-
osknows - Posts: 946
- Joined: Wed Jul 29, 2009 12:01 am
by GaryRussell » Fri Sep 10, 2010 1:26 pm
That will show you how many have been withdrawn since the market was first displayed in Excel. The total number of non runners, including those containing (NR), is displayed in cell G3.
-
GaryRussell - Site Admin
- Posts: 9872
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
- superhans
- Posts: 11
- Joined: Thu Sep 09, 2010 7:15 pm
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 33 guests