A new ability in Numbers 4.1 is a function that gives you current stock prices.
Let's take a look at that.
I'll go into a cell right here.
I'll type equals and stock, which is the function.
I'll also search for it over here so I can see the information about the stock function.
It takes two parameters.
The first one is going to be a symbol so for instance the stock symbol.
The second one is going to be another value where you can ask for a certain thing like
price name, amount change, open price.
That kind of thing.
Let's start off simply here.
I'll do a quote AAPL which is the Apple stock price, close quote there and I will get the
value for Apple stock right now.
So that's the simplest thing you can do with it.
You can do it with anything else you want.
So, for instance, stock and if I wanted say Goggle I can do that.
So let's make things a little bit more interesting.
Let's delete those and let's put some stock names on the left here.
So start with AAPL, and we'll have GOOG as well.
Let's use the stock function and use this as the value right there, comma, and then
I'll use one of these second parameter things like price.
So let's do price, price like that, and it'll give us the price.
The cool thing is that if I copy this and paste it here it's of course going to pickup
the Goggle stock name rather than Apple and I get that.
So now I can add whatever I want here to the left.
So I can do Tesla for instance.
If I copy and paste that, I get that.
You can use this for other things as well.
So, for instance I can do stock and click there of course, comma, and let's use one
of these other things I can do; open, close, change, market cap, volume, anything I want.
Even there's one here for name, for instance.
So let's do that.
You can see it gives me the official name for the company.
If I copy and paste it here and here then the formula will move accordingly and I get
Apple, Inc, Alphabet, Inc which is the official name for Goggle, and Tesla, Inc.
You can do that for other things as well.
If I wanted to have the volume I can do the volume and I'll copy and paste it for those.
So you can kind of keep track of your stocks very easily here.
Just add a new row here, just copy and paste this row there, and I can get Amazon's price
really easily.
Now you may have noticed that there's another stock related function.
It's called Stock H and if I look for the Help for that I can see it gives me the historic
information for it.
So I can do price for Apple there, and I can say I want the, let's see I have to pick here
something a little different.
So I can say the closing price or the opening price, or the high.
So let's do the closing price and then you have to pick a date.
So the date can be in a special format, you know, just like this, so that's January 3,
2017 and that should work there.
There we go and I copy and paste that here I'm going to get the closing price for January
3rd for each one of those.
You can do all sorts of other things with the history there.
You can also pull from another field what the date is rather than actually typing it
there in quotes.
One note of caution there is you have to have a date that works.
So if I did January 1st, the stock market was closed that day, so there was no closing
price and I would get an error.
So it's useful and the stock and stock history functions can be a great addition to your
spreadsheets if you use them to track Wall Street.