NYSE, Microsoft and MDX bring data in from Excel
By Tom Groenfeldt
Developers and analysts who want to use market data in Excel can turn to a new combination of technology from the NYSE, Microsoft and MDX.
NYSE Technologies, a unit of NYSE Euronext and MDX Technology of London, have used Sibos to announce an alliance to provide MDXT ConnectExcel, a data analysis tool that enables traders to stream and analyse real-time, normalised market data directly in Microsoft Excel 2010.
“Excel is a ubiquitous desktop,” explained Paul Watmough, chief executive of MDX. With the new alliance, Excel can receive current market data. Large problems can be expanded to run on a number of servers or the spreadsheets and analytics can be shared with others through SharePoint.
Brian Doherty, managing director at NYSE Technologies, said the technology arm of the exchange can deliver market data from more than 200 venues, normalise it and make it available through the firm’s middleware agnostic messaging API, known as Mama. Then traders and analysts can consume and publish real-time market data directly on Microsoft Excel.
High speed market data which has been used to feed high frequency or algorithmic trading engines can now be used at the desktop. Clients wanted to leverage their existing ticker plants. “They want to see their portfolio in real-time and get it onto Excel.” The feeds from NYSE can run to millions of data changes per second; NYSE will send a reduced set for use on Excel. The companies expect the new method for consuming market data in Excel will be popular with existing Wall Street customers who will use it for modelling, simulations, market making and visualisation. CMC Markets in the UK has been an early adopter of MDX.
An alternative to taking high speed feeds from NYSE is to use market data on demand from a company such as Xignite, which offers specific data from a cloud, delivered at internet speeds and priced by the amount of data consumed.
Comments