[December 28, 2000] A December 2000 announcement from The Financial Information Services Division (FISD) of the Software and Information Industry Association (SIIA) describes the formation of an XML for Market Data Working Group. The XML Working Group will attempt "to consolidate industry efforts to define the parameters of the XML for market data discussion (i.e., the fields needed to describe a security and its price). ['Fields' mean (e.g.) Identifier, ISIN, CUSIP, Last, Open, Best Bid, Best Ask, Close, Next Bid, Size, Maturity Date, Coupon, Yield, Call/Put, Strike Price, etc.] If the industry is able to unify around a common size and scope definition, FISD is interested in (1) serving as the facilitator of the discussion to create a standard, (2) supporting and maintaining the standard as a permanent home and (3) coordinating with the other major financial industry XML standards efforts such as NewsML (news), FpML (derivatives), IRML (investment research) and XBRL (business reporting) as appropriate." According to the announcement, "user firms are interested in extracting information from a vendor's data feed ('vendor' defined as any information provider including exchanges and contributors) into common desktop applications. The requirement is not for an individual trader who wants access to multiple sources of data, but rather for distributing information to disparate systems throughout the organization. For that, the users need a standard protocol and common data format. Jeremy Sanders (Merrill Lynch) envisions using the XML standard primarily for end-of-day and intra-day snapshot application feeds rather than for streaming data."
An antecedent to this effort is a draft Market Data Markup Language (MDML) Specification authored by Bridge, which "describes an implementation of XML to be used for distributing financial information. A primary goal of this implementation is to be flexible enough to carry data from any financial market data vendor, including, but not limited to, exchanges, brokerage houses, banks, and information vendors." Background to the MDML XML specification is described thus: "While all market data vendors carry largely overlapping sets of data, they have all developed different data models, protocols and symbologies. Each vendor supplies a highly specialized application set for making the best use of their data. Extracting information from a vendor's data feed into common desktop applications can only be done with custom software. A class of products called integration platforms has been developed to ease this problem. Integration platforms convert vendor data into their own proprietary models so their specialized application set can make use of data from many vendors. While this solves the immediate problem of a trader who wants access to multiple sources of data through a single desktop, it doesn't solve the larger problem of distributing information to disparate systems in an organization... Most if not all market data vendors have solved the problem of data modeling by developing simple models which allow them to carry an ever increasing variety of information without making changes to their infrastructure or simple display applications. There are two broad classes of representation, which here will be referred to as pages and records. Pages are unstructured collections of data formatted for display in a fixed sized window. A record is a set of properties each containing a piece of information related to that record. Records representing different types of securities (i.e., Japanese Government Bonds and Dollar Yen Swaps) will contain different sets of properties. Even when vendors' wire protocol represents information in fixed sized structures, it is still conceptually sets of properties. Pages themselves can be, and often are, distributed as sets of properties - containing the page's width, height, text, color attributes in separate properties. Other types of information can be represented as sets of properties, but tend to have more complex request parameters, and usually contain repeating rows of data. Examples are news headlines, historical trades, and options and futures chains. In order to represent this information in XML, MDML defines a property and its attributes, as well as conventions for assembling properties into the objects that are returned from queries on a vendor's data feed. MDML also defines a convention for representing repeating rows of data. In order to improve access to the information, MDML defines a default set of object types with default properties, as well as request structures for them. The set of object types, and their properties, is extensible so a market data vendor can include its own value-added information and differentiate its products. This specification includes examples of MDML, but not schemas or DTDs. Examples are much better at conveying the structure and use of an XML. Once MDML is finalized, schemas and/or DTDs will be published, separate from this document, to allow parsers to validate MDML... MDML tags [used in the draft specification] are defined to be in the MDML namespace, which is uri:xml.com.bridge/mdml-1.0. Appendix 2, 'Market Data Control Set', lists the elements and attributes that are used by MDML."
[January 05, 2001] Dow Jones MDML Overview and XML DTD. "Dow Jones MDML is an XML application, and is described by an XML-compliant DTD. The root element is called mds-results, and represents a transaction package. It has attributes that represent criteria specified at the beginning of the transaction, and other information that might be needed to complete it. Some attributes are geared toward a web server request, such as 'remote-user' and 'http-user-agent'. Others are used to pass on information about the process that created the MDML data, such as 'creation-date', 'error-condition', 'error-code' and 'route'. The mds-results element has container elements that each hold a different type of data. For example, some of the children of mds-results are instrument-set, portfolio-set, headline-set and earnings-report-set. Keeping each type of data in a separate container, and making each container optional, makes the DTD very modular. This allows placement of any combination of data into one MDML document, or just one data type. Data can be matched up between the different containers using key values, such as ticker symbol, or an identification scheme like SEDOL or ISIN. In general, all data are represented in an object-oriented manner, with elements representing objects (e.g., purchase, instrument, headline) and attributes representing properties of the objects (e.g., number-of-shares, news-symbol, headline-text). This content-less model works well for raw data and reduces hierarchical complexity. The DTD contains specific markup vocabularies for many different types of market data: (1) corporate earnings; (2) equities; (3) bonds; (4) indexes; (5) options; (6) mutual funds; (7) currencies; (8) commodities; (9) U.S. Treasuries. It also has structures for holding lists of headlines, which may be related to a company in an instrument set. It is designed for easy expansion to cover other instruments and markets. WSJ.com developed the Dow Jones Market Data Markup Language in 1999 to describe market data, symbology and portfolio information on the web site. Later WSJ.com began using the XML-based DTD as an interchange format with an internal database of corporate earnings, and with Factiva, the electronic archival service that is a joint venture of Dow Jones and Reuters Inc." [See the description document.]
References:
Market Data Markup Language (MDML) Specification. Version 0.12, Working Draft 03 May, 2000. 47 pages. [cache]
"FISD Forms XML for Market Data Working Group." Announcement 2000-12-20. "FISD is forming a Working Group to consolidate industry efforts and define the parameters of XML for market data discussion. Interested members please contact Michael Atkin. The first working group meeting is targeted for January 2001." [cache]
Market Data Markup Language Presentation. By James E. Hartley (Global Technical Lead, Bridge Internet Toolkit). December 6-8, 2000.
XML for Market Data Presentation. By Jeremy Sanders (Merrill Lynch)
XML: The Future of Data Exchange." By Dr. Martin McCaig (Solutions Marketing Director, Reuters Ltd.). September 2000.
Sample MDML Documents (request, response)
[January 05, 2001] Dow Jones MDML XML DTD (PDF), text version. By Lee Cookson (Dow Jones & Company). Last Revised: 11/20/2000. "Dow Jones MDML is an XML application, and is described by an XML-compliant DTD..." [cache]
[January 09, 2001] XML Working Group to Meet January 17, 2001. "The initial meeting of FISD's XML Working Group has been scheduled for Wednesday, January 17 from 2:00 - 5:00 pm at the offices of Merrill Lynch in New York City (4 World Financial Center, 250 Vesey Street, North Tower, 3rd Floor, Room B). The XML Working Group was formed during the FISD General Membership Meeting in December. Our initial discussion will focus on: (1) defining the parameters of XML for market data; (2) outlining the plan for assessing and filling out the standard (i.e., definition of the elements and attributes to be included, standardizing the nomenclature, resolving symbology, etc.); and (3) determining the process for ensuring coordination among the other major financial industry XML efforts."
[January 05, 2001] "Dow Jones Contributes XML Work to Market Data Project." - "Dow Jones & Company announced today that it is providing its Market Data Markup Language to a financial industry consortium as a starting point toward development of an XML-based global standard for market data delivery. The Market Data Markup Language (MDML), developed by Dow Jones is now posted at www.fisd.net, the web site of the Financial Information Services Division (FISD) of the Software & Information Industry Association (SIIA). The FISD -- a forum for business and technical issues related to the distribution of financial information -- recently formed a working group to coordinate XML efforts in the market data industry. Dow Jones contributed its MDML to speed development of a common framework to publish market data. 'We will jump-start the new FISD initiative by contributing a good portion of our XML expertise in this area,' said Kevin M. Roche, news systems manager and head of the XML group at Dow Jones. 'Our approach to the structural and content markup of financial statistics will provide a solid base for industry discussions.' The Dow Jones MDML has been in production for about two years at The Wall Street Journal Online at WSJ.com. The language is used for posting text and statistical data on the web site, and as a system interchange format within Dow Jones and with entities such as Factiva, a joint venture of Dow Jones and Reuters. 'Timely market data is essential to all market participants,' said Bill Godfrey, chief technology officer of Dow Jones. 'Dow Jones is both a consumer and supplier of market information, and XML is a powerful new way of exchanging data within the industry. Creating a standard, open framework enabling data to stream across company boundaries and multiple platforms will benefit the entire financial industry, and Dow Jones is committed to taking an active role in that creation.' 'The market data industry is working together to solve the challenges of moving data from multiple sources into common desktop applications,' said Michael Atkin, vice president of the FISD. 'Dow Jones has provided a technological cornerstone for our XML project and we're grateful to them for their contribution to this initiative.' The FISD market data work will be done in coordination with other XML initiatives, including XBRL, or Extensible Business Reporting Language. The XBRL consortium (www.xbrl.org) is developing XML vocabularies for corporate earnings and regulatory filings. Dow Jones, Reuters Group, and Reuters' Lipper subsidiary are all participants in XBRL. The FISD effort also dovetails with two XML standards developed by the International Press Telecommunications Council, of which Dow Jones, Associated Press, and Reuters are all members: NewsML is an XML model for packaging and managing news objects of any media type; the News Industry Text Format is an XML application for markup of news text." [alt URL]
