Other sources put it at 17-19, which may just be 6 months out of date. Tse:ryWOW… This is neat… Just needed a tweek to get the latest formula formats and a slight change in the symbol.. Old Watchlist … I’ve been meaning on getting a watchlist rolling. Specifically regarding dividend and yield data. LibreOffice Calc is a free spreadsheet and there is GETQUOTE add-in that can be used for the stock data. @Steve, Excel also has a “stock addin” that will enable you to do the same thing. I had no idea Google Spreadsheet could do that.You just convinced me to switch to Google Spreadsheet for that purpose. So, I guess it may be still working….The API isnât the same thing as the Google Sheets function. Updated: March, 2019. I brought this post out of the archives due to a number of recent emails about how to track stock holdings. [Optional] To save videos to buy or watch later, tap Watchlist . @SavingMentor, although Office may be offered in the cloud in the near future, I doubt that they’ll offer it for free! She's been a professional writer for two years, with a year of experience devoted to cord-cutting coverage. @Alex, the Google stock quotes are still working for me? Â For example, if you would buy RY.TO when it has a 4% yield, then put 4% in that field. Under "Your Stocks," see the stocks you follow. The challenge I have run into is that there is a max of 1000 GoogleFinance functions and I am hitting it :( I may just move to Excel. There’s also the fact that different websites calculate ratios different ways. Sign in to a different account. If you sign in, the place where you stopped watching a video is saved so you can pick up where you left off on any device. I really like to have access to my spreadsheet everywhere. I see 52-week high and low but not all time.how to determine price of stock is correct or not? @Sustainable_PF, the updates are about the same as the info has to load from the web. It’s not free on the G&M site but it is free on Lesaffaires.comAwesome. They are sometimes missing or worse, incorrect. I, similarly to FT, use historical yields to signal a buying opportunity but I would like to also use historical PEs as a second measure. What’s neat about Google Spreadsheets is that it has a built in stock quote function that can be quite useful. The following instructions outline how to access the Basic Watchlist through the website using a mobile browser: Eg bmo investorline (same program as the globe investor) calculates the dividend yield by multiplying the last dividend payment by 12 / stock price, while yahoo calculates using the last 12 months dividends.
I haven’t tried Office online yet …Don’t forget to add .TO for Canadian stocks otherwise you may pull in the US price.I used google spreadsheet but I soon reached the 1000 formulas limit. I think I tried them all.
Under that, you’ll see the “Watchlist” option you’ll want to select.Once on your Watchlist, select the series or film you want to remove from the list.Select the checkmark next to the “Play” button to remove the show.If the plus (+) sign is shown after selecting that icon, you have removed that piece of content from your Watchlist.Kennedy is a cord-cutting writer who is all about helping others save money. Â You can generally get this information directly from the company website, or even other stock info websites (stockhouse.com, google finance, msn, dividendinvestors.ca).The B7 manual entry field is the dividend yield that you would find attractive enough for you to buy. The way that I calculate cash flow is: net earnings + amortization/depreciation – capex.Isn’t Microsoft planning a massive move to the cloud with their next release of office? When your terms appear on a webpage, they will be… The “Search” button is located in the top row on the desktop site. I didn’t know it was possible to do all of that with Google Spreadsheets and I use them a fair bit myself.I tend to use Google Finance for watching stocks and tracking performance but adding some of this data into a spreadsheet for tracking investments could definitely come in handy as well.Nice tip! In other word is it right time to buy or not?I found your website by chance while surfing the web. Found it quite useful.Thanks for the update ! That sounds like around half the real number. What’s neat about Google Spreadsheets is that it has a built in stock quote function that can be quite useful. Ie. Does anyone else have a good way to look it up?Great tip! Thanks. I usually just use Google Finance for watching, and a custom spreadsheet for tracking.I also use Google Finance to keep an eye on stocks and track my own positions manually with an Excel spreadsheet. Can this be used to track mutual funds, or is it stocks only?FYI, if you try and copy and paste your very first example as I did when trying mine out for the first time, it doesn’t work because the first quotation symbol in front of GOOG is backwards for some reason.Great tip though and thanks for the info, I use a lot of google products.I can’t seem to make it work with stocks on the CNSX.
@Gord, it really depends on how they calculate cash flow.  I still use Google spreadsheets  today to track my dividend holdings.With the market volatility, there is a heightened interest in While not everyone has Excel to use their stock quote addin, most have access to Google’s free spreadsheet app. On mobile, it’s in the lower section in the second spot to the right.Once you have searched and selected your show or movie, a plus (+) sign appears next to the “Play” button. If you’ve already watched a show on your list, you can remove it if you don’t intend to watch it again. Track your stocks and investments with MSN Money's portfolio manager. Pretty soon we probably won’t be able to say that Google docs has that advantage over office.The google data (both spreadsheet and google finance) are sometimes defective. The above article may contain affiliate links, which help support How-To Geek.How-To Geek is where you turn when you want experts to explain technology. On the mobile app, you’ll first have to select your “Account” icon in the lower-right corner. I like how the goog spreadsheet can be accessed from any computer, where the excel spreadsheet is local. The changes include a sleeker design that is mobile-friendly so that you can more easily track your investments across devices.