Webinar – Using Google Finance Functions

For our webinar on Monday, October 8, we will learn how to use the Google finance functions in Google Sheets (online spreadsheets).

Google Sheets is a free, web-based app that creates spreadsheets which can be shared with other people. All that is required to use Google Sheets is a web browser on any operating system. If you are familiar with Microsoft Excel or Apple Numbers, you will be comfortable with Google Sheets.

Unlike Microsoft Excel or Apple Numbers, Google Sheets offer a wide array of financial functions such as current prices, fundamental stock data, and mutual fund performance. The financial functions can be embedded in a Google Sheet to provide nearly real time updates. For more information see the Google Finance help page.

We will use this example Google Sheet for the webinar. You can save it your Goole account and modify it for your use. Also, here are the presentation slides.

Webinar – How to Become an Investor Computer Geek

Here are the slides from our webinar on February 1, 2016. Click here to download the slides.

You can find more about Google Finance on this Google help page. Here is a good article from Investopedia on using Yahoo Finance.

We showed several examples of Google Sheets. You can download the examples, save them to your Google account, and adopt them for your own use. The complete list Google Finance functions can be found here.  Here is a good article on using the Google financial function. Example 1 shows how they work.

We also mentioned two exceptional on line services. Here are links to these services and descriptions of their missions.

Manifest Investing. “The mission of Manifest Investing is to dramatically simplify the world of investing and to transform the experience of individual investors into something less mysterious, less stressful and more successful.”

Stock Rover. Its mission is “to empower investors of all levels to make better investment decisions by offering a comprehensive, accessible, and affordable stock research platform.”