{"id":731,"date":"2022-10-11T08:59:12","date_gmt":"2022-10-11T08:59:12","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=731"},"modified":"2024-03-14T08:03:33","modified_gmt":"2024-03-14T08:03:33","slug":"get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in","title":{"rendered":"Get Historical, Intraday &#038; Fundamental data with EODHD Google Sheets Add-In"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"entry-content-asset\"><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"980\" height=\"552\" src=\"https:\/\/www.youtube.com\/embed\/pMs6FFG-gKY?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/div>\n<\/div><\/figure>\n\n\n\n<p class=\"bordered_paragraph\">If you want to learn how to install the <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/google_sheets_financial_addin\/258473626842\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD Google Sheets Add-In<\/a> and activate your API key, I recommend to start with exploring of our <a href=\"https:\/\/eodhistoricaldata.com\/financial-apis\/google-sheets-financial-add-in-for-eod-fundamentals-data\/\">Documentation for it<\/a>.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><a class=\"maxbutton-1 maxbutton maxbutton-subscribe-to-api external-css btn\" href=\"https:\/\/eodhd.com\/register\"><span class='mb-text'>Register &amp; Get Data<\/span><\/a><\/p>\n\n\n\n<p>In this video Matt shows you how to automatically download Stock Price Data and other Financial information into a Google Sheet with the <strong>EODHD Google Sheets Add-In<\/strong>.<br>Without any complicated code, you can easily get:<br>\u2022 Fundamental data for Stocks, ETF or Funds<br>\u2022 End-of-day historical data<br>\u2022 Intraday data<br>straight into a Google Sheets, where you can perform any Financial Analysis you want to do.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=13\" target=\"_blank\" rel=\"noreferrer noopener\">00:13<\/a> \u2014 Quick start<\/strong> <br>To get started you&#8217;ll need to:<br> \u2022 Log into your Google Sheets<br> \u2022 Start a blank worksheet<br> \u2022 Prepare to install the add-in<\/p>\n\n\n\n<p><strong><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=54\" target=\"_blank\" rel=\"noreferrer noopener\">00:54<\/a> <\/strong>\u2014 Installation<\/strong><br>To begin the installation, you&#8217;ll need to do next steps:<br> \u2022 Follow the link to &#8220;<a href=\"https:\/\/workspace.google.com\/marketplace\/app\/google_sheets_financial_addin\/258473626842\" target=\"_blank\" rel=\"noreferrer noopener\">Install our Google Add-in<\/a>&#8220;<br> \u2022 Or, go to the <strong>Extensions<\/strong> in your Google Sheet<br> \u2022 Next, <strong>Add-ons<\/strong> and then <strong>Get add-ons<\/strong><br> \u2022 Search for EOD, you&#8217;ll need to choose EODHD APIs and install it<br> \u2022 Once you&#8217;ll done it just close the installation window<br> \u2022 You&#8217;ll see the icon <strong>Google Sheets Financial add-in<\/strong> on the right menu<br> \u2022 If you don&#8217;t, then just start a new sheet and it should show up<br> \u2022 Just click on it and you are ready to activate the Add-in<br> \u2022 Next what you&#8217;ll need is to <a href=\"https:\/\/eodhistoricaldata.com\/register\" target=\"_blank\" rel=\"noreferrer noopener\">Register an Account here<\/a><br> \u2022 Or if you already have an account <a href=\"https:\/\/eodhistoricaldata.com\/login\" target=\"_blank\" rel=\"noreferrer noopener\">Log In<\/a>, to get your API Key and insert it into the Add-in&#8217;s menu<br> \u2022 Once you&#8217;ll done that, just click the Get Data button<\/p>\n\n\n\n<p class=\"has-text-align-center\"><a class=\"maxbutton-1 maxbutton maxbutton-subscribe-to-api external-css btn\" href=\"https:\/\/eodhd.com\/register\"><span class='mb-text'>Register &amp; Get Data<\/span><\/a><\/p>\n\n\n\n<p><br><img decoding=\"async\" class=\"wp-image-799\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif\" alt=\"EODHD-Google-Sheets-Add-In-Installation\"><\/p>\n\n\n\n<p class=\"bordered_paragraph\">There&#8217;s another option, where you can upgrade your Data Package. I&#8217;m just assuming that you&#8217;re using the free package and if that doesn&#8217;t eventually meet your needs, then you can upgrade to one of <a href=\"https:\/\/eodhistoricaldata.com\/pricing\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD APIs paid data feeds<\/a>.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/www.youtube.com\/watch?v=2GtSM9vU0pM&amp;list=PLo41eTPq_j3rwDZmMNskgfRcWnT2KTZkP&amp;index=1&amp;t=58s\" target=\"_blank\" rel=\"noreferrer noopener\">00:58<\/a> \u2014 Get the Financial Data Options<\/strong><br>Click on <strong>Get Data<\/strong> <strong>button<\/strong> and you&#8217;ll see the set of options with is the different Data Feeds that are available to us:<br> \u2022 End-of-Day Historical Data<br> \u2022 Intraday Historical Data<br> \u2022 Fundamental Data<br> \u2022 Bulk Fundamental Data<br> \u2022 ETF Data<br> \u2022 Options Data<br> \u2022 Stock Market Screener<br><img decoding=\"async\" class=\"wp-image-804\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Financial-Data-Options.gif\" alt=\"EODHD Google Sheets Add-In Financial Data Options\"><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=146\" target=\"_blank\" rel=\"noreferrer noopener\">02:26<\/a> \u2014<\/strong> <strong>Get End-of-Day Historical Data<\/strong><br>To start off doing something simple and we&#8217;ll get some End-of-Day price data, I&#8217;ll get it for <a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/AAPL.US\" target=\"_blank\" rel=\"noreferrer noopener\">Apple Inc (AAPL.US)<\/a>. I can just sort of decide how far back in history I want to go the data feed, it goes back to 1985.<br>If you don&#8217;t want daily, you can choose weekly or monthly data by changing one of these options.<br>Once that&#8217;s done, if you want, we can get a chart. But the Google Charts aren&#8217;t all that exciting, so I&#8217;ll get it just so we can see what it looks like and I click Get.<br><img decoding=\"async\" class=\"wp-image-807\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Get-End-of-Day-Historical-Data.gif\" alt=\"EODHD APIs Get End-of-Day Historical Data\"><br>It creates a new sheet and, yep we get the data just that quickly and there&#8217;s that like I said sort of unexciting chart which you could play around with it to adjust the the y-axis here so that at least the we don&#8217;t have all this white space.<br>All right but I&#8217;m just going to leave it at that obviously right we could start adding whatever data transformations we wanted here as columns in this spreadsheet.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=202\" target=\"_blank\" rel=\"noreferrer noopener\">03:22<\/a> \u2014<\/strong> <strong>Get Intraday Historical Data<\/strong><br>In case if you&#8217;ve closed the navigation bar while doing previous steps, just click again on the sidebar icon. Now you are able to obtain the daily data, if you want, you can get it down to one-minute increments with the free account, it&#8217;s going to be a day-delayed. You&#8217;ll get yesterday&#8217;s intraday trading prices were it works the same way as the daily data does, so I&#8217;m not going to demonstrate that.<br><img decoding=\"async\" class=\"wp-image-810\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Get-Intraday-Historical-Data.gif\" alt=\"EODHD APIs Get Intraday Historical Data\"><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=228\" target=\"_blank\" rel=\"noreferrer noopener\">03:48<\/a> \u2014 Get Stocks Fundamental Data<\/strong><br>We might as well take a quick look at Fundamental Data though so you can see what&#8217;s available there. I&#8217;m going to just stick with <a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/AAPL.US\" target=\"_blank\" rel=\"noreferrer noopener\">Apple Inc (AAPL.US)<\/a> here and we&#8217;ll get that.<br><img decoding=\"async\" class=\"wp-image-813\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Get-Stocks-Fundamental-Data.gif\" alt=\"EODHD APIs Get Stocks Fundamental Data\"><br>You can see it&#8217;s pretty quick, the connection comes back right away and all sorts of Fundamental Data Points here are available. Now, you can start doing whatever analyzes you want on.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=253\" target=\"_blank\" rel=\"noreferrer noopener\">04:13<\/a> \u2014 Bulk Fundamental Data for Stocks<\/strong><br>One nice feature is allows us to download the Bulk Fundamental Data for a lot of symbols. If you have a list of symbols you can kind of feed those in here. Right otherwise it works pretty much the same way, we can choose a specific exchange to obtain the tickers data of it.<br><img decoding=\"async\" class=\"wp-image-816\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Bulk-Fundamental-Data-for-Stocks.gif\" alt=\"EODHD APIs Bulk Fundamental Data for Stocks\"><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=271\" target=\"_blank\" rel=\"noreferrer noopener\">04:31<\/a> \u2014 Get ETF Data<\/strong><br>You can easily get ETF data directly into your Google Sheet.<br><img decoding=\"async\" class=\"wp-image-818\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Get-ETF-Data-.gif\" alt=\"EODHD APIs Get ETF Data\"><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=274\" target=\"_blank\" rel=\"noreferrer noopener\">04:34<\/a> \u2014 Get Stocks Options Data<\/strong><br>If I&#8217;ll stick in <a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/AAPL.US\" target=\"_blank\" rel=\"noreferrer noopener\">Apple Inc (AAPL.US)<\/a> again and I&#8217;ll specify &#8216;From&#8217; and &#8216;To&#8217; to obtain all the Options for October or if you want to go out to the regular expiration, you can set in any data slice.<br>You&#8217;ll see that data comes back pretty quickly and the results are placed into the subtotal. The outline format shows the three weekly option expirations and if you want to click on the + it expands it out, and you can see:<br> \u2022 what the strike is<br> \u2022 whether it&#8217;s a call or it&#8217;s a put<br> \u2022 when the last trade was<br> \u2022 the bid and the ask<br><img decoding=\"async\" class=\"wp-image-821\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Get-Stocks-Options-Data.gif\" alt=\"EODHD APIs Get Stocks Options Data\"><br>You also get some implied volatilities here, so some high-level statistics are available too like the put\/call ratio and that kind of thing.<\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=355\" target=\"_blank\" rel=\"noreferrer noopener\">05:55<\/a> \u2014 Find Tickers With the Stock Market Screener<\/strong><br>Another nice feature of the EODHD APIs Google Sheets add-in is this Screener.<br>You can just use it to download all the symbols in an exchange, or to create your personal screener presets by choosing from a lots of options. Let&#8217;s choose 50-day low for example, or if you want to get a little bit more involved, you can start adding filters to look for:<br> \u2022 a specific market capitalization<br> \u2022 a specific yield<br> \u2022 and you can add in as many filters here as you want<br><br>Let&#8217;s just see what happens when we take a 50-day low?<br><img decoding=\"async\" class=\"wp-image-826\" style=\"width: 900px;\" src=\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-APIs-Stock-Market-Screener.gif\" alt=\"EODHD APIs Stock Market Screener\"><br>Yep it goes out and it quickly gets that data where all these Securities should be hitting their 50-day lows or are below their 50-day lows. You can see that some of them are not traded in dollars, so you can filter out whatever whatever Stock Exchange you&#8217;re interested in. <br>That&#8217;s another thing about EOD HD APIs data: they pretty much have all of the major stock markets from around the world all right over 60 of them instead of giving you U.S. only data, like most API providers do.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><a class=\"maxbutton-1 maxbutton maxbutton-subscribe-to-api external-css btn\" href=\"https:\/\/eodhd.com\/register\"><span class='mb-text'>Register &amp; Get Data<\/span><\/a><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/youtu.be\/pMs6FFG-gKY?t=427\" target=\"_blank\" rel=\"noreferrer noopener\">07:07<\/a> \u2014 Conclusion<\/strong><\/p>\n\n\n\n<p>Hopefully that helps you to get started with EODHD APIs to download and then manipulate data however you like in a Google Sheet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to learn how to install the EODHD Google Sheets Add-In and activate your API key, I recommend to start with exploring of our Documentation for it. In this video Matt shows you how to automatically download Stock Price Data and other Financial information into a Google Sheet with the EODHD Google Sheets [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[43],"tags":[51],"coding-language":[],"ready-to-go-solution":[58],"qualification":[33],"financial-apis-category":[34,36],"financial-apis-manuals":[39,38,37],"class_list":["post-731","post","type-post","status-publish","format-standard","hentry","category-how-to-get-stocks-data-examples","tag-youtube","ready-to-go-solution-google-sheets-add-in","qualification-newbie","financial-apis-category-crypto-market-prices","financial-apis-category-stock-market-prices","financial-apis-manuals-end-of-day","financial-apis-manuals-intraday","financial-apis-manuals-stocks-fundamentals"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v26.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Get End-of-Day Historical Stocks Data in Google Sheets with EODHD Add-In | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"Discover how to download historical stock data into Google Sheets with the EODHD Add-In. Start performing financial analysis effortlessly\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get Historical, Intraday &amp; Fundamental data with EODHD Google Sheets Add-In\" \/>\n<meta property=\"og:description\" content=\"Discover how to download historical stock data into Google Sheets with the EODHD Add-In. Start performing financial analysis effortlessly\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\" \/>\n<meta property=\"og:site_name\" content=\"Financial Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/eodhistoricaldata\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-11T08:59:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T08:03:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2022\/10\/Get-Historical-Intraday-Fundamental-data-with-EODHD-Google-Sheets-Add-In.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Matt Macarty\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/mjmacarty\" \/>\n<meta name=\"twitter:site\" content=\"@EOD_data\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt Macarty\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\"},\"author\":{\"name\":\"Matt Macarty\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/60415de1596098ca8152e233c446a992\"},\"headline\":\"Get Historical, Intraday &#038; Fundamental data with EODHD Google Sheets Add-In\",\"datePublished\":\"2022-10-11T08:59:12+00:00\",\"dateModified\":\"2024-03-14T08:03:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\"},\"wordCount\":1142,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif\",\"keywords\":[\"YouTube Videos\"],\"articleSection\":[\"How to Get Stocks Data Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\",\"name\":\"Get End-of-Day Historical Stocks Data in Google Sheets with EODHD Add-In | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif\",\"datePublished\":\"2022-10-11T08:59:12+00:00\",\"dateModified\":\"2024-03-14T08:03:33+00:00\",\"description\":\"Discover how to download historical stock data into Google Sheets with the EODHD Add-In. Start performing financial analysis effortlessly\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage\",\"url\":\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif\",\"contentUrl\":\"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get Historical, Intraday &#038; Fundamental data with EODHD Google Sheets Add-In\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/\",\"name\":\"Financial APIs Academy | EODHD\",\"description\":\"Financial Stock Market Academy\",\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eodhd.com\/financial-academy\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\",\"name\":\"EODHD (EOD Historical Data)\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/EODHD-Logo.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/EODHD-Logo.png\",\"width\":159,\"height\":82,\"caption\":\"EODHD (EOD Historical Data)\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/eodhistoricaldata\",\"https:\/\/x.com\/EOD_data\",\"https:\/\/www.reddit.com\/r\/EODHistoricalData\/\",\"https:\/\/eod-historical-data.medium.com\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/60415de1596098ca8152e233c446a992\",\"name\":\"Matt Macarty\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a323524269378edb9025ce263fb588b98fd68a6188e577b95d0bdfe6dd8ccc43?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a323524269378edb9025ce263fb588b98fd68a6188e577b95d0bdfe6dd8ccc43?s=96&d=mm&r=g\",\"caption\":\"Matt Macarty\"},\"sameAs\":[\"https:\/\/linkedin.com\/in\/mjmacarty\",\"https:\/\/x.com\/https:\/\/twitter.com\/mjmacarty\"],\"url\":\"https:\/\/eodhd.com\/financial-academy\/author\/mattmacarty\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Get End-of-Day Historical Stocks Data in Google Sheets with EODHD Add-In | EODHD APIs Academy","description":"Discover how to download historical stock data into Google Sheets with the EODHD Add-In. Start performing financial analysis effortlessly","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in","og_locale":"en_US","og_type":"article","og_title":"Get Historical, Intraday & Fundamental data with EODHD Google Sheets Add-In","og_description":"Discover how to download historical stock data into Google Sheets with the EODHD Add-In. Start performing financial analysis effortlessly","og_url":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2022-10-11T08:59:12+00:00","article_modified_time":"2024-03-14T08:03:33+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2022\/10\/Get-Historical-Intraday-Fundamental-data-with-EODHD-Google-Sheets-Add-In.png","type":"image\/png"}],"author":"Matt Macarty","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/mjmacarty","twitter_site":"@EOD_data","twitter_misc":{"Written by":"Matt Macarty","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in"},"author":{"name":"Matt Macarty","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/60415de1596098ca8152e233c446a992"},"headline":"Get Historical, Intraday &#038; Fundamental data with EODHD Google Sheets Add-In","datePublished":"2022-10-11T08:59:12+00:00","dateModified":"2024-03-14T08:03:33+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in"},"wordCount":1142,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage"},"thumbnailUrl":"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif","keywords":["YouTube Videos"],"articleSection":["How to Get Stocks Data Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in","url":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in","name":"Get End-of-Day Historical Stocks Data in Google Sheets with EODHD Add-In | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage"},"thumbnailUrl":"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif","datePublished":"2022-10-11T08:59:12+00:00","dateModified":"2024-03-14T08:03:33+00:00","description":"Discover how to download historical stock data into Google Sheets with the EODHD Add-In. Start performing financial analysis effortlessly","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#primaryimage","url":"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif","contentUrl":"https:\/\/eodhistoricaldata.com\/financial-academy\/wp-content\/uploads\/2022\/10\/EODHD-Google-Sheets-Add-In-Installation.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/get-historical-intraday-fundamental-data-with-eodhd-google-sheets-add-in#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"Get Historical, Intraday &#038; Fundamental data with EODHD Google Sheets Add-In"}]},{"@type":"WebSite","@id":"https:\/\/eodhd.com\/financial-academy\/#website","url":"https:\/\/eodhd.com\/financial-academy\/","name":"Financial APIs Academy | EODHD","description":"Financial Stock Market Academy","publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eodhd.com\/financial-academy\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/eodhd.com\/financial-academy\/#organization","name":"EODHD (EOD Historical Data)","url":"https:\/\/eodhd.com\/financial-academy\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/logo\/image\/","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/EODHD-Logo.png","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/EODHD-Logo.png","width":159,"height":82,"caption":"EODHD (EOD Historical Data)"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/eodhistoricaldata","https:\/\/x.com\/EOD_data","https:\/\/www.reddit.com\/r\/EODHistoricalData\/","https:\/\/eod-historical-data.medium.com\/"]},{"@type":"Person","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/60415de1596098ca8152e233c446a992","name":"Matt Macarty","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a323524269378edb9025ce263fb588b98fd68a6188e577b95d0bdfe6dd8ccc43?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a323524269378edb9025ce263fb588b98fd68a6188e577b95d0bdfe6dd8ccc43?s=96&d=mm&r=g","caption":"Matt Macarty"},"sameAs":["https:\/\/linkedin.com\/in\/mjmacarty","https:\/\/x.com\/https:\/\/twitter.com\/mjmacarty"],"url":"https:\/\/eodhd.com\/financial-academy\/author\/mattmacarty"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-bN","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/comments?post=731"}],"version-history":[{"count":2,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/731\/revisions"}],"predecessor-version":[{"id":3009,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/731\/revisions\/3009"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=731"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=731"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=731"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=731"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=731"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}