{"id":130146,"date":"2020-12-09T13:24:55","date_gmt":"2020-12-09T10:24:55","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/"},"modified":"2020-12-09T13:24:55","modified_gmt":"2020-12-09T10:24:55","slug":"how-to-use-the-built-in-stocks-feature-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/","title":{"rendered":"#How to Use the Built-In Stocks Feature in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6aee4b5d906db\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6aee4b5d906db\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/#Add_Stock_Data_to_Your_Excel_Sheet\" >Add Stock Data to Your Excel Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/#View_the_Data_Type_Card\" >View the Data Type Card<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/#Refresh_the_Stocks_Data\" >Refresh the Stocks Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/#Dont_See_the_Stocks_Feature\" >Don\u2019t See the Stocks Feature?<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use the Built-In Stocks Feature in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-435491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/xstock-lede-microsoft-office_excel-1.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Bi7kk-HHRf.png\" alt=\"Excel Logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you need stock market data for your spreadsheet, you can save time and get up-to-date information with the built-in Stocks data type in Microsoft Excel. Here\u2019s how to populate your sheet with details like ticker symbols, market caps, previous close, and more.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_Stock_Data_to_Your_Excel_Sheet\"><\/span>Add Stock Data to Your Excel Sheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To use the Stocks data type in Microsoft Excel, you only need an internet connection and a bit of your own data to start.<\/p>\n<p>Open your spreadsheet and type a piece of information, like a company name or stock symbol. With the cell still selected, open the \u201cData\u201d tab, and then click \u201cStocks\u201d in the \u201cData Types\u201d section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-703584 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/ClickStocksInDataType-Excel.png.pagespeed.ce.0R13lfpDAP.png\" alt=\"Click Data then Stocks in Data Types\" width=\"508\" height=\"245\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After a few seconds (depending on your internet connection), you might see the \u201cData Selector\u201d sidebar open on the right. This h<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ens when your item can\u2019t be found or more than one stock with that name is available.<\/p>\n<p>Click \u201cSelect\u201d under any of the available options in the sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-703585\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/xStocksDataSelector-Excel.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.uqboSzucXQ.png\" alt=\"Stocks Data Selector\" width=\"650\" height=\"331\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you click away from the cell that contains your initial data, just select it again, and then click the small Insert Data icon that appears next to it. A long, scrollable list containing all the stock market details you could possibly need will appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-703586\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/503x600xStocksInsertData-Excel.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.f8a8dg6Bhy.png\" alt=\"Click Insert Data to View a List\" width=\"503\" height=\"600\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose the information you want to include and it will pop into the cell at the right. You can continue adding details for the stock in this same way. Any additional details you choose will populate in the subsequent cells to the right.<\/p>\n<p>You can also add column headers to identify the data you include. At any time, though, you can just click the cell containing an item to see what it is in the Formula Bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-703583\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/xStocksCellDataDetail-Excel.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.VPJrwrzkwX.png\" alt=\"Stocks Data Detail in Formula Bar\" width=\"650\" height=\"114\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"View_the_Data_Type_Card\"><\/span>View the Data Type Card<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The scrollable list of details for a stock is helpful, but you can also view this same data in a card format. Just right-click the cell containing the company or stock you first typed, and then select \u201cShow Data Type Card\u201d from the menu that appears.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-703587\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/xStocksShowDataTypeCard-Excel.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.XIUl_T-hJ4.png\" alt=\"Click Show Data Type Card\" width=\"490\" height=\"108\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can then see those same details in an easy-to-read snapshot. You can also drag the bottom-right corner to enlarge the card if necessary. To add move information from the card to your sheet, just hover your cursor over that piece of data, and then click the Extract to Grid icon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-703588\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/xStocksShowDataTypeCardAddToGrid-Excel.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.OXu-CdI4HJ.png\" alt=\"Click Extract to Grid to Add Data\" width=\"513\" height=\"534\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Refresh_the_Stocks_Data\"><\/span>Refresh the Stocks Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Like the Geography data type in Microsoft Excel, the Stocks data type retrieves information from an online source. This means you can update it without opening a web browser.<\/p>\n<p>To do so, just right-click the cell that contains the company name or stock symbol, and then select Data Type &gt; Refresh from the menu that appears.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-703589\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/12\/xRefreshStocksDataType-Excel.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.byf0rlRMOY.png\" alt=\"Click Data Type then Refresh\" width=\"635\" height=\"391\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Dont_See_the_Stocks_Feature\"><\/span>Don\u2019t See the Stocks Feature?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you don\u2019t see the Stocks data type in Microsoft Excel, make sure your system meets the following requirements:<\/p>\n<ul>\n<li><strong>You\u2019re using Excel for Microsoft 365:<\/strong> <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/linked-data-types-faq-and-tips-d48d6394-c83a-43cd-9d94-78257102f054\">Microsoft<\/a>\u00a0might add this feature to additional versions in the future, but for now, you\u2019ll have to use this one.<\/li>\n<li><strong>You\u2019ve updated to the latest version of Office:<\/strong> Microsoft is rolling out this feature gradually, so you might have to wait a bit. Just keep\u00a0checking for new versions of Office.<\/li>\n<li><strong>English is set as the editing language in Office:<\/strong> Excel\u2019s data types are only available if you\u2019ve done this. You can learn how to change it in Microsoft Word\u00a0here, and this will also change it in Excel.<\/li>\n<\/ul>\n<p><strong>RELATED:<\/strong> <strong><em>How to Change the Language in Microsoft Word<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/703580\/how-to-use-the-built-in-stocks-feature-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use the Built-In Stocks Feature in Microsoft Excel&#8221; If you need stock market data for your spreadsheet, you can save time and get up-to-date information with the built-in Stocks data type in Microsoft Excel. Here\u2019s how to populate your sheet with details like ticker symbols, market caps, previous close, and more. Add Stock&#8230;<\/p>\n","protected":false},"author":1,"featured_media":130147,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/thumbcache\/2\/200\/2144ab7a8e4ef0c005417526e2a219c4\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-130146","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/130146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=130146"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/130146\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/130147"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=130146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=130146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=130146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}