- Joined
- Oct 13, 2010
- Messages
- 10,767
I started out with MYM back when the PC first came out. Stayed with it when NationsBank bought it. It was abandoned by the bank when they got an online version, but I still actually use it! But primarily as a checkbook reconciliation tool. The DW gets a lump sum, so I don't have a lot of transactions to enter. I do keep my investment accounts in it, and it's a bit of a pain to mark my stocks and MF's to value (manual, not download), but I only do it monthly or quarterly. If there aren't any reinvestments, I just type the value from the statement and hit reconcile with adjusting transaction and relabel the adjustment to gain (or loss).
The benefit of this data entry is minimal but what is helpful is to compare long-term utility costs, long-term travel costs, etc. For instance, we were planning a rare summer cruise and I was able to look-up several past cruises in that we had taken in the spring (when prices are much less expensive). I determined that it was like 60% more expensive than usual (after adjusting for various things). Still went on the cruise but at least knew what we were getting into.
As for the AA / NW, I have been using the same spreadsheet for 20+ years. That actually takes quite some time to do (but every quarter only). I've written my own scraper that works for Fidelity statements, but I don't enter all that detail into the NW spreadsheet; it just takes the ins/outs/gains/losses. The result of this work is valuable in that it allows me to re balance. It also shows me the IRR of each investment, the IRR of a collection of accounts, the IRR over a specific period, and ad hoc analysis of my investments going back to the 1980's. Folks here seem to be pretty quote happy...what's the one about if you don't learn from failures, you're destined to repeat them?
--Dale--
The benefit of this data entry is minimal but what is helpful is to compare long-term utility costs, long-term travel costs, etc. For instance, we were planning a rare summer cruise and I was able to look-up several past cruises in that we had taken in the spring (when prices are much less expensive). I determined that it was like 60% more expensive than usual (after adjusting for various things). Still went on the cruise but at least knew what we were getting into.
As for the AA / NW, I have been using the same spreadsheet for 20+ years. That actually takes quite some time to do (but every quarter only). I've written my own scraper that works for Fidelity statements, but I don't enter all that detail into the NW spreadsheet; it just takes the ins/outs/gains/losses. The result of this work is valuable in that it allows me to re balance. It also shows me the IRR of each investment, the IRR of a collection of accounts, the IRR over a specific period, and ad hoc analysis of my investments going back to the 1980's. Folks here seem to be pretty quote happy...what's the one about if you don't learn from failures, you're destined to repeat them?
--Dale--