Here are a variety of functions, features and tips for Mac Numbers that many Numbers users don't know about.
Check out 25 Things You Didn’t Know You Could Do With Mac Numbers at YouTube for closed captioning and more options.
Download the example file.
Thank you very much for this topic, it’s really helpful when working in Numbers.
Very timely. I just looked at the Stocks template yesterday and couldn’t figure out how they had done some calculations. After poking around, I found ‘Previous gain’ in a hidden row. Your video has now shown me more things that I wasn’t aware of, and some will be helpful. As an aside, I wish Apple annotated their templates to explain how they were pulled together.
You just blew my mind with this.
I’m using Numbers at the very basic level of just showing tabular data.
I knew that there were many formulas available, and I’ve used some of the math functions. But this goes beyond anything I would need to do! Still, fun to know.
Very helpful, Gary. Do you have a way to generate a value for “yesterday” which also skips over holidays? I’d like to use that in a spreadsheet to look at yesterday’s closing stock value, since todays closing value won’t be correct until after the close.
Ray: Look at WORKDAYS in the help. You can use a value like -1 and then add your holidays in to get the previous work day.
Tried that: =WORKDAY(“1/1/21″,-1,”1/1/21″) returns 12/30/20, not 31. Also tried =STOCK(TSLA, previous close), but that seems to return value for two days ago, according to =STOCKH(TSLA,close,”2/18/21”) {today’s the 20th}.
Ray: WORKDAY(“1/1/21″,-1,”1/1/21″) probably returns 12/30/20 because you are eliminating 1/1/21 and also going back one more day as well. The other one makes sense because you are asking for the “previous” close, not the current price.
Thanks, Gary. For my personal finance tracking, those answers work well enough. I think I’ll use the =STOCK( ticker,previous close) function for just a quick look, and perhaps the =WORKDAY( date,-1) function (no holidays) and =STOCKH( ticker,close,date ) for trend tracking.