Jason

Thanks for that. I'll give it a whirl and see how it goes.

It's not the stock market, it's sports markets on Betfair via an API
into XL. The main trading period is in the 10-15 mins leading up to an
event and into the "in play" period. Data refreshes in milliseconds
from the Betfair server to the API, so 1 second is quite slow
comparatively. You need a nimble mind and even nimbler fingers to
trade them which is why I want to get a visual representation of the
data rather than a rapidly changing screen full of numbers. Often by
the time you've checked certain numbers, check a couple of graphs in
the API, interpreted what they may indicate, etc etc, the price
movement has peaked/troughed and is on its way back!!!