{"id":5574,"date":"2024-05-13T10:33:09","date_gmt":"2024-05-13T10:33:09","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=5574"},"modified":"2024-07-24T05:05:24","modified_gmt":"2024-07-24T05:05:24","slug":"financial-statement-analysis-with-google-sheets","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets","title":{"rendered":"Financial Statement Analysis with Google Sheets"},"content":{"rendered":"\n<p>Analyzing a company&#8217;s financial statements is essential for investors and finance professionals to assess corporate performance and health. While this process can be complex, Financial Statement Analysis in Google Sheets powered by dynamic <a href=\"https:\/\/eodhd.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">EODHD APIs<\/a> is much more efficient.<\/p>\n\n\n\n<p>In this guide, we&#8217;ll walk through how to build a Google Sheets template that pulls key financial statement data from EODHD&#8217;s APIs, allowing you to analyze any public company&#8217;s financials. EODHD provides simple JSON APIs covering fundamentals, stock prices, 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\/13hVTd-G_TU72zeDP06vG7WQwWmL8Dk2JNucZUd04D8k\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Financial Analysis Google Sheets Template<\/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 spreadsheet cell from an API is a &#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\/stock-etfs-fundamental-data-feeds\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fundamentals API<\/a> to retrieve the financial statement figures for your chosen stock:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=ARRAYFORMULA(SUBSTITUTE(ARRAYFORMULA(SUBSTITUTE(ARRAYFORMULA(SUBSTITUTE(INDEX(SPLIT(TRANSPOSE(IMPORTDATA(\"https:\/\/eodhd.com\/api\/fundamentals\/\"&amp;$B$5&amp;\"?api_token=\"&amp;$B$3&amp;\"&amp;filter=Financials::\"&amp;$B$9&amp;\"::yearly::\"&amp;TEXT($B$7,\"YYYY-MM-DD\"))), \":\"),,2), \"\"\"\", \"\")),\"}\",\"\")),\"{\",\"\"))<\/pre>\n\n\n\n<p>Here&#8217;s how it works step by step:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3094139?hl=en\" target=\"_blank\" rel=\"noreferrer noopener\">TEXT<\/a>($B$7,&#8221;YYYY-MM-DD&#8221;): This part formats the date in the cell $B$7 as &#8220;YYYY-MM-DD&#8221;. This formatted date is then used in the API request.<\/li>\n\n\n\n<li><em>&#8220;https:\/\/eodhd.com\/api\/fundamentals\/&#8221;&amp;$B$5&amp;&#8221;?api_token=&#8221;&amp;$B$3&amp;&#8221;&amp;filter=Financials::&#8221;&amp;$B$9&amp;&#8221;::yearly::&#8221;&amp;TEXT($B$7,&#8221;YYYY-MM-DD&#8221;)<\/em>: This part constructs the URL for the <a href=\"https:\/\/eodhd.com\/financial-apis\/stock-etfs-fundamental-data-feeds\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fundamentals API<\/a> request. It concatenates various parameters:\n<ul class=\"wp-block-list\">\n<li>$B$5 contains the ticker symbol.<\/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\n\n\n<li>$B$9 contains the type of financial statement (Balance Sheet, Income Statement, Cash Flow).<\/li>\n\n\n\n<li>TEXT($B$7,&#8221;YYYY-MM-DD&#8221;) provides the date of filing.<\/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\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3094262?hl=en&amp;sjid=14796491918837278708-EU\" target=\"_blank\" rel=\"noreferrer noopener\">TRANSPOSE<\/a>: This function transposes the imported data, making it easier to manipulate.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3094136?hl=en&amp;sjid=14796491918837278708-EU\" target=\"_blank\" rel=\"noreferrer noopener\">SPLIT<\/a>: This function splits the transposed data into columns based on the colon &#8220;:&#8221; delimiter.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3098242?hl=en&amp;sjid=14796491918837278708-EU\" target=\"_blank\" rel=\"noreferrer noopener\">INDEX<\/a>(&#8230;,,2): This function indexes only the second column of the split data, extracting the values. For the names of raws, you need to use the first column.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3094215?hl=en&amp;sjid=14796491918837278708-EU\" target=\"_blank\" rel=\"noreferrer noopener\">SUBSTITUTE<\/a>: This function removes any quotes (&#8220;) from the extracted values, making them clean.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/3093275?hl=en&amp;sjid=14796491918837278708-EU\" target=\"_blank\" rel=\"noreferrer noopener\">ARRAYFORMULA<\/a>: This function enables the use of array operations, allowing the formula to apply operations to entire ranges of data.<\/li>\n\n\n\n<li>The formula repeats the SUBSTITUTE operation multiple times (three times in total) to ensure all quotes are removed. The formula removes any remaining curly braces {} and &#8221; using SUBSTITUTE.<\/li>\n<\/ul>\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\/Fundamental_Analysis_Filings.gif\" alt=\"Financial Statement Analysis with Google Sheets\" class=\"wp-image-5592\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-add-ratios\">Add Ratios<\/h2>\n\n\n\n<p>There are several ways to calculate ratios or metrics to show the trend in financial statements over the period.<\/p>\n\n\n\n<p><strong>Year-over-Year (<a href=\"https:\/\/www.wallstreetprep.com\/knowledge\/year-over-year-yoy\/\" target=\"_blank\" rel=\"noreferrer noopener\">YoY<\/a>) Growth Rate:<\/strong> Calculate the percentage change in earnings from one year to the next. For example:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">2023 vs 2022: (27195000000 - 24512000000) \/ 24512000000 = 10.95%<\/pre>\n\n\n\n<p>Then duplicate the formula over the number of periods required. The template has 4 years, you can monitor the change over longer periods depending on your analysis time horizon.<\/p>\n\n\n\n<p><strong>Compound Annual Growth Rate (<a href=\"https:\/\/www.investopedia.com\/terms\/c\/cagr.asp\" target=\"_blank\" rel=\"noreferrer noopener\">CAGR<\/a>):<\/strong> Calculate the average annual growth rate over the entire period. For example: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CAGR = (Ending Value \/ Beginning Value)^(1 \/ Number of Years) - 1 CAGR = (27195000000 \/ 19269000000)^(1 \/ 3) - 1 = 12.19%<\/pre>\n\n\n\n<p>These ratios help demonstrate the trend in financials over the period. The YoY Growth Rate shows the year-to-year changes, the CAGR represents the average annual growth rate.<\/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\/Fundamental_Analysis_YoY_CAGR.gif\" alt=\"\" class=\"wp-image-5593\"\/><\/figure>\n\n\n\n<p>To pull in the current recalculated ratios from the Fundamentals API, use the following cell formula with the <a href=\"https:\/\/eodhd.com\/financial-apis\/stock-etfs-fundamental-data-feeds\/\" target=\"_blank\" rel=\"noreferrer noopener\">Fundamental API call<\/a> and the &#8220;Highlights&#8221; filter field:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=TRANSPOSE(ARRAYFORMULA(SUBSTITUTE(ARRAYFORMULA(SUBSTITUTE(ARRAYFORMULA(SUBSTITUTE(INDEX(SPLIT(TRANSPOSE(IMPORTDATA(\"https:\/\/eodhd.com\/api\/fundamentals\/\"&amp;$B$5&amp;\"?api_token=\"&amp;$B$3&amp;\"&amp;filter=Highlights\")), \":\"),,2), \"\"\"\", \"\")),\"}\",\"\")),\"{\",\"\")))<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-add-sparkline-cell-charts\">Add sparkline cell charts<\/h2>\n\n\n\n<p>Utilizing sparklines in fundamental analysis provides valuable insights into the fluctuations within filings. It&#8217;s crucial to delve deeper into the values that have experienced significant changes over the specified period. An example of cell formula:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SPARKLINE(G13:G73)<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1254\" height=\"324\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/image-12.png\" alt=\"\" class=\"wp-image-5594\"\/><\/figure>\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()<\/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>Analyzing a company&#8217;s financial statements is essential for investors and finance professionals to assess corporate performance and health. While this process can be complex, Financial Statement Analysis in Google Sheets powered by dynamic EODHD APIs is much more efficient. In this guide, we&#8217;ll walk through how to build a Google Sheets template that pulls key [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":5590,"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,42],"tags":[91,85,83],"coding-language":[],"ready-to-go-solution":[58],"qualification":[31,33],"financial-apis-category":[],"financial-apis-manuals":[37],"class_list":["post-5574","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-analysis-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-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>Financial Statement Analysis with Google Sheets | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"Financial Statement Analysis with Google Spreadsheets, get your own Free Google Sheets financial statement 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\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Financial Statement Analysis with Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Financial Statement Analysis with Google Spreadsheets, get your own Free Google Sheets financial statement template.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-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-05-13T10:33:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-24T05:05:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1846\" \/>\n\t<meta property=\"og:image:height\" content=\"861\" \/>\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\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets\"},\"author\":{\"name\":\"Andrei Paulavets\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\"},\"headline\":\"Financial Statement Analysis with Google Sheets\",\"datePublished\":\"2024-05-13T10:33:09+00:00\",\"dateModified\":\"2024-07-24T05:05:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets\"},\"wordCount\":863,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png\",\"keywords\":[\"Best Financial API\",\"financial data spreadsheets\",\"Google sheets portfolio\"],\"articleSection\":[\"Fundamental Analysis Examples\",\"How to Get Stocks Data Examples\",\"Stocks Data Analysis Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets\",\"name\":\"Financial Statement Analysis with Google Sheets | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png\",\"datePublished\":\"2024-05-13T10:33:09+00:00\",\"dateModified\":\"2024-07-24T05:05:24+00:00\",\"description\":\"Financial Statement Analysis with Google Spreadsheets, get your own Free Google Sheets financial statement template.\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png\",\"width\":1846,\"height\":861},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financial Statement Analysis with 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":"Financial Statement Analysis with Google Sheets | EODHD APIs Academy","description":"Financial Statement Analysis with Google Spreadsheets, get your own Free Google Sheets financial statement 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\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets","og_locale":"en_US","og_type":"article","og_title":"Financial Statement Analysis with Google Sheets","og_description":"Financial Statement Analysis with Google Spreadsheets, get your own Free Google Sheets financial statement template.","og_url":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2024-05-13T10:33:09+00:00","article_modified_time":"2024-07-24T05:05:24+00:00","og_image":[{"width":1846,"height":861,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.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\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets"},"author":{"name":"Andrei Paulavets","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e"},"headline":"Financial Statement Analysis with Google Sheets","datePublished":"2024-05-13T10:33:09+00:00","dateModified":"2024-07-24T05:05:24+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets"},"wordCount":863,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png","keywords":["Best Financial API","financial data spreadsheets","Google sheets portfolio"],"articleSection":["Fundamental Analysis Examples","How to Get Stocks Data Examples","Stocks Data Analysis Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets","url":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets","name":"Financial Statement Analysis with Google Sheets | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png","datePublished":"2024-05-13T10:33:09+00:00","dateModified":"2024-07-24T05:05:24+00:00","description":"Financial Statement Analysis with Google Spreadsheets, get your own Free Google Sheets financial statement template.","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#primaryimage","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2024\/05\/Fundamental_Analysis.png","width":1846,"height":861},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/fundamental-analysis-examples\/financial-statement-analysis-with-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"Financial Statement Analysis with 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\/05\/Fundamental_Analysis.png","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-1rU","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5574","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=5574"}],"version-history":[{"count":11,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5574\/revisions"}],"predecessor-version":[{"id":5796,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/5574\/revisions\/5796"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media\/5590"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=5574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=5574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=5574"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=5574"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=5574"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=5574"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=5574"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=5574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}