Spreadsheet Man

View Original

Charting The Performance of Stocks on a Google Sheet

When looking for stock investments, I often want to know how one stock has performed in comparison to another. Sometimes that comparison will be to an index, like the Dow Jones Industrials (.DJIA) or sometimes to a competitor company or sometimes just two staple companies in two different industries to see how the industry performance compares.

Example of a comparison: Slack (WORK) vs Zoom (ZM)

The main data you need to do this is historical price quotes - usually closing prices being enough to do the job. Google Sheets allows you to get historical data in a spreadsheet as I described in an earlier blog post. It also allows you to chart that data quite easily.

In these crazy times of COVID19 - and related crazy investment markets, I found myself wanting to do these comparisons more and more - and I also found lots of other people who wanted the sameā€¦. so, of course - I created a spreadsheet to share that does this quite easily.

You can request access to this spreadsheet to get your own copy and do your own comparisons!