About a month ago, I posted here asking for help/tips with my investing spreadsheet. Now that I've had some time to tinker with it, I'd like to resubmit my spreadsheet for some brutal constructive criticism.
I will try to field any questions about how I use it or how I came up with my formulas and rankings; but here are answers to some questions I anticipate:
-
This data reflects my actual investment portfolio. It's not much, but it's what I have to start with.
-
I invest based on Rule 1 principles (Warren Buffet, Charlie Munger, Phil Town). This means that I evaluate each company to find their sticker price and then cut that in half to find the MOS (Margin of Safety) price. If you have any questions on this method, I can highly recommend Phil Town's book, Rule #1.
-
My rankings are also based on Rule 1 principles, which valuates every company and gives a score between 1-100 (100 being best). I take the Rule 1 score and multiply it by the difference in stock price and the MOS price. This is not a perfect ranking system, and it merely serves to sort my list. I DO NOT rely entirely on this ranking to make my investments. It is simply another metric that helps me determine value vs cost.
-
I hide a lot of my columns on the "Watch List" tab, but I have the sheet protected from editing to keep all you filthy animals from wrecking it. I copied that tab and un-hid the columns so you can poke around and see what's under the hood.
-
If you would like an editable copy of this sheet, please feel free to make a copy for yourself. If you cannot make a copy due to the restrictions I've placed on it, DM me and I will send you a copy of your own.
-
On the "Open Positions" tab, where you see my value "vs. market", this represents the multiple at which I am growing compared to the general market (Dow, Nasdaq, S&P 500). For instance, if this number is 2, then I am growing at 2x the market pace. You'll see how I come up with the 'market' rate on the "Performance Calculator" tab. (This multiplier is also in use on Column W on the "Watch List" tab)
-
I bought my first stock on May 24, 2017 and then picked up a few more along the way. You'll notice that some of my numbers are calculated from that date. I did this to set a baseline for myself from my own entry point into the market.
-
Column AC shows a sparkline that shows the momentum of growth (these lines are NOT representative of the historical stock price). This sparkline is shaped by the growth rate of each company, and the figures used to calculate that rate are hidden to the right of Column AC.
-
As much as I have been able to, I pull data from Google's finance API. If you see anywhere that I have missed an opportunity to automate fields that are otherwise being manually entered, I'd be glad to take some instruction.
So without further ado, I submit to you, Reddit, my current investing spreadsheet. Please be gentle in your critiques... I'm still new to this. :)
Submitted June 21, 2017 at 02:44PM by shamgar_bn http://ift.tt/2rDCLyt
No comments:
Post a Comment