Is it possible to see more than three prices on excel?

[Ian1506]

Hi folks. Can anyone tell me if it is possible to see the back and lay prices that are more than three ticks away from the current price. I would like to look at these on a spreadsheet similar to what can be seen on the ladder. I am interested in looking to see where there is only a few dollars waiting on the back or lay side and this is usually more than three ticks away from the current price.
Cheers Ian

[Grisu]

hi Ian,

I think you should take a look to the example sheet from Gary.

http://www.gruss-software.co.uk/forum/v ... php?t=3825

regards,
Grisu

[Ian1506]

Thanks Grisu.
I should have known that someone here would have had the answer at their fingertips.
Cheers Ian