{"id":905,"date":"2014-12-03T06:33:06","date_gmt":"2014-12-03T11:33:06","guid":{"rendered":"http:\/\/www.amibroker.com\/kb\/?p=905"},"modified":"2014-12-06T06:39:32","modified_gmt":"2014-12-06T11:39:32","slug":"how-to-verify-if-eod-data-is-available-for-download-at-google-finance","status":"publish","type":"post","link":"https:\/\/www.amibroker.com\/wordpress\/kb\/2014\/12\/03\/how-to-verify-if-eod-data-is-available-for-download-at-google-finance\/","title":{"rendered":"How to verify if EOD data is available for download at Google Finance"},"content":{"rendered":"<p>AmiQuote downloader allows to get free quotes from a number of sources included Google Finance. AmiQuote works like a specialized web-browser, so the quotations can be downloaded if they are accessible at the website of that particular data-vendor. In case of Google Finance downloads, not every symbol that is present on their site is available for historical download. <\/p><p><strong>Google Finance page does NOT allow downloading historical data for non-US (international) symbols and some indices.<\/strong><\/p><p>If you have trouble downloading particular symbol (you are getting errors in AmiQuote), chances are that Google Finance does not allow downloading data for this symbol. To verify that we need to look for <strong>Download to spreadsheet<\/strong> link on Google Finance page as instructed below:<\/p><ol><li>Visit <a href=\"http:\/\/finance.google.com\/\" title=\"Google Finance\" target=\"_blank\">http:\/\/finance.google.com\/<\/a><li>Use <strong>Search <\/strong>field to find the symbol we need, e.g. MSFT<li>Go to <strong>Historical Prices<\/strong> section and look for <strong>Export: Download to spreadsheet<\/strong><\/ol><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2014\/12\/gf1.png\" alt=\"Historial Prices\" \/><\/p><p>If <strong>Export: Download to spreadsheet<\/strong> is present, it means that historical data are available for download. If the link is NOT present &#8211; it means no data for download. As you can see in the picture below, the link is present for US stocks like MSFT:<\/p><p><img src=\"\/\/www.amibroker.com\/kb\/wp-content\/uploads\/2014\/12\/gf2.png\" alt=\"Historial Prices\" \/><\/p><p>But <strong>Download to spreadsheet<\/strong> link is missing for SP500 and PLC (Traded on London Exchange) &#8211; as you can see using these two links:<br \/><a href=\"http:\/\/www.google.com\/finance\/historical?q=INDEXSP:.INX\" title=\"SP500\" target=\"_blank\">Historical Prices page for SP500 (no download link)<\/a><br \/><a href=\"http:\/\/www.google.com\/finance\/historical?q=LON%3ATSCO\" title=\"Tesco PLC\" target=\"_blank\">Historical Prices page for TESCO, PLC (no download link)<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>AmiQuote downloader allows to get free quotes from a number of sources included Google Finance. AmiQuote works like a specialized web-browser, so the quotations can be downloaded if they are accessible at the website of that particular data-vendor. In case of Google Finance downloads, not every symbol that is present on their site is available [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/905"}],"collection":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/comments?post=905"}],"version-history":[{"count":2,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/905\/revisions"}],"predecessor-version":[{"id":914,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/posts\/905\/revisions\/914"}],"wp:attachment":[{"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/media?parent=905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/categories?post=905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amibroker.com\/wordpress\/kb\/wp-json\/wp\/v2\/tags?post=905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}