Feature Archives

Buying a Computer

Trends in the computing industry and issues to consider before purchasing a new computer or upgrading your current system.


Analyzing, selecting and trading exchange-traded funds

Investor Sentiment

Using investor sentiment to indentify tops and bottoms in the market.

Market Breadth & Timing

Market breadth and momentum indicators to gauge the market's overall direction.

Mutual Fund Screening & Analysis

Screening for and analyzing mutual funds.

Portfolio Management

Constructing a portfolio of investments and the issues involved, including risk management.

Software Reviews

In-depth reviews of some of the most popular investment-related software.

Stock Screening & Analysis

Using quantitative stock screening filters to identify possible investment and analyzing individual stocks.

Stock Valuation

Determining the "true worth" of a company.

Technical Analysis & Charting

Using technical indicators and charts to help time your buy and sell decisions.

Tax Preparation

Using computerized tools and resources to prepare and file your personal income taxes.
Computerized Investing > First Quarter 2011

Online Spreadsheet Programs

PRINT | | | | COMMENTS (10) | A A   Reset

by Wayne A. Thorp, CFA

Spreadsheets are simple, yet powerful, investment analysis tools. In each issue of Computerized Investing, the Spreadsheet Corner introduces spreadsheet templates and utilities that individual investors may use in their investment analysis and tracking. Over the years, there have been many spreadsheet programs: AppleWorks, Lotus 1-2-3, Microsoft Excel and Quattro Pro, just to name a few. While a useful analytical tool, spreadsheet software can be a bit pricey. According to the Microsoft website, Excel retails for around $140.

With the advent of Web 2.0 technologies and faster Internet connections, there has been a trend in recent years toward online spreadsheets. These Web-based applications offer many of the features found with their software-based brethren at little or no cost. While typically not as powerful as software-based spreadsheet programs, online spreadsheets have the benefit of being accessible via a Web browser without the need to buy and install software. Furthermore, many online spreadsheets allow for multi-user collaboration, meaning that you can share your spreadsheet with other users, who can also collaborate in modifying and enhancing the spreadsheet. In this article, we cover some of the more full-featured online spreadsheets available today and discuss their functionality. To evaluate each service, we attempted to replicate the Simple Valuation Spreadsheet discussed in this issue’s Spreadsheet Corner article that begins on page 12.

...To continue reading this article you must be a Computerized Investing Subscriber.

Gain exclusive access to this article and all of the benefits and investment education a Computerized Investing subscription offers.

SUBSCRIBE TODAY for just $24.
Log in
Already a CI subscriber? Login to read the rest of this article.

A subscription to Computerized Investing includes a monthly email and access to the CI Website, all of which aim to benefit your investing skills with respect to computers and the Internet.