{"id":1092,"date":"2007-09-23T12:22:03","date_gmt":"2007-09-23T12:22:03","guid":{"rendered":"http:\/\/www.amibroker.org\/userkb\/2007\/09\/17\/yahoos-data-providers\/"},"modified":"2007-10-06T07:11:59","modified_gmt":"2007-10-06T07:11:59","slug":"yahoos-data-providers","status":"publish","type":"post","link":"http:\/\/www.amibroker.org\/editable_userkb\/2007\/09\/23\/yahoos-data-providers\/","title":{"rendered":"Yahoo&#8217;s Data Providers (v2)"},"content":{"rendered":"<p>Yahoo sources data from a&nbsp;number of providers who are&nbsp;acknowledged at the bottom of the Y!Finance page: <a title=\"http:\/\/finance.yahoo.com\/\" href=\"http:\/\/finance.yahoo.com\/\">http:\/\/finance.yahoo.com\/<\/a>&nbsp;<\/p>\n<p><img loading=\"lazy\" height=\"232\" alt=\"Yahoo001\" src=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/09\/yahoo001.png\" width=\"770\" border=\"0\"><\/p>\n<p>The partner page link in that section opens&nbsp;a&nbsp;list of&nbsp;delayed intra-day data suppliers: <a title=\"http:\/\/finance.yahoo.com\/exchanges\" href=\"http:\/\/finance.yahoo.com\/exchanges\">http:\/\/finance.yahoo.com\/exchanges<\/a><\/p>\n<p>As well as that, other providers are acknowledged in other places e.g. the S&amp;P500 index is provided by <em>Comstock<\/em> and industry information, &#8220;on 7500 publicly traded U.S. companies&#8221;, is from <em>Hemscott Americas<\/em> etc.<\/p>\n<p>The obvious point is that there are, at the least, two historical&nbsp;quotes databases, a fundamental database&nbsp;and several delayed intra-day data streams used, in different ways and in different places, at the site and there is no relationship between them in anyway. Some pages are a compendium, sourced from different providers, and it is difficult to be certain, in some cases, what is coming from where.<\/p>\n<p>The main points to be aware of:<\/p>\n<ul>\n<li>1) The intra-day quotes, for listings on the major US exchanges, come directly from the exchanges.\n<li>2) Intra-day quotes, for non-U.S.&nbsp;listings,&nbsp;are&nbsp;supplied by third party providers e.g. <em>Comstock<\/em> and <em>Telekurs<\/em>.\n<li>3) Fundamental data, for American exchange listings, is supplied by <em>Capital IQ<\/em>, a division of <em>Standard and Poor&#8217;s<\/em>. <\/li>\n<\/ul>\n<p>Note:&nbsp;The&nbsp;<em>Capital IQ<\/em>&nbsp; database&nbsp;is the logical choice as the underlying database for two stock screeners, although this is not confirmed at the site:<\/p>\n<p><em>Java<\/em> screener &#8211; <a title=\"http:\/\/screener.finance.yahoo.com\/newscreener.html\" href=\"http:\/\/screener.finance.yahoo.com\/newscreener.html\">http:\/\/screener.finance.yahoo.com\/newscreener.html<\/a>&nbsp;&nbsp;<\/p>\n<p>HTML screener &#8211;&nbsp; <a title=\"http:\/\/screener.finance.yahoo.com\/stocks.html\" href=\"http:\/\/screener.finance.yahoo.com\/stocks.html\">http:\/\/screener.finance.yahoo.com\/stocks.html<\/a>&nbsp;<\/p>\n<p>At the time of writing the HTML database&nbsp;contains 8467 listings, but sadly only allows users to view screened lists 20 at a time, while the newer <em>Java<\/em> screener, which has superior exporting abilities, only references <em>NYSE,<\/em> <em>Nasdaq<\/em> and <em>Amex<\/em> stock i.e. 4370 listings.<\/p>\n<p><em>Bulletin Board<\/em> (.OB) listings are included in the HTML screener database but <em>Pink Sheets<\/em> symbols (.PK) are not (to obtain all listings for the databases run a filter using price &gt;= 0 as the criteria).<\/p>\n<ul>\n<li>4) Historical data, for the U.S. markets, is supplied by <em>Commodity Service Inc<\/em> (CSI)&nbsp;and is updated after hours (in a trial conducted by the author the update was logged at 8 PM EST (USA) i.e. four hours after the close).\n<li>5) Historical and delayed intra-day data for the non-U.S. markets is supplied by <em>Hemscott&nbsp;Americas<\/em> (historical data is updated after hours).<\/li>\n<\/ul>\n<p>Note: International listings require a suffix to identify the exchange.<\/p>\n<p>For a list of suffixes for each exchange refer to:&nbsp;<a title=\"http:\/\/finance.yahoo.com\/exchanges\" href=\"http:\/\/finance.yahoo.com\/exchanges\">http:\/\/finance.yahoo.com\/exchanges<\/a><\/p>\n<ul>\n<li>6) The stock listings in the&nbsp;CSI (historical)&nbsp;database are not the same as for the&nbsp;<em>Capital IQ<\/em>&nbsp;(fundamental) database, or&nbsp;any other database for that matter.&nbsp;\n<li>7) Only one of the &#8216;databases&#8217; has a downloadable index, albeit a limited download, while access to other resources at the site is on a symbol by symbol basis.<\/li>\n<\/ul>\n<p>There is, however,&nbsp;the &#8216;mother of all indexes&#8217; at: <a title=\"http:\/\/biz.yahoo.com\/i\/\" href=\"http:\/\/biz.yahoo.com\/i\/\">http:\/\/biz.yahoo.com\/i\/<\/a>&nbsp;(it seems likely that this index is provided by CSI, based on it&#8217;s size and content e.g. it is mainly comprised of US and Canadian listings and the number of constituents also approximates the CSI universe.<\/p>\n<p>The patchwork nature of&nbsp;the site&nbsp;sometimes produces surprising outcomes.&nbsp;<\/p>\n<p>One example:<\/p>\n<p>Japanese financial services company Acom Co Ltd is an ADR traded on the OTC market. It is not a constituent of the&nbsp;HTML screened&nbsp;list, and it does not have a &#8216;Yahoo&#8217; chart.&nbsp;A search for the company by name,&nbsp;using Symbol Lookup, sometimes returns a result &#8230;&#8230;.&nbsp;<\/p>\n<p><img alt=\"Yahoo002\" src=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/09\/yahoo0021.png\" border=\"0\"><\/p>\n<p>&#8230;&#8230;&#8230;.and&nbsp;at other times it doesn&#8217;t (pity about that).<\/p>\n<p><img alt=\"Yahoo004\" src=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/09\/yahoo004.png\" border=\"0\"><\/p>\n<p>&nbsp;In spite of all that&nbsp;it does have&nbsp;quotation and historical&nbsp;data at the Yahoo site.<\/p>\n<p>Note:&nbsp; To go to&nbsp;Yahoo!Finance site and enter <strong>ACMUY.PK<\/strong> in the <strong>Enter Symbol(s)<\/strong> input box and click on <strong>GET QUOTES<\/strong> at any <em>Y!Finance<\/em> page.<\/p>\n<p><img alt=\"Yahoo002\" src=\"http:\/\/www.amibroker.org\/userkb\/wp-content\/uploads\/2007\/09\/yahoo002.png\" border=\"0\"><\/p>\n<p>Clicking on the <strong>Historical Prices<\/strong> link, in the <em>Quotes<\/em> section of the left hand side bar, will open approximately&nbsp;two years of data for this symbol. (Yes &#8211; Amiquote will download the data).<\/p>\n<p>This is a result that is typical for OTC ADR&#8217;s.<\/p>\n<p>All in all a mixed bag from Yahoo!Finance.<\/p>\n<ul>\n<li><sub><em>Version 1 &#8211; Sept21\/2007<\/em><\/sub>\n<li><em><sub>Version 2 &#8211; Sept23\/2007 &#8211; Corrected minor errors and added links.<\/sub><\/em><\/li>\n<\/ul>\n<p><sub><em>Written using Windows XPHome and Internet Explorer v7.<\/em><\/sub><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yahoo sources data from a&nbsp;number of providers who are&nbsp;acknowledged at the bottom of the Y!Finance page: http:\/\/finance.yahoo.com\/&nbsp; The partner page link in that section opens&nbsp;a&nbsp;list of&nbsp;delayed intra-day data suppliers: http:\/\/finance.yahoo.com\/exchanges As well as that, other providers are acknowledged in other places e.g. the S&amp;P500 index is provided by Comstock and industry information, &#8220;on 7500 publicly [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[89],"tags":[],"_links":{"self":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1092"}],"collection":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/comments?post=1092"}],"version-history":[{"count":0,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/posts\/1092\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/media?parent=1092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/categories?post=1092"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.amibroker.org\/editable_userkb\/wp-json\/wp\/v2\/tags?post=1092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}