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.
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.
- Click on the Insert button that appears at the top of the window.
- Select the Stock Quote option.
- 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.
- 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.
- Select a cell.
- Tap the green Cell button at the bottom right.
- Choose Stock Quote.
- 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.
- Select the information you want to be displayed in the cell.
- 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.
Some of the links added in the article are part of affiliate campaigns and may represent benefits for Softonic.