views:

414

answers:

4

Hi there,

I'm looking for an Application Programming Interface which will allow me to access quotes and other data about multiple company symbols for at least the following stock exchanges:

American Stock Exchange (AMEX)
Australian Stock Exchange (ASX)
Bank of Canada
Bombay Stock Exchange (BOM) 
Canadian Venture Exchange (CVE) 
Euronext: Amsterdam (AMS)
Euronext: Brussels (EBR)
Euronext: Lisbon (ELI)  
Euronext: Paris (EPA)  
Frankfurt Stock Exchange
Hong Kong Stock Exchange (HKG)
London Stock Exchange (LON)
NASDAQ Stock Exchange (NASDAQ)
National Stock Exchange of India
New York Stock Exchange (NYSE)
New Zealand Stock Exchange (NZE)
Nikkei Indices
Shanghai Stock Exchange (SHA)
Shenzhen Stock Exchange (SHE)
Taiwan Stock Exchange (TPE)
Tokyo Stock Exchange (TYO)
Toronto Stock Exchange (TSE)

Both Google and Yahoo finance seem to limit themselves to the American and European market, they also delay data. Interactive Brokers offers an API (http://www.interactivebrokers.com/en/pagemap/pagemap_APISolutions.php), but they do not share any details and they do not allow you use the API without depositing 10.000 USD and a few hundred a month. This is too expensive just to give it a try.

So, I'm wondering, are there any APIs out there that do fit my needs?

Thanks in advance.

+1  A: 

If USD 10K is too expensive then other alternatives such as Bloomberg and Reuters (Thomson) will also be prohibitive.

If the intention at this juncture is simply to 'give it a try' could you not start with a source like http://googleblog.blogspot.com/2007/01/real-time-quotes-for-free.html as a testing ground.

It's also a question of what your intention is: is this a trading platform for your self or client, or are you developing an application to sell (you'll be up against some well entrenched competition with deep-pockets).

All the best

Marcus from London
Hi Marcus. Unfortunately the google API only returns companies from your portefolio. It seems what I'm looking for is only there for those with a lot of money on their hands.
Tom
+1  A: 

If you are just looking for top of book quotes then try using IQFeed. It is quite a bit clunkier than say thomson but it seems to work ok. I have not had many data quality issues with them over the past year that I have been using them. You can also get some fundamental data from them although it is much more limited than thomson. Still depending on what you are using the data for it may work.

Steve
A: 

You should have a look at the web services provided by Xignite. They have a global quotes service that has many of the exchanges (although perhaps not all) you have asked for.

The advantages of using Xignite:

  1. Their services are fully documented on their website without any additional sign up.

  2. They support REST and SOAP, and for the latter they expose their WSDL so you should be able to easily build a client stub using your preferred web service toolkit.

  3. Their pricing is relatively cheaper than the IB feed you mentioned and you can sign up for a trial to test against real data (although you could also dump the WSDL into a tool like eviWare's soapUI to act as a mock for their web services). However, as commenters have mentioned any decent, quality, reliable financial data is not going to be 'cheap' in the absolute sense.

Of course, this is an pull service compared to the streaming push services provided by Thomson Reuters, Bloomberg, ACTIV Financial, etc so there are definitely types of financial apps (high-frequency trading systems, etc) that this sort of data feed is not appropriate for.

James Webster
Howmuch delay would the difference between a push and pull service cause? And does Xignite offer all companies in stock markets listed above?
Tom
If you are worried about data latency you are looking for feeds in the wrong price range.
Steve
My bad, I was living in an imaginary world where economists realized the importance of a transparent market. I learned a lot though. ;)
Tom
+4  A: 

Well, there are Thomson-Reuters and Bloomberg very very expensive, but comprehensive global coverage, both real-time data and fundamental stuff. Morningstar acquired real-time data provider tenfore recently. They are almost as comprehensive as the previous two, but slightly more afforable. All three have real-time "solutions" (these big words is what you pay for) that provide a nice (or at least workable) API. I have used them all, and they all have their issues and niceties. In my experience, if you can convince one of their salespeople of your potential as a customer you can generally get a trial for a month or so. Ask to get the API documentation before the trial starts so you can hit the ground running and by the end of the month you will be able to determine if the high price is worth it.

In general though, real-time data is bloody expensive, and the fee you pay to the data provider is generally just the start. These days quite a few exchanges also require direct payment from parties receiving real-time data. $10.000 + $500/month is a very good deal, but spend some time reading the contract and note that using their API will probably lock you into their brokerage services. After giving you the cheap data, they might decide to get their profits elsewhere.

UPDATE: I was just looking at the IB link you provide, and I see a 50 quotes/second limit note that -for example- just AAPL generates about 100,000 quotes during the 16 hours of main market activity. 2/second on average (peak periods, around regular open/close of market often have 10 times the average message rate or more). You'll regularly be hitting that 50 quote/second limit the moment you become interested in more than a few dozen stocks. This NANEX article about the may-6 flash crash has some interesting info about the volumes involved in the HFT field. Also, their NxCore product might interest you.

jilles de wit
Thanks a lot. It's a shame SO doesn't have a PM feature, would have liked to have a chat with you. :)
Tom
feel free to e-mail me, or if you need more info I can update my answer some more.
jilles de wit