Thanks oldchippy..I already have access to the data, and its coming in on a UDP port,so I do not want to use the http access that etikr uses. Besides, etikr is importing data for markets that I do not need. Thanks for the thought though.
I'll try to further simplify my query, so maybe somone could help me on the scripting of an appropriate solution.
Following is an example of the stream im receiving. I captured this via a port sniffer.
MBP|MSFT;REG;BUY;1,1000,3.00$1,1000,2.95$3,7000,2.85$2,11000,2.75$2,1000,2.70$1,2000,2.60$2,20000,2.55$4,26500,2.50$1,40000,2.25$1,10000,2.10$;SELL;2,7000,3.10$1,2000,3.15$2,4500,3.20$6,9500,3.25$3,4000,3.30$2,7000,3.35$8,39000,3.40$5,9000,3.45$11,15500,3.50$3,3500,3.60$;|*
This is the stream for Market by Price, for the top 10 buy prices, and the top 10 sell prices. The stream comes in continously, and whta I wish to do is to align it into tables in Excel in real time in the following format, and have it continually update,with a very small refresh rate.
Any help?
Thanks
Bookmarks