|
#2
| |||
| |||
| I think Treasury Notes and -- now that they're available -- Bonds are handled fine in Money. Your purchase, redeem, and record interest just as you would any other bond. And, as with other bonds, prices can't be updated online. Treasury Bills are quite another thing: Money -- to be blunt -- sucks with them. The problem with bills is documented at http://support.microsoft.com/default...b;en-us;823031 and the resolution I suggested there turns out not to work. -- Michael Gordon <Mr.Warmth[at]gmail.com> wrote in message news:1176348607.534076.187610[at]y5g2000hsa.googlegroups.com... - quote - > Hello folks, I was searching around for this topic and couldn't find a > good answer. I have recently started to invest in government bonds via > Treasury Direct and was wondering the proper way to keep these > instruments in Microsoft Money. > The 13-week t-bill I bought, I think I figured it out OK, but the 2 > year Treasury Note was a little bit of a problem. > First, how do add the investment? I know that Microsoft recognized the > ticker TC2Y for the two year treasury, but when I added the investment > by using the ticker, it didn't seem to work so well. > Also, I believe I was prompted for the coupon rate, which I don't know > for this bond, or at least not how to figure it out. I do know, from > the treasury direct website that there's a dividend payment due to me > on this bond on a specific date, but I haven't found a way to > represent this knowledge in Money. > Does anyone have any advice for how to keep track of these government > bonds in Microsoft Money? > Thanks! |
|
#1
| |||
| |||
| In additon to what L Cramer said, the symbols used on MSN Money (e.g. TC2Y) is only going to give you the price for the most current bill available (i.e. would not match with one you purchased last year). -Mark "L Cramer" <lzcraexcludemer[at]yahoo.com> wrote in message news:NboTh.1351$AE5.1275[at]newsfe06.lga... - quote - > Others here have commented that Money doesn't handles Treasury debt well. > I > agree. I regularly rollover 4-week, 3- and 6-month bills, and 2-year > notes. > Since I didn't want new individual investments each time I did a rollover, > I > set up a separate investment account with individual investments for each > bill/note time period. I treat them as CDs, entering the net purchase > price > and recording interest separately when paid or the CD/bill is redeemed. > This works well for bills. > If you want to enter each 2-year note separately as a bond, which will > pick > up correctly the small capital gain at redemption, the "coupon rate" is > simply the stated interest rate, the purchase price will be 99.xxxx%. > When > I've done it this way, I've used names that include the maturity date, > T-Note 2y 10-07. No ticker symbol is needed or useful as far as I know. > <Mr.Warmth[at]gmail.com> wrote in message > news:1176348607.534076.187610[at]y5g2000hsa.googlegroups.com... > > Hello folks, I was searching around for this topic and couldn't find a > > good answer. I have recently started to invest in government bonds via > > Treasury Direct and was wondering the proper way to keep these > > instruments in Microsoft Money. > > > The 13-week t-bill I bought, I think I figured it out OK, but the 2 > > year Treasury Note was a little bit of a problem. > > > First, how do add the investment? I know that Microsoft recognized the > > ticker TC2Y for the two year treasury, but when I added the investment > > by using the ticker, it didn't seem to work so well. > > > Also, I believe I was prompted for the coupon rate, which I don't know > > for this bond, or at least not how to figure it out. I do know, from > > the treasury direct website that there's a dividend payment due to me > > on this bond on a specific date, but I haven't found a way to > > represent this knowledge in Money. > > > Does anyone have any advice for how to keep track of these government > > bonds in Microsoft Money? > > > Thanks! > |
| | |||
| |||
| Others here have commented that Money doesn't handles Treasury debt well. I agree. I regularly rollover 4-week, 3- and 6-month bills, and 2-year notes. Since I didn't want new individual investments each time I did a rollover, I set up a separate investment account with individual investments for each bill/note time period. I treat them as CDs, entering the net purchase price and recording interest separately when paid or the CD/bill is redeemed. This works well for bills. If you want to enter each 2-year note separately as a bond, which will pick up correctly the small capital gain at redemption, the "coupon rate" is simply the stated interest rate, the purchase price will be 99.xxxx%. When I've done it this way, I've used names that include the maturity date, T-Note 2y 10-07. No ticker symbol is needed or useful as far as I know. <Mr.Warmth[at]gmail.com> wrote in message news:1176348607.534076.187610[at]y5g2000hsa.googlegroups.com... - quote - > Hello folks, I was searching around for this topic and couldn't find a > good answer. I have recently started to invest in government bonds via > Treasury Direct and was wondering the proper way to keep these > instruments in Microsoft Money. > The 13-week t-bill I bought, I think I figured it out OK, but the 2 > year Treasury Note was a little bit of a problem. > First, how do add the investment? I know that Microsoft recognized the > ticker TC2Y for the two year treasury, but when I added the investment > by using the ticker, it didn't seem to work so well. > Also, I believe I was prompted for the coupon rate, which I don't know > for this bond, or at least not how to figure it out. I do know, from > the treasury direct website that there's a dividend payment due to me > on this bond on a specific date, but I haven't found a way to > represent this knowledge in Money. > Does anyone have any advice for how to keep track of these government > bonds in Microsoft Money? > Thanks! |
|
#-1
| |||
| |||
| Hello folks, I was searching around for this topic and couldn't find a good answer. I have recently started to invest in government bonds via Treasury Direct and was wondering the proper way to keep these instruments in Microsoft Money. The 13-week t-bill I bought, I think I figured it out OK, but the 2 year Treasury Note was a little bit of a problem. First, how do add the investment? I know that Microsoft recognized the ticker TC2Y for the two year treasury, but when I added the investment by using the ticker, it didn't seem to work so well. Also, I believe I was prompted for the coupon rate, which I don't know for this bond, or at least not how to figure it out. I do know, from the treasury direct website that there's a dividend payment due to me on this bond on a specific date, but I haven't found a way to represent this knowledge in Money. Does anyone have any advice for how to keep track of these government bonds in Microsoft Money? Thanks! |
| Tags |
| microsoft, money, notes, treasury |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| How to handle a Treasury Bill alocksley: MS Money 2005 I record the purchase of a 10K 6-mo T-Bill with the number of shares (10000) and the auction price (say 97.55). as a buy with a... | Microsoft Money | 2 | 12-04-2006 02:54 PM | |
| Treasury Direct email and replies Lena: Did any other acount holders get an email from Treasury Direct asking to update your email and home addresses and phone number, and then get a... | Microsoft Money | 4 | 09-19-2006 03:18 PM | |
| Adding Treasury bill transaction BKE: How and where do I add a transactions/investments for treasury bills? I am using MSMoney2006 Standard. I am an first time user of Money. | Microsoft Money | 2 | 04-27-2006 12:12 AM | |
| Follow-up/Add notes missing in MS Money 2005 Pranab: I upgraded from MSMoney 2003 Deluxe to 2005 Deluxe and I didn't see my follow-up notes from my earlier version of my money file. Also I didn't see... | Microsoft Money | 2 | 01-01-2005 05:25 PM | |
| Interest and return of principal on US Treasury bills Baldwin Maull: An estate bought a US Treasury bill at a discount on 10/21/02 at a price of 99.148 less commission of $43.96 for a total cash outlay of $49,626.96.... | Microsoft Money | 2 | 08-23-2003 10:49 PM | |
| Thread Tools | |
| Display Modes | |
| |