{"id":5390,"date":"2024-03-31T06:26:52","date_gmt":"2024-03-31T06:26:52","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=5390"},"modified":"2024-07-31T05:44:16","modified_gmt":"2024-07-31T05:44:16","slug":"microsoft-excel-stock-market-dashboard","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard","title":{"rendered":"Microsoft Excel Stock Market Dashboard"},"content":{"rendered":"\n<p>Microsoft Excel provides a powerful platform for building custom financial dashboards and analysis tools. By creating a Stock Market Dashboard in Excel with the EODHD Financial APIs, you can make a robust spreadsheet that pulls in real-time historical and current market data.<\/p>\n\n\n\n<p>This tutorial will walk through importing stock data from EODHD into Excel, 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>Download our Excel Stock Market Dashboard Template to follow the article:<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-010b6a6e-fcb2-412f-80f1-0b55c4b5e74b\" href=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/EODHD_Stock_Dashboard.xlsm\">EODHD_Stock_Dashboard<\/a><a href=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/EODHD_Stock_Dashboard.xlsm\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-010b6a6e-fcb2-412f-80f1-0b55c4b5e74b\">Download<\/a><\/div>\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 class=\"has-text-align-left\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-connecting-excel-to-the-eodhd-api\">Connecting Excel to the EODHD API<\/h2>\n\n\n\n<p>Using the EODHD API requires registering for an API key. However, you can follow along with this article using the &#8216;demo&#8217; key for the tickers AAPL, MSFT, TSLA, and MCD.<\/p>\n\n\n\n<p>To import data from the EODHD API into Excel, we&#8217;ll use the <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4\" target=\"_blank\" rel=\"noreferrer noopener\">WEBSERVICE <\/a>function. This allows fetching data from a URL directly into cells.<\/p>\n\n\n\n<p>In a new Excel spreadsheet, enter the following formula to pull in the list of supported stock <a href=\"https:\/\/eodhd.com\/financial-apis\/exchanges-api-list-of-tickers-and-trading-hours\/\" target=\"_blank\" rel=\"noreferrer noopener\">exchanges<\/a>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=WEBSERVICE(\"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 EODHD API key. This will populate the sheet with a JSON array of the exchange data. You can change &#8220;&amp;fmt=json&#8221; to &#8220;&amp;fmt=csv&#8221; to get the data in CSV format instead.<\/p>\n\n\n\n<p>WEBSERVICE function loads all the data in one cell, for one value this function would be sufficient. However, for a list of values, it&#8217;s better to transform the data using <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7\" target=\"_blank\" rel=\"noreferrer noopener\">TEXTSPLIT<\/a> and <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027\" target=\"_blank\" rel=\"noreferrer noopener\">TRANSPOSE<\/a> functions. An example of the cell formula is the following:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=TEXTSPLIT(WEBSERVICE(\"https:\/\/eodhd.com\/api\/exchanges-list\/?api_token=YOUR_API_KEY&amp;fmt=json\"),\":\",\",\")<\/pre>\n\n\n\n<p>Similar to get the <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\">stock ticker list<\/a> for a specific exchange, like the US market (code &#8220;US&#8221;):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=WEBSERVICE(\"https:\/\/eodhd.com\/api\/exchange-symbol-list\/US?api_token=YOUR_API_KEY&amp;fmt=json\")<\/pre>\n\n\n\n<p>This returns all active US stocks and ETFs in JSON format.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1234\" height=\"622\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Proccess_Lists_Excel_Market_Dashboard.gif\" alt=\"\" class=\"wp-image-5408\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-importing-historical-eod-data\">Importing Historical EOD Data<\/h3>\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 price<\/a> data for a stock, use this formula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=WEBSERVICE(\"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>Adjust the ticker symbol, date range, and API key as needed. This will pull in the daily OHLCV data for Apple between the specified dates.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-getting-live-delayed-stock-quotes\">Getting live (Delayed) Stock Quotes<\/h3>\n\n\n\n<p>The EODHD API provides <a href=\"https:\/\/eodhd.com\/financial-apis\/live-realtime-stocks-api\/\" target=\"_blank\" rel=\"noreferrer noopener\">a live endpoint<\/a> for fetching delayed price quotes. In a new sheet, enter:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=WEBSERVICE(\"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 gets the current trading price for AAPL. The &#8220;&amp;filter=close&#8221; parameter returns only the last price. Remove the filter to get the full OHLCV quote.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-creating-a-treemap-chart-in-excel\">Creating a Treemap Chart in Excel<\/h2>\n\n\n\n<p>A treemap chart is the best way to visualize hierarchical data, allowing you to spot patterns and compare proportions. In a stock market context, it&#8217;s often used to show the relative market capitalizations of companies within a sector or index.<\/p>\n\n\n\n<p>To create a treemap of the largest stocks in a market:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set up a table with 4 columns:\n<ul class=\"wp-block-list\">\n<li>Tickers: The stock symbols<\/li>\n\n\n\n<li>Market Cap: The market capitalization in dollars<\/li>\n\n\n\n<li>Change (%): The daily percent change<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>To get the market cap, use the <a href=\"https:\/\/eodhd.com\/financial-apis\/stock-etfs-fundamental-data-feeds\/\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD Fundamentals API<\/a> with the filter parameter set to &#8220;Highlights::MarketCapitalization&#8221;:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\">=WEBSERVICE(\"https:\/\/eodhd.com\/api\/fundamentals\/AAPL?api_token=YOUR_API_TOKEN&amp;fmt=json&amp;filter=Highlights::MarketCapitalization\")<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>For the daily percent change, use the Live API with &#8220;&amp;filter=change_p&#8221;:<\/li>\n\n<\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\">=VALUE(WEBSERVICE(\"https:\/\/eodhd.com\/api\/real-time\/\"&amp;B50&amp;\"?api_token=\"&amp;$B$2&amp;\"&amp;fmt=json&amp;&amp;filter=change_p\"))<\/pre>\n\n\n\n<p>Here, we used the function <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2\" target=\"_blank\" rel=\"noreferrer noopener\">VALUE<\/a> to extract values from the text data received from the API. Later the data will be used in charts.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Select the data table and go to Insert &gt; Charts &gt; Treemap.<\/li>\n\n\n<li>Apply filter to the range(Since there is only a sequential gradient color rule for Treemap charts):\n\n<ul class=\"wp-block-list\">\n\n<li>Select filtered cells<\/li>\n\n\n<li>Home&gt;Sort&amp;Filter&gt;Filter<\/li>\n\n\n<li>Sort by the change column, it&#8217;ll create a gradient color for the treemap based on the current stock price change.<\/li>\n\n<\/ul>\n\n<\/li>\n\n\n<li>Customize the chart labels, colors, and styles as desired.<\/li>\n\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1234\" height=\"622\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Treemap_Chart_Excel_Market_Dashboard.gif\" alt=\"\" class=\"wp-image-5409\"\/><\/figure>\n\n\n\n<p>The result will be an interactive treemap showing the largest companies, sized by market cap and colored by their performance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-sparklines-charts-and-other-visualizations\">Sparklines, Charts, and Other Visualizations<\/h2>\n\n\n\n<p>To create charts from EODHD data:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Import the data into a table using the WEBSERVICE function and the appropriate API endpoint (EOD, Intraday, Fundamentals, etc.) on a separate sheet.<\/li>\n\n\n\n<li>Select the data you want to chart<\/li>\n\n\n\n<li>Go to Insert &gt; Charts and choose the desired chart type, or select a sparkline.<\/li>\n\n\n\n<li>Customize the chart title, axis labels, series names, and formatting<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1164\" height=\"922\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/SparklineExcel_Market_Dashboard.gif\" alt=\"\" class=\"wp-image-5410\"\/><\/figure>\n\n\n\n<p>With the raw market data imported, you can create an assortment of charts and visualizations in Excel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use Insert &gt; Sparklines &gt; line to generate inline price charts in individual cells<\/li>\n\n\n\n<li>Traded volume pie chart<\/li>\n\n\n\n<li>Histogram of the daily change in % <\/li>\n<\/ul>\n\n\n\n<p>The EODHD API provides a wide variety of fundamental, event-driven, and sentiment data you can incorporate to build a rich, interactive dashboard.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-getting-started\">Getting Started<\/h2>\n\n\n\n<p>Sign up for an EODHD API key to get started building your own best Excel trading dashboard today. Feel free to contact our support team at <a href=\"mailto:support@eodhistoricaldata.com\" target=\"_blank\" rel=\"noreferrer noopener\">support@eodhistoricaldata.com<\/a> for any questions or current discount offers. We&#8217;re happy to assist you through the process of leveraging EODHD&#8217;s data to elevate your investment workflow.<\/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>Microsoft Excel provides a powerful platform for building custom financial dashboards and analysis tools. By creating a Stock Market Dashboard in Excel with the EODHD Financial APIs, you can make a robust spreadsheet that pulls in real-time historical and current market data. This tutorial will walk through importing stock data from EODHD into Excel, setting [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":5404,"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,77,42,48],"tags":[91,85,82],"coding-language":[],"ready-to-go-solution":[],"qualification":[],"financial-apis-category":[],"financial-apis-manuals":[73,57,37],"class_list":["post-5390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-get-stocks-data-examples","category-portfolio-performance-examples","category-stocks-data-analysis-examples","category-stocks-data-processing-examples","tag-best-financial-api","tag-financial-data-spreadsheets","tag-market-dashboard","financial-apis-manuals-live-delayed-15-mins","financial-apis-manuals-real-time","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>Microsoft Excel Stock Market Dashboard | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"How to build a Best Excel Stock Market Dashboard using the live data from Financial API. Download our Free Dashboard Template.\" \/>\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\/microsoft-excel-stock-market-dashboard\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel Stock Market Dashboard\" \/>\n<meta property=\"og:description\" content=\"How to build a Best Excel Stock Market Dashboard using the live data from Financial API. Download our Free Dashboard Template.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard\" \/>\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-31T06:26:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-31T05:44:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"963\" \/>\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=\"5 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\/microsoft-excel-stock-market-dashboard#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard\"},\"author\":{\"name\":\"Andrei Paulavets\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\"},\"headline\":\"Microsoft Excel Stock Market Dashboard\",\"datePublished\":\"2024-03-31T06:26:52+00:00\",\"dateModified\":\"2024-07-31T05:44:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard\"},\"wordCount\":822,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png\",\"keywords\":[\"Best Financial API\",\"financial data spreadsheets\",\"Market Dashboard\"],\"articleSection\":[\"How to Get Stocks Data Examples\",\"Portfolio Performance Examples\",\"Stocks Data Analysis Examples\",\"Stocks Data Processing Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard\",\"name\":\"Microsoft Excel Stock Market Dashboard | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png\",\"datePublished\":\"2024-03-31T06:26:52+00:00\",\"dateModified\":\"2024-07-31T05:44:16+00:00\",\"description\":\"How to build a Best Excel Stock Market Dashboard using the live data from Financial API. Download our Free Dashboard Template.\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png\",\"width\":1920,\"height\":963},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel Stock Market Dashboard\"}]},{\"@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":"Microsoft Excel Stock Market Dashboard | EODHD APIs Academy","description":"How to build a Best Excel Stock Market Dashboard using the live data from Financial API. Download our Free Dashboard Template.","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\/microsoft-excel-stock-market-dashboard","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel Stock Market Dashboard","og_description":"How to build a Best Excel Stock Market Dashboard using the live data from Financial API. Download our Free Dashboard Template.","og_url":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2024-03-31T06:26:52+00:00","article_modified_time":"2024-07-31T05:44:16+00:00","og_image":[{"width":1920,"height":963,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard"},"author":{"name":"Andrei Paulavets","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e"},"headline":"Microsoft Excel Stock Market Dashboard","datePublished":"2024-03-31T06:26:52+00:00","dateModified":"2024-07-31T05:44:16+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard"},"wordCount":822,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png","keywords":["Best Financial API","financial data spreadsheets","Market Dashboard"],"articleSection":["How to Get Stocks Data Examples","Portfolio Performance Examples","Stocks Data Analysis Examples","Stocks Data Processing Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard","url":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard","name":"Microsoft Excel Stock Market Dashboard | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png","datePublished":"2024-03-31T06:26:52+00:00","dateModified":"2024-07-31T05:44:16+00:00","description":"How to build a Best Excel Stock Market Dashboard using the live data from Financial API. Download our Free Dashboard Template.","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#primaryimage","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/03\/Excel_Market_Dashboard.png","width":1920,"height":963},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/stocks-data-processing-examples\/microsoft-excel-stock-market-dashboard#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel Stock Market Dashboard"}]},{"@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\/Excel_Market_Dashboard.png","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-1oW","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5390","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=5390"}],"version-history":[{"count":8,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5390\/revisions"}],"predecessor-version":[{"id":5415,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5390\/revisions\/5415"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media\/5404"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=5390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=5390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=5390"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=5390"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=5390"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=5390"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=5390"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=5390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}