Rank

[Chad]

Hi I was wondering if there was a way to use the RANK command to determine the fav before the off. Then to either back or lay it in running. If the price either came in or went out to a set figure.

[mak]

place this formula in AK5 cell & drag down to AK50
=IF(F5="";"";(RANK(F5;$F$5:$F$55;1)+COUNTIF($F$5:F5;F5)-1))

you see this also
http://www.gruss-software.co.uk/forum/v ... light=rank

you can see Gary's example here
http://www.gruss-software.co.uk/forum/v ... php?t=3723

finally there is a search facility
http://www.gruss-software.co.uk/forum/s ... de=results

[Chad]

Hi Mak
Thanks for the help. Would this be able to take a snap shot of the rank say 10secs before the off or would it be continually changing.

[mak]

you have to place a formula like this one (provided from Gary)

=IF(LEFT(D2)<>"-";(HOUR(D2)*3600)+(MINUTE(D2)*60)+SECOND(D2);-((HOUR(SUBSTITUTE(D2;"-";""))*3600)+(MINUTE(SUBSTITUTE(D2;"-";""))*60)+SECOND(SUBSTITUTE(D2;"-";""))))

and work out your trigger to place the bet accordignly

The formula as you will find out will work as seconds countdowner of cell d2

[Chad]

Cheers Mak
I work shifts so I can’t check it out till then but it looks good.
Very grateful