![]() ![]() Then I could Copy and Paste that throughout here. So if I use Goggle Finance here I can grab the symbol and I could say instead of price I could say volume. Then you could copy the function there and paste it in and it will get all of those. So you can create a whole list of stocks that you want to track. That way I can put something in another cell like that and then copy this formula here, Command C and Command V to paste, and now it will grab the price of this symbol here. Then in here change the formula so that it just refers to that cell. Now a cleaner way to do it would be to have the ticker symbol here. So Goggle Finance and then in quotes the stock ticker symbol and I'll get Apple's stock price like that. The function I want is called Goggle Finance. So if I wanted to get a stock price I'll start entering in a formula with the equals symbol. So you can have numbers and all sorts of different things in here. This looks a lot more like Excel than it does Numbers but the same basic idea for entering formulas applies. When you do that you get a simple spreadsheet. Then you can click New and one of the types of documents you can create is a Goggle Sheet. You go to and you have your file stored here. If you have a gmail account or a YouTube account you've got a Goggle account. You access it through your Goggle account. So GoggleSheets is a spreadsheet app just like Excel and Numbers except it's on the web. If you want you could copy and paste between Goggle Sheets and Numbers to combine the best of both. It's not using Numbers but using Goggle spreadsheets instead. However there is a way for you to get live stock prices in the spreadsheet on your Mac. There's probably some sort of legal and licensing reasons behind that. While that functionality originally gave us live stock prices that soon changed to just daily closing prices. So I love using Numbers and it was great when a few years ago Apple introduced new functions to bring stock prices into cells in Number spreadsheets. ![]() Join us and get exclusive content and course discounts. There you can read more about the Patreon Campaign. MacMost is supported by more than 500 viewers just like you. Let me show you how to get live stock quotes in a spreadsheet on your Mac. Check out How To Get Live Stock Market Prices In a Spreadsheet On Your Mac at YouTube for closed captioning and more options. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |