Tick difference

[doris_day]

Can anyone tell me the best way to write an Excel function which determines whether the Best Lay Price (H5 say) is no further away from the Best Back Price (F5 say) than 5 TICKS....

For example IF(H5-F5 < 5 Ticks,..........)

Hopefully you'll see what I need.....

PS, I have a module which includes Gary's uptick and downtick code but this places a value in the R column which I need for a different price so I can't use this value as it stands unless I can shift Gary's values to another column....if you see what I mean

[Ian]

dgs2001 has already done this, see ............

http://www.gruss-software.co.uk/forum/v ... ight=ticks

[doris_day]

Magic, just what the doctor ordered. Works too

[kettywilson01]

If you have excel 2007 then you can go for it's support there is very simple and sober tutorial for each and every function. Try it out.