{"id":2420,"date":"2023-09-29T13:01:50","date_gmt":"2023-09-29T13:01:50","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=2420"},"modified":"2024-03-14T08:06:02","modified_gmt":"2024-03-14T08:06:02","slug":"how-to-get-eod-prices-with-google-sheets-add-in","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in","title":{"rendered":"How to Get EOD Prices with Google Sheets Add-in"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>In today&#8217;s financial landscape, access to real-time data stands as a cornerstone for informed decision-making in the markets. For many investors and traders, end-of-day (EOD) stock data holds paramount importance, offering critical insights. Obtaining this data has become significantly more accessible through various technological tools, including integration with Google Sheets.<\/p>\n\n\n\n<p>This article aims to explore an efficient method of acquiring EOD data using the Google Sheets Add-in. This tool provides a streamlined pathway to closing prices, empowering users to swiftly analyze markets and make well-informed choices. Let&#8217;s delve step by step into leveraging this Add-in to obtain current data and enhance your capabilities in financial analysis.<\/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\n\n\n<p><strong>Before continue to work with our APIs, make sure that you <a href=\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-start-using-eodhd-google-sheets-add-in\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">installed and configured our Add-in<\/span><\/a>.\u00a0More detailed information about functions of EOD API you can find on our <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\" target=\"_blank\" rel=\"noreferrer noopener\"><u>documentation web-page<\/u><\/a>.<\/strong><\/p>\n\n\n\n<p>1. Use \u201c<strong>DEMO<\/strong>\u201d API key to test our data from a limited set of the tickers without registering:<br><a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/AAPL.US\" target=\"_blank\" rel=\"noreferrer noopener\">AAPL.US<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/TSLA.US\" target=\"_blank\" rel=\"noreferrer noopener\">TSLA.US&nbsp;<\/a>|&nbsp;<a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/VTI.US\" target=\"_blank\" rel=\"noreferrer noopener\">VTI.US<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/AMZN.US\" target=\"_blank\" rel=\"noreferrer noopener\">AMZN.US<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/BTC-USD.CC\" target=\"_blank\" rel=\"noreferrer noopener\">BTC-USD<\/a>&nbsp;|&nbsp;<a href=\"https:\/\/eodhistoricaldata.com\/financial-summary\/EURUSD.FOREX\" target=\"_blank\" rel=\"noreferrer noopener\">EUR-USD<\/a><br><a href=\"https:\/\/eodhistoricaldata.com\/financial-apis\/new-real-time-data-api-websockets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Real-Time Data<\/a>&nbsp;and All the APIs (except bulk) are included without limitations on API calls.<br>2. Register to get your free API key (limited by 20 API calls per day) with access to:<br><a href=\"https:\/\/eodhistoricaldata.com\/financial-apis\/api-for-historical-data-and-volumes\/\" target=\"_blank\" rel=\"noreferrer noopener\">End-Of-Day Historical Data<\/a>&nbsp;with only past year for any ticker and&nbsp;<a href=\"https:\/\/eodhistoricaldata.com\/financial-apis\/exchanges-api-list-of-tickers-and-trading-hours\/#Get_List_of_Tickers_Exchange_Symbols\" target=\"_blank\" rel=\"noreferrer noopener\">List of tickers per Exchange<\/a><br>3. To unlock your API key, we recommend <a href=\"https:\/\/eodhd.com\/pricing\" target=\"_blank\" rel=\"noreferrer noopener\">choosing a subscription<\/a> which covers your needs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Retrieving EOD Historical Data<\/h2>\n\n\n\n<p>After entering the API key, you need to click the \u201cGET DATA\u201d button, and you&#8217;ll be taken to the main Add-in interface. To obtain EOD prices, you need to select \u201cEnd-Of-Day Historical Stock\u201d, enter the required ticker, pick output period (daily, weekly, monthly), and set the time interval. You can also check the box to get the chart along with the data. Then click the GET button, and you&#8217;re done!<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg\" alt=\"\"\/><\/figure>\n<\/div><\/div><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>Here is the example of daily data with chart:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"606\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/image-6.png\" alt=\"\" class=\"wp-image-4393\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The example for weekly data:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1203\" height=\"610\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/image-7.png\" alt=\"\" class=\"wp-image-4394\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>And finally, monthly data:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1210\" height=\"610\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/image-9.png\" alt=\"\" class=\"wp-image-4402\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Please note, that OHLC data with this Add-in is provided raw, adjusted neither to splits nor to dividends, while adjusted closes are adjusted to both splits and dividends, and volume is adjusted to splits.<\/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","protected":false},"excerpt":{"rendered":"<p>Introduction In today&#8217;s financial landscape, access to real-time data stands as a cornerstone for informed decision-making in the markets. For many investors and traders, end-of-day (EOD) stock data holds paramount importance, offering critical insights. Obtaining this data has become significantly more accessible through various technological tools, including integration with Google Sheets. This article aims to [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"everybody","_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":[],"coding-language":[],"ready-to-go-solution":[58],"qualification":[33],"financial-apis-category":[34,36],"financial-apis-manuals":[39],"class_list":["post-2420","post","type-post","status-publish","format-standard","hentry","category-how-to-get-stocks-data-examples","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"],"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>How to Access EOD Prices with Google Sheets | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"Unlock the power of Google Sheets for EOD data. Learn how to leverage the Google Sheets Add-in to quickly access and analyze closing stock prices\" \/>\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\/how-to-get-eod-prices-with-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=\"How to Get EOD Prices with Google Sheets Add-in\" \/>\n<meta property=\"og:description\" content=\"Unlock the power of Google Sheets for EOD data. Learn how to leverage the Google Sheets Add-in to quickly access and analyze closing stock prices\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-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=\"2023-09-29T13:01:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T08:06:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/09\/EODHD-Financial-Google-Sheets-Add-in.png\" \/>\n\t<meta property=\"og:image:width\" content=\"801\" \/>\n\t<meta property=\"og:image:height\" content=\"261\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Eugen from EODHD\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@EOD_data\" \/>\n<meta name=\"twitter:site\" content=\"@EOD_data\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eugen from EODHD\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/how-to-get-eod-prices-with-google-sheets-add-in#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in\"},\"author\":{\"name\":\"Eugen from EODHD\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/ccc2b180b8e69e73b0d95ef4b24dc3a8\"},\"headline\":\"How to Get EOD Prices with Google Sheets Add-in\",\"datePublished\":\"2023-09-29T13:01:50+00:00\",\"dateModified\":\"2024-03-14T08:06:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in\"},\"wordCount\":386,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage\"},\"thumbnailUrl\":\"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg\",\"articleSection\":[\"How to Get Stocks Data Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in\",\"name\":\"How to Access EOD Prices with Google Sheets | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage\"},\"thumbnailUrl\":\"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg\",\"datePublished\":\"2023-09-29T13:01:50+00:00\",\"dateModified\":\"2024-03-14T08:06:02+00:00\",\"description\":\"Unlock the power of Google Sheets for EOD data. Learn how to leverage the Google Sheets Add-in to quickly access and analyze closing stock prices\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage\",\"url\":\"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg\",\"contentUrl\":\"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Get EOD Prices with 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\/ccc2b180b8e69e73b0d95ef4b24dc3a8\",\"name\":\"Eugen from EODHD\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/940112153e11364b5bc780ac905443245fadf2aed5296b7d3653491fc42584dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/940112153e11364b5bc780ac905443245fadf2aed5296b7d3653491fc42584dc?s=96&d=mm&r=g\",\"caption\":\"Eugen from EODHD\"},\"url\":\"https:\/\/eodhd.com\/financial-academy\/author\/eugen-eodhd\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Access EOD Prices with Google Sheets | EODHD APIs Academy","description":"Unlock the power of Google Sheets for EOD data. Learn how to leverage the Google Sheets Add-in to quickly access and analyze closing stock prices","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\/how-to-get-eod-prices-with-google-sheets-add-in","og_locale":"en_US","og_type":"article","og_title":"How to Get EOD Prices with Google Sheets Add-in","og_description":"Unlock the power of Google Sheets for EOD data. Learn how to leverage the Google Sheets Add-in to quickly access and analyze closing stock prices","og_url":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2023-09-29T13:01:50+00:00","article_modified_time":"2024-03-14T08:06:02+00:00","og_image":[{"width":801,"height":261,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/09\/EODHD-Financial-Google-Sheets-Add-in.png","type":"image\/png"}],"author":"Eugen from EODHD","twitter_card":"summary_large_image","twitter_creator":"@EOD_data","twitter_site":"@EOD_data","twitter_misc":{"Written by":"Eugen from EODHD","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in"},"author":{"name":"Eugen from EODHD","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/ccc2b180b8e69e73b0d95ef4b24dc3a8"},"headline":"How to Get EOD Prices with Google Sheets Add-in","datePublished":"2023-09-29T13:01:50+00:00","dateModified":"2024-03-14T08:06:02+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in"},"wordCount":386,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage"},"thumbnailUrl":"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg","articleSection":["How to Get Stocks Data Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in","url":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in","name":"How to Access EOD Prices with Google Sheets | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage"},"thumbnailUrl":"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg","datePublished":"2023-09-29T13:01:50+00:00","dateModified":"2024-03-14T08:06:02+00:00","description":"Unlock the power of Google Sheets for EOD data. Learn how to leverage the Google Sheets Add-in to quickly access and analyze closing stock prices","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#primaryimage","url":"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg","contentUrl":"https:\/\/lh3.googleusercontent.com\/MS3LMV0GHbQO3avRpQZ3oPGcPrh-U2hqdmPPUW6ajFHA9Yn0SqjDBps4OAX28Duh0aMZcfTeuag8UqIY29skRFNe1gurhP4scbibzNga0FFIVD1gYHNUz9Gjxz9OAAJEg5Xh1gognHqwMA1BhE1zsIg"},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/how-to-get-stocks-data-examples\/how-to-get-eod-prices-with-google-sheets-add-in#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"How to Get EOD Prices with 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\/ccc2b180b8e69e73b0d95ef4b24dc3a8","name":"Eugen from EODHD","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/940112153e11364b5bc780ac905443245fadf2aed5296b7d3653491fc42584dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/940112153e11364b5bc780ac905443245fadf2aed5296b7d3653491fc42584dc?s=96&d=mm&r=g","caption":"Eugen from EODHD"},"url":"https:\/\/eodhd.com\/financial-academy\/author\/eugen-eodhd"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-D2","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/2420","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/comments?post=2420"}],"version-history":[{"count":59,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/2420\/revisions"}],"predecessor-version":[{"id":4404,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/2420\/revisions\/4404"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=2420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=2420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=2420"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=2420"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=2420"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=2420"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=2420"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=2420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}