{"id":5232,"date":"2024-03-18T18:04:19","date_gmt":"2024-03-18T18:04:19","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=5232"},"modified":"2024-03-18T18:04:21","modified_gmt":"2024-03-18T18:04:21","slug":"how-to-create-a-stock-market-dashboard-in-google-sheets","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets","title":{"rendered":"How to Create a Stock Market Dashboard in Google Sheets"},"content":{"rendered":"\n<p><a href=\"https:\/\/workspace.google.com\/intl\/en_ie\/products\/sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets<\/a> provides a powerful and flexible platform for building custom dashboards and analysis tools. By creating a&nbsp;Stock Market Dashboard in Google Sheets with the EODHD Financial APIs, you can make a robust dashboard that pulls in real-time historical and current market data into Google Sheets.<\/p>\n\n\n\n<p>This tutorial will walk through importing stock data from EODHD into Google Sheets, setting up functions to fetch live quotes, and visualizing the data through charts and summaries.<\/p>\n\n\n\n<p>You can also check our guides for <a href=\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\/\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create Google Sheets Portfolio Tracker<\/a> and <a href=\"https:\/\/eodhd.com\/financial-apis\/google-sheets-financial-add-in-for-eod-fundamentals-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD Google Sheets Add-in<\/a>. Here you&#8217;ll find more information on our <a href=\"https:\/\/eodhd.com\/financial-apis\/category\/stock-prices-solutions\/\" target=\"_blank\" rel=\"noreferrer noopener\">Ready-to-Go<\/a> solutions.<\/p>\n\n\n\n<p>This is a usable <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1tiKzqjFWUuzmgGAUqbY-rqPfSHC7CpmrTgNwFAPlZTY\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets example<\/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\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-copy-google-sheets-stock-market-dashboard\">Copy Google Sheets Stock Market Dashboard<\/h2>\n\n\n\n<p>To create a new, independent version of the <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1tiKzqjFWUuzmgGAUqbY-rqPfSHC7CpmrTgNwFAPlZTY\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">spreadsheet<\/a> (any changes made to the copied spreadsheet will not affect the original spreadsheet), follow the steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the Google Sheets <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1tiKzqjFWUuzmgGAUqbY-rqPfSHC7CpmrTgNwFAPlZTY\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">spreadsheet<\/a>.<\/li>\n\n\n\n<li>Click &#8220;File&#8221; in the top menu.<\/li>\n\n\n\n<li>From the dropdown menu, select &#8220;Make a copy&#8221;.<\/li>\n\n\n\n<li>In the &#8220;Copy document&#8221; dialog box, you can customize the options:\n<ul class=\"wp-block-list\">\n<li>Enter a name for the copied spreadsheet in the &#8220;Name&#8221; field.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click the &#8220;Make a copy&#8221; button.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"484\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Copy_spreadsheet.gif\" alt=\"Copy Google Spreadsheet\" class=\"wp-image-5269\" style=\"width:691px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-connect-your-google-sheets-to-eodhd-api\">Connect Your Google Sheets to EODHD API <\/h2>\n\n\n\n<p>Using the API requires registering and getting your personal API key. However, you can follow the article using the &#8216;demo&#8217; key for the tickers AAPL, MSFT, TSLA, and MCD.<\/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>To start with, you need to make yourself familiar with the basic <a href=\"https:\/\/eodhd.com\/financial-apis\/quick-start-with-our-financial-data-apis\/\" target=\"_blank\" rel=\"noreferrer noopener\">functionality that the EODHD APIs<\/a> provide.<\/p>\n\n\n\n<p>The &#8220;<a href=\"https:\/\/support.google.com\/docs\/answer\/3093335?hl=en\" target=\"_blank\" rel=\"noreferrer noopener\">=IMPORTDATA(URL)<\/a>&#8221; function in Google Sheets allows you to import data from an URL directly into cells. We&#8217;ll use this to fetch data from the EODHD API endpoints. The IMPORTDATA function can fetch and parse both <a href=\"https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\" target=\"_blank\" rel=\"noreferrer noopener\">CSV\u00a0<\/a>and <a href=\"https:\/\/en.wikipedia.org\/wiki\/JSON\" target=\"_blank\" rel=\"noreferrer noopener\">JSON<\/a> formats into the table. However, the function handles the formats slightly differently, and you need to test which output satisfies your needs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-examples-of-eodhd-apis-usage-in-google-spreadsheet\">Examples of EODHD APIs Usage in Google Spreadsheet<\/h2>\n\n\n\n<p>In a new Google Sheet, enter the following formula to pull in the <a href=\"https:\/\/eodhd.com\/financial-apis\/exchanges-api-list-of-tickers-and-trading-hours\/\" target=\"_blank\" rel=\"noreferrer noopener\">list<\/a> of supported exchanges:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/exchanges-list\/?api_token=YOUR_API_KEY&amp;fmt=json\")<\/pre>\n\n\n\n<p>Replace YOUR_API_KEY with your actual EODHD API key. This will populate the sheet with a JSON array of the exchange data. You can change the field &#8220;&amp;fmt=json&#8221; into &#8220;&amp;fmt=csv&#8221; to get a CSV output from the API.<\/p>\n\n\n\n<p>To get a stock ticker list for a particular exchange, you can use the &#8220;<a href=\"https:\/\/eodhd.com\/financial-apis\/exchanges-api-list-of-tickers-and-trading-hours\/#Get_List_of_Tickers_Exchange_Symbols\" target=\"_blank\" rel=\"noreferrer noopener\">Get Ticker List API<\/a>&#8221; with the exchange code. For the US market, the code is &#8220;US&#8221;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/exchange-symbol-list\/US?api_token=YOUR_API_KEY&amp;fmt=json\")<\/pre>\n\n\n\n<p>This will return all active stocks and ETFs on the US market in JSON format.<\/p>\n\n\n\n<p>To import <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\" target=\"_blank\" rel=\"noreferrer noopener\">historical end-of-day <\/a>data for stock, use this formula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/eod\/AAPL.US?from=2022-01-01&amp;to=2023-01-01&amp;api_token=YOUR_API_KEY&amp;fmt=json\")<\/pre>\n\n\n\n<p>This will pull the daily open, high, low, close, and volume for Apple (AAPL) between the date range specified. Adjust the ticker, date range, and your API key as needed.<\/p>\n\n\n\n<p>The <a href=\"https:\/\/eodhd.com\/financial-apis\/live-realtime-stocks-api\/\" target=\"_blank\" rel=\"noreferrer noopener\">Live API<\/a> also provides a live prices endpoint to get  delayed quotes. Create a new sheet and enter:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/real-time\/AAPL.US?api_token=YOUR_API_KEY&amp;fmt=json&amp;filter=close\")<\/pre>\n\n\n\n<p>This will fetch the current trading price data for Apple Inc. &#8220;&amp;filter=close&#8221; field helps to get only the close value from the API. To get open\/close\/volume values, you can delete the filter.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"966\" height=\"504\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/IMPORTDATA_EOD.gif\" alt=\"Live data Google Sheet\" class=\"wp-image-5270\" style=\"width:657px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-create-a-sparkline-chart-in-the-cell\">Create a Sparkline Chart in The Cell<\/h2>\n\n\n\n<p> Now that you have imported market data into Google Sheets, you can start building your trading dashboard!<\/p>\n\n\n\n<p>To get a sparkline into cell, you need to IMPORTDATA from a <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\" target=\"_blank\" rel=\"noreferrer noopener\">historical <\/a>API (either <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\" target=\"_blank\" rel=\"noreferrer noopener\">intraday <\/a>or <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\" target=\"_blank\" rel=\"noreferrer noopener\">EOD<\/a>) into Google&#8217;s <a href=\"https:\/\/eodhd.com\/financial-apis\/category\/historical-prices-live-data-apis\/\" target=\"_blank\" rel=\"noreferrer noopener\">SPARKLINE <\/a>function. <\/p>\n\n\n\n<p>The cell value will look like this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SPARKLINE(IMPORTDATA(\"https:\/\/eodhd.com\/api\/eod\/AAPL?api_token=YOUR_API_KEY&amp;fmt=json&amp;filter=adjusted_close&amp;from=2024-01-01\"))<\/pre>\n\n\n\n<p>This will create a sparkline based on the end-of-day EODHD data for AAPL from the specified date.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1174\" height=\"544\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/SPARKLINE_EOD.gif\" alt=\"Financial Sparkline Chart in The Cell Google Sheets Dashboard\" class=\"wp-image-5273\" style=\"width:663px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-treemap-market-cap-chart\">Treemap Market Cap Chart<\/h2>\n\n\n\n<p>For a <a href=\"https:\/\/support.google.com\/docs\/answer\/9146947?hl=en\" target=\"_blank\" rel=\"noreferrer noopener\">Treemap Chart<\/a> of a market, you need to structure the data in 4 columns similar to the following table:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Tickers<\/strong><\/td><td><strong>Exch<\/strong><\/td><td><strong>Market Cap($)<\/strong><\/td><td><strong>Change(%)<\/strong><\/td><\/tr><tr><td>US<\/td><td><\/td><td>{The sum of components market cap}<\/td><td><\/td><\/tr><tr><td>MSFT<\/td><td>US<\/td><td>3,094,183,936,000.00<\/td><td>-2.0695<\/td><\/tr><tr><td>AAPL<\/td><td>US<\/td><td>2,665,580,593,152.00<\/td><td>-0.2197<\/td><\/tr><tr><td>NVDA<\/td><td>US<\/td><td>2,195,912,523,776.00<\/td><td>-0.1222<\/td><\/tr><tr><td>AMZN<\/td><td>US<\/td><td>1,811,770,245,120.00<\/td><td>-2.4224<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Example of the table structure for a Google Sheets Treemap Chart<\/figcaption><\/figure>\n\n\n\n<p>The Tickers column will be used to name elements of the chart, Exchange will show to which node value the name belongs, Marketcap will be used for the size of the element, and the Change(%) column for the color. Note that the first line after the header specifies the node and the total sum of the included component weights.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1267\" height=\"718\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Treemap_Chart_MarketCap.gif\" alt=\"Treemap Market Cap Chart\" class=\"wp-image-5274\" style=\"width:693px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<p>To get market capitalization, you can use the <a href=\"https:\/\/eodhd.com\/financial-apis\/stock-etfs-fundamental-data-feeds\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fundamentals API<\/a> with the &#8220;&amp;filter=Highlights::MarketCapitalization&#8221; field:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/fundamentals\/AAPL?api_token=YOUR_API_TOKEN&amp;fmt=json&amp;filter=Highlights::MarketCapitalization\")<\/pre>\n\n\n\n<p>The cell formula will fetch the market cap value for AAPL into the selected cell.<\/p>\n\n\n\n<p>For daily changes in price, you can our <a href=\"https:\/\/eodhd.com\/financial-apis\/live-realtime-stocks-api\/\" target=\"_blank\" rel=\"noreferrer noopener\">Live(delayed)<\/a> API with field &#8220;&amp;filter=change_p&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/real-time\/AAPL.US?api_token=YOUR_API_KEY&amp;fmt=json&amp;filter=change_p\")<\/pre>\n\n\n\n<p>The formula will provide the current stock price change for the selected cell.<\/p>\n\n\n\n<p>An example of Google Sheets Stock Market <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1tiKzqjFWUuzmgGAUqbY-rqPfSHC7CpmrTgNwFAPlZTY\/edit#gid=0\">Dashboard<\/a> is shown below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1480\" height=\"826\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Treemap_Chart_Example.gif\" alt=\"Treemap Market Cap Chart Google Sheets Dashboard\" class=\"wp-image-5275\" style=\"width:643px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-leverage-eodhd-apis-for-your-financial-results\">Leverage EODHD APIs for your Financial results<\/h2>\n\n\n\n<p>You can use your ingenuity to create summaries of your portfolio holdings, import news\/sentiment data, analyze pricing trends using charts and sparklines, and set up conditional formatting rules to highlight trading signals.<\/p>\n\n\n\n<p>The EODHD API provides a wide range of data endpoints from pricing to fundamentals to corporate events that you can integrate to create a rich, comprehensive trading dashboard.<\/p>\n\n\n\n<p>By leveraging the power of Google Sheets combined with the high-quality data from EODHD, you can deploy a robust, customizable trading analysis tool to aid your investment decisions. Get started today by signing up for an EODHD API key!<\/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>Feel free to contact our amazing support to ask for the currently available discounts, we would be more than happy to assist and guide you through the process.<\/p>\n\n\n\n<p><a href=\"mailto:support@eodhistoricaldata.com\" target=\"_blank\" rel=\"noreferrer noopener\">support@eodhistoricaldata.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets provides a powerful and flexible platform for building custom dashboards and analysis tools. By creating a&nbsp;Stock Market Dashboard in Google Sheets with the EODHD Financial APIs, you can make a robust dashboard that pulls in real-time historical and current market data into Google Sheets. This tutorial will walk through importing stock data from [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":5266,"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":[1,43,48],"tags":[85,83,82],"coding-language":[],"ready-to-go-solution":[],"qualification":[33],"financial-apis-category":[],"financial-apis-manuals":[39,38,73,37],"class_list":["post-5232","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fundamental-analysis-examples","category-how-to-get-stocks-data-examples","category-stocks-data-processing-examples","tag-financial-data-spreadsheets","tag-google-sheets-portfolio","tag-market-dashboard","qualification-newbie","financial-apis-manuals-end-of-day","financial-apis-manuals-intraday","financial-apis-manuals-live-delayed-15-mins","financial-apis-manuals-stocks-fundamentals","has_thumb"],"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 Create a Stock Market Dashboard in Google Sheets | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"How to create a\u00a0Google Sheets Stock Market Dashboard with a Treemap Chart,\" \/>\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\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Stock Market Dashboard in Google Sheets\" \/>\n<meta property=\"og:description\" content=\"How to create a\u00a0Google Sheets Stock Market Dashboard with a Treemap Chart,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\" \/>\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=\"2024-03-18T18:04:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-18T18:04:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1905\" \/>\n\t<meta property=\"og:image:height\" content=\"497\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Andrei Paulavets\" \/>\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=\"Andrei Paulavets\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\"},\"author\":{\"name\":\"Andrei Paulavets\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\"},\"headline\":\"How to Create a Stock Market Dashboard in Google Sheets\",\"datePublished\":\"2024-03-18T18:04:19+00:00\",\"dateModified\":\"2024-03-18T18:04:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\"},\"wordCount\":941,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png\",\"keywords\":[\"financial data spreadsheets\",\"Google sheets portfolio\",\"Market Dashboard\"],\"articleSection\":[\"Fundamental Analysis Examples\",\"How to Get Stocks Data Examples\",\"Stocks Data Processing Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\",\"name\":\"How to Create a Stock Market Dashboard in Google Sheets | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png\",\"datePublished\":\"2024-03-18T18:04:19+00:00\",\"dateModified\":\"2024-03-18T18:04:21+00:00\",\"description\":\"How to create a\u00a0Google Sheets Stock Market Dashboard with a Treemap Chart,\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png\",\"width\":1905,\"height\":497},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Stock Market Dashboard in Google Sheets\"}]},{\"@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\/beb3cf1cd77acbb7720cda8c63e5565e\",\"name\":\"Andrei Paulavets\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7ac21633a5988e5054e9edbe412f1f07957970ee6e9f6dbada15224224cdd2c9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7ac21633a5988e5054e9edbe412f1f07957970ee6e9f6dbada15224224cdd2c9?s=96&d=mm&r=g\",\"caption\":\"Andrei Paulavets\"},\"description\":\"Investment professional with a strong engineering background, leveraging diverse background and risk managment experience to enhance investor financial analysis and data-driven decision-making in financial markets.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/andreipaulavets\"],\"url\":\"https:\/\/eodhd.com\/financial-academy\/author\/andrew-eodhd\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create a Stock Market Dashboard in Google Sheets | EODHD APIs Academy","description":"How to create a\u00a0Google Sheets Stock Market Dashboard with a Treemap Chart,","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\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets","og_locale":"en_US","og_type":"article","og_title":"How to Create a Stock Market Dashboard in Google Sheets","og_description":"How to create a\u00a0Google Sheets Stock Market Dashboard with a Treemap Chart,","og_url":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2024-03-18T18:04:19+00:00","article_modified_time":"2024-03-18T18:04:21+00:00","og_image":[{"width":1905,"height":497,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png","type":"image\/png"}],"author":"Andrei Paulavets","twitter_card":"summary_large_image","twitter_creator":"@EOD_data","twitter_site":"@EOD_data","twitter_misc":{"Written by":"Andrei Paulavets","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets"},"author":{"name":"Andrei Paulavets","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e"},"headline":"How to Create a Stock Market Dashboard in Google Sheets","datePublished":"2024-03-18T18:04:19+00:00","dateModified":"2024-03-18T18:04:21+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets"},"wordCount":941,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png","keywords":["financial data spreadsheets","Google sheets portfolio","Market Dashboard"],"articleSection":["Fundamental Analysis Examples","How to Get Stocks Data Examples","Stocks Data Processing Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets","url":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets","name":"How to Create a Stock Market Dashboard in Google Sheets | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png","datePublished":"2024-03-18T18:04:19+00:00","dateModified":"2024-03-18T18:04:21+00:00","description":"How to create a\u00a0Google Sheets Stock Market Dashboard with a Treemap Chart,","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#primaryimage","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png","width":1905,"height":497},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/how-to-create-a-stock-market-dashboard-in-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"How to Create a Stock Market Dashboard in Google Sheets"}]},{"@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\/beb3cf1cd77acbb7720cda8c63e5565e","name":"Andrei Paulavets","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7ac21633a5988e5054e9edbe412f1f07957970ee6e9f6dbada15224224cdd2c9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7ac21633a5988e5054e9edbe412f1f07957970ee6e9f6dbada15224224cdd2c9?s=96&d=mm&r=g","caption":"Andrei Paulavets"},"description":"Investment professional with a strong engineering background, leveraging diverse background and risk managment experience to enhance investor financial analysis and data-driven decision-making in financial markets.","sameAs":["https:\/\/www.linkedin.com\/in\/andreipaulavets"],"url":"https:\/\/eodhd.com\/financial-academy\/author\/andrew-eodhd"}]}},"jetpack_featured_media_url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Google_Sheets_Dashboard.png","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-1mo","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5232","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/comments?post=5232"}],"version-history":[{"count":38,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5232\/revisions"}],"predecessor-version":[{"id":5315,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5232\/revisions\/5315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media\/5266"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=5232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=5232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=5232"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=5232"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=5232"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=5232"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=5232"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=5232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}