Update January 26, 2012: I've updated the sheet. Go to the Investing Resources to download the latest sheet.
FINALLY! It's been a couple of months since I wrote. A newborn and a 2-year old definitely takes up a majority of my free time! Today was a bit of a vacation. The family is staying over at my parents' for the weekend and so, I have some time to sit down and do some personal stuff, while there are plenty of people looking after the kids!
I promised, earlier on, to publish my Rule #1 spreadsheet with the auto stock lookup. You can access the spreadsheet HERE. The first thing you need to do is make a copy of the sheet so you can make edits to the sheet. Click on File > Make a Copy, and name the file to your liking. Oh yeah, you'll need a Google account.
How the Sheet Works
The main difference in the sheet lies in the "Stock List" tab. The tab is designed to run the Rule #1 analysis on the symbols that is specified in column A. Here's a simple procedure on how to use the sheet.
- Fill in Columns A and B with the symbols and their respective stock exchange.
- Click on Automation > Run Stocks - Start at Top. This will start the script and the table will be filled with the Big 5 numbers.