Databases
StackOverflow2013
Postsdbo
POlooking for an intraday stock quote feed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POlooking for an intraday stock quote feed
    primarykey
    data
    text
    <p>I have an application which needs to get <strong>intraday</strong> stock quotes on several assets (indices, commodities etc').</p> <p>I want to be able to query the data in HTTP and get it as CSV/XML format.</p> <p>Now, I'd like to be able to ask the data provider for example what was the last bid/ask/price on GE (General Electric) at 4:00PM, and ask it in let's say 4:05PM on that day, for further processing.</p> <p><strong>Similar services to what I'm looking for</strong>:</p> <p>Reuter's DataLink service can give me this data on the last trade of the day.<br> I need it to flow through all day long - intraday.</p> <p><strong><a href="http://www.gummy-stuff.org/Yahoo-data.htm" rel="noreferrer">Yahoo Finance</a></strong> (the query formay within it) is a great service which does what I want in terms of data delivery yet I'm unsure regarding its reliability/timing since it's free.<br> Also, I couldn't find any information regarding the delay of the data they provide relatively from the real world timing (like many websites give this data in delay of ~20min).</p> <p><strong><a href="http://www.quoterss.com/quote.php?symbol=GOOG&amp;frmt=0&amp;Freq=1" rel="noreferrer">QuoteRSS</a></strong> gives this for free as well, it let's me pick a ticket and get its data, yet once again I'm unsure regarding its reliability, as well as its timing, which I have doubt if this is "realtime" or close to that.</p> <p>Finally this blog post by google "<a href="http://googleblog.blogspot.com/2008/06/at-long-last-real-time-stock-quotes-are.html" rel="noreferrer">At long last, real-time stock quotes are here</a>" claims to offer free data on certain stocks, but in <strong><a href="http://finance.google.com/finance" rel="noreferrer">Google Finance</a></strong>'s pages I can't find anything about it, nor at their API pages, and again, who knows what delay I get from the realtime data.</p> <p>In addition to the concern with the above mentioned services (Yahoo, QuoteRSS &amp; Google) I'm not sure how/if they provide an intraday information regarding the stocks, something which I need.</p> <p>Worth mentioning is that <strong>many websites which deal with Forex claim to be getting their data feed from Reuters/Bloomberg</strong>.<br> Didn't find such a solution on both's sites. I even went online with a sales rep. at Reuters to ask about it and his answer, after a decent discussion, was that "he's afraid he cannot offer me anything better than their service DataLink". <strong>How odd!!</strong></p> <p><strong>So to summarize my question</strong>;<br> <strong>1)</strong> Where do I get such data feed, in which I select several tickets from several markets, and get a closer-than-20min information regarding these tickets, in concise format (CSV/XML)?<br> <strong>2)</strong> If Reuters/Bloomberg offer it (I'll probably also call them later) - where is it being offered, at their websites? I'd like to get the data from a "big name" such as these guys, for reliability reasons.<br> <strong>3)</strong> Regarding "realtime" or not, it depends on the cost. What costs should I prepare to? I'm assuming that realtime feed costs a LOT, so, is there an option between realtime and the 20min delayed feed? Something like 2-5min delay?<br> <strong>4)</strong> Please mention how, or if, I can query for stocks' data in a timely manner, like "what was the price of GOOG at 4:00PM?".</p> <p><em>Note #1</em>:<br> Please keep in mind, when answering, that I need the quotes intraday and not "by the end of the day".</p> <p><em>Note #2</em>:<br> If google/yahoo do actually offer this kind of service for free, how do I find it? Directly. I don't mind starting with these "freewares" for testing and such, especially if I can query for data in a timely manner as mentioned above ("what was the price of GOOG at 4:00PM?").</p> <p><em>Note #3</em>:<br> In terms of licensing, I do not intend to resell this information. Simply as that.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPoni
    1. USPoni
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POlooking for an intraday stock quote feed
      1. US太極者無極而生
      1. VTFavorite
    2. VO
      singulars
      1. POlooking for an intraday stock quote feed
      1. USEugene Osovetsky
      1. VTFavorite
    3. VO
      singulars
      1. POlooking for an intraday stock quote feed
      1. This table or related slice is empty.
      1. VTDownMod
    1. CO@Poni this is a very interesting question, but too related to the financial realm to be addressed in a programmer's site with depth. There are a lot of usability restrictions practical, commercial, and legal to encourage a concise answer by any knowledgeable person.
      singulars
      1. POlooking for an intraday stock quote feed
      1. USDr. belisarius
    2. CO@belisarius in fact there's some truth in your words, this subject is very complicated. I'll add note #3. Thanks for pointing it out!
      singulars
      1. POlooking for an intraday stock quote feed
      1. USPoni
    3. COAlso, it does relate somehow to the SO's subject because it's like asking "what best IDE for Linux"... I mean, I treat the feed data as a tool to leverage another thing. And besides, the community here is so good, I just had to try my luck (:
      singulars
      1. POlooking for an intraday stock quote feed
      1. USPoni
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload