Financial Market Data Web Services – Xignite Blog

Tracking multi-asset class portfolios in real-time is critical to active investors. Since many investors, particularly portfolio managers and analysts, typically spend a good part of their day in Microsoft Excel, having the capability to track multi-asset class portfolios within Excel would be a tremendous benefit.

Getting real-time pricing on multi-asset class portfolios within Excel has historically been a tedious (and often expensive) chore, requiring multiple vendors and technologies.  But with Xignite’s on-demand cloud APIs, it’s now simple and straightforward.  Even those without a programming background can be up and running in just a few minutes.

In this article, I’ll provide step by step instructions on how to create your own multi-asset class P&L tool in Excel with real-time pricing data from Xignite. All the examples in this post are available for download in this Excel spreadsheet.

This is the fourth post in our series on combining the power of Excel and Xignite.  For more info on this topic, be sure to review our posts on automating financial models, importing market data using XML and importing data using CSV.

Importing Multi-Asset Class Data into Excel

In this example, let’s suppose we hold a multi-asset class portfolio with a few stocks (ORCL, AA & T), an ORCL call option, an ORCL bond, and crude oil futures. To create a real-time multi-asset P&L tool,  we need live financial data. We’ll use the following web services APIs from Xignite to import them into Excel via XML:

• Xignite ExtendedRealQuotes for stock quotes
• Xignite RealTimeOptions for options data
• Xignite Bonds for bond data
• Xignite Futures for futures data

We covered how to import XML in a previous post, but let’s quickly review the process by pulling the stock data as an example.  We’ll start on the Web page for the GetExtendedRealQuotes operation, a Xignite Web service providing real-time stock quotes.

Once you are on the webpage, update the symbols (ORCL, AA, T) in the prompt at the top of the page, click on view in XML, and copy the URL that gets generated.  Next, open a new Excel worksheet, Read more

Technology has led a dynamic transformation of the exchange industry, and cloud strategies are an important factor in unlocking the revenue potential of exchange data.  The following article about how to monetize exchange data via the cloud was recently published in “How To Build An Exchange,” a fascinating must-read collection from our friends at Mondo Visione.  Request access to the full collection from Mondo Visione here. 

_____________

Monetizing Market Data in an Evolving Global Marketplace

The global environment for exchanges and data originators is rapidly evolving with exploding data volumes, increasing and unpredictable regulation, expanding variety of financial instruments, fragmenting market, competitive encroachment and the need for new sources of revenue. Beyond these challenges, the race to microsecond latency will stretch the infrastructure capacities and budgets at major financial services firms.

Exchanges and data originators are struggling to service the opportunities of the future with the products and solutions of the past. A paradigm shift is rapidly approaching as old monolithic systems designed for universal applicability are being replaced by new custom tailored micro and mobile apps designed to satisfy the needs of a specific knowledge worker or user type.

The emergence of new mobile technologies and use-specific applications is altering the usage patterns of market data and changing the ways market data is purchased and consumed. If an emerging exchange is to succeed, it must tackle these issues in new ways.

A few years from now the market data application mix will boil down to two distinct flavors: low latency and everything else. How will exchanges capture new market data revenue profitably and manage the delivery of these two distinct flavors when their target applications, usage patterns and infrastructure requirements are so dramatically different? Read more

The Developer Focus series profiles developers who have built applications using Xignite’s Cloud APIs, highlighting their experiences, observations, and advice.

John Morris is the lead developer and CTO for StockTouch, an innovative financial market data visualization app that is currently the #1 paid financial app in the iTunes Store (read more about StockTouch in our recent Customer Spotlight).

StockTouch’s groundbreaking data visualization interface has received widespread attention from the media and from Apple, who have selected StockTouch as one of the few apps to be loaded on all iPads and iPhones in their Apple Stores worldwide.  We recently sat down with John to learn more about him and the development process behind StockTouch.

Q: Tell us a little bit about your background?

John Morris – I’ve been programming since 1981, mostly as a contractor. My primary focus has been the gaming industry, mainly for two reasons. First, I love games! But perhaps more importantly, game development requires optimizing code at all levels in order to ensure good performance. It’s a challenge I enjoy taking on.

Q: How did you get involved with StockTouch?

John Morris – I learned about the StockTouch project through a mutual friend.  I joined the project initially as a consultant to build the prototype.  As everything came together, I was offered and accepted a position as the co-founder and CTO of StockTouch.

Q: How is the development process for StockTouch structured?

John Morris – The StockTouch team is completely virtual with the core members in New York, Seattle and Los Angeles. There are actually only two of us who are involved on the coding side of StockTouch. I work on the client side, and we have a contractor who works on the server side. We also work very closely with the other members of the team that deal with the overall user experience and feature set.

To build StockTouch, I was initially given just six screenshots, but we always had a pretty clear vision of what we wanted to do. We wanted the app to have a very intuitive interface with a fluid user experience. As a game developer, I personally wanted the application to offer a superior and unique visual experience, backed by extremely powerful features. StockTouch performs its rendering via OpenGL, and we really push the graphical capabilities of the iPad to deliver a cutting-edge experience.

Q: How difficult was the transition to the iOS platform?

John Morris – I’ve been building iOS products since 2008, so it wasn’t an issue for me.  For programmers unfamiliar with iOS, transitioning to the platform is not very easy—there’s a Read more

Our Customer Spotlight series showcases the innovative ways our clients are using Xignite’s Cloud APIs to power their applications.

Quantbench is a San Francisco-based start-up that combines a unique marketplace for non-traditional data sets, with a financial data analysis platform for financial analysts, academics and data scientists. This 100% cloud-based financial research platform provides its members with the data sets and tools necessary to conduct deep quantitative analysis.

Xignite sat down with Stefan Petry, Co-Founder and Chief Operating Officer, to learn more about Quantbench.

Q: Describe the Quantbench platform?

Stefan Petry – Quantbench combines a cloud-based platform for unstructured data exploration and analysis, with a marketplace where investment researchers and fund managers can purchase non-traditional data sets.

The platform includes data sets that we and others provide. Right now our members have access to more standard market data sets such as tick-by-tick and end-of-day stock data, and indices data. In time, we will be adding more and more non-traditional data sets that are sourced from areas like web search, online advertising, news, social media etc.  Users can perform analyses using R-Project and Amazon Elastic MapReduce. They can also purchase certain data sets in our marketplace for download and in-house processing.

Q: Describe the technology behind Quantbench and the advantages of Xignite Cloud APIs?

Stefan Petry – Perhaps the most innovative part of our approach is that we make it easy for our users to get up and running quickly. Everything that a financial analyst or data scientist needs to conduct quantitative analysis is instantly available. We are able to achieve this because the technology behind our community is 100% cloud-based. All of the analytical tools, data sets, and infrastructure are on the cloud. This approach also enabled us to launch very quickly, and will allow us to scale efficiently as our community grows.

We use Xignite’s market data cloud because Read more