Creating your own Dividend Meter, a dividend tracking spreadsheet, can be accomplished in just a few minutes.While Excel is often utilized to track investment portfolios, there are import functions in Google Sheets that are extremely useful for automatically updating stock quotes and dividend figures.Spreadsheets help us sort and label in a way that makes sense, so we can reference it and perform calculations later.
All you'll need is a web browser (or the Google Sheets app on your i OS or Android device), and a free Google account.
On your Mac or PC, head over to sheets.google.com, and you're ready to get started.
There was only one problem: these spreadsheets were tied to a single machine, which made it difficult to share data.
Plus, if your sheet was accidentally erased or lost due to computer failure, it was gone for good.
And so, as the next evolution of the papyrus scratchpad, Google brought spreadsheets online in 2006 with their Google Docs suite.
Now in Google Sheets, you can create spreadsheets together with others online, and crunch numbers from any internet-connected device. It looks and functions much like any other spreadsheet tool, but because it's an online app, it offers much more than most spreadsheet tools.
Try looking for data that’s actually in an HTML table (like movie data from IMDB, for example) to avoid getting funky pasted data in your spreadsheet.
Note: Make sure you only click once on a cell before pasting data, so Google Sheets will turn it into a list with each item in its own cell.
Interested in writing your own scripts for Google Sheets?
We'll dig into those in chapter 8 with tutorials on writing Google Apps Script.
As soon as you open a new spreadsheet, if you just start typing you’ll see that your data starts populating the selected cell immediately—usually the top left cell.