{"id":3897,"date":"2023-11-22T23:13:37","date_gmt":"2023-11-22T23:13:37","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=3897"},"modified":"2024-05-06T00:29:44","modified_gmt":"2024-05-06T00:29:44","slug":"how-to-create-a-google-sheets-stock-portfolio","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio","title":{"rendered":"How to Create a Google Sheets Stock Portfolio Spreadsheet"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-stock-portfolio-spreadsheet\">Stock Portfolio Spreadsheet<\/h2>\n\n\n\n<p>Managing and tracking your investment portfolio is a crucial aspect of successful financial planning. While there are many sophisticated tools available for this purpose, creating a simple and personalized stock portfolio spreadsheet tracker in Google Sheets can offer a high level of customization and control. In this article, we will guide you through the process of building a portfolio tracker using APIs (Application Programming Interfaces) in Google Sheets. You are free to copy or download the template to navigate the article more easily here: <\/p>\n\n\n\n<p><strong><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/16Ubsf_U0doigyAs2QmAJF86F24MpsZFRt-Fc1KzaNnI\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">Download<\/a><\/strong><\/p>\n\n\n\n<p class=\"has-text-align-center\"><a class=\"maxbutton-1 maxbutton maxbutton-subscribe-to-api external-css btn\" href=\"https:\/\/eodhd.com\/register\"><span class='mb-text'>Register &amp; Get Data<\/span><\/a><\/p>\n\n\n\n\n\n\n\n<p>It&#8217;s worth checking our ready-to-use <a href=\"https:\/\/eodhd.com\/financial-apis\/google-sheets-financial-add-in-for-eod-fundamentals-data\/#Google_Sheets_Financial_Add-In\">EODHD Add-in for Google Sheets<\/a>, which could help you to get reliable information directly into your spreadsheet. If you are looking for an Excel portfolio tracker spreadsheet please check the following <a href=\"https:\/\/eodhd.com\/financial-academy\/stocks-data-analysis-examples\/excel-stock-portfolio-spreadsheet-how-to-build\/\">article<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-setting-up-financial-spreadsheet\">Setting Up Financial Spreadsheet<\/h2>\n\n\n\n<p>Google Sheets Start by opening a new <a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\">Google Sheets<\/a> spreadsheet and organizing it with the necessary columns. Common columns include &#8220;Ticker,&#8221; &#8220;Company Name,&#8221; &#8220;Quantity,&#8221; &#8220;Purchase Price,&#8221; &#8220;Current Price,&#8221; and &#8220;Market Value.&#8221; You can add additional columns based on your preferences, such as dividend yield, sector, or any other relevant information.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1286\" height=\"223\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png\" alt=\"Google Sheets Portfolio Tracker\" class=\"wp-image-3997\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-api-requests-for-dynamic-spreadsheets\">API Requests for Dynamic Spreadsheets<\/h2>\n\n\n\n<p>Now you have bones of the future portfolio tracker and you need to populate it with data. To create a dynamically updatable spreadsheet we will use Google Sheets&#8217; <a href=\"https:\/\/support.google.com\/docs\/table\/25273?hl=en\">functions<\/a> which call data using external URL requests. The most commonly used function is &#8216;=IMPORTDATA()&#8217;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"521\" height=\"211\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-13.png\" alt=\"IMPORTDATA for Financial data extraction\" class=\"wp-image-3998\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/eodhd.com\/financial-apis\/\">EODHD<\/a> provides all the necessary data you need to track your portfolio efficiently. In the article, we will be using a couple of them to give you the basics of working with EODHD APIs:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/eodhd.com\/financial-apis\/live-realtime-stocks-api\/\">Live API<\/a><\/strong> &#8211; to dynamically track today&#8217;s change of the stock<\/li>\n\n\n\n<li><a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\"><strong>End-of-Day API<\/strong><\/a> &#8211; to plot stock price performance<\/li>\n\n\n\n<li><strong><a href=\"https:\/\/eodhd.com\/financial-apis\/stock-etfs-fundamental-data-feeds\/\">Fundamentals API<\/a> <\/strong>&#8211; to get fundamental ratios<\/li>\n<\/ul>\n\n\n\n<p>We recommend you register a free account to get free access to some of our APIs: <a href=\"https:\/\/eodhd.com\/register\">https:\/\/eodhd.com\/register<\/a><\/p>\n\n\n\n<p>To get full access necessary for a proper stock analysis you can subscribe to our packages here: <a href=\"https:\/\/eodhd.com\/pricing\">https:\/\/eodhd.com\/pricing<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-working-with-api-requests\">Working with API requests<\/h2>\n\n\n\n<p>To get the needed data efficiently you need to visit a documentation page of the API. There you can understand how requests and received data are structured.<\/p>\n\n\n\n<p>For <a href=\"https:\/\/eodhd.com\/financial-apis\/live-realtime-stocks-api\/\">live API<\/a> you can open the link and browse the page to find necessary information. It&#8217;s important to understand the functionality and potential output of the API to implement it effectively.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1430\" height=\"778\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/LiveDoc.gif\" alt=\"How to use Financial APIs\" class=\"wp-image-4000\" \/><\/figure>\n\n\n\n<p>To insert the live data into the cell we will use the following function:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/real-time\/\"&amp;B11&amp;\".\"&amp;$C$8&amp;\"?api_token=\"&amp;$C$5&amp;\"&amp;fmt=json&amp;filter=close\")<\/pre>\n\n\n\n<p>Note that in the function we use cell values to get ticker (B11), market ($C$8), and API token information ($C$5). The URL itself contains a filter parameter &#8220;&amp;filter=close&#8221; which will limit the output for the Live API to close price only. &#8220;&amp;fmt=json&#8221; URL parameter sets output in JSON, for live data we can also choose CSV, however, in this case, we have cleaner data with JSON output.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1468\" height=\"778\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/SheetsDoc.gif\" alt=\"Importdata for live stock prices\" class=\"wp-image-4003\" \/><\/figure>\n\n\n\n<p>You can find your API token on your <a href=\"https:\/\/eodhd.com\/cp\/settings\">Settings <\/a>page after the registration. You can also use a &#8220;demo&#8221; token to get data for AAPL, MSFT, AMZN, and TSLA tickers. The spreadsheet used a demo token you can change it on yours.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-plot-stock-performance-using-historical-data\">Plot Stock Performance Using Historical Data<\/h2>\n\n\n\n<p>Having a price chart always helps to get a better understanding of sporting trends, to get Historical data for the line chart we will use the <a href=\"https:\/\/eodhd.com\/financial-apis\/api-for-historical-data-and-volumes\/\">End-of-Day API<\/a>. You can find an example on a Price Chart bookmark of the <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/16Ubsf_U0doigyAs2QmAJF86F24MpsZFRt-Fc1KzaNnI\/edit?usp=sharing\">template <\/a>spreadsheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1468\" height=\"778\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/PlotDoc.gif\" alt=\"IMPORTDATA for historical stock prices, how to plot data\" class=\"wp-image-4004\" \/><\/figure>\n\n\n\n<p>Here price chart is generated on selected stock from your portfolio from the time it was bought. <\/p>\n\n\n\n<p>To insert historical data for the plot into table we will use the following function:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=IMPORTDATA(\"https:\/\/eodhd.com\/api\/eod\/\"&amp;$B$3&amp;\".\"&amp;Portfolio!$C$8&amp;\"?api_token=\"&amp;Portfolio!$C$5&amp;\"&amp;fmt=csv&amp;filter=adjusted_close&amp;from=\"&amp;TEXT($C$3,\"YYYY-MM-DD\")&amp;\"&amp;period=d\")<\/pre>\n\n\n\n<p>Here we also use cell values for ticker($B$3), market(Portfolio!$C$8&amp;), and API token(Portfolio!$C$5). However, for the price range, we need to get a date from the cell in the proper format for this we use the &#8216;TEXT($C$3,&#8221;YYYY-MM-DD&#8221;)&#8217; function.<\/p>\n\n\n\n<p>For the stock selected, we used &#8216;<a href=\"https:\/\/support.google.com\/docs\/answer\/186103?hl=en&amp;co=GENIE.Platform%3DDesktop\">Dropdown<\/a>&#8216; menu from the range, and for the automatically updated date used &#8216;<a href=\"https:\/\/support.google.com\/docs\/answer\/3093318?hl=en\">VLOOKUP<\/a>&#8216; function.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1468\" height=\"778\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/PlotDoc2.gif\" alt=\"\" class=\"wp-image-4005\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-financail-ratios-data\">Financail Ratios Data<\/h2>\n\n\n\n<p>One of the core principles of fundamental investing is the analysis of corporate financial <a href=\"https:\/\/eodhd.com\/financial-academy\/financial-faq\/historical-financial-ratios-how-to-calculate\/\">ratios<\/a>. In the spreadsheet, we are using <a href=\"https:\/\/eodhd.com\/financial-apis\/stock-etfs-fundamental-data-feeds\/\">Fundamental API<\/a> to get core analytical data for the portfolio&#8217;s stocks.<\/p>\n\n\n\n<p>To insert fundamental data into the spreadsheet we will use the following function:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=TRANSPOSE(IMPORTDATA(\"https:\/\/eodhd.com\/api\/fundamentals\/\"&amp;$B$3&amp;\".\"&amp;Portfolio!$C$8&amp;\"?api_token=\"&amp;Portfolio!$C$5&amp;\"&amp;filter=Highlights\"))<\/pre>\n\n\n\n<p>As previously we cell values for ticker($B$3), market(Portfolio!$C$8&amp;), and API token(Portfolio!$C$5). In this case, we also need to use the &#8216;<a href=\"https:\/\/support.google.com\/docs\/answer\/3094262?hl=en\">TRANSPOSE<\/a>&#8216; Google Sheets function to get the data into the column instead of a line.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1468\" height=\"778\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/FundDoc.gif\" alt=\"TRANSPOSE and IMPORTDATA with the Fundamental Financial Data\" class=\"wp-image-4007\" \/><\/figure>\n\n\n\n<p>For the ratios on the main &#8216;Portfolio&#8217; page, we use Google&#8217;s &#8216;SUM&#8217; function and algebraic operations supported by the spreadsheet. You can check it by clicking on the cells.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-add-new-tickers\">Add New Tickers<\/h2>\n\n\n\n<p>To add new tickers you need to poot the ticker code into the left cell of the portfolio table, add the purchase date and the stock price of the transaction.<\/p>\n\n\n\n<p>After you need to simply drag previous cells down and all ratios and current data will be updated in an instance. You can see how it&#8217;s done below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1485\" height=\"802\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/AddStockDoc.gif\" alt=\"Template of the stock portfolio spreadsheet in Google sheets\" class=\"wp-image-4008\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>By combining the power of Google Sheets and financial APIs, based on our spreadsheet <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/16Ubsf_U0doigyAs2QmAJF86F24MpsZFRt-Fc1KzaNnI\/edit?usp=sharing\">template<\/a> you can create a personalized portfolio tracker that suits your specific needs. This approach allows you to stay informed about your investments in real time and empowers you with the flexibility to customize and expand your tracker as needed.<\/p>\n\n\n\n<p>Feel free to contact support to ask for the current discounts, we would be more than happy to assist and guide you through the process.<\/p>\n\n\n\n<p><a href=\"mailto:support@eodhistoricaldata.com\">support@eodhistoricaldata.com<\/a><\/p>\n\n\n\n<p class=\"has-text-align-center\"><a class=\"maxbutton-1 maxbutton maxbutton-subscribe-to-api external-css btn\" href=\"https:\/\/eodhd.com\/register\"><span class='mb-text'>Register &amp; Get Data<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Stock Portfolio Spreadsheet Managing and tracking your investment portfolio is a crucial aspect of successful financial planning. While there are many sophisticated tools available for this purpose, creating a simple and personalized stock portfolio spreadsheet tracker in Google Sheets can offer a high level of customization and control. In this article, we will guide you [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"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":[77,42],"tags":[],"coding-language":[],"ready-to-go-solution":[58],"qualification":[31,33],"financial-apis-category":[34,36],"financial-apis-manuals":[39,73,37],"class_list":["post-3897","post","type-post","status-publish","format-standard","hentry","category-portfolio-performance-examples","category-stocks-data-analysis-examples","ready-to-go-solution-google-sheets-add-in","qualification-experienced","qualification-newbie","financial-apis-category-crypto-market-prices","financial-apis-category-stock-market-prices","financial-apis-manuals-end-of-day","financial-apis-manuals-live-delayed-15-mins","financial-apis-manuals-stocks-fundamentals"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v26.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create a Google Sheets Stock Portfolio Spreadsheet | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"Free template and guide on how to build your own stock portfolio spreadsheet. You will learn how to use Financial APIs with Google Sheets.\" \/>\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\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Google Sheets Stock Portfolio Spreadsheet\" \/>\n<meta property=\"og:description\" content=\"Free template and guide on how to build your own stock portfolio spreadsheet. You will learn how to use Financial APIs with Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\" \/>\n<meta property=\"og:site_name\" content=\"Financial Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/eodhistoricaldata\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-22T23:13:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-06T00:29:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/09\/EODHD-Financial-Google-Sheets-Add-in.png\" \/>\n\t<meta property=\"og:image:width\" content=\"801\" \/>\n\t<meta property=\"og:image:height\" content=\"261\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Andrei Paulavets\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@EOD_data\" \/>\n<meta name=\"twitter:site\" content=\"@EOD_data\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrei Paulavets\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\"},\"author\":{\"name\":\"Andrei Paulavets\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\"},\"headline\":\"How to Create a Google Sheets Stock Portfolio Spreadsheet\",\"datePublished\":\"2023-11-22T23:13:37+00:00\",\"dateModified\":\"2024-05-06T00:29:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\"},\"wordCount\":951,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png\",\"articleSection\":[\"Portfolio Performance Examples\",\"Stocks Data Analysis Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\",\"name\":\"How to Create a Google Sheets Stock Portfolio Spreadsheet | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png\",\"datePublished\":\"2023-11-22T23:13:37+00:00\",\"dateModified\":\"2024-05-06T00:29:44+00:00\",\"description\":\"Free template and guide on how to build your own stock portfolio spreadsheet. You will learn how to use Financial APIs with Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png\",\"width\":1286,\"height\":223},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Google Sheets Stock Portfolio Spreadsheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/\",\"name\":\"Financial APIs Academy | EODHD\",\"description\":\"Financial Stock Market Academy\",\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eodhd.com\/financial-academy\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\",\"name\":\"EODHD (EOD Historical Data)\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/EODHD-Logo.png\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/12\/EODHD-Logo.png\",\"width\":159,\"height\":82,\"caption\":\"EODHD (EOD Historical Data)\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/eodhistoricaldata\",\"https:\/\/x.com\/EOD_data\",\"https:\/\/www.reddit.com\/r\/EODHistoricalData\/\",\"https:\/\/eod-historical-data.medium.com\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\",\"name\":\"Andrei Paulavets\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7ac21633a5988e5054e9edbe412f1f07957970ee6e9f6dbada15224224cdd2c9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7ac21633a5988e5054e9edbe412f1f07957970ee6e9f6dbada15224224cdd2c9?s=96&d=mm&r=g\",\"caption\":\"Andrei Paulavets\"},\"description\":\"Investment professional with a strong engineering background, leveraging diverse background and risk managment experience to enhance investor financial analysis and data-driven decision-making in financial markets.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/andreipaulavets\"],\"url\":\"https:\/\/eodhd.com\/financial-academy\/author\/andrew-eodhd\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create a Google Sheets Stock Portfolio Spreadsheet | EODHD APIs Academy","description":"Free template and guide on how to build your own stock portfolio spreadsheet. You will learn how to use Financial APIs with Google Sheets.","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\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio","og_locale":"en_US","og_type":"article","og_title":"How to Create a Google Sheets Stock Portfolio Spreadsheet","og_description":"Free template and guide on how to build your own stock portfolio spreadsheet. You will learn how to use Financial APIs with Google Sheets.","og_url":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2023-11-22T23:13:37+00:00","article_modified_time":"2024-05-06T00:29:44+00:00","og_image":[{"width":801,"height":261,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/09\/EODHD-Financial-Google-Sheets-Add-in.png","type":"image\/png"}],"author":"Andrei Paulavets","twitter_card":"summary_large_image","twitter_creator":"@EOD_data","twitter_site":"@EOD_data","twitter_misc":{"Written by":"Andrei Paulavets","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio"},"author":{"name":"Andrei Paulavets","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e"},"headline":"How to Create a Google Sheets Stock Portfolio Spreadsheet","datePublished":"2023-11-22T23:13:37+00:00","dateModified":"2024-05-06T00:29:44+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio"},"wordCount":951,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png","articleSection":["Portfolio Performance Examples","Stocks Data Analysis Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio","url":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio","name":"How to Create a Google Sheets Stock Portfolio Spreadsheet | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png","datePublished":"2023-11-22T23:13:37+00:00","dateModified":"2024-05-06T00:29:44+00:00","description":"Free template and guide on how to build your own stock portfolio spreadsheet. You will learn how to use Financial APIs with Google Sheets.","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#primaryimage","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/image-12.png","width":1286,"height":223},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/how-to-create-a-google-sheets-stock-portfolio#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"How to Create a Google Sheets Stock Portfolio Spreadsheet"}]},{"@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":"","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-10R","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/3897","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=3897"}],"version-history":[{"count":15,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/3897\/revisions"}],"predecessor-version":[{"id":5567,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/3897\/revisions\/5567"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=3897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=3897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=3897"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=3897"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=3897"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=3897"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=3897"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=3897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}