thnx for the video! The stock prices don't update when Numbers is opened right? I have to close and open to see updated stock prices. Is it possible to update when Numbers is opened?
Only question I have is how often it updates, or does it only update the values when opening the doc? Great video I would have never guessed you can track stocks and crypto in Numbers.
I like the practical applications of your video. Make a video that I can watch in 10 minutes and put into practice immediately. Just what a new comer to MacOS needs to put the Mac Mini to use. I can always open my brokerage account to get the details, but this is a great way to see how my portfolio is doing at a glance. Thank you Gary.
Is there a way to disable folders on certain desktops on Mac, so that one desktop has my folders but when I three-finger swipe left the other one does not?
Great video. very helpful, thank you!.... Quick question. After all set up, how do I refresh the STOCK formula/values? Without having to close and reopen the document? Cheers!
MY GUY IM SO GLAD I FOUND YOU Years ago needed app help and you still fixing my computer to this day Fr one of the best ones right here Thanks for everything
You chose bitcoin as the crypto to use for your example, that's how I know you are a good and smart man at heart :) It would be awesome if you could put together a nice tutorial to create a numbers spreedsheet\setup all to do with tracking stocks and crypto, like your stock purchases, how to track you cost basis etc etc. Would make tax season much easier ;)
this is great, thank you so much. on the other hand it doesn't bring the close value, not updating I think. when I check the yahoo finance it is true but the value in numbers is different even the stock market is closed 5 hrs ago. Is there any solution for this problem?
thank you so much for this video… you help me a lot because i was wondering how to copy all the crypto files i need in school. And I found your video. I really really appreciate it ! thanks again good sir.
Throughout the day the Stock function in Numbers returns the previous closing price. Which is why I changed to Google sheets to get the recent price (with the 20 minute delay). Any explanation?
can you give example and breakdown for - acquisition cost, - floating profit / loss, - realized profit / loss, - floating ROI and, - realized ROI (return of investment)?
damn thanks for the video, you are the man, I like your videos always learn something new, I just wish the price of BTC was what it was at when you uploaded this lmao
GREAT, THNX GARRY !I dont have find the way without you. how can i join YOU ON patreon? just a pRobl. my numbers is in french. it is complex to transcript your explanations in the french interface. for example, the func names are different. Is there un way to change the interface languGE ON THE FLY?
Thanks. Very helpful video. The tip about Yahoo Finance is very useful. Now I know how to update my numbers/stocks app to get stock quotes in euro from Frankfurt exchange ( I live in Berlin ). Have a great day !
I like using numbers, but I’m pretty new to using it and thought I could find some help on YT. These videos are informative, but I noticed something when searching, he’s one of the very few making videos like these on YT. Is that an indictment of the programs popularity?
@@macmost Popular products tend to have a variety of videos and tutorials. I like to get my info from different sources. Searching for Excel tutorials gives much more diverse results than searching for the same thing in Numbers. It’s mainly just you making videos for this. Don’t get me wrong, I like Numbers, but I’d also like for more people to make videos on them to get different perspectives. This isn’t your fault of course. But it does make it look like Numbers is smaller and more niche than alternative programs.
@@maxminutiae1170 It definitely is more niche. After all, it is only on Macs whereas Excel is on Windows and Mac, and Google Sheets as well. So it will always have a smaller audience. If having tons of tutorials and support from a massive community is your concern, then Excel is definitely the right choice for you.
thnx for the video! The stock prices don't update when Numbers is opened right? I have to close and open to see updated stock prices. Is it possible to update when Numbers is opened?
Only question I have is how often it updates, or does it only update the values when opening the doc? Great video I would have never guessed you can track stocks and crypto in Numbers.
Daily.
I like the practical applications of your video. Make a video that I can watch in 10 minutes and put into practice immediately. Just what a new comer to MacOS needs to put the Mac Mini to use. I can always open my brokerage account to get the details, but this is a great way to see how my portfolio is doing at a glance. Thank you Gary.
Is there a way to disable folders on certain desktops on Mac, so that one desktop has my folders but when I three-finger swipe left the other one does not?
No, every Desktop shows the same file contents (the Desktop folder).
Opens a lot of possibilities in charting stocks with graphs and such while using Numbers, as well. Thanks for these great tips.
What is the name of the application that shows the keystroke in the stream?
That's done by my screen recording app, ScreenFlow. macmost.com/j-screenflow (affiliate link)
could u explean us how to use Mac for start do data analysis.
"Data analysis" is a big topic. Is there something you are trying to do, specifically?
Just what I needed. Thanks!
Like Agostinho asks, how does refreshing work?
Great video. very helpful, thank you!.... Quick question. After all set up, how do I refresh the STOCK formula/values? Without having to close and reopen the document? Cheers!
did you already found it? im looking for the same.
@@p.m.8316 unfortunately no :😬
I just resigned to the close/open refresh mode 😞
@@agostinhoserra yes that sucks
So appreciate your video
However, the stock price will change automatically??
In the Stocks app, yes.
@@macmostthanks your reply asap.
but in numbers sheet too ?
@@ryanchen7212 In Numbers, the updates are daily. But if you just leave the spreadsheet open and don't make any changes it won't look.
@@macmost Tkanks your reply
Thanks for Video, So may I ask how can I add Stock Marketcap and Date update (previous time) on colum?
Look through the Help info for the STOCK and STOCKH functions to see what is possible.
Another great video, Gary!! Does this price update automatically or is there some user input required like in Google Sheets?
It updates daily.
@@macmost Is there a way to "force" update?
@@tropicaldany9306 The data itself is daily. So forcing an update during the same day would just give you the same number.
great video! how to have a real time price value for cripto or an updating in 1 minute or hour by hour? thanks.
You can't do it in Numbers. Some sort of website or app is probably what you need for that.
Hi! How to do it with Binance charts etc.. ?
Do what, exactly?
Track the charts from mid or small caps crypto, that not supported by yahoo. maybe read data from coingecko or coinmarket.@@macmost
load data from other chnnels like coinmarket / coingecko etc.. So to have access to charts yahoo do not have.@@macmost
How do we track unleaded gasoline per gallon price on Apple Stocks?
You can't since it isn't a stock or a commodity like that. Each gas station has its own price.
A GREAT tip for crypto. Thank you Garry.
Thank you for your excellent videos! Have you done one on Apple Car Play? Thank you. Cheers
No, it changes too frequently and varies from car-to-car. Did you have a question about it?
MY GUY IM SO GLAD I FOUND YOU
Years ago needed app help and you still fixing my computer to this day
Fr one of the best ones right here
Thanks for everything
Awesome video! Is there anyway you can make a video for keeping track of a portfolio in numbers? Cost basis tracking?
see templates
Back in 2017 one could do this is Google sheets until the service it used didn’t allow it any more. This is great news !
When we all got BTC for $6k, rode the wave to $17k, didn't sell and then ended up selling at $3k cos we didn't HODL! Those were the days ........
You chose bitcoin as the crypto to use for your example, that's how I know you are a good and smart man at heart :)
It would be awesome if you could put together a nice tutorial to create a numbers spreedsheet\setup all to do with tracking stocks and crypto, like your stock purchases, how to track you cost basis etc etc. Would make tax season much easier ;)
Thank you so much!!!! 🙏🙏 Your tip is like the holy grail for me!!! Thanks!!
this is great, thank you so much. on the other hand it doesn't bring the close value, not updating I think. when I check the yahoo finance it is true but the value in numbers is different even the stock market is closed 5 hrs ago. Is there any solution for this problem?
Not sure when the numbers update exactly. Test and see.
thank you so much for this video… you help me a lot because i was wondering how to copy all the crypto files i need in school. And I found your video. I really really appreciate it ! thanks again good sir.
how do you insert the realized cap to the equation? can’t find them, there’s only market cap
Thanks!
Throughout the day the Stock function in Numbers returns the previous closing price. Which is why I changed to Google sheets to get the recent price (with the 20 minute delay). Any explanation?
Yes, that's right. It is only daily. Probably complicated legalities involved there. I do have this video: th-cam.com/video/Q-nC8kCJB28/w-d-xo.html
@@macmost Thanks for the quick reply, Gary. I use Sheets for stock work and Numbers for everything else. I enjoy your videos.🙂
Great tips!! I can't get SI=F (SILVER) to work but other work fine. Any thoughts?
That works in the Stocks app, but it doesn't seem to in Numbers. I don't know why.
can you give example and breakdown for
- acquisition cost,
- floating profit / loss,
- realized profit / loss,
- floating ROI and,
- realized ROI (return of investment)?
Sounds like questions for an accountant, not me...
Fantastic, thank you. I have been looking for a solution using mac. Brilliant video 🙏
damn thanks for the video, you are the man, I like your videos always learn something new, I just wish the price of BTC was what it was at when you uploaded this lmao
GREAT, THNX GARRY !I dont have find the way without you. how can i join YOU ON
patreon? just a pRobl. my numbers is in french. it is complex to transcript your explanations in the french interface. for example, the func names are different. Is there un way to change the interface languGE ON THE FLY?
Thanks! macmost.com/patreon is the link. In System Settings, General, Language & Region, you can set languages for each app if you want.
Thanks bunches
Thanks. Very helpful video.
The tip about Yahoo Finance is very useful.
Now I know how to update my numbers/stocks app to get stock quotes in euro from Frankfurt exchange ( I live in Berlin ).
Have a great day !
You are a genius :)
Thank you, Gary! 👏🏻❤️
Nice video, however I would like to know how to get ALL crypto prices in Mac for Excel. Stock info etc is still very limited there
Not sure what you mean. Excel is different. Look in the docs for how to do stocks in Excel.
I like using numbers, but I’m pretty new to using it and thought I could find some help on YT. These videos are informative, but I noticed something when searching, he’s one of the very few making videos like these on YT. Is that an indictment of the programs popularity?
Why does it matter if it is popular?
@@macmost Popular products tend to have a variety of videos and tutorials. I like to get my info from different sources. Searching for Excel tutorials gives much more diverse results than searching for the same thing in Numbers. It’s mainly just you making videos for this. Don’t get me wrong, I like Numbers, but I’d also like for more people to make videos on them to get different perspectives. This isn’t your fault of course. But it does make it look like Numbers is smaller and more niche than alternative programs.
@@maxminutiae1170 It definitely is more niche. After all, it is only on Macs whereas Excel is on Windows and Mac, and Google Sheets as well. So it will always have a smaller audience. If having tons of tutorials and support from a massive community is your concern, then Excel is definitely the right choice for you.
@@macmost I prefer the functionality and look of Numbers better. My hope is that someday more TH-camr will take a greater interest in the program.
this data from Yahoo seems to not be real-time. Thanks for the video
Yes. Yahoo, and other free data, are usually 20 minutes. You have to pay for real-time.
Great video. Thank you.
I just have the yahoo app on my phone, but going to play with this and see if I can make live charts or graphs in Numbers.