Tracking Stocks With Numbers On Your Mac

You can track and chart stocks in Numbers on your Mac with the STOCKH function. You can get the close, high and low prices for a stock on different days and then use formulas and filters to build various charts. You can then easily change the stock symbol and dates to generate new charts.

Comments: 12 Responses to “Tracking Stocks With Numbers On Your Mac”

    Todd Smith
    4 years ago

    I have used that STOCKH function set to get the closing price every Friday. I find that many times when I open the spreadsheet after the market closed the prices are not updated on my sheet PRices do not update until sometime on Saturday. Ami missing something?

    4 years ago

    Todd: Maybe it is previous day's closing, so it won't show. Also, maybe trying changing a value (some extra cell) toileting get the formulas to recalculate?

    Tim A
    4 years ago

    From Numbers Notes
    "If you enter a formula with STOCKH when the internet is unavailable, STOCKH returns no value. However, when the internet becomes available, the formula updates with a value returned by STOCKH."

    I just experimented and found Numbers far more 'intelligent.' Once I had a successful download I could go offline and the stock values were retained. More surprisingly I could look back 6 months and the cell populated correctly!

    Maury Cralle
    4 years ago

    How can I grab all my stock symbols from by broker account and insert them into Numbers so they only go one per cell?

    4 years ago

    Maury: Hard to say without knowing the details. But look for an export function from your broker and get a CSV file, or Excel file. Or, just copy and paste. If pasting doesn't work, then paste into TextEdit (plain text) first and clean it up with one per line, then copy and paste from there.

    Tim A
    4 years ago

    A nice way to see all the details of a function instead of trying to scroll through them of to the right (1:36) is viewing them in:
    Menu/Help/Formulas and Function Help
    which takes you to a full page display in your browser...https://help.apple.com/functions/mac/9.1/

    David Barnet
    4 years ago

    I am trying to add RDS.A using Stock in Numbers to get the name and updated information. It won't populate, since RDS.A is a Holland-based company to I need to add anything to the Stock Symbol to get it to populate?

    4 years ago

    David: Well when I did a search online for RDS.A it came up with the Yahoo stock price for it. There the symbol is RDS-A, if that is the same thing. I tried "RDS-A" in Numbers and it gave me a price.

    Joseph Snow
    4 years ago

    Thanks for the great videos; makes my Patreon donation an easy choice to continue supporting your work!
    I started with the Portfolio example template from Pages, which seemed to be a good place to start loading
    Looking at the STOCK function, I would like to add a column for the 52 week high, which is supported by STOCK. However, when I try to add that column, I get an error message that states "This formula can’t reference its own cell, or depend on another formula that references this cell."

    4 years ago

    Joseph: hard to know what could be wrong without seeing the formula. What is it?

    len
    3 years ago

    Thanks! but how do we add/locate stocks trading on TSE? can only find NASDAQ stock.

    3 years ago

    len: Just find out the exact characters used to represent the symbol on Yahoo Finance.

Comments Closed.