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. Sony Hack? A group of hackers claims to have accessed all of its systems

    Sony Hack? A group of hackers claims to have accessed all of its systems

    Read more
  2. Pixel Watch redesigned after the latest Fitbit update

    Pixel Watch redesigned after the latest Fitbit update

    Read more
  3. The most impossible crossover in history brought together DC superheroes with… Tintin!

    The most impossible crossover in history brought together DC superheroes with… Tintin!

    Read more
  4. Nissan envisions the future of the electric car in Europe

    Nissan envisions the future of the electric car in Europe

    Read more
  5. Snapchat's "My AI" chatbot has a new friend: Microsoft

    Snapchat's "My AI" chatbot has a new friend: Microsoft

    Read more
  6. If you’ve just bought a PS5, know that Sony is giving you one of these 12 video games for free

    If you’ve just bought a PS5, know that Sony is giving you one of these 12 video games for free

    Read more