Financial Market Data Web Services – Xignite Blog

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

Like many of us, you may have run into challenges when importing real-time market data in Excel, Visual Studio & SQL Server. With the recent addition of Xignite Financial Market Data to the Microsoft Azure Marketplace Datamarket, users can now pull live stock quotes directly into Microsoft Excel 2010, develop data rich applications using Visual Studio 2010 and seamlessly populate backend database with SQL Server 2010.

In late 2010, Xignite and Microsoft teamed up to make XigniteBATSLastSale, a real-time stock quote data service, available through the Azure Marketplace Datamarket, with the addition of other datasets scheduled to rollout in the months ahead. With this, Microsoft users can obtain instant online access to real-time stock quotes from the BATS Exchange. Now everyone from hardcore mobile app developers to garage based startups can obtain access to the same professional grade APIs to power their applications.

New to Xignite is the addition of OData, or Open Data Protocol, a method of querying and updating data which unlocks the data from the silos that exist in legacy applications. Today, OData is being used to expose and access information from a variety of sources including, but not limited to, relational databases, file systems, content management systems and traditional Web sites.

Wes Yanaga with Microsoft’s Channel 9 sat down with Shoshanna Budzianowski (SQL Azure) and Chas Cooper (Xignite) to get the low down on what this partnership is all about, and how it will benefit end user around the globe.

After the Channel 9 video was completed, Shoshanna Budzianowski sat down with Marc Bollinger, Web Service Engineer at Xignite, for some one-on-one developer talk and a bit of programming fun (CLICK MORE to see developer video)

Read more

Henry Ford once said: “Any customer can have a car painted any color that he wants, so long as it is black.” Then, in 1923 Alfred Sloan came along and cleaned his clock by offering a tremendous variety in colors and models. But, Sloan didn’t do it one customer at a time. GM redesigned its manufacturing line with the flexibility to produce a multitude of models and colors without compromising the inherent economies-of-scale of Ford’s assembly line innovation—a practice that today has evolved into the concepts of flexible manufacturing and mass customization.

What does any of this have to do with cloud computing? And for that matter, what does it have to do with financial market data? This is the third post in a series called “Thinking Out Cloud” with the aim of helping financial services and market data IT professionals charged with developing cloud computing strategies separate the cloud buzz from the cloud reality. This post explores the important idea of mass customization in the cloud and its relevance to market data management.

Mass Customization and Market Data

According to Wikipedia, mass customization is about providing “services to meet individual customer’s needs with near mass production efficiency” by offering a “tremendous increase in variety and customization without a corresponding increase in costs.” Or rather, have it your way at a cost you can afford. In the last installment in this series entitled Thinking Out Cloud – The Market Data Sweet Spot, I pointed out that the best way to identify market data that can benefit from cloud computing is to look for data that is hard-to-use, hard-to-manage, and hard-to-access. Mass customization on the cloud strikes at the core of the “hard-to-use” problem by replacing inflexible data feeds and files in static formats with financial Web services that allow applications to select and consume highly customized market data sets on the fly.

Mass Customization, Meta Data and Web Services

In software, mass customization is achieved by converting hard-coded application functions into meta-data, so that the functional behavior of the software can be controlled through data on an ad-hoc basis. For example, the only real difference between this Xignite WordPress blog and a million other WordPress blogs comes down to a few theme files and the store of data that comprises the brilliant blog posts within. The posts in turn get shuffled around the Internet using RSS (really simple syndication). The RSS standard lies at the heart of the Web 2.0 revolution, powering the distribution of widely varied content such as blogs, news, friends, tweets, music, video, etc., all because a few abstract meta-data elements like “title”, “description”, and “link” can be generalized to contain an enormous and disparate variety of data. Swapping out this data can literally change one blog to any other blog (or one friend to any other friend!).

In cloud computing, meta-data abstraction is realized through Web services (like RSS). Web services take the concept of configurability through meta-data abstraction to its natural limit, because every operation of a Web service is inherently abstracted to meta-data in the XML inputs and outputs of the API. For example, the Xignite delayed stock quote Web service allows applications to retrieve a single quote for a single symbol, multiple quotes for multiple symbols, intraday tick-by-tick prices, market volume and news, simply by varying the Web service operation and the input parameters, i.e., the meta data. Providing access to such a wide variety of information in an ad-hoc fashion from a statically formatted feed or file is simply not possible without lots of hardware, software and custom development–most likely to create a Web service.

Wrap it Up, I’ll Take It!

More plainly, market data Web services are built for mass customization, because they cleanly wrap the underlying market data and data management infrastructure in meta-data enabling highly customized output based on variable input. Therefore, applications that require highly varied, ad-hoc market data subsets will be better served by Web services over the static formats of data feeds and files. Or, as we like to say at Xignite: “There’s an op[eration] for that!”

If you look at our new corporate bond master service, XigniteBondMaster, you’ll quickly see that you can use it to get information for over 125,000 U.S. corporate bonds, including issuer information, maturity dates, coupon rates and so on.  But you’re not likely to see one of the best features of the service until you roll up your sleeves and start digging around in the data:  the ability to look up official CUSIP identifiers with remarkable ease.

CUSIP identifiers are highly valued throughout the industry as the de facto standard for uniquely identifying over 9.1 million financial instruments.  And now you can easily look up CUSIPs for thousands of corporate bonds using XigniteBondMaster.  Interested in a particular issue, but not sure what its CUSIP is?  Try looking it up by the bond issuer!  Or just look it up by bond name.

All CUSIP data comes from CUSIP Global Services, an organization managed by Standard & Poor’s on behalf of the American Bankers Association specifically to oversee the official set of CUSIP identifiers.

You do need to have an agreement in place with CUSIP Global Services in order to receive CUSIP data, since this is highly valued data that must be licensed first.  But once you have an agreement in place, CUSIPs will automatically start appearing in your XigniteBondMaster outputs.

In the next 5 minutes, you could get $5 worth of plumbing services, $30 worth of legal advice or $17 worth of psychotherapy. Or, you could just spend your next five minutes building a real-time stock quote widget. Don’t think it can be done in 5 minutes? Check out a video showing us doing it in less time.

Here’s how you can do the same thing using PHP and Eclipse, although the same basic process can be used for any language and any IDE:
Read more

Every five minutes, a business in the U.S. catches fire, someone in the UK swears, and a clock that took 5 years and £1 million to build before being unveiled by none other than Stephen Hawking, finally tells the time accurately for a second or two.

What will you do with your next 5 minutes?

Here’s a thought: Why not build a real-time forex currency converter? Sound like fun? If so, give it a try using the steps below. Or, if you’d rather leave all the fun to someone else, why not just watch a video of us doing it?

Here’s how it’s done: Read more

A few years back, if you asked your IT professionals about Cloud Computing, you probably would have received a blank stare, followed up with an “I love my servers” comment. At that time, even the term “Cloud Computing” was plagued by confusion, uncertainty and a fair amount of misinformation. Early misconceptions were further reinforced by the many ‘cloud flavors’ being lumped into one term, SaaS, PaaS, utility computing, virtualized computing, managed services, resource computing, elastic computing and so on. Many concluded that Cloud Computing was more a buzzword than a definable technology.

Today, that is no longer the case, with an overwhelming consensus affirming that the winds of change are blowing in the clouds favor. The desire to move into the clouds is quickly turning into a necessity, with a wide range of internal and external forces leading the charge. Redundancy, efficiency, availability, simplicity, stability or plain & simple economics, every entity has its own unique set of reasons for moving into the clouds. With its inherent time and cost benefits, It’s no surprise that there is a growing wave of support for Cloud Computing, with some of that support coming from some unlikely places. Read more