@davec7176
I don't believe the changes to version 2.0 are value added. I have been using version 1.0 with personal modifications for a few years now and love it. Makes monitoring my portfolio a breeze. For detailed asset allocation, I use Empower. Automatic, simple and quick. Keep up the great work Rob!
@stevebenson1802
Now you have given me a project for a weekend I am supposed to work in the garden! Looks good. Thank you.
@kentkingston3180
Rob love your videos and thinking on investment/money matters. I took your 1.0 spreadsheet and used it in creating my own Investment Tracking Sheet in Apple Numbers. After initial creation I have added other tables and tabs as needed to answer my questions. My sheet would not have been possible without your great thinking. Will use today's video to look if I need to do any updates to mine. Thank you again!! Playing with spreadsheets is fun!!
@davidtvedte1337
I do love me a good spreadsheet. Your original spreadsheet did inspire me to create my own. I do like the idea of more precisely determining the asset classes. Especially as ETF's and Mutual Funds do tend to have some overlapping. I have my accounts at Fidelity and do look at the asset classes in detail periodically. I do use my spreadsheet for dynamic rebalancing but do not currently have different rebalance percentages based on asset class. Usually if an asset class gets over/under its target amount by more than my percentage, it is pretty obvious where to rebalance to.
@srconrad
Thanks, Rob! You are a gentleman and a scholar. I've been using your first version since you first posted it all those years ago and it's been a great tool for me. I made my own modifications over the years but I grabbed version 2.0 and I will be giving it a whirl. What a generous thing to provide.
@dslovesau
thank you for this tool! You are awesome. Just got finished reading your book. Can'y wait for the next one. I never miss a video or podcast.
@gapey
I like 2.0 better. One thing I updated on mine is to add the cost basis for each investment and a formula to get my return. I can't wait till I retire and can roll my 401k to IRA so I have more control over the investments. The tickers they use in the 401k don't show up anywhere and are very limited. Also can't separate the investments between the pre-tax and roth within the 401k. Only a couple more years to go. :)
@martinomovies
so funny. I was trying to do this myself yesterday! Thank you!
@asphaltandtacos
Nice update!
@dancoyle7697
Thanks for making this available!
@sixstringsdaddy2477
By your reasoning VTI should have a percentage in Int'l, it holds Apple for example. I think you either need to stick to "I don't need Int'l because US companies have sales abroad", or use the country of origin like VXUS does
@NYCNibbles
Thanks, Rob. I've been using v1.0 for a little bit so I'll grab 2.0 and probably slowly get that info moved over. Maybe the 100k that went up in smoke during Tariff Week will reappear. 🤔
@uglywiley
Suggestion: Add a column in your Data page that assigns the number of holdings in each account and use that info to add rows to Holding sheet
@МЕГАПоЗиТИВ-й2е
Not about the functionality of the spreasheet itself but I think it's very important to break out allocation WITHIN the bond portion. For example, how much short-term treasuries(i.e. SGOV, VGSH), long-term treasuries (TLT), corporate investment-grade (VCIT), corporate intermediate, and also TIPS. I think for stocks a simple VTI/VXUS combination is fine, but for fixed income it's really more complicated.
@pamgreene5828
Thanks for this. It’s helpful. I think the weighted expense ration is 100x too high, though
@InterCity134
For the breaking up of individual stocks to asset classes - why not just use the HQ location (ie Apple is US). Because if you start splitting up the revenue sources between US and nonUS then should you not do the same for the funds? Eg if I own an international stock such as VWAGY, I’d have to figure out how much of their revenue comes from the US market vs rest of world. Or an international fund - where the various companies each have some % of revenue in the US - for all of the major holdings. That’s a lot of work. I’m thinking consistency is important. Additional complication : the added problem of 401k with partial conversion to Roth. It’s on a % of assets , spread over the entire set of holdings. EG my 401k is 92% pretax, but I’ve converted 8% to Roth. How is that accounted for?
@erbfour
I use your 1.0 version almost weekly. I have tweeked it a bit and works pretty. I follow your objective developing 2.0, however, the 2.0 seems to be missing some fomula links and therefore doesn't to work for me at the moment!
@davebickers7209
Perhaps the Solver add-on for the "what-if" analysis.
@puckluck33
Thank you for sharing. It's a fun project and I've done many versions of these over the years. However, it's not worth the time and effort for me. I keep going back to the tools and views that my broker, Fidelity, offers.
@InterCity134