Wednesday, July 30, 2014

Rule #1 Investing Spreadsheet Version 1.4.1

Update October 7, 2014: Spreadsheet has been updated.  See

Hello Readers!  If you've been following me previously, then I must thank you for your loyalty, because my last personal post was written more than 2 years ago!  It's funny how priorities change very quickly in life.  Well, the word "idle" definitely doesn't describe my life over the past 2 years!  Anyhow, I'm glad I actually got around to writing this!

And if it's your first time to this blog, please take a look at all of my older posts...the last 2 years have proven that my wisdom, albeit finite, is not so bad after all.  Do click around and if you like what you see, please subscribe and/or follow (see navigation bar on right)!

Sorry, back on topic.  Although I paused blogging for a while, I definitely haven't stopped investing.  I've also made some tweaks to my Rule #1 Investing spreadsheet.  I give you Version 1.4.1:  In order to use this sheet, you will need a Google account.  Once you're logged in to Google, click on File > Make a Copy and you're good to go.  You now have a copy of the spreadsheet in your Google Drive.  Feel free to make any modifications as you see fit.

Just a quick note of how to work the sheet.  In the "Stock" tab, you will see a "User Inputs" section on the left.  This is the only place where you should be typing in stuff.  Leave everything else alone if you just want to use the sheet as is.  Type in the symbol, select the country, type in any overriding inputs (e.g. estimated growth, etc.).  As soon as you type something, the sheet will automatically update.  It shouldn't take any more than a couple of seconds.

As a final note, I've been using the Fischer valuation model quite a bit and I like it over the Rule #1 model.  You can read all about it here:

Have fun investing!  And write me a comment if you get a chance!