{"id":5601,"date":"2024-05-13T10:34:25","date_gmt":"2024-05-13T10:34:25","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=5601"},"modified":"2024-05-17T21:12:50","modified_gmt":"2024-05-17T21:12:50","slug":"google-sheets-dividend-tracker","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker","title":{"rendered":"Google Sheets Dividend Tracker"},"content":{"rendered":"\n<p>Monitoring a company&#8217;s dividend payments is crucial for income investors seeking to maximize their returns. While tracking dividends across multiple holdings can be time-consuming, the Google Sheets Dividend Tracker, powered by dynamic <a href=\"https:\/\/eodhd.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD APIs<\/a>, simplifies the process.<\/p>\n\n\n\n<p>In this guide, we&#8217;ll walk through how to build a Google Sheets Dividend Tracker Template that pulls key data from EODHD&#8217;s APIs, allowing you to track dividends for any public company. EODHD provides simple JSON APIs covering dividend payments, yields, ex-dates, and more for 150,000+ tickers across 70+ worldwide exchanges.<\/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>You can also check our template libraries with step-by-step guides for <a href=\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/excel-templates-for-market-analysis\" target=\"_blank\" rel=\"noreferrer noopener\">Excel <\/a>and <a href=\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-templates-for-market-analysis\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets <\/a>spreadsheets. 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>Check our Financial Analysis Google Sheets Template to follow the article:<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1EuBWYb8xuHwVc6bmPZu1-VMoxUaeTgAPdXakUg_l1Ng\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a><\/p>\n\n\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-sign-up-for-eodhd-and-get-your-api-key\">Sign up for EODHD and get your API key<\/h2>\n\n\n\n<p>Register for a free EODHD account at&nbsp;<a href=\"https:\/\/eodhd.com\/register\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/eodhd.com\/register<\/a>&nbsp;to receive your API key. The free plan allows 20 API requests\/day and 1 year of EOD historical data. Paid plans starting at <a href=\"https:\/\/eodhd.com\/pricing\" target=\"_blank\" rel=\"noreferrer noopener\">$19.99\/month<\/a> enable more API calls and access to 30+ years of data.<\/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 follow the article and test the basic <a href=\"https:\/\/eodhd.com\/financial-apis\/quick-start-with-our-financial-data-apis\/\" target=\"_blank\" rel=\"noreferrer noopener\">functionality <\/a>of our APIs you can use our &#8220;demo&#8221; key. The key gives you access to the Fundamentals and Historical data for AAPL, TSLA, MSFT, and MCD tickers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-pull-in-data-from-eodhd-to-google-sheets\">Pull in data from EODHD to Google Sheets<\/h2>\n\n\n\n<p>The main tool to retrieve data into the Google Sheets Dividend Tracker Template cells from an API is the &#8220;=IMPORTDATA()&#8221; Google Sheets formula. By using the formula you can get access to all our Fundamental And Historical APIs. Thus, It is important to check the official <a href=\"https:\/\/support.google.com\/docs\/answer\/3093335?hl=en\" target=\"_blank\" rel=\"noreferrer noopener\">Google Sheets Documentation<\/a>.<\/p>\n\n\n\n<p>Use the <a href=\"https:\/\/eodhd.com\/financial-apis\/api-splits-dividends\" target=\"_blank\" rel=\"noreferrer noopener\">Historical Splits and Dividends API<\/a> to retrieve the dividends values over a certain period of time for your chosen stock:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>&#8220;https:\/\/eodhd.com\/api\/div\/&#8221;&amp;B7&amp;&#8221;?from=&#8221;&amp;TEXT(D7,&#8221;YYYY-MM-DD&#8221;)&amp;&#8221;&amp;to=&#8221;&amp;IF(E7=0, TEXT(TODAY(),&#8221;YYYY-MM-DD&#8221;),TEXT(E7,&#8221;YYYY-MM-DD&#8221;))&amp;&#8221;&amp;api_token=&#8221;&amp;$B$3: This part constructs the URL for the API request. It concatenates various parameters:\n<ul class=\"wp-block-list\">\n<li>B7 contains the ticker symbol.<\/li>\n\n\n\n<li>D7 contains the start date of the data range for dividends.<\/li>\n\n\n\n<li>E7 contains the end date of the data range for dividends. If E7 is zero (or blank), it uses today&#8217;s date.<\/li>\n\n\n\n<li>$B$3 contains an API key. To get full access please subscribe to one of <a href=\"https:\/\/eodhd.com\/pricing\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD&#8217;s monthly plans<\/a>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3093335?hl=en\" target=\"_blank\" rel=\"noreferrer noopener\">IMPORTDATA<\/a>: This function retrieves data from the specified URL.<\/li>\n<\/ol>\n\n\n\n<p>The URL constructed by the formula requests dividend data for a specific ticker symbol (B7) within a specified date range (D7 to E7, or from D7 to today&#8217;s date if E7 is zero) using an API token ($B$3).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1485\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker_Google_Sheets.gif\" alt=\"Google Sheets Dividends Tracker\" class=\"wp-image-5610\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-add-ratios-to-the-dividend-tracker\">Add Ratios to the Dividend Tracker<\/h2>\n\n\n\n<p>To calculate ratios for a specific period we need to pull data from the <a href=\"https:\/\/eodhd.com\/financial-apis\/api-splits-dividends\" target=\"_blank\" rel=\"noreferrer noopener\">Historical Dividend<\/a> and the <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\" target=\"_blank\" rel=\"noreferrer noopener\">End-of-Day historical API<\/a>. The Google Sheets cell formula for the Combined Dividend Payouts is the following:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUM(TRANSPOSE((INDEX(IMPORTDATA(\"https:\/\/eodhd.com\/api\/div\/\"&amp;B7&amp;\"?from=\"&amp;TEXT(D7,\"YYYY-MM-DD\")&amp;\"&amp;to=\"&amp;IF(E7=0, TEXT(TODAY(),\"YYYY-MM-DD\"),TEXT(E7,\"YYYY-MM-DD\"))&amp;\"&amp;api_token=\"&amp;$B$3),,2))))*C7<\/pre>\n\n\n\n<p> For the Combined Dividend Yield:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=(F7\/C7)\/INDEX(IMPORTDATA(\"https:\/\/eodhd.com\/api\/eod\/\"&amp;B7&amp;\"?from=\"&amp;TEXT(D7,\"YYYY-MM-DD\")&amp;\"&amp;to=\"&amp;TEXT(D7+10,\"YYYY-MM-DD\")&amp;\"&amp;api_token=\"&amp;$B$3&amp;\"&amp;filter=close&amp;fmt=csv\"),2,)<\/pre>\n\n\n\n<p>We need to use Fundamentals API for current ratios which will show precalculated ratios pulled straight from the EODHD platform. The cell formula for the Current Dividend\/Share:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/fundamentals\/\"&amp;B7&amp;\"?api_token=\"&amp;$B$3&amp;\"&amp;filter=Highlights::DividendYield\")<\/pre>\n\n\n\n<p>Current Dividend Yield:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/fundamentals\/\"&amp;B7&amp;\"?api_token=\"&amp;$B$3&amp;\"&amp;filter=Highlights::DividendShare\")<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1628\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker_Google_Sheets_Ratios.gif\" alt=\"\" class=\"wp-image-5613\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-add-sparklines-and-charts\">Add Sparklines and Charts<\/h2>\n\n\n\n<p>Sparklines could be used to demonstrate performance over time without uploading the preformatted data from the APIs into cells. Sparkline Cell formula for combined Yield:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SPARKLINE((INDEX(IMPORTDATA(\"https:\/\/eodhd.com\/api\/eod\/\"&amp;B7&amp;\"?from=\"&amp;TEXT(D7,\"YYYY-MM-DD\")&amp;\"&amp;to=\"&amp;IF(E7=0, TEXT(TODAY(),\"YYYY-MM-DD\"),TEXT(E7,\"YYYY-MM-DD\"))&amp;\"&amp;api_token=\"&amp;$B$3),,6)))<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1831\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker_Google_Sparklines.gif\" alt=\"\" class=\"wp-image-5614\" \/><\/figure>\n\n\n\n<p>Select the range and insert the chart to visualize historical performance or to compare the performance of the holdings against each other. It is better to locate historical data for a specific ticker on a newly created separate bookmark to have a clean dividend portfolio dashboard.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>With this template powered by EODHD&#8217;s APIs, you can quickly access and analyze the financials for any stock to uncover crucial insights. The EODHD platform offers:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Worldwide coverage: 150,000+ stocks, 20,000+ ETFs, 1000+ indices across 70+ exchanges<\/li>\n\n\n\n<li>Deep history: 30+ years of fundamentals and EOD pricing data<\/li>\n\n\n\n<li>Google Sheets-friendly: Simple APIs that work seamlessly with the IMPORTDATA() cell formula<\/li>\n\n\n\n<li>Low cost: Plans from $19.99\/month<\/li>\n<\/ul>\n\n\n\n<p>EODHD&#8217;s financial data APIs combined with Google Sheets&#8217; analysis capabilities provide a powerful yet accessible toolset for in-depth financial statement analysis. This templated approach streamlines the data gathering to let you focus on uncovering actionable insights to drive better investment decisions.<\/p>\n\n\n\n<p>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>Monitoring a company&#8217;s dividend payments is crucial for income investors seeking to maximize their returns. While tracking dividends across multiple holdings can be time-consuming, the Google Sheets Dividend Tracker, powered by dynamic EODHD APIs, simplifies the process. In this guide, we&#8217;ll walk through how to build a Google Sheets Dividend Tracker Template that pulls key [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":5606,"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,77,42,48],"tags":[91,85,83],"coding-language":[],"ready-to-go-solution":[58],"qualification":[31,33],"financial-apis-category":[],"financial-apis-manuals":[39,80],"class_list":["post-5601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-fundamental-analysis-examples","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-google-sheets-portfolio","ready-to-go-solution-google-sheets-add-in","qualification-experienced","qualification-newbie","financial-apis-manuals-end-of-day","financial-apis-manuals-splits-dividends","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>Google Sheets Dividend Tracker | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"Step-by-Step guide on how to create a personal Google Sheets dividend tracker spreadsheet. Find a link to a Free Template in an article.\" \/>\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\/fundamental-analysis-examples\/google-sheets-dividend-tracker\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets Dividend Tracker\" \/>\n<meta property=\"og:description\" content=\"Step-by-Step guide on how to create a personal Google Sheets dividend tracker spreadsheet. Find a link to a Free Template in an article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker\" \/>\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-05-13T10:34:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-17T21:12:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1855\" \/>\n\t<meta property=\"og:image:height\" content=\"866\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker\"},\"author\":{\"name\":\"Andrei Paulavets\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\"},\"headline\":\"Google Sheets Dividend Tracker\",\"datePublished\":\"2024-05-13T10:34:25+00:00\",\"dateModified\":\"2024-05-17T21:12:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker\"},\"wordCount\":755,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png\",\"keywords\":[\"Best Financial API\",\"financial data spreadsheets\",\"Google sheets portfolio\"],\"articleSection\":[\"Fundamental Analysis Examples\",\"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\/fundamental-analysis-examples\/google-sheets-dividend-tracker\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker\",\"name\":\"Google Sheets Dividend Tracker | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png\",\"datePublished\":\"2024-05-13T10:34:25+00:00\",\"dateModified\":\"2024-05-17T21:12:50+00:00\",\"description\":\"Step-by-Step guide on how to create a personal Google Sheets dividend tracker spreadsheet. Find a link to a Free Template in an article.\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png\",\"width\":1855,\"height\":866},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets Dividend Tracker\"}]},{\"@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":"Google Sheets Dividend Tracker | EODHD APIs Academy","description":"Step-by-Step guide on how to create a personal Google Sheets dividend tracker spreadsheet. Find a link to a Free Template in an article.","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\/fundamental-analysis-examples\/google-sheets-dividend-tracker","og_locale":"en_US","og_type":"article","og_title":"Google Sheets Dividend Tracker","og_description":"Step-by-Step guide on how to create a personal Google Sheets dividend tracker spreadsheet. Find a link to a Free Template in an article.","og_url":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2024-05-13T10:34:25+00:00","article_modified_time":"2024-05-17T21:12:50+00:00","og_image":[{"width":1855,"height":866,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker"},"author":{"name":"Andrei Paulavets","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e"},"headline":"Google Sheets Dividend Tracker","datePublished":"2024-05-13T10:34:25+00:00","dateModified":"2024-05-17T21:12:50+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker"},"wordCount":755,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png","keywords":["Best Financial API","financial data spreadsheets","Google sheets portfolio"],"articleSection":["Fundamental Analysis Examples","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\/fundamental-analysis-examples\/google-sheets-dividend-tracker","url":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker","name":"Google Sheets Dividend Tracker | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png","datePublished":"2024-05-13T10:34:25+00:00","dateModified":"2024-05-17T21:12:50+00:00","description":"Step-by-Step guide on how to create a personal Google Sheets dividend tracker spreadsheet. Find a link to a Free Template in an article.","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#primaryimage","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Dividend_Tracker.png","width":1855,"height":866},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/google-sheets-dividend-tracker#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"Google Sheets Dividend Tracker"}]},{"@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\/05\/Dividend_Tracker.png","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-1sl","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5601","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=5601"}],"version-history":[{"count":10,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5601\/revisions"}],"predecessor-version":[{"id":5625,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5601\/revisions\/5625"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media\/5606"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=5601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=5601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=5601"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=5601"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=5601"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=5601"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=5601"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=5601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}