[et_pb_section][et_pb_row][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]<\/p>\n
[\/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]<\/p>\n
Google Docs Spreadsheets<\/a><\/strong>\u00c2\u00a0is a free cloud-based app that creates spreadsheets which can be shared with other people. All that is required to use\u00c2\u00a0Google\u00c2\u00a0Sheets\u00c2\u00a0is a web browser on any operating system. If you are familiar with Microsoft Excel or Apple Numbers, you will be comfortable with Google Docs Spreadsheets.<\/p>\n If you have not used a Google Docs spreadsheet before, take a look at the Google help pages for spreadsheets<\/a><\/strong>. \u00c2\u00a0You also can find \u00c2\u00a0helpful tutorials and videos at GCFLearnFree.org<\/a><\/strong>.<\/p>\n Unlike Microsoft Excel or Apple Numbers,\u00c2\u00a0Google Docs Spreadsheets\u00c2\u00a0offers 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 Docs Spreadsheet to provide nearly real time updates. For more information see the\u00c2\u00a0Google docs finance help page<\/a>.<\/strong><\/p>\n Here are some examples of Google Docs Spreadsheets that you can use to track portfolios, create stock watch lists, and compare mutual funds. \u00c2\u00a0Simply follow the links and download the spreadsheets in your own Google account. Feel free to copy these spreadsheets to your Google Docs account and modify them to meet your investing needs.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Blurb” title=”Ex. 1 – Google Financial Functions” url=”https:\/\/docs.google.com\/spreadsheet\/pub?key=0Ault2FD3uBwydEVqWERkWEh3Nkl4QjVIR0lFVE93dlE&output=html” url_new_window=”off” animation=”top” background_layout=”light” text_orientation=”center” image=”https:\/\/stockherd.com\/blog\/wp-content\/uploads\/2014\/01\/Ex1_GoogleFinancialFunctions.png” alt=”Ex. 1 – Google Financial Functions”]<\/p>\n These are the basic Google financial functions. They include market data for stocks and ETFs. They also include performance data for mutual funds. You can build powerful spreadsheets to monitor your stocks, mutual funds, or portfolios from any web browser.<\/p>\n You can download a copy of this spreadsheet by clicking here<\/a><\/strong>.<\/p>\n [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Blurb” title=”Ex. 2 – Watchlist” url=”https:\/\/docs.google.com\/spreadsheet\/pub?key=0Ault2FD3uBwydG5IVWt3blltWWVXdDR1T2otaDBqTXc&output=html” url_new_window=”off” image=”https:\/\/stockherd.com\/blog\/wp-content\/uploads\/2014\/01\/Ex2_WatchList.png” alt=”Ex. 2 – Watch List” animation=”top” background_layout=”light” text_orientation=”center”]<\/p>\n This spreadsheet uses Google financial functions to create a security watch list. Note that in each row, the only data that has to be entered manually is the ticker symbol for the security. All of the columns populate automatically.<\/p>\n This watch list shows the 52 week high and low price for each security. \u00c2\u00a0See columns G and H. It also calculates how close the current price is to the 52 week high. See column I. This other\u00c2\u00a0market data is self explanatory.<\/p>\n You can download a copy of this spreadsheet by\u00c2\u00a0clicking here<\/a><\/strong>.<\/p>\n [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Blurb” title=”Ex. 3 – Watch List + Holdings” url=”https:\/\/docs.google.com\/spreadsheet\/pub?key=0Ault2FD3uBwydDlBY1dSeF9iOGlaQmRFclNkNUtHMUE&output=html” url_new_window=”off” image=”https:\/\/stockherd.com\/blog\/wp-content\/uploads\/2014\/01\/Ex3_WatchListandHoldings.png” alt=”Ex. 3 – Watch List + Portfolio” animation=”top” background_layout=”light” text_orientation=”center”]<\/p>\n This spreadsheet uses Google financial functions to create a combined stock watch list and a portfolio tracker.<\/p>\n Columns H and I of this spreadsheet show how to calculate the net gain or loss between two dates. Column P shows how to extract dividend yield from the Google Finance website. \u00c2\u00a0Column P shows how to handle errors by using the iferror() function.<\/p>\n You can download a copy of this spreadsheet by\u00c2\u00a0clicking here<\/a><\/strong>.<\/p>\n [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Blurb” title=”Ex. 4 – Track Portfolio” url=”https:\/\/docs.google.com\/spreadsheet\/pub?key=0Ault2FD3uBwydHVEUFhBa0QyYkJCazhTSENyYndBbWc&output=html” url_new_window=”off” image=”https:\/\/stockherd.com\/blog\/wp-content\/uploads\/2014\/01\/Ex4_TrackPortfolio.png” animation=”top” background_layout=”light” text_orientation=”center”]<\/p>\n This spreadsheet uses Google financial functions to track a portfolio. It includes some key metrics including the relative weights of each holding in the portfolio. This portfolio also shows how to get closing prices for specific dates to compute return.<\/p>\n