calmloki
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
So we're going round and round here. Started buying 6 month T-Bills on almost a weekly basis back in 10/22, shooting for a 6 month ladder. Currently have 20 T-bills and have moved them all to Fidelity and are buying new issues as they come up and saying "yes" to auto-roll.
Someone here shared an Excel spreadsheet and I'm using it (first time on Excel). So that's nice - I can see weighted days to maturity, total basis, stuff like that. Our problem is that my intent is to hold all the T-Bills to maturity, so while my simple self says "hey, twenty at $1000 par, value $20,000" my gal tracks our market value on everything on a daily basis. Which is actually more valid and reality based.
But we are having no luck recording that daily change in value in our 2006 version Quicken. We do all entries manually. I had been using the "stock" area and showing one entry for the bill purchase, then making a maturity dated entry with a deposit of the discounted amount. Something was very wrong with that, because we were getting thousands in the red as time went on. Now we're trying to use a register type Quicken account, and we just aren't staying in balance with Fidelity's reported balance.
We want to keep using our Quicken - there are a bunch of accounts and all our other expenditures and income streams there. We've massaged our classes and categories and have no desire to blow decades of entries and reports with an updated subscription new model Quicken. Just going wacky trying to figure out how to properly make the Quicken entries match the reality.
Halp!
Someone here shared an Excel spreadsheet and I'm using it (first time on Excel). So that's nice - I can see weighted days to maturity, total basis, stuff like that. Our problem is that my intent is to hold all the T-Bills to maturity, so while my simple self says "hey, twenty at $1000 par, value $20,000" my gal tracks our market value on everything on a daily basis. Which is actually more valid and reality based.
But we are having no luck recording that daily change in value in our 2006 version Quicken. We do all entries manually. I had been using the "stock" area and showing one entry for the bill purchase, then making a maturity dated entry with a deposit of the discounted amount. Something was very wrong with that, because we were getting thousands in the red as time went on. Now we're trying to use a register type Quicken account, and we just aren't staying in balance with Fidelity's reported balance.
We want to keep using our Quicken - there are a bunch of accounts and all our other expenditures and income streams there. We've massaged our classes and categories and have no desire to blow decades of entries and reports with an updated subscription new model Quicken. Just going wacky trying to figure out how to properly make the Quicken entries match the reality.
Halp!