{"id":4054,"date":"2023-11-28T21:50:09","date_gmt":"2023-11-28T21:50:09","guid":{"rendered":"https:\/\/eodhd.com\/financial-academy\/?p=4054"},"modified":"2024-10-08T09:10:23","modified_gmt":"2024-10-08T09:10:23","slug":"excel-stock-portfolio-spreadsheet-how-to-build","status":"publish","type":"post","link":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build","title":{"rendered":"Create a Winning Stock Portfolio with Our Free Excel Template!"},"content":{"rendered":"\n<p>In the dynamic world of finance, following the market trends and managing your investment portfolio effectively is crucial for achieving your financial goals. Excel, with its versatile data analysis and manipulation capabilities, serves as a powerful tool for investors. However, manually tracking stock prices and calculating portfolio performance can be time-consuming. This is where financial data APIs step in, seamlessly integrating real-time market data into your Excel spreadsheets, and transforming your investment management experience. You are free to download the Excel template spreadsheet first to navigate the article more easily: <\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-81169177-9b01-44f7-9837-1a66cf38051c\" href=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Portfolio_Tracker_Spreadsheet.xlsx\">Portfolio_Tracker_Spreadsheet.xls<\/a><a href=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Portfolio_Tracker_Spreadsheet.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-81169177-9b01-44f7-9837-1a66cf38051c\">Download<\/a><\/div>\n\n\n\n<p><\/p>\n\n\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-excel-and-financial-data-apis-stock-portfolio-spreadsheet-implementation\">Excel and Financial Data APIs Stock Portfolio Spreadsheet Implementation<\/h2>\n\n\n\n<p>For the ready-to-use Excel spreadsheet solution, you may check our ready-to-use <a href=\"https:\/\/eodhd.com\/financial-apis\/excel-financial-add-in-fundamentals-end-of-day-charts\/\">Excel add-in<\/a>, which could help you to get reliable information directly into your spreadsheet. You are also free to check our article on how to build a similar portfolio in <a href=\"https:\/\/eodhd.com\/financial-academy\/stocks-data-analysis-examples\/how-to-create-a-google-sheets-stock-portfolio\/\">Google Sheets<\/a>.<\/p>\n\n\n\n<p>It&#8217;s important to be aware that external URL requests through the desktop version are not available for macOS users. However, you can still use the <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/work-in-excel-for-the-web-812f519f-8db1-4de2-81d2-d7f3510168ca\">web version<\/a> of Excel.<\/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<h2 class=\"wp-block-heading\" id=\"h-why-use-financial-data-apis-with-excel-stock-portfolio\">Why Use Financial Data APIs with Excel stock portfolio?<\/h2>\n\n\n\n<p>Financial data APIs, also known as market data APIs, provide programmatic access to a wealth of financial information, including stock prices, company financials, economic indicators, and more. By connecting your Excel spreadsheet to a financial data API, you can automate the process of retrieving and updating market data, ensuring that your portfolio analysis is always based on the latest information.<\/p>\n\n\n\n<p><a href=\"https:\/\/eodhd.com\/financial-apis\/\">EODHD<\/a> provides all the necessary data for your financial analysis. In the article, we will be using a couple of them to give you the basics of working with EODHD APIs and integrating them into an Excel spreadsheet:<\/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-design-your-spreadsheet\">Design Your Spreadsheet<\/h2>\n\n\n\n<p>Set up your Excel spreadsheet to track all the important stuff \u2013 stock ticker symbols, purchase dates, prices, quantities, total investment amounts, and portfolio performance metrics. 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<h2 class=\"wp-block-heading\" id=\"h-connect-to-the-api\">Connect to the API<\/h2>\n\n\n\n<p>This is where the magic happens. Use Excel&#8217;s Power Query feature to establish a connection to the financial data API. Think of it like building a bridge between your spreadsheet and the API&#8217;s data stream.<\/p>\n\n\n\n<p>To create a dynamically updatable spreadsheet we will use Microsoft Excel&#8217;s <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173\">functions<\/a> which call data using external URL requests. The most commonly used function is &#8216;=<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4\">WEBSERVICE<\/a>()&#8217;. We will also have a look at the newly added &#8216;=<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7\">TEXTSPLIT<\/a>()&#8217; which will help us to automatically structure the received data correctly in the table. The &#8216;=TEXTSPLIT&#8217; function is available only with the Office 360 updated after 2022.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1886\" height=\"854\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_Portfolio_Overview.gif\" alt=\"Excel portfolio overview, WEBSERVICE function.\" class=\"wp-image-4064\"\/><\/figure>\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 into your Excel Stock Portfolio spreadsheet 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\/image-14.png\" alt=\"Financial API overview\" class=\"wp-image-4066\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-getting-live-stock-prices\">Getting Live Stock Prices <\/h2>\n\n\n\n<p>Utilize the API&#8217;s data retrieval functions to fetch current stock prices for each ticker symbol in your portfolio.<\/p>\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\">=WEBSERVICE(\"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. &#8216;&amp;fmt=json&#8217; 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. You will find all the filters listed in the <a href=\"https:\/\/eodhd.com\/financial-apis\/live-realtime-stocks-api\/\">live API<\/a> documentation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1580\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/WEBSERVECE_Portfolio.gif\" alt=\"Live data Excel portfolio\" class=\"wp-image-4067\"\/><\/figure>\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>. The API provides daily historical data which could be used for stock price analysis.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1580\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/WEBSERVECE_Historical_Price.gif\" alt=\"\" class=\"wp-image-4068\"\/><\/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 the table we will use the following function:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUBSTITUTE(SUBSTITUTE(WEBSERVICE(\"https:\/\/eodhd.com\/api\/eod\/\"&amp;$B$3&amp;\".\"&amp;Portfolio!$C$8&amp;\"?api_token=\"&amp;Portfolio!$C$5&amp;\"&amp;fmt=json&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.  The Microsoft &#8216;<a href=\"https:\/\/support.microsoft.com\/en-au\/office\/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332\">=SUBSTITUTE<\/a>&#8216; function is used to delete symbols &#8216;[&#8230;]&#8217; from the start and end of the returned dataset. After getting all the data into one cell we need to modify it to create a table of values, for this, we first use &#8216;=TEXTSPLIT&#8217;:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=TEXTSPLIT(B6,,\",\")<\/pre>\n\n\n\n<p>The formula splits our cell value into tables, however, the data is formatted as text, to transform it to number format we need to use the function &#8216;=VALUE&#8217; for each cell in a list:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=VALUE(B8)<\/pre>\n\n\n\n<p>To get dates for each close price we could use the previous cell formulas with &#8216;..&amp;filter=date..&#8217;, &#8216;=TEXTSPLIT&#8217; and &#8216;=DATEVALUE&#8217;, similar to price values:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUBSTITUTE(SUBSTITUTE(WEBSERVICE(\"https:\/\/eodhd.com\/api\/eod\/\"&amp;$B$3&amp;\".\"&amp;Portfolio!$C$8&amp;\"?api_token=\"&amp;Portfolio!$C$5&amp;\"&amp;fmt=json&amp;filter=date&amp;from=\"&amp;TEXT($C$3,\"YYYY-MM-DD\")&amp;\"&amp;period=d\"),\"[\",\"\"),\"]\",\"\")\n=TEXTSPLIT(A6,,\",\")\n=TEXT(DATEVALUE(RIGHT(LEFT(A8,LEN(A8)-1),LEN(A8)-2)),\"YYYY-MM-DD\")<\/pre>\n\n\n\n<p>For the stock selected, we used the &#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<h2 class=\"wp-block-heading\" id=\"h-fundamental-data\">Fundamental 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<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1580\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/WEBSERVICE_Fundamental_Data.gif\" alt=\"\" class=\"wp-image-4069\"\/><\/figure>\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\">=WEBSERVICE(\"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). We are using only the &#8216;Highlights&#8217; section of the Fundamental API output with parameter &#8216;&amp;filter=Highlights&#8217; in the URL request to get only ratios in our spreadsheet. To get the full list <\/p>\n\n\n\n<p>This time we use the &#8216;=TEXTSPLIT&#8217; function to get data into nice 2x column table, an example of the cell formula is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=TEXTSPLIT(RIGHT(LEFT(B6,LEN(B6)-1),LEN(B6)-2),\":\",\",\")<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-calculate-portfolio-performance\">Calculate Portfolio Performance<\/h2>\n\n\n\n<p>You can Apply Excel algebraic formulas to calculate metrics such as total portfolio value, unrealized gains\/losses, and portfolio returns.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1580\" height=\"756\" src=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_Portfolio_Ratios.gif\" alt=\"\" class=\"wp-image-4070\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-automate-data-updates\">Automate Data Updates<\/h2>\n\n\n\n<p>Don&#8217;t want to manually refresh your data? Schedule regular data updates using Excel&#8217;s Data Connection Manager. This keeps your portfolio analysis always up-to-date, even when you&#8217;re sleeping.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-benefits-of-using-financial-data-apis-with-excel\">Benefits of Using Financial Data APIs with Excel<\/h2>\n\n\n\n<p>Combining Excel with financial data APIs is like giving your investment management a supercharged boost:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Real-time Data Access:<\/strong> Get the latest stock prices and market data without manually updating spreadsheets.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Reduced Errors:<\/strong> No more typos or miscalculations messing up your numbers.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enhanced Portfolio Analysis:<\/strong> Gain deeper insights into your portfolio performance with automated calculations.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Data Customization:<\/strong> Tailor the data retrieved from the API to your specific portfolio needs.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Scalability:<\/strong> Manage a growing portfolio without the burden of manual data updates.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>By leveraging financial data APIs in conjunction with Excel&#8217;s powerful data analysis capabilities, you can transform your investment management process, making it more efficient, accurate, and data-driven. Financial data APIs and your own customizable Excel stock portfolio spreadsheet empower you to make informed investment decisions based on real-time market information, enabling you to navigate the dynamic world of finance with confidence.<\/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\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the dynamic world of finance, following the market trends and managing your investment portfolio effectively is crucial for achieving your financial goals. Excel, with its versatile data analysis and manipulation capabilities, serves as a powerful tool for investors. However, manually tracking stock prices and calculating portfolio performance can be time-consuming. This is where financial [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":4073,"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":[45],"qualification":[31,33],"financial-apis-category":[36],"financial-apis-manuals":[39,73,37],"class_list":["post-4054","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portfolio-performance-examples","category-stocks-data-analysis-examples","ready-to-go-solution-excel-add-in","qualification-experienced","qualification-newbie","financial-apis-category-stock-market-prices","financial-apis-manuals-end-of-day","financial-apis-manuals-live-delayed-15-mins","financial-apis-manuals-stocks-fundamentals","has_thumb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v26.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create a Winning Stock Portfolio with Our Free Excel Template! | EODHD APIs Academy<\/title>\n<meta name=\"description\" content=\"Our step-by-step guide and customizable Excel Stock Portfolio template make it easy. Start optimizing your investments today.\" \/>\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\/excel-stock-portfolio-spreadsheet-how-to-build\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create a Winning Stock Portfolio with Our Free Excel Template!\" \/>\n<meta property=\"og:description\" content=\"Our step-by-step guide and customizable Excel Stock Portfolio template make it easy. Start optimizing your investments today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build\" \/>\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-28T21:50:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-08T09:10:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1520\" \/>\n\t<meta property=\"og:image:height\" content=\"760\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"7 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\/excel-stock-portfolio-spreadsheet-how-to-build#article\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build\"},\"author\":{\"name\":\"Andrei Paulavets\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e\"},\"headline\":\"Create a Winning Stock Portfolio with Our Free Excel Template!\",\"datePublished\":\"2023-11-28T21:50:09+00:00\",\"dateModified\":\"2024-10-08T09:10:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build\"},\"wordCount\":1332,\"publisher\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#organization\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg\",\"articleSection\":[\"Portfolio Performance Examples\",\"Stocks Data Analysis Examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build\",\"name\":\"Create a Winning Stock Portfolio with Our Free Excel Template! | EODHD APIs Academy\",\"isPartOf\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage\"},\"image\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage\"},\"thumbnailUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg\",\"datePublished\":\"2023-11-28T21:50:09+00:00\",\"dateModified\":\"2024-10-08T09:10:23+00:00\",\"description\":\"Our step-by-step guide and customizable Excel Stock Portfolio template make it easy. Start optimizing your investments today.\",\"breadcrumb\":{\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage\",\"url\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg\",\"contentUrl\":\"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg\",\"width\":1520,\"height\":760},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/eodhd.com\/financial-academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create a Winning Stock Portfolio with Our Free Excel Template!\"}]},{\"@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":"Create a Winning Stock Portfolio with Our Free Excel Template! | EODHD APIs Academy","description":"Our step-by-step guide and customizable Excel Stock Portfolio template make it easy. Start optimizing your investments today.","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\/excel-stock-portfolio-spreadsheet-how-to-build","og_locale":"en_US","og_type":"article","og_title":"Create a Winning Stock Portfolio with Our Free Excel Template!","og_description":"Our step-by-step guide and customizable Excel Stock Portfolio template make it easy. Start optimizing your investments today.","og_url":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build","og_site_name":"Financial Academy","article_publisher":"https:\/\/www.facebook.com\/eodhistoricaldata","article_published_time":"2023-11-28T21:50:09+00:00","article_modified_time":"2024-10-08T09:10:23+00:00","og_image":[{"width":1520,"height":760,"url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg","type":"image\/jpeg"}],"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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#article","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build"},"author":{"name":"Andrei Paulavets","@id":"https:\/\/eodhd.com\/financial-academy\/#\/schema\/person\/beb3cf1cd77acbb7720cda8c63e5565e"},"headline":"Create a Winning Stock Portfolio with Our Free Excel Template!","datePublished":"2023-11-28T21:50:09+00:00","dateModified":"2024-10-08T09:10:23+00:00","mainEntityOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build"},"wordCount":1332,"publisher":{"@id":"https:\/\/eodhd.com\/financial-academy\/#organization"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg","articleSection":["Portfolio Performance Examples","Stocks Data Analysis Examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build","url":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build","name":"Create a Winning Stock Portfolio with Our Free Excel Template! | EODHD APIs Academy","isPartOf":{"@id":"https:\/\/eodhd.com\/financial-academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage"},"image":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage"},"thumbnailUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg","datePublished":"2023-11-28T21:50:09+00:00","dateModified":"2024-10-08T09:10:23+00:00","description":"Our step-by-step guide and customizable Excel Stock Portfolio template make it easy. Start optimizing your investments today.","breadcrumb":{"@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#primaryimage","url":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg","contentUrl":"https:\/\/eodhd.com\/financial-academy\/wp-content\/uploads\/2023\/11\/Excel_portfolio_spreadsheet.jpg","width":1520,"height":760},{"@type":"BreadcrumbList","@id":"https:\/\/eodhd.com\/financial-academy\/portfolio-performance-examples\/excel-stock-portfolio-spreadsheet-how-to-build#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/eodhd.com\/financial-academy\/"},{"@type":"ListItem","position":2,"name":"Create a Winning Stock Portfolio with Our Free Excel Template!"}]},{"@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\/2023\/11\/Excel_portfolio_spreadsheet.jpg","jetpack_shortlink":"https:\/\/wp.me\/pdOdVT-13o","jetpack_sharing_enabled":true,"acf":[],"_links":{"self":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/4054","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=4054"}],"version-history":[{"count":7,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/4054\/revisions"}],"predecessor-version":[{"id":5955,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/posts\/4054\/revisions\/5955"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media\/4073"}],"wp:attachment":[{"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/media?parent=4054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/categories?post=4054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/tags?post=4054"},{"taxonomy":"coding-language","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/coding-language?post=4054"},{"taxonomy":"ready-to-go-solution","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/ready-to-go-solution?post=4054"},{"taxonomy":"qualification","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/qualification?post=4054"},{"taxonomy":"financial-apis-category","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-category?post=4054"},{"taxonomy":"financial-apis-manuals","embeddable":true,"href":"https:\/\/eodhd.com\/financial-academy\/wp-json\/wp\/v2\/financial-apis-manuals?post=4054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}