Financial Market Data Web Services – Xignite Blog

In 2011 the cloud finally went from an unproven curiosity to an accepted mainstream technology solution. In 2012 we will witness the deepening penetration of the cloud into the consciousness of multiple industries.  The market data industry is an interesting case in point because the major industry trends are all pointing to the rapid adoption of an on-demand cloud-based market data solution.

Let’s review each of these trends individually to understand how important the cloud will be for the market data industry in 2012:

1. Market Data Supplier Economics

The suppliers of market data are in a state of flux. On one hand, the cost of business is soaring with the new technology resources required to support sky-rocketing message rates, microsecond execution, and new regulation. On the other hand, the exchanges are experiencing sluggish revenue growth. Traditionally exchanges had four distinct sources of revenue: 1.) execution; 2.) listings; 3.) clearing; and 4.) market data. Of these, only market data is growing, while the others have either completely dried up or are not likely to be a significant source of revenue in the future.  The exchanges have responded to these unfavorable economics with a wave of consolidation in an attempt to reduce costs but the health of the industry depends on growing the revenue side of the equation. The exchanges understand that their best revenue strategy is to distribute their most valuable asset, market data, direct to consumers. This strategy has already seen success with the exchanges offering direct feeds, co-location, and other services to their low-latency clients.

In 2012 we will see more exchanges begin to focus on the largely untapped segment of consumers who need market data, such as historical trade and quote data, but are not latency sensitive. This is potentially a huge revenue source for the exchanges and is ideally suited to the on-demand market data cloud. Forward-thinking exchanges such as CME DataCloud, Direct Edge EdgeBook Cloud, and NASDAQ Data-On-Demand, have already moved in this direction, but 2012 will be the year that many more exchanges embrace the market data cloud to sell directly to consumers.

(Read more about how the exchanges are embracing the cloud in our recent blog post – Cloud Strategy for Exchanges and Financial Markets.)

2. Market Data Consumer Economics

As with the suppliers of market data, consumers are also facing an uncertain future. For many consumers, particularly in the financial services industry, the whole process of data management has become overwhelming. The old model of bringing all market data in-house, so that it can be accessed quickly, is under considerable pressure. There is now simply too much data to do this cost-effectively. Another related issue is time to implementation. With intense competition, many investment firms require immediate access to global and multi-asset class market data. Unfortunately, the traditional method of having a vendor add a feed can be a very slow process. Investment firms require a much more nimble solution that allows them to quickly access discrete data sets.

In 2012 we’ll see more firms conclude that not all data should be brought in-house. This change in mindset will lead firms to become much more discerning about what data should be stored locally, and what data should be retrieved on an ad-hoc basis from a market data cloud.

3. Proliferation of Mobile Devices

It is clear that we are in the midst of a technological sea change Read more

The last few years have been undeniably tough for the once brash hedge fund industry. Recent headlines do not suggest any improvement with August being the worst month for hedge funds since October 2008, and marquee firms like Paulson & Company firm down 34% year-to-date.  Prior to the crisis of 2008, the industry appeared to be on a steady upward trajectory, evolving from a small, scrappy upstart, that catered to high net worth investors, to a more formalized $2 trillion industry, that serviced the largest pension funds in the world. Since the crisis, however, the industry seems to have lost its way. What exactly happened and how can what we term the “Hedge Fund Cloud” return the industry to its former glory?

Institutionalize or Die

Pre-crisis, managers believed that the measure of success was not only returns but assets under management. In their race to acquire new assets, managers were motivated to “institutionalize” their infrastructure so that they could go after the really big allocations from large pension funds and endowments. For many firms this institutionalization meant leaving the relative simplicity of their single prime relationship to the much more complex world of building out their own multi-prime infrastructure. Almost overnight managers found themselves running complex and unwieldy businesses. Seemingly simple operations like adding a strategy, that required a new asset-class, or producing a new report, became long and involved IT projects.  Any thought of outsourcing any of this burden was dismissed because of perceived privacy and control concerns.

Prisoners of their own Hedge fund Infrastructure

The actual crisis further exposed the inflexibility of hedge funds’ infrastructures. Managers struggled to view their true exposure across asset classes and multi-prime relationships. Just when managers most needed their former agility they discovered that they had become prisoners of their own expensive infrastructures.

Fast forward to today. We are still experiencing the after effects of the crisis. A strong regulatory backlash response has been unavoidable. There is still tremendous uncertainly about the true impact of these new regulations, but what is certain, is that the business of running a hedge fund will become even more complex and costly.

How can the industry remove itself from this funk and prepare itself for the next crisis? The answer is that the industry needs to return to basics by once again making alpha generation its sole focus. The industry needs to regain its former investment agility. In short, managers need to get out of the running-a-hedge-fund business and get back to the investment business.

The Hedge Fund Cloud to the Rescue

Fortunately, the Hedge Fund Cloud offers managers the opportunity to get back to basics.  The Hedge Fund Cloud allows Read more

Perhaps nowhere more in the diverse world of hedge fund strategies is the prospect of alpha decay more unsettling than at high-frequency trading firms. In many ways high-frequency trading firms are now facing a reality that other hedge funds with more esoteric strategies may one day face – too much money chasing a finite amount of alpha.

The End of the Hardware Arms Race

The latest figures indicate that high-frequency trading now accounts for somewhere between 60-70% of trading volume in the US. This is up from around 35% just five short years ago. High-frequency trading firms, that in the past have been among the most profitable on Wall Street, are now seeing that increased competition has crowded out many of their traditional strategies. High-frequency trading firms have responded by co-locating their black boxes and by throwing ever more expensive hardware at the problem. This approach has worked for some of the larger, better-funded firms, but only postpones the inevitable.

What will happen when this hardware arms race meets the laws of physics? The answer is that many of these firms will need to develop high-frequency trading strategies where alpha is still relatively abundant and competition less fierce.

New High-Frequency Trading Alpha Opportunities

The two most common opportunities that high-frequency trading are now exploring are as follows:

1. Alpha outside the US – The US was the first to develop electronic trading, other regions are still in the process of building out their electronic trading infrastructure. A recent Credit Suisse study estimated that high-frequency trading activity accounts for 35% in Europe and only 10% in Asia (excluding Japan). Many high-frequency trading firms are now seeking to port the strategies that worked so well in the US over to these less developed markets.
2. Multi-Dimensional Strategies – The traditional strategies of high-frequency trading have typically been one-dimensional involving the high-frequency trading in and out of a single large, liquid name. The newer high-frequency trading strategies are much more complex and multi-dimensional in nature searching for arbitrage opportunities across asset-classes, geographies etc.

The New Arms Race and Cloud-based Market Data

The common thread that runs through these new strategies is the need for access to more diverse and dispersed market data sets. Market data Read more

Ad hoc Excel financial models are employed across a wide range of applications from stock portfolio management, currency trading, loan processing, etc., but they all have one thing in common: they all need ad-hoc financial market data as the input to the analysis.

This is the third post in a series that describes how to use Xignite on-demand financial market data with Excel. The last post in the series described how to import live market data into Excel using Xignite Web Service XML output. This post will take it to the next level and explore how to create Excel financial models that not only bring in live market data over the Internet, but allow you to modify the market data requested using Excel macros to create dynamic Excel financial models. All the examples in this post are available for download in this Excel spreadsheet.

The first step is to Read more

The beauty of Xignite on-demand market data is that it can power any application from spreadsheets to major financial websites, anywhere, anytime, because it uses industry standard Web service APIs and XML data exchange formats. This is great news for Excel users, because Excel has fantastic XML support.

This is the second post in a series for Xignite customer’s using Excel that explores how to import market data into Excel using XML. The previous post in this series showed how you can import market data into Excel using a CSV file (comma separated values), the most common data exchange format for spreadsheets. As the native data format of Xignite Web services, XML allows you to go beyond the simple file import available with CSV to create direct links to Xignite Web services that allow you to update real-time market data from within Excel.

Importing Market Data into Excel from an XML File

The simplest way to get market data into Excel using XML is to import an XML file just as you would import a CSV file.  Simply go to the Web page on Xignite’s website for any Web service operation, type in the relevant input parameters, and click the “View in XML” button.  This will open a new browser tab with the Web service output in XML.  Let’s try it now on the Web page for the GetLastSales operation in XigniteBATSLastSale, an Xignite Web service providing real-time stock quotes.  Keep in mind you must be logged in to your Xignite Web services account in order to receive data.  If you don’t have an account, just sign up for a free trial.

The output should look something like the image above. The next step is Read more

It may be easier than you think to get the latest financial market data in Excel spreadsheets using Xignite.  Most of our customers use Xignite’s web services to power their custom-built applications and websites with financial market data.  But if you’re a financial analyst or a power user of Microsoft Excel, you may not want to build a new application.  What if you aren’t a programmer?  What if you just want the market data in Excel and you don’t need any other application?  In that case, all you really want is a simple way to get market data in Excel so you can perform your analytical magic without the need to hire a programmer.  In this blog post, I’ll show you a simple, easy way to do just that.

Read more

One of the most common financial applications of Xignite on-demand market data is portfolio management software.  Portfolio management software is used by a wide range of Xignite customers including asset managers, wealth managers, hedge funds, financial advisers, broker-dealers and publishers of online portfolio websites.   Each portfolio management software customer has unique requirements that vary across asset classes and update frequencies, however, the hit calculation required to select the right Xignite Web services subscription plans is essentially the same.

This is the third post in a blog series on hit calculation that will provide detailed example calculations for portfolio management software applications.  The first post and second post in this series provided a comprehensive hit calculation tutorial as well as a general hit calculation spreadsheet. The examples in this post are also available in this sample portfolio management software hit calculation spreadsheet.

Single Hit Data Block for Portfolio Management Software

Every portfolio management software application Read more