Using Google Sheets to Create a Portfolio Tracker

October 18, 2014

Google offers several productivity apps that allow users to create documents, spreadsheets and presentations and access them from any computer, anywhere in the world, for free. These apps are called Google Docs, Sheets and Slides. In this Spreadsheet Corner, we concentrate on Google Sheets. Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and simultaneously work with other people.

Introduction to Google Sheets

Google lists these features in their Google Sheets explanation:

  • Import and convert Excel, .csv, .txt and .ods formatted data to a Google spreadsheet
  • Export Excel, .csv, .txt and .ods formatted data, as well as PDF and HTML files
  • Use formula editing to perform calculations on your data, and use formatting make it look the way you’d like
  • Chat in real time with others who are editing your spreadsheet
  • Create charts with your data
  • Embed a spreadsheet, or individual sheets of your spreadsheet, on your blog or website

Read More »

Contact CI       Computerized Investing

CI Market Dashboard

We have put together a collection of market indicators and track them to help you gauge the direction of the market.

CI Analysis Worksheets

Interactive analysis templates covering DuPont analysis (return on equity), valuing stocks the Warren Buffett way, and more to come.

CI Blog Feed Revamps Site and Releases Mint Bills
posted 17 minutes ago by Jaclyn McClellan

Schwab Launches “Intelligent Portfolios” in 2015
posted 4 days ago by Jaclyn McClellan

TomTom Multi-Sport GPS Watch
posted 4 days ago by Hareesh Jayanthi

Trends IV portfolio tracker
posted 5 days ago by Hareesh Jayanthi

Product launches to look forward to in 2015
posted 7 days ago by Hareesh Jayanthi

Recent Articles

July 19, 2014

CI’s Financial Ratio Analysis Spreadsheet

Excel spreadsheet automatically derives financial ratios for company analysis after a simple import of financial statement data from

First Quarter 2014

Calculating Mohanram’s G-Score Using SI Pro and Microsoft Excel

Quantifying a strategy focused on separating the winners from the losers in high price-to-book-value stocks.

Fourth Quarter 2013

Excel 2013/Office 365 Home Premium

A look at the fundamental changes that have taken place with Office 2013 and some new features offered in Excel 2013.

Third Quarter 2013

The Ulcer Index of the AAII Stock Screens

Calculating the downside risk of the stock screening methodologies tracked at

Click here for entire collection of Spreadsheet Corner articles ➜