Financial Market Data Web Services – Xignite Blog

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

XigniteMoneyMarketsDemand for real-time interest rate information has never been stronger. We recently launched XigniteMoneyMarkets as a comprehensive source of real-time US Treasury and real-time global swap rate information for more than 24 currencies. For a demo of all available rates, check here.

Web Service EnhancementsWe constantly enhance existing services by adding new operations or data sets to existing services. Here is a quick rundown of some enhancements for the last few months:

• Addition of real-time Currency Forward Rates to XigniteCurrencies.
• Addition of historical cross bid-ask information to XigniteCurrencies.
• Addition of real-time and historical currency converters to XigniteCurrencies.
• Addition of currency reports to XigniteCurrencies.
• Addition of Canadian NewsWire (CNW) to XigniteReleases.
• Addition of new data points to XigniteFundamentals including StateOfIncorporation, TotalDebt, TotalCash, TotalAssets, TotalLiabilities, NetIncome, TotalRevenue, TotalExpenses, TotalOperatingExpenses, OperatingIncome, StateOfIncorporation, SECName, LastAnnualReport, LastQuarterly, LastProxyStatement, IRSNumber,

Don’t hesitate to contact us if youn eed new operations or new data to increase the value you get from our web services. We pride ourselves in being able to respond to our clients quickly and effectively.