Home Page link  

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

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
How do I enter current market value for Canadian bonds and funds that Quicken does NOT get Market Value for? RsH 11-08-2007
Posted by RsH on November 8, 2007, 2:03 pm
Please log in for more thread options
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 rsh@idirect.com as well as replying in this usenet
group if you believe you have valid suggestions.... TIA]

Posted by Fred Smith on November 8, 2007, 8:20 pm
Please log in for more thread options
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.

2. Canada Savings Bond CS51
Quicken knows that all bonds are priced per $100. As Quantity x Price = Market
Value, you need to enter (ie, buy) the correct quantity. If you have a $1000
bond, enter a quantity of 10. When you buy the bond, you buy it at a price of
$100. 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
$100 and never change it. Most new systems show accrued interest, so calculate a
unit price which includes accrued interest.

3. 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.

--
Regards,
Fred


>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 rsh@idirect.com as well as replying in this usenet
> group if you believe you have valid suggestions.... TIA]



Posted by Sharx35 on November 9, 2007, 12:58 am
Please log in for more thread options

>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 rsh@idirect.com as well as replying in this usenet
> group if you believe you have valid suggestions.... TIA]

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?






Similar ThreadsPosted
Money Market Funds August 23, 2007, 11:16 pm
How to set up Money Market funds in Q07? August 25, 2007, 4:25 pm
Money Market funds - performance February 25, 2007, 10:34 am
How to handle sweep money market funds April 11, 2006, 7:38 pm
How do I determine cost basis for money market funds? October 7, 2008, 12:13 pm
Fidelity Money Market not showing up in Quicken January 4, 2007, 3:00 am
Quicken and money market fund reconciliation September 22, 2009, 2:14 pm
changing market value November 10, 2007, 6:22 pm
market value graph is wrong September 11, 2006, 2:11 am
Problem with Market Value in Overview tab February 11, 2007, 6:10 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap