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)

Looking forward, Xignite has plans to put the vast

majority its data onto the Azure DataMarket. "We have

started with our most popular data sets, but will continue to add

data until the market is satisfied with what Xignite is

offering" said Chas Cooper, VP of Product management at

Xignite.

Microsoft brings a very horizontal

market to Xignite, with DataMarket providing broad coverage

across different verticals. When Microsoft looked for companies

to work with on Data Market, two things attracted Microsoft to

Xignite; 1) the fact that Xignite understands how to deliver

on-demand market data and financial web services" and

2) out of all the financial data providers evaluated for Azure

Datamarket, Xignite has the most reasonable, rational terms of

use across its data sets. Xignite also uses standards such as

SOAP, REST & JSON to make integrate with Xignite's web

services simple and straight forward.

Developers should visit href="http://datamarket.azure.com">http://datamarket.azure.com,

where they can type Xignite into the search bar there and see all

of the services available. More information is available at href="http://xignite.web-services-blog.com/www.xignite.com">www.xignite.com.

Share and Enjoy:

href="mailto:?subject=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20&body=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F"

title="email"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/email_link.png"

title="email" alt="email" class="sociable-hovers" />

href="http://twitter.com/home?status=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20%20-%20http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F"

title="Twitter"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/twitter.png"

title="Twitter" alt="Twitter" class="sociable-hovers"

/>

href="http://www.facebook.com/share.php?u=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&t=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20"

title="Facebook"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/facebook.png"

title="Facebook" alt="Facebook" class="sociable-hovers"

/>

href="http://www.linkedin.com/shareArticle?mini=true&url=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20&source=Financial+Market+Data+Web+Services+-+Xignite+Blog+It%26%23039%3Bs+not+the+data.++It%26%23039%3Bs+the+delivery.&summary=With%20the%20recent%20addition%20of%20Xignite%20Financial%20Market%20Data%20to%20the%20Microsoft%20Azure%20Marketplace%20Datamarket%2C%20users%20can%20now%20pull%20live%20stock%20quotes%20directly%20into%20Microsoft%20Excel%202010%2C%20develop%20data%20rich%20applications%20using%20Visual%20Studio%202010%20and%20seamlessly%20populate%20backend%20database%20with%20SQL%20Server%202010.%20%20Wes%20Yanaga%20with%20Microsoft%27s%20Channel%209%20sat%20down%20with%20Shoshanna%20Budzianowski%20%28SQL%20Azure%29%20and%20Chas%20Cooper%20%28Xignite%29%20to%20get%20the%20low%20down%20on%20what%20this%20partnership%20is%20all%20about%2C%20and%20how%20it%20will%20benefit%20end%20user%20around%20the%20globe.%0D%0A"

title="LinkedIn"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/linkedin.png"

title="LinkedIn" alt="LinkedIn" class="sociable-hovers"

/>

href="http://digg.com/submit?phase=2&url=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20&bodytext=With%20the%20recent%20addition%20of%20Xignite%20Financial%20Market%20Data%20to%20the%20Microsoft%20Azure%20Marketplace%20Datamarket%2C%20users%20can%20now%20pull%20live%20stock%20quotes%20directly%20into%20Microsoft%20Excel%202010%2C%20develop%20data%20rich%20applications%20using%20Visual%20Studio%202010%20and%20seamlessly%20populate%20backend%20database%20with%20SQL%20Server%202010.%20%20Wes%20Yanaga%20with%20Microsoft%27s%20Channel%209%20sat%20down%20with%20Shoshanna%20Budzianowski%20%28SQL%20Azure%29%20and%20Chas%20Cooper%20%28Xignite%29%20to%20get%20the%20low%20down%20on%20what%20this%20partnership%20is%20all%20about%2C%20and%20how%20it%20will%20benefit%20end%20user%20around%20the%20globe.%0D%0A"

title="Digg"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/digg.png"

title="Digg" alt="Digg" class="sociable-hovers" />

href="http://www.stumbleupon.com/submit?url=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20"

title="StumbleUpon"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/stumbleupon.png"

title="StumbleUpon" alt="StumbleUpon" class="sociable-hovers"

/>

href="http://technorati.com/faves?add=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F"

title="Technorati"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/technorati.png"

title="Technorati" alt="Technorati" class="sociable-hovers"

/>

href="http://twitter.com/home/?status=tip%20@Techmeme%20http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F%20Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20"

title="Suggest to Techmeme via Twitter"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/techmeme.png"

title="Suggest to Techmeme via Twitter" alt="Suggest to Techmeme

via Twitter" class="sociable-hovers" /> rel="nofollow" target="_blank"

href="http://delicious.com/post?url=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20&notes=With%20the%20recent%20addition%20of%20Xignite%20Financial%20Market%20Data%20to%20the%20Microsoft%20Azure%20Marketplace%20Datamarket%2C%20users%20can%20now%20pull%20live%20stock%20quotes%20directly%20into%20Microsoft%20Excel%202010%2C%20develop%20data%20rich%20applications%20using%20Visual%20Studio%202010%20and%20seamlessly%20populate%20backend%20database%20with%20SQL%20Server%202010.%20%20Wes%20Yanaga%20with%20Microsoft%27s%20Channel%209%20sat%20down%20with%20Shoshanna%20Budzianowski%20%28SQL%20Azure%29%20and%20Chas%20Cooper%20%28Xignite%29%20to%20get%20the%20low%20down%20on%20what%20this%20partnership%20is%20all%20about%2C%20and%20how%20it%20will%20benefit%20end%20user%20around%20the%20globe.%0D%0A"

title="del.icio.us"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/delicious.png"

title="del.icio.us" alt="del.icio.us" class="sociable-hovers"

/>

href="http://www.google.com/bookmarks/mark?op=edit&bkmk=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20&annotation=With%20the%20recent%20addition%20of%20Xignite%20Financial%20Market%20Data%20to%20the%20Microsoft%20Azure%20Marketplace%20Datamarket%2C%20users%20can%20now%20pull%20live%20stock%20quotes%20directly%20into%20Microsoft%20Excel%202010%2C%20develop%20data%20rich%20applications%20using%20Visual%20Studio%202010%20and%20seamlessly%20populate%20backend%20database%20with%20SQL%20Server%202010.%20%20Wes%20Yanaga%20with%20Microsoft%27s%20Channel%209%20sat%20down%20with%20Shoshanna%20Budzianowski%20%28SQL%20Azure%29%20and%20Chas%20Cooper%20%28Xignite%29%20to%20get%20the%20low%20down%20on%20what%20this%20partnership%20is%20all%20about%2C%20and%20how%20it%20will%20benefit%20end%20user%20around%20the%20globe.%0D%0A"

title="Google Bookmarks"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/googlebookmark.png"

title="Google Bookmarks" alt="Google Bookmarks"

class="sociable-hovers" />

target="_blank"

href="https://favorites.live.com/quickadd.aspx?marklet=1&url=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F&title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20"

title="Live"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/live.png"

title="Live" alt="Live" class="sociable-hovers" />

href="http://www.friendfeed.com/share?title=Microsoft%20Now%20Offers%20Real-Time%20Stock%20Data%20in%20Excel%2C%20Visual%20Studio%20and%20SQL%20Server%20%28Powered%20by%20Xignite%29%20&link=http%3A%2F%2Fxignite.web-services-blog.com%2F2011%2F08%2Fmicrosoft-now-offers-real-time-stock-data-in-excel-visual-studio-and-sql-server-powered-by-xignite%2F"

title="FriendFeed"> src="http://xignite.web-services-blog.com/wp-content/plugins/sociable/images/friendfeed.png"

title="FriendFeed" alt="FriendFeed" class="sociable-hovers"

/>