I use Quicken, and it is one click to get a portfolio update and info on any distributions/dividends. Quicken has its ideosyncracies, but overall seems to be a pretty good tool for this.
There are several references here to "updating my spreadsheet" from daily to quarterly. For those of you using this approach:
- What are your inputs?
- What are your outputs (displays, calculations, i.e. what do you look at?)
- What decisions do you guide by your spreadsheet tracking and calculations?
Thanks!
I use Quicken and Excel. My process is to update Quicken, and then I copy some numbers from Quicken to Excel to get some more customized data than Quicken is able to provide.
I update Q and E daily, although I'm trying to wean myself to weekly since nothing changes that much and I usually end up seeing more "noise" than information. I never trade on what I see in my spreadsheets either, I'm a LTBH.
As to your questions:
1. The data that gets transferred over from Q to E is basically two things: the current valuation of all my assets and liabilities and my last six months expenditures by top level Quicken category (Kids, Taxes, Insurance, Auto, Food, etc.).
2. For outputs, I have a worksheet dedicated to each question I am trying to answer. For example, what is my liquidity situation? What are my life insurance needs? How are my kids' college funds coming along? How are my FIRE plans coming along? I also have a "dashboard" which pulls data from the other sheets, combines it with my target goals, and uses Excel's conditional formatting to tell me if I'm in good shape or not (green = good, red = pay attention).
3. Decisions I make or am making based on my spreadsheets include: (1) How much cash I can safely invest in my taxable Vanguard account and still have enough cash cushion for emergencies? (2) Do I need to buy life insurance? (3) Do I need to increase or decrease the rate of savings into my kids' college accounts? (4) Should I suck it up and stay in my soul-sucking but good paying job, find a different, more highly paid soul-sucking job, or should I go do what I want at a lower salary? (5) What kinds of offers are worth my time to do in my 0% BT game? (6) How much overtime should I work at my day job?
2Cor521