How do I enter current market value for Canadian bonds and funds that Quicken does NOT get Market Value for?

I am using Quicken XG 2007 [Canadian version]

I have NO problem with my Canadian and U.S. dollar accounts at CIBC I have not yet tried my account at BMO I have not yet tried my accounts at ING I still have other accounts to set up, BUT

I have a number of cut coupon bonds and a bond mutual fund and canada compounding savings bonds in my retirement savings plan accounts. I cannot figure out how to get current market for any of them. Using the return of capital negative number changes the cash position in the accounts and that is wrong, since the cash is unchanged... The original purchase prices are also correct. That keeps showing as the market price too, and these are bonds that I cannot find any symbol for.

How are these handled? How do I get current market value to show up in the analysis for these funds? How do I do that without distorting the actual cash position of the account, which using Return of Capital would do?

Examples include:

BMO Nesbitt Burns Bond Fund [not to be found in the list of Canadian mutual funds that come up in the list when mutual funds are looked at.]

Canada Savings Bond CS51

Province of Ontario cut coupon bonds maturing in 2009, 2010 and 2013 Province of British Columbia cut coupon bond maturing in 2015 Loblaws Companies cut coupon bond maturing in 2017 Ontario Hydro cut coupon bond

You get the idea, I suspect. All were purchased at a discount, and at maturity will pay their face value, obviously, except the CSB, which will pay all accumulated interest plus principal at maturity.

The fact is that there are two current values... one is the pro-rated difference between what was paid to buy the discounted bond and its maturity value, simply established by dividing the total number of days between the two dates by the original discount to face amount and adding that amount to the cost of the bond in my retirement plan, the other is the value in the market, which accounts for the current interest rate against the original discount price, which accounted for the then interest rate. I can get NEITHER value for these bonds.

The Quicken tools do NOT find any of these financial instruments and do not update any of these instruments. BMO Nesbitt-Burns is a financial investment institution that Quicken also does not seem to recognise, and BMO is a bank that it no longer works with, so it is getting most annoying even using the product with my investments, but there seems to be nothing better out there.

HELP!!!! [email snipped-for-privacy@idirect.com as well as replying in this usenet group if you believe you have valid suggestions.... TIA]

Reply to
RsH
Loading thread data ...
  1. BMO Nesbitt Burns Bond Fund Your statement should have the fund code on it (often called symbol). If it's not there, phone BMO and ask the for it. Enter this code in the Symbol field of the Security Detail. Make sure the Exchange is Mutual Funds. Finally, make sure you are asking for this price to be downloaded. In One Step Update, Select quotes to download, and make sure there is a check mark next to this security. Once you've done this, the price should download properly.

  1. Canada Savings Bond CS51 Quicken knows that all bonds are priced per 0. As Quantity x Price = Market Value, you need to enter (ie, buy) the correct quantity. If you have a 00 bond, enter a quantity of 10. When you buy the bond, you buy it at a price of 0. Subsequently, with every statement, enter a price which gets you the market value shown on the statement. Some old systems simply price the bond at 0 and never change it. Most new systems show accrued interest, so calculate a unit price which includes accrued interest.

  2. Strip bonds Enter quantity as Face Value / 100. Your purchase confirmation will show you the price you bought it at (eg 84.51). Every month when you get your statement, enter the current price. There's no such thing as downloading prices on bonds.

We don't need a dissertation on problems with your financial institution. Everyone has experienced them. Bottom line, never throw up your hands. You can always find a reasonable solution of how to make Quicken work for your financial situation.

Sorry about not personally e-mailing this to you. We posters have this silly idea that if you want free, pertinent advice, you should be willing to do follow the procedures of the gropu. Besides, posting to the newsgroup lets others see the answers.

Ask away.

Reply to
Fred Smith

Yet more reason to severely question the value of those downloads. Of course, you could simply override them with the CORRECT value after each download. I restrict my downloads of current share prices to once a week, or I simply only do the correcting overrides ONCE ever so often. Yeah, it's a pain but not likely to change, what do you expect from $100 software?

Reply to
Sharx35

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.