Advertisement

News

A Better Way to Track Stocks: Adding Updated Quotes to Numbers on Mac, iPad, and iPhone

Automatically updated stock market information

A Better Way to Track Stocks: Adding Updated Quotes to Numbers on Mac, iPad, and iPhone
David Bernal Raspall

David Bernal Raspall

A really useful feature when preparing certain types of spreadsheets is to be able to have the updated price of certain stocks. Fortunately, Numbers, both in its Mac and iPhone or iPad version, offers exactly this option. Let’s see how to use it to avoid having to ask Siri for each value.

Numbers DOWNLOAD

All the information of a market value in our Numbers sheet

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 can help us to make certain decisions or to perform certain calculations. On our Mac the steps to insert this information in our sheet are as follows.

  1. Click on the Insert button that appears at the top of the window.
  2. Select the Stock Quote option.
  3. Choose a company or index from the ones in our Stock Market app or use the search engine to type a company name or a symbol.
  4. In the Attribute section we choose what information we want to be displayed in the cell.

So simple, let’s say, because the amount of options offered by the attribute section is enormous. Among others, 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, the market capitalization, the volume of transactions, the maximum and minimum in 52 weeks, the annual dividends and much more.

With this information, which is updated on a regular basis, we can perform various calculations as if it were just another cell of information 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.

The stock exchange also comes to Numbers for iPad or iPhone

In a similar way to the Mac, we can perform the same management on our iPhone or iPad. The steps are very similar, let’s see them in detail after having our document open and ready.

  1. Select a cell.
  2. Tap the green Cell button at the bottom right.
  3. Choose Stock Quote.
  4. Choose a company or index from those in our Stock Market app or use the search engine to type a company name or a symbol.
  5. Select the information you want to be displayed in the cell.
  6. Tap OK.

Just like on the Mac, a double tap on the cell in question allows us to see the complete information for that stock and the time the information was last updated.

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 Apple Pencil, 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.

Numbers DOWNLOAD

Some of the links added in the article are part of affiliate campaigns and may represent benefits for Softonic.

David Bernal Raspall

David Bernal Raspall

Architect | Creator and editor of hoyenapple.com | Trainer in Apple technologies | Editor at Softonic and iDoo_tech and previously at Applesfera

Latest from David Bernal Raspall

You may also like

  1. Stay Updated on Roland Garros 2023: Find Out When and Where Carlos Alcaraz Plays in the Grand Slam Event

    Stay Updated on Roland Garros 2023: Find Out When and Where Carlos Alcaraz Plays in the Grand Slam Event

    Read more
  2. HBO’s Captivating Documentary Series Nears Conclusion, Solidifying its Status as the Best of the 21st Century

    HBO’s Captivating Documentary Series Nears Conclusion, Solidifying its Status as the Best of the 21st Century

    Read more
  3. How did The Little Mermaid do at the box office?

    How did The Little Mermaid do at the box office?

    Read more
  4. SkyShowtime Takes the Crown: The Top Series of the Year that Outshine Succession and The Last of Us

    SkyShowtime Takes the Crown: The Top Series of the Year that Outshine Succession and The Last of Us

    Read more
  5. Need a New Binge-Worthy Series? Here Are the Top 5 Shows to Watch Post-Succession

    Need a New Binge-Worthy Series? Here Are the Top 5 Shows to Watch Post-Succession

    Read more
  6. From Legendary Series to Lousy Movies: The 10 Most Disappointing Live-Action Adaptations, including The Knights of the Zodiac

    From Legendary Series to Lousy Movies: The 10 Most Disappointing Live-Action Adaptations, including The Knights of the Zodiac

    Read more