Get Free Email Updates!
Join us for FREE to get instant email updates!
Investing Tools I Use
Today I’ll give you a basic overview of the tools I use to manage my investments. As I always say, I am not a financial planner nor an investments expert, nor do I consider myself even close to these things; I’m just a guy who has done a lot of research and done well with investing over the years.
-By Caleb Jones
As always, my primary tool is spreadsheets. Google Sheets is perfectly fine, but I prefer Microsoft Excel. I use an old version (2007) because it’s more than enough to meet my needs. (I was actually using Word and Excel 2003 for many years before upgrading to 2007 just a few years ago because I started having trouble reading other people’s data.) My Excel spreadsheets are double-encrypted, first with Excel’s password protection, then the fact that my entire hard drive on my laptop is encrypted (as well as my backups) as I explained here.
I have numerous spreadsheets that document every aspect of my financial life, too many to describe here. Today I’ll just give you the ones that overview my investments. If you want more details on what I do, you’ll have to come to one of my future seminars. My first spreadsheet is my balance sheet, which lists summarized figures of every asset I have. (If I had any debts, which I don’t, they would be on there as well.) This sheet breaks out my savings numbers, my investment portfolio number (which is different than savings), and my various other assets like my real estate and businesses and such. With one exception I’ll explain in a minute, all of these numbers are accurate to the dollar, and are updated three to four times per month.
Numbers assigned to my business valuations are educated guesses that could be way off, so those are on a separate part of the sheet. Because of this, I actually have two net worth numbers, one “guaranteed” net worth figure; this is a literal sum of all my quantifiable assets, and a “guess” net worth that includes the value of my businesses, which again, is only a guess. My long-term financial goals reflect the fact there are two different figures as well. Another spreadsheet is my speculation portfolio, which is represented just as a single number in my balance sheet spreadsheet. My portfolio sheet shows current balances of all of my speculative investments with information on each such as:
Current value Value when purchased Weighted averages of total contributions ROI percentages for the current calendar year, past calendar year, and all-time total All of these numbers are updated three to four times per month.
It then has various totals showing total portfolio value, total ROI on the portfolio (again for the current year and for all time), breakdown percentages of types of investments, breakdown percentages in terms of how much my portfolio represents as compared to my total savings and total net worth, and so on. These two sheets are fantastic since I can quickly glance at just a few numbers and instantly get a very accurate picture of my overall financial health. I use them often, and they are the backbone of my finances (not my businesses, business is different than finance).
Investopedia.com is essentially Wikipedia for investors, but even better-written and structured. Any time I come across a term I don’t understand, or a complex calculation I need to make, Investopedia always has the answers, written in clear-cut English. Hugely valuable. I have never not found what I needed at Investopedia.
3. My Brokerage Firms
I can’t tell you which firms I use, but you will need to use a brokerage firm to purchase at least some of your investments. Obviously you don’t need a firm to own silver bars or bitcoin, but for things like ETF’s, stocks, and money market accounts, you’ll need to go through a brokerage firm. Any firm that is big and has a long track record is fine, and I have no specific recommendations beyond that. Guys with more extensive investments should probably use two or three firms to spread out risk.
If you’re an American, examples of investment firms would be Charles Schwab, E-Trade, Fidelity, Merrill Edge, Ameritrade, and many others. If you’re outside of the US, just do a Google search. Once you have your account set up at your firm, you’ll have access to their website where it will list all of your investments in ways very similar to my spreadsheets. Plus, they will always have the current stock prices up-to-date in real time. Many guys just use their brokerage’s website to manage their investments instead of making spreadsheets like I do, but I prefer my spreadsheets since I want things organized and totaled exactly the way I like.
You can search a stock ticker symbol for any stock, ETF, money market account, or whatever on Google, and it will instantly bring up the current real time price plus all the relevant historical charts. I have a group of tabs as favorites in my browser (I use Firefox since it’s most conducive for online privacy) set up where I can pull up the current prices of all the relevant assets I own with one click, and without having to log into a brokerage or use Yahoo Finance (which is what I used to use). Very nice.
That’s about it! You’ll notice I don’t use any financial management software or systems (like Morningstar, etc). Part of my personal Code is to always keep things as simple as possible. A spreadsheet or two and a few websites are all you need. If you find the content on this blog helpful, you should join the Alpha 2.0 Community where there’s even more. We have over 460 members who help each other with their financial and woman lives and building an Alpha Male 2.0 lifestyle. I also have community-only podcasts there that aren't available anywhere else. It's free to join. Just click here.
Want over 35 hours of how-to podcasts on how to improve your woman life and financial life? Want to be able to coach with me twice a month? Want access to hours of technique-based video and audio? The SMIC Program is a monthly podcast and coaching program where you get access to massive amounts of exclusive, members-only Alpha 2.0 content as soon as you sign up, and you can cancel whenever you want. Click here for the details.
Get Free Email Updates!
Join us for FREE to get instant email updates!
JohnB 2018-02-28 17:51:14
Your thoughts on China's Communist Party to eliminate term limits for both the president and vice president?
Caleb Jones 2018-03-01 12:47:32
Your thoughts on China’s Communist Party to eliminate term limits for both the president and vice president?More authoritarian bullshit from China's government, as usual. Now let's get back on topic.
joelsuf 2018-03-01 15:26:28
Exactly how many things are you invested in and how long does it take to keep track of them all?
Caleb Jones 2018-03-01 15:29:42
Exactly how many things are you invested inNot giving you the exact number, but a decent amount.
and how long does it take to keep track of them all?An average of 1.5 hours per week is spent managing my investments.
Investor 2018-03-02 02:58:53
Do you update the values of investments yourself manually or have you got some system in place that the spreadsheet fetches the data from some websites? I was thinking of setting up something like that for myself, Should not be too hard.
Curtis 2018-03-02 10:53:14
Will you consider putting a template of your spreadsheets (not your actual info) in any future versions of the unchained man or any "pay for content" format?
Caleb Jones 2018-03-02 11:36:34
Do you update the values of investments yourself manually or have you got some system in place that the spreadsheet fetches the data from some websites? I was thinking of setting up something like that for myself, Should not be too hard.No. Too complicated in my opinion, and I like to keep things simple. It only takes me literally a few seconds to do it, and I only do it 3-4 times a month. I suppose if I had literally hundreds of different kinds of investments, I'd set up this system (or better yet, hire one of my VA's to do it for me).
Will you consider putting a template of your spreadsheets (not your actual info) in any future versions of the unchained man or any “pay for content” format?Yes, good idea.
Social Justice Whiner 2018-03-03 11:51:26
I completely agree with Investopedia. When I was in college it gave a more clear and concise definition of terms and equations than most PhDs did (people with masters' degrees working in the field were vastly better professors.) I've read a lot about the value investing philosophy but I'm interested in what philosophies you think are most effective at consistently beating the market or generating above average returns for active management. Any suggestions on books to read and blogs to follow? Thank you
Cronos 2018-03-03 13:44:46
I’m interested in what philosophies you think are most effective at consistently beating the marketDo the opposite of what everyone is doing.
Caleb Jones 2018-03-05 12:21:11
I’ve read a lot about the value investing philosophy but I’m interested in what philosophies you think are most effective at consistently beating the market or generating above average returns for active management.I don't believe in beating the market. I believe in having most of your money in safe investments that make as much or even a little less than the market, but never losing money. I also believe in having a small amount of your assets outside of the market in speculative places to potentially make more money, but be okay if you lose it all.
Any suggestions on books to read and blogs to follow?A few investment ones here: https://calebjonesblog.com/moving-out-of-the-country-resources-to-help-you/