{"id":227073,"date":"2023-05-26T14:19:00","date_gmt":"2023-05-26T12:19:00","guid":{"rendered":"https:\/\/sftarticles.wpenginepowered.com\/es\/?p=285706"},"modified":"2025-07-01T19:05:36","modified_gmt":"2025-07-02T02:05:36","slug":"quote-stock-numbers","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/quote-stock-numbers\/","title":{"rendered":"A Better Way to Track Stocks: Adding Updated Quotes to Numbers on Mac, iPad, and iPhone"},"content":{"rendered":"\n<p>A really useful feature when preparing certain types of spreadsheets is <strong>to be able to have the updated price of certain stocks<\/strong>. Fortunately, <em>Numbers<\/em>, both in its Mac and iPhone or iPad version, offers exactly this option. Let&#8217;s see how to use it to avoid having to ask <a href=\"https:\/\/en.softonic.com\/articles\/siri-iphone?ex=DINS-635.0\" target=\"_blank\" rel=\"noreferrer noopener\">Siri<\/a> for each value.<\/p>\n\n\n\n<!--more-->\n\n\n<div class=\"sc-card-program\">\r\n  <div class=\"sc-card-program__body\">\r\n    <div class=\"sc-card-program__row clearfix\">\r\n      <div class=\"sc-card-program__col-logo\">\r\n        <img decoding=\"async\" class=\"sc-card-program__img\" alt=\"Numbers\" src=\"https:\/\/images.sftcdn.net\/images\/t_app-icon-m\/p\/37a79d7a-99eb-11e6-9e7b-00163ec9f5fa\/3647472257\/numbers-icon.png\" width=\"100px\" height=\"100px\">\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-title\">\r\n        <span class=\"sc-card-program__title\">Numbers<\/span>\r\n        <a class=\"sc-card-program__button sc-card-program-internal\" href=\"https:\/\/numbers.en.softonic.com\/mac\" target=\"_self\" rel=\"noopener noreferrer\">DOWNLOAD<\/a>\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-rating\">\r\n        <svg class=\"rating-score__content\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.1\" x=\"0\" y=\"0\" viewbox=\"0 0 50 50\" enable-background=\"new 0 0 50 50\" xml:space=\"preserve\"><path class=\"rating-score__background rating-score--good\" fill=\"none\" stroke-width=\"6\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><path class=\"rating-score__value rating-score__value--0\" fill=\"none\" stroke-width=\"6\" stroke-dashoffset=\"0\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><text class=\"rating-score__number\" content=\"\" text-anchor=\"middle\" transform=\"matrix(1 0 0 1 25 31.0837)\" data-auto=\"app-user-score\"><\/text><\/svg>\r\n      <\/div>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <span class=\"sc-card-program__description\"><\/span>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <img decoding=\"async\" class=\"sc-card-program__bigpic\" src=\"\" onerror=\"this.style.display='none'\">\r\n    <\/div>\r\n    <a class=\"sc-card-program__link track-link sc-card-program-internal\" href=\"https:\/\/numbers.en.softonic.com\/mac\" target=\"_self\" rel=\"noopener noreferrer\"><\/a>\r\n  <\/div>\r\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">All the information of a market value in our Numbers sheet<\/h2>\n\n\n\n<p>Inserting the information of a stock or a security is really simple. The grace of this kind of information is that it is updated with the price, so it <strong>can help us to make certain decisions or to perform certain calculations<\/strong>. On our Mac the steps to insert this information in our sheet are as follows.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Click on the <em>Insert<\/em> button that appears at the top of the window.<\/li><li>Select the <em>Stock Quote<\/em> option.<\/li><li>Choose a company or index from the ones in our <em>Stock Market<\/em> app or use the search engine to type a company name or a symbol.<\/li><li>In the <em>Attribute<\/em> section we choose what information we want to be displayed in the cell.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-block-embed-Youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Escape from the Office | Apple at Work\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/GC5Gmkn92Bg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>So simple, let&#8217;s say, because the amount of options offered by the attribute section is enormous. Among others, <strong>we can choose between the price, the name, the exchange rate, the percentage of change, how much it has opened at, its maximum, its minimum<\/strong>, the market capitalization, the volume of transactions, the maximum and minimum in 52 weeks, the annual dividends and much more.<\/p>\n\n\n\n<p>With this information, which is updated on a regular basis, <strong>we can perform various calculations as if it were just another cell of information<\/strong> and set up our prediction system or evaluation of one or more securities. Whenever we double-click on the cell itself we can see the information, the last date and time of update and change the attribute we want to display.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The stock exchange also comes to Numbers for iPad or iPhone<\/h2>\n\n\n\n<p>In a similar way to the Mac, we can perform <strong>the same management on our iPhone or iPad<\/strong>. The steps are very similar, let&#8217;s see them in detail after having our document open and ready.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Select a cell.<\/li><li>Tap the green <em>Cell button<\/em> at the bottom right.<\/li><li>Choose <em>Stock Quote<\/em>.<\/li><li>Choose a company or index from those in our <em>Stock Market<\/em> app or use the search engine to type a company name or a symbol.<\/li><li>Select the information you want to be displayed in the cell.<\/li><li>Tap OK.<\/li><\/ol>\n\n\n\n<p>Just like on the Mac, <strong>a double tap on the cell in question allows us to see the complete information<\/strong> for that stock and the time the information was last updated.<\/p>\n\n\n\n<p>No doubt being able to have up-to-date information about the behavior of actions in Numbers spreadsheets is really interesting. Of course we can copy and paste the different values manually, even write them with the <a href=\"https:\/\/en.softonic.com\/articles\/apple-pencil\" target=\"_blank\" rel=\"noreferrer noopener\">Apple Pencil<\/a>, it may be faster if we need information second by second, but from a certain amount of actions it will not be the most comfortable method. Fortunately, a few clicks allow us to have the information just there, really efficient.<\/p>\n\n\n<div class=\"sc-card-program\">\r\n  <div class=\"sc-card-program__body\">\r\n    <div class=\"sc-card-program__row clearfix\">\r\n      <div class=\"sc-card-program__col-logo\">\r\n        <img decoding=\"async\" class=\"sc-card-program__img\" alt=\"Numbers\" src=\"https:\/\/images.sftcdn.net\/images\/t_app-icon-m\/p\/37a79d7a-99eb-11e6-9e7b-00163ec9f5fa\/3647472257\/numbers-icon.png\" width=\"100px\" height=\"100px\">\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-title\">\r\n        <span class=\"sc-card-program__title\">Numbers<\/span>\r\n        <a class=\"sc-card-program__button sc-card-program-internal\" href=\"https:\/\/numbers.en.softonic.com\/mac\" target=\"_self\" rel=\"noopener noreferrer\">DOWNLOAD<\/a>\r\n      <\/div>\r\n      <div class=\"sc-card-program__col-rating\">\r\n        <svg class=\"rating-score__content\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.1\" x=\"0\" y=\"0\" viewbox=\"0 0 50 50\" enable-background=\"new 0 0 50 50\" xml:space=\"preserve\"><path class=\"rating-score__background rating-score--good\" fill=\"none\" stroke-width=\"6\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><path class=\"rating-score__value rating-score__value--0\" fill=\"none\" stroke-width=\"6\" stroke-dashoffset=\"0\" stroke-miterlimit=\"10\" d=\"M40 40c8.3-8.3 8.3-21.7 0-30s-21.7-8.3-30 0 -8.3 21.7 0 30\"><\/path><text class=\"rating-score__number\" content=\"\" text-anchor=\"middle\" transform=\"matrix(1 0 0 1 25 31.0837)\" data-auto=\"app-user-score\"><\/text><\/svg>\r\n      <\/div>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <span class=\"sc-card-program__description\"><\/span>\r\n    <\/div>\r\n    <div class=\"sc-card-program__row\">\r\n      <img decoding=\"async\" class=\"sc-card-program__bigpic\" src=\"\" onerror=\"this.style.display='none'\">\r\n    <\/div>\r\n    <a class=\"sc-card-program__link track-link sc-card-program-internal\" href=\"https:\/\/numbers.en.softonic.com\/mac\" target=\"_self\" rel=\"noopener noreferrer\"><\/a>\r\n  <\/div>\r\n<\/div>\n\n\n\n<p><em>Some of the links added in the article are part of affiliate campaigns and may represent benefits for Softonic.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few clicks allow us that the information is simply there, really efficient.<\/p>\n","protected":false},"author":9262,"featured_media":227076,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":2},"categories":[1015],"tags":[4154,4155],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-227073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news","tag-bolsa","tag-numbers"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/227073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/users\/9262"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/comments?post=227073"}],"version-history":[{"count":1,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/227073\/revisions"}],"predecessor-version":[{"id":320054,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/227073\/revisions\/320054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media\/227076"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media?parent=227073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/categories?post=227073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/tags?post=227073"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/usertag?post=227073"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/vertical?post=227073"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/content-category?post=227073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}