Table of contents Author City Company Country State/Province Term Interchange  

The Role of XML in Finance

Coates, Anthony B. , Leader of XML Architecture & Design ,   Reuters ,  Chief Technology Office,     London    United Kingdom 

Email: Tony.Coates@reuters.com

Web site:http://about.reuters.com/researchandstandards/

Biography

Anthony B. Coates is Leader of XML Architecture & Design in Reuters Chief Technology Office, and represents Reuters on technical working groups for FpML (Financial Products Markup Language), Market Data Definition Language (MDDL), and IRML (Investment Research Markup Language). He is an architect of Reuters' MarketsML specification. As Leader of XML Architecture & Design, Tony recommends XML technologies and design strategies to product groups within Reuters to co-ordinate the business usage of XML and leverage the best available solutions. This includes both general XML technologies and specific vertical market XML languages. His background includes developing software for technical analysis & financial graphics, developing multimedia & Web applications, and theoretical & experimental physics. He has worked with XML since 1998. Prior to joining Reuters CTO, Tony worked as a software engineer for Equity Systems Pty Ltd, where he designed and implemented an XML architecture for financial graphics solutions.

Abstract

The financial world has long been a large and demanding user of information technology. XML is the latest tool for rebuilding existing work practices to open up new market opportunities. This presentation provides an overview of why the finance sector is turning to XML, and where the effort is currently being focussed.



Introduction

In this presentation, the use of XML in the financial world is discussed. The first section introduces what "finance" is, as the terms "finance" and "commerce" are often used interchangeably in colloquial speech. Finance is the provision of money. It is a vital enabler of general commercial activities, but commerce covers a much broader range of activities than the purely financial.

Next, some of the reasons why the financial community is moving to XML are discussed. This is followed by catalogue of major financial XML specifications, and a few related commercial ones. Finally, areas in which XML does not yet sufficiently satisfy the needs of the financial community are discussed.

What is Finance?

Show Me the Money

finance  money  Once upon a time, the people with money were the nobility. If you wanted to borrow some money to finance a business venture, you had to plead to your local king/queen or duke/duchess. There wasn't necessarily a choice of who you could deal with, and even a good business proposition might be turned down on a whim. Even if you got the money, there was no guarantee that you could afford the amount you would eventually be expected to pay back. This kind of environment is a discouragement to people who have good ideas but not the money to bring them to reality.

Later on there were money lenders, which at least gave you choice, but there was a lot of legwork to do in order to find the best deal. There was also no guarantee that a good deal would be available later if you didn't accept that deal immediately.

Financial markets Financial markets developed as lenders came together in one spot where haggling could take place. While there is a disadvantage to the lenders in having to offer competitive terms for finance, there is the advantage that potential borrowers are drawn to such markets so they can get a better deal. The attraction of markets to both lenders and borrowers is that each gets greater access to the other, and each knows that is better for business.

To Market, To Market

Stock markets  risk   Stock markets change the traditional lending story by sharing ownership (and risk) among a large number of investors, each of whom own a small part of a company. You don't need have to have enough money to buy a company just to be able to invest in a company, and you can split your investments across multiple companies so that your fortunes are not too closely tied to the fortunes of one single company. Although people often do not think of it this way, when they buy shares, they are lending their money to a company, in the belief that the company will pay them a fair return for the loan (either through dividends or a growing share price).

liquidity  market makers  The unseen part of markets is the market makers, who buy your shares when you want to sell and sell them on when someone else then wants to buy. They provide liquidity to the market, without which buyers and sellers would have difficulty matching themselves to others who want sell/buy exactly the same number of shares in a single transaction. The ability to buy or sell immediately (albeit at the going market price) is what makes a market attractive to investors. Shares have much greater value if you are able to sell them whenever you want or need to.

Taking a Risk

risk management  risk portfolio  In industrialised countries, almost all of us borrow money at some time or other, particularly for a car or house. None of us ever consider ourselves to be a bad risk, but each of us is a risk. Each of us might one day find ourselves in a circumstance where we cannot repay the money that we owe. For large money lenders, the cumulative risk can be enormous. Much of the complexity that is seen in the financial world today is because of the need for risk management. If the institution that loaned you money is taking too great risks, you might find they will suddenly have to forclose on your loan to cover their losses, and so you will be forced to pay back early. You may not be able to, and you might be bankrupted. So the need for lenders to manage their risk portfolio is as important to borrowers as it is to the lenders.

government bonds  investment  risk analysis  Modern risk management is based on a surprisingly simple result which comes from risk analysis. If you have access to both a low-risk investment and a high-risk investment, you can choose the level of total risk that you are exposed to by controlling how much you invest at low risk (and low return) versus how much you invest at high risk (and high promised return). In the financial world, low risk is provided by government bonds, which are treated as a more-or-less zero-risk investment.

futures  options  Risk management has also led to options and futures, where you pay for a guarantee that you will be able to buy or sell something at a particular price in the future. Large institutions use these to protect themselves against large swings in prices. Sellers of futures and options make money when the underlying prices do not move sufficiently for those large institutions to want to buy or sell.

exotic financial instrumentsThere are many exotic financial instruments with complex conditions (understood only by lawyers with mathematics degrees, or vice-versa) that exist to offer alternative new risk strategies that can be used within a risk portfolio to spread the risk as evenly as possible. In the end, all of this contributes to a sharing of the total risk among all players, which increases stability. Businesses tend to flourish best in stable predictable conditions, so markets needs to take this stable and sustainable approach to risk.

Extra, Extra, Read All About It

central bank  financial news and information  interest rate movement  If you are taking calculated risks, you need to continuously evaluate whether those risks are working for or against you. This makes the financial community a voracious consumer of financial news and information. The latest and most accurate news and information, delivered as quickly as possible, is what is required. As an example, Reuters once scooped an interest rate movement announced by a central bank. It was a whole minute before our competition reported the event. During that one minute alone, one of our customers made enough money to pay for its news and information for the following 1–2 years. When single trades are tens of millions of US dollars or more and the margins are narrow (as is common in areas like FX trading), you need to be sure that you are trading based on what correct right now, not based on what was happening five minutes (or more) ago. It is a lot easier to lose money than to make it.

What Does XML Offer For Finance?

There are a number of areas in which the finance community, which is a major spender on IT , is looking to XML to improve business. Within companies, XML is being used to integrate legacy systems, some of which implement complex financial models developed over many years, and which remain mission critical. This integration XML is sometimes internally developed, and sometimes built using a selection of 3rd party ML s. This usage of XML for integration is not fundamentally different to what is done outside of the financial world.

contextual metadata  integration  Another growing usage is for the dissemination of news and information. Consider that Reuters publishes 3 bibles worth of news every day (mostly financial), and more again in terms of financial information (such as the latest stock market prices from around the world). All of this information is valuable to someone, but no one person has the time to make sense of it all. While some filtering of this information can be done using simple techniques like free text searching, the way forward is seen to be by the addition of contextual metadata to the information, so that end users can filter the information they receive based on well-known topic areas. XML 's flexible tree structure lends itself to the addition of layers of metadata to the underlying data.

financial transactionsPerhaps the most compelling financial use for XML , however, is in financial transactions. XML is certainly making inroads for general commercial transactions; it fuelled the rise of Commerce One, and is the raison d'être for ebXML . Financial transactions push the boundaries of normal commercial transactions on two fronts. The first is their time-sensitivity. The price of some goods might only change once per year, but the prices of stocks, options, futures, and commodities can change hundreds of times a day. If you cannot trade quickly, you might end up trading at the wrong price, and trading out of that position may only come at a significant loss.

terms and conditionsThe second area where financial transactions push the boundaries is complexity, and this is where XML is particularly appropriate. There are many financial instruments which are not traded on exchanges, but directly between institutions, and these have developed a range of intricate terms and conditions. Originally, each trade of such an instrument would require the individual attention of legal staff, because each trade could have its own individual terms and conditions, and nothing could be assumed for new trades based on previous trades. The situation was greatly improved when standard contracts were developed for so-called vanilla versions of these instruments, because there was less need to check each contract word for word. Even this is not enough, however.

Standard contracts still require many blanks to be filled in by both sides, and time constraints mean that these cannot be agreed in detail over the phone. So even with standard contracts, days are still required to confirm that both parties are actually agreeing to the same deal. This greatly impacts on the cost of transactions, and the cost of a transaction greatly impacts the minimum viable size of transactions. The minimum size of transactions greatly impacts the number of institutions and/or individuals who can make those trades. The number of institutions/individuals making transactions greatly impacts the long-term viability of a particular class of financial instrument. So, there are strong incentives to reduce the manual effort required to process individual transactions. XML transactions formats allow well-known default values to be easily applied to contracts, and allow the contract details from both sides to be compared automatically. Humans only need intervene where a disagreement is found, greatly reducing the time required to confirm the transactions.

operational riskCurrently, transactions are mostly characterised between T+3 (deal is finally concluded 3 days after the initial trade order is executed) and T+5 (concluded 5 days after). This means that both your money and item(s) you bought/sold are in limbo for 3 to 5 days. If the market moves in that time, there is nothing you can do. This leads to a high level of operational risk for traders. The US is pushing for transactions to move to T+1 by 2005. The only way the markets and major traders will be able to achieve this is by broad vendor-independent automation of the trading process, and XML will figure strongly in such processes.

What are the Available Financial MLs?

FpML

FpML is a set of financial specifications which is initially focussing on transactions of over-the-counter financial instruments. These are financial products which are not traded via an exchange, but directly between two financial institutions, such as banks.

over-the-counter financial instrumentsTraditionally, over-the-counter deals are agreed by telephone, where only the most important details are discussed. After this, each party faxes and couriers the full details to the other, and the details are then compared to make sure that both parties were actually agreeing to the same thing. Time pressures mean that the full details cannot be agreed during the telephone phase of the negotiations. As such, the process of confirmation, comparing what both parties believed the they had agreed to, is manually tedious, and this makes it a good candidate for automation using XML . FpML messages each have a known and predefined set of defaults which are be overridden explicitly by either party as required. This makes the process of not specifying something explicitly a well-defined one, and allows the confirmation to be done in a fast semi-automatic fashion where only mismatched information is brought to the attention of humans.

forward rate agreements  interest rate swaps   FpML currently covers interest rate swaps and forward rate agreements, and is being extended to equity derivatives, FX spots, FX forwards, FX swaps, non-deliverable forwards (NDF), simple FX options and FX option strategies. Transactions which are currently exchange-based, such as "sell 1000 Reuters shares on the LSE for no less than £15 per share", are out of scope at present.

Refer to the FpML talks from this conference for more details.

XBRL

XBRL is a financial specification which is initially focussing on company filings and reports. On an international level, the major complexity with company reports at present is that each country has its own accounting standard. In the USA , the US GAAP is used, while in the UK it is the UK GAAP , Australia has an Australian GAAP , etc. Each accounting standard requires a different XBRL "taxonomy". What differs in each case are:

XBRL allows companies to add their own items by extending their local XBRL taxonomy. This allows those items which are important to a company's understanding of its own business to be directly related to the standard accounting terms required in its annual filing and report.

The US GAAP (Commercial & Industrial) was the first completed XBRL taxonomy. It contains thousands of items. The UK GAAP is taking a different approach, and is limited initially to hundreds of items. It is hoped that this will significantly reduce the learning curve, and thus speed the uptake of XBRL in the UK . Reuters is the first UK company to start publishing its results in XBRL (using a taxonomy based on the UK GAAP ). The UK and Australian GAAP taxonomies are based on the IAS GAAP taxonomy, and EU corporations will be required to submit company reports in IAS form from 2005.

Refer to the XBRL talk from this conference for more details.

MDDL

MDDL is a financial information specification produced by the FISD , part of the SIIA . MDDL 1.0 was released at the start of November 2001, and supports the publication of snapshots and historical time-series of equity prices, financial indices, and mutual fund data.

equity prices  financial indices  historical time-series  mutual fund  snapshots  Many of the world's major financial companies have contributed to the development of the MDDL 1.0 vocabulary, which guarantees that MDDL contains the items that are really used every day. A goal of MDDL is to stimulate the development of new and innovative applications of financial information by providing a common and flexible language which can be used to pass information between applications.

MDDL has features which can be used to help reduce its bandwidth requirements. Commonly used fragments can be written once in the <references> section at the start of the document, and then referenced wherever required in the remainder of the document. Most MDDL elements can have property elements as children, but property values are also inherited from ancestors, which helps reduce the need to inline the same values multiple times. Another MDDL 1.0 feature is an optional <other> element which provides extensions points throughout MDDL documents, so that there is plenty of scope for augmentation of the standard MDDL information.

Future versions of MDDL will extend the range of supported financial information, and may eventually address real-time updates as well. Development of a financial query language is also envisioned.

Refer to the MDDL talk from this conference for more details.

swiftML

SWIFT is an existing electronic messaging system used by major banks. The messages are being converted to XML under the name "swiftML". SWIFT are closely involved with ISO 15022, on which the latest set of SWIFT messages is based, so swiftML is also closely aligned to ISO 15022. swiftML will be merged with FIXML as part of the ISO 15022 XML effort.

FIXML

electronic messaging FIX is a non- XML financial transaction protocol which aims to be vendor-neutral. The FIX consortium is composed of a group of banking and financial institutions who view themselves as clients rather than vendors. FIXML has been announced as the XML -isation of the existing FIX protocol (messages). The intention is that, for an interim period, both traditional FIX messages and FIXML will be supported in parallel until FIX is eventually deprecated in favour of FIXML . FIXML will be merged with swiftML as part of the ISO 15022 XML effort.

RIXML

RIXML is an investment research specification which focusses on metadata rather than on the way that research reports are structured. The intention of RIXML is not to provide a way of writing investment research content using XML , but to provide a standard attachment that can be used with any media type to indicate the nature of the content. One of the key uses of XML in financial specifications is to allow metadata to be associated with content so that the best possible filtering and ranking of the available information can be done. RIXML is unusual in completely externalising the metadata from the content, but effectively delivers its users' major value-add (filtering) without requiring any change to the content formats they use, so it does not interrupt existing workflows.

ISO 15022

A major non- XML specification has contributed to MDDL and other financial XML specifications is ISO 15022. This provides a standard set of (>10k) data fields for financial information and (~100) messages for financial transactions. The data dictionary and catalogue of messages are maintained on ISO's behalf by SWIFT , a banking industry co-operative. An effort has been started to define a direct XML version of ISO 15022, one which supports not only ISO 15022 but also the existing (non- XML ) SWIFT and FIX transaction protocols.

NewsML

NewsML is a multimedia news packaging and distribution format from the IPTC . While it is not specific to finance, it is important to remember that news is as important as statistics in shaping decisions on what to buy and sell. So, when considering XML formats for financial information, NewsML is important as the XML way to provide the news side of the equation. While NewsML provides rich facilities for packaging news and adding metadata, it does not define the formats of the actual content. Textual content in NewsML is most likely to be done using XHTML or NITF . Reuters will be using XHTML (automatically converted to NITF where required), while some US -based news providers will be using NITF directly, as this is the preferred format of some US newspapers. When Reuters moves its full news production to a NewsML architecture in 2002, it will more than likely become the world's largest publisher of XHTML .

MarketsML

Reuters has announced that it will be producing an XML specification for financial information and transactions, named "MarketsML". Reuters is the largest financial information supplier in the world, and the intention with MarketsML is to build a comprehensive set of XML Schemas which cover the full range of financial information and messages which Reuters deals with, both now and into the future. MarketsML will interoperate with NewsML to allow complex linking between news and financial statistics. Further details have not been released at the time of writing, but check the latest version of this talk for more information.

What are the Related Commercial MLs?

IFX

IFX is an XML messaging specification which supports commercial and personal banking. IFX messages can be used to manage accounts and specify transfers of money between banks, businesses, and customers. IFX also handles billing and payments. This is an important part of commercial banking, but not investment banking, so IFX is a commercial rather than a financial XML format. IFX is based in part on OFX .

OFX

OFX is an earlier commerical and personal banking specification that has migrated from SGML to XML (by removing support for implicit end tags). It has been extended to support tax forms, and there are also plans to extend it to support financial planning and insurance.

ebXML

While ebXML is a general e-business XML specification, and not specific to the financial industry, it is likely to play a growing role in the financial world. Financial services are often divided into "view" (information) and "do" (transactions); the "do" half of financial XML is about financial transactions. Due to the sums of money and the risks involved, financial transactions typically have more demanding requirements for speed, validation, authentication, and security than do general business transactions. However, once the global ebXML infrastructure is in place, it would be very surprising if that infrastructure were not suitable for at least some financial transactions, and the migration could well continue from there if the needs of the financial world drive the performance and functionality of ebXML implementations. So, expect to see ebXML take a not insignificant role in financial transactions in the future, though be aware that it is too early in ebXML 's life to say where the first uses of ebXML for finance might occur.

What Does Finance Still Need From XML

You Are Only As Good As Your Tools

XML is a great technology, but the tools are still immature, in the sense that they tend to demand that users have an understanding of how XML works, and of how to make it work best. Ideally, companies want business analysts to be able to write XML schemas ( DTD s/ W3C XML Schemas/ RELAX NG /Schematron/whatever) without having to train them up at IT specialists. It should be enough for analysts to be domain specialists, which means that XML tools need to be as approachable as word processors or diagramming packages.

Who's the Boss

XML has added another dimension to data modelling, one that can complicate the process if not managed properly. Once upon a time, the database gurus designed the database schemas, and they were in charge of data modelling, as well as transactions and reports. Then came 3-tier systems, and the object-oriented code gurus insisted that their object models were the real data models, while the database was just a place where objects could be parked overnight. Now your XML gurus will tell you that the XML defines the data model, and that object models and database schemas are just necessary evils whose task is to support the needs of the XML .

There is a need for tools that make it easier to integrate these data models without any of the three (database, object, XML ) looking like an awkward mechanical creation. These tools need to be multi-directional, because you can never be sure which of the data models will be the most appropriate one to modify directly, but once you do change one, you need to be able to propagate the changes to the other data models. There is a need for harmony between how you store your information in a database, how you serialise it for transmission using XML , and how you represent it as objects in memory.

Remember too that financial corporations have invested heavily in developing legacy financial models which tend to be implemented in "big iron" relational databases. These existing models are not going to go away quickly, because too much has been invested in them, so the easier it becomes for new XML formats (and their underlying data models) to be integrated with the legacy models, the easier it will be for those XML formats to get corporate acceptance.

Refer to Dave Carlson's talk from this conference for details of one technique for integrating UML and W3C XML Schema, which is a good start in this direction.

The Schema Dilemna

The use of XML for financial transactions is made more difficult at present by the differences between XML Schema processors. XML Schema is a natural choice for financial applications, because it provides strict datatyping that DTDs do not. When your XML documents represent transactions of millions or hundreds of millions of dollars, you do not want to take any chances with the interpretation of data types. However, as it now stands, a corporation can validate an XML message against an XML Schema with one validation engine and then send it, only to discover that the receiver rejected the message as invalid because the receiver's (different) validation engine found the message to be invalid against the same XML Schema. This is a major challenge for financial applications, where go/no-go decisions on correctness are preferred to "best effort" methods, but missing your chance to buy or sell can be disastrous. It is to be hoped that the W3C XML Schema Test Collection will help to sufficiently address this problem.

The Port 80 Legacy

The textual nature of XML , and its consequent raw size, can make it infeasible to deliver large amounts of financial information (and deliver it in a timely fashion) over the many lower bandwidth connections which exist even in industrialised countries. The world is still a long way from having the network capacity for on-demand digitial video at every desktop, and as a consequence the delivery of news and financial information in XML often requires compression (the best case), or the (expensive) development of compact binary transmission formats, one per schema, which can carry the same information more succinctly (the worst case). Bandwidth issues would have existed even without XML , because the number of trades reported daily from the world's markets is growing exponentially. The desire of end users to receive XML , however, is compounding the situation, and will continue to do so in the short to medium term. This means there is a need, and hence a market opportunity, for tools which can transparently squeeze the most XML through the available bandwidth.

Conclusion

As the financial community looks to reduce costs and increase the accessibility of markets through off-the-shelf technologies and multi-vendor standards, XML is playing a key role as the technology which suddenly made everyone want to take part in an industry consortium and work with their competitors. While early results look promising, the current generation of XML tools focusses too much on the technology and not enough on achieving what users need to achieve as simply as possible. This is a natural developmental stage with a new technology, as XML still is, so there is great scope for the next generation of tools to simplify the work processes required to get data flowing freely among the financial community, to the profit of all.

The latest version of this presentation will be available at http://about.reuters.com/researchandstandards/events/2001/12/xml-2001/ . If you find that this URL is not in place when you check it, the author can be contacted directly by e-mail as Tony.Coates@reuters.com .


Bibliography

[ebXML] ebXML — http://www.ebxml.org/
[FpML] FpML — Financial Products Markup Language, http://www.fpml.org/
[FIXML] FIXML — http://www.FIXprotocol.org/
[IFX] IFX — Interactive Financial eXchange, http://www.ifxforum.org/
[ISO15022] ISO 15022 — http://www.iso15022.org/ , http://groups.yahoo.com/group/XML_Init_Main
[MDDL] MDDL — Market Data Definition Language, http://www.mddl.org/
[NewsML] NewsML — http://www.newsml.org/ , http://newsshowcase.reuters.com/
[NITF] NITF — News Industry Text Format, http://www.nitf.org/
[OFX] OFX — Open Financial Exchange, http://www.ofx.net/
[RELAX NG] RELAX NG, http://www.oasis-open.org/committees/relax-ng/
[RIXML] RIXML — Research Information eXchange Markup Language, http://www.rixml.org/
[Schematron] Schematron — http://www.ascc.net/xml/resource/schematron/schematron.html
[swiftML] swiftML — http://www.swift.com/index.cfm?item_id=6609
[XBRL] XBRL — eXtensible Business Reporting Language, http://www.xbrl.org/
[XHTML] XHTML — eXtensible HyperText Markup Language, http://www.w3.org/MarkUp/
[XML Schema Test] W3C XML Schema Test Collection, http://www.w3.org/2001/05/xmlschema-test-collection.html
  Table of contents Author City Company Country State/Province Term Interchange