You can view your watchlist across your iPhone, iPad, iPod touch, and Mac when you’re signed in with the same Apple ID. On your iPhone, iPad, and iPod touch, go to Settings your name iCloud, then turn on Stocks. On your Mac, choose Apple menu System Preferences, then do one of the following. Timely business news is easy to find in the Stocks app. How to read and share business news. Note: Apple News isn’t available in all countries or regions. To browse the Stocks User Guide, click Table of Contents at the top of the page. Or market capitalization. Use the same Stocks watchlist on your Mac, iPhone, and iPad. Change the chart. Install any app with ease. The Mac App Store revolutionises the way apps are installed on a computer — it happens in one step. Enter the same iTunes password you use to buy apps and music on your iPhone, iPad, Mac or iPod touch.
Add stock information to your spreadsheet
- Tap or click the cell you want to add stock information to.1
- On your iPhone, iPad, or iPod touch, tap Cell > Stock Quote. You might need to swipe up to see it.
- On your Mac, click the Insert button , then choose Stock Quote.
- On your iPhone, iPad, or iPod touch, tap Cell > Stock Quote. You might need to swipe up to see it.
- Choose a stock in the list. If you want to search for a specific stock, enter the company name or stock symbol.
- Choose the attribute you want to track.
- On your iPhone, iPad, or iPod touch, tap the attribute you want to track in this cell. The attribute you’re tracking has a to the left of it. Tap Done.
- On your Mac, in the Attribute pop-up menu, choose what information you want to track in this cell. Click outside the dialog.
If you want to see updated information as of the previous day's close or change the attribute you're tracking, double-tap or double-click on the cell.
You can also use the STOCK formula to enter and edit stock information in a cell. Here's how to edit the STOCK as a formula:
- On your iPhone, iPad, or iPod touch, tap on the cell, tap Cell, then tap Edit Formula.
- On your Mac, double-click on the cell, then click Edit as Formula.
![Apple Apple](/uploads/1/2/6/0/126070615/878726951.jpg)
1You must be connected to the Internet to add stock information. If Stock Quote is dimmed, the Internet might be unavailable. Check your network connection. When you're offline, any cell that actively pulls information from the Internet is empty.
Stock attributes that you can track
When you edit the STOCK formula, you can use any of these strings or numbers to show different pieces of data:
- “price” (0 or omitted): The share price of the specified stock at the market close of the previous market day.
- “name” (1): The full name of the stock or company.
- “change” (2): The difference between the last trade on the previous market day and the closing price on the market day prior to that. If the stock hasn’t traded in that interval, the change reported is “0.”
- “percent change” (3): The percentage change in the stock’s two most recent closing prices.
- “open” (4): The starting price at which the stock traded at the opening of trading on the previous market day.
- “high” (5): The highest price at which the stock traded during the previous market day.
- “low” (6): The lowest price at which the stock traded during the previous market day.
- “market cap” (7): The total market value of all the outstanding shares of the stock on the previous market day. This is calculated as the total number of outstanding shares multiplied by the price per share.
- “volume” (8): The number of shares of the stock that changed hands during the previous market day.
- “yield” (9): The ratio of the stock’s annual dividend (cash payout) per share as a percentage of the share price.
- “1-year target” (10): The one-year target price estimate, which is the median target price as forecast by analysts covering the stock.
- “52-week high” (11): The stock’s highest trade price in the last 52 weeks.
- “52-week low” (12): The stock’s lowest trade price in the last 52 weeks.
- “avg. 3-month volume” (15): The monthly average of the cumulative trading volume during the last 3 months divided by 22 days.
- “beta” (16): The measure of the volatility (systematic risk) of a security or commodity in comparison to the market as a whole.
- “currency” (19): The currency in which the stock is priced.
- “annual dividend” (20): The yearly dividend (cash payout) amount per share.
- “eps” (21): Earnings per share—calculated as a company’s total earnings divided by the number of outstanding shares (the stock currently held by all its shareholders).
- “exchange” (22): The stock exchange on which the stock is traded (for example, NYSE, NASDAQ, Euronext, and so on).
- “p/e ratio” (23): The price/earnings ratio, calculated by dividing the stock’s current market price by the trailing 12-month earnings per share.
- “previous close” (24): The stock’s closing price for the trading day prior to the last trade reported.
- “symbol” (25): The stock symbol (ticker symbol) that uniquely identifies the stock.
Track stock history
If you want to track the history of a specific stock, use STOCKH. When you add the formula, you must define these attributes:
- Symbol: An abbreviation that uniquely identifies publicly traded shares of a stock on a particular stock market, enclosed in quotes, or a reference to a cell that contains the symbol.
- Attribute: An optional value specifying the stock attribute to be returned. Numbers automatically suggests 'close.' Instead of close, you can choose open, high, low, or volume.
- Date: The date for which you want the historical stock price information
Add currency exchange rates to your spreadsheet
Apple Stocks App For Mac Pro
You can use the CURRENCY formula to pull data about currency exchange rates from the Internet and use them in your spreadsheet. When you add the formula, you must define these attributes:
- Currency-1: This is the currency code for the currency from which you’re converting. Use quotes around your string.
- Currency-2: This is the currency code for the currency to which you’re converting. Use quotes around your string.
For your third attribute, Numbers automatically suggests “price.' If you enter 0 or omit this item entirely, the cell shows the exchange rate of currency-1 to currency-2, expressed as currency-2.
Currency attributes that you can track
When you edit the formula, you can use any of these strings or numbers to show different pieces of data:
- “name” (1): The currency codes of the specified currencies, shown in the formula for calculating the exchange rate.
- “change” (2): The difference in the exchange rate at the close of trading on the two most recent business days.
- “percent change” (3): The percentage change in the exchange rate’s two most recent closing prices.
- “open” (4): The exchange rate at the opening of trading on the previous business day.
- “high” (5): The highest exchange rate on the previous business day.
- “low” (6): The lowest exchange rate on the previous business day.
- “52-week high” (7): The highest exchange rate in the last 52 weeks.
- “52-week low” (8): The lowest exchange rate in the last 52 weeks.
Track currency history
If you want to track the history of a specific currency, use CURRENCYH. When you add the formula, you must define these attributes:
- Currency-1: The currency code for the currency from which you’re converting. currency‑1 is a string enclosed in quotes.
- Currency-2: The currency code for the currency to which you’re converting. currency‑2 is a string enclosed in quotes.
- Attribute: An optional value specifying the currency attribute to be returned. Numbers automatically suggests 'close.' Instead of close, you can choose open, high, low, or any other currency attribute (see Currency attributes that you can track).
- Date: The date for which you want the historical exchange rate information.
Great apps for your Mac. Right there on your Mac.
The Mac App Store makes it easy to find and download Mac apps as well as widgets and extensions — like editing extensions for the new Photos app. You can browse Mac apps by category, such as games, productivity, music and more. Or do a quick search for something specific. Read descriptions and customer reviews. Flip through screenshots. When you find an app you like, click to buy it. The Mac App Store has apps for just about everything and everyone. Here are a few of our favourites.
Pages
Create beautiful documents, letters, flyers, invitations and more.
View in Mac App Store
View in Mac App Store
Numbers
Make eye-catching spreadsheets and charts in just a few clicks.
View in Mac App Store
View in Mac App Store
Keynote
Put together a presentation with captivating graphics and transitions.
View in Mac App Store
View in Mac App Store
![Mac Mac](/uploads/1/2/6/0/126070615/129602695.jpg)
iBooks Author
Create stunning Multi-Touch books for iPad and Mac.
View in Mac App Store
View in Mac App Store
Final Cut Pro X
Bring your film to life using revolutionary video editing software.
View in Mac App Store
View in Mac App Store
Logic Pro X
Turn your Mac into a complete professional recording studio.
View in Mac App Store
View in Mac App Store
Wunderlist
Manage and share your to‑do lists across all your devices. View in Mac App Store
Evernote
Take notes, save web pages, create lists, attach images and PDFs, and more. View in Mac App Store
Cobook Contacts
Find, organise and keep your contacts up to date in even easier ways. View in Mac App Store
Things
Keep track of to-dos, deadlines and projects with this task manager app. View in Mac App Store
Notability
Annotate documents, record lectures and take notes with this all-in-one app. View in Mac App Store
Autodesk SketchBook
Take your ideas further with a complete set of digital drawing tools.View in Mac App Store
Day One
Keep a journal that sends reminders and looks great in day or month view. View in Mac App Store
Pocket
See something you like? Save interesting articles, videos and web pages for later. View in Mac App Store
The Photo Cookbook
Follow over 240 easy‑to‑prepare recipes picture by picture. View in Mac App Store
Kuvva Wallpapers
Choose specially curated wallpapers from a new artist each week. View in Mac App Store
Tonality
Create inspiring black-and-white images on your Mac.View in Mac App Store
swackett
Get visual weather reports that turn complex data into fun infographics. View in Mac App Store
Sky Gamblers Cold War
Rule the action-packed skies in over a dozen different aeroplanes. View in Mac App Store
Sparkle 2
This easy-to-play but enthralling game makes the most of the Retina display. View in Mac App Store
Bike Baron
Beat hundreds of challenges as you master over 100 different bike tracks. View in Mac App Store
Civilization V: Campaign Edition
Build and defend the most powerful empire the world has ever known. View in Mac App Store
Galaxy On Fire 2™ Full HD
Battle your way through a 3D war-torn galaxy against an alien armada. View in Mac App Store
SimCity 4 Deluxe Edition
Build a city from the ground up and manage your metropolis in every way. View in Mac App Store
Money
Set a budget, schedule payments and track investments — all in one app. View in Mac App Store
MoneyWiz – Personal Finance
View all your accounts, transactions, budgets and bills in one secure place. View in Mac App Store
iBank
Manage your money with this fully featured, intuitive personal finance app. View in Mac App Store
Next - Track your expenses and finances
See your expenses by year, month or day, and take control of your finances. View in Mac App Store
Investoscope
Monitor your portfolio of stocks, bonds, mutual funds and more. View in Mac App Store
StockTouch
Keep track of the market in a whole new way. View in Mac App Store
djay
Mix songs from your iTunes library and spin live on a digital turntable. View in Mac App Store
Sound Studio
Record, edit and produce digital audio. Create your own mixes and add effects. View in Mac App Store
Shazam
Like what you hear? Identify a song at a moment’s notice. Then share it or buy it. View in Mac App Store
Tabular
Read and write tablature notation for guitar, bass, drums and more. View in Mac App Store
AmpKit
Turn your Mac into a powerful guitar amp and effects studio. View in Mac App Store
Sound Forge 2
Record, edit, process and render high-resolution audio files. View in Mac App Store
Install any app with ease.
The Mac App Store revolutionises the way apps are installed on a computer — it happens in one step. Enter the same iTunes password you use to buy apps and music on your iPhone, iPad, Mac or iPod touch. Within seconds, your new app flies to Launchpad, ready to go. So you can spend more time enjoying new apps and less time installing them.
Keep your apps up to date.
Since developers are constantly improving their apps, the Mac App Store keeps track of your apps and tells you when an update is available — including OS X software updates. Update one app at a time or all of them at once, for free. You can even have your apps and OS X update automatically, so you’ll always have the latest version of every app you own.
The app you need. When you need it.
Can’t open a file you’ve downloaded or received in an email? OS X can search the Mac App Store to find the app that can open the file. Buy what you need instantly and get back to business.
Apple Mac App Store App
Buy, download and even re-download.
You can install apps on every Mac authorised for your personal use, and even download them again. This is especially convenient when you buy a new Mac and want to load it with apps you already own.