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: 6 Responses to “Tracking Stocks With Numbers On Your Mac”

    Todd Smith
    3 months 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?

    3 months 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
    3 months 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
    3 months 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?

    3 months 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
    3 months 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/

Leave a New Comment Related to "Tracking Stocks With Numbers On Your Mac"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)