Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #5  
Old 10-17-2007, 12:40 AM
Bob
Guest
 
Posts: n/a
Default Re: MS Money - Investments - Acount Summary

Cal,
Absolutely amazing! Worked like a charm!! TKS!
BTW .. if you are in the market I would recommend CVRD also traded on NYSE.
Ask your broker and I'm sure you'll get a BUY recommendation!
Again ... tks for the tip.



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Bob wrote:
> > 1. Investment details:
> > Investment Name: CVRD (Companhia Vale Rio Doce)
> > Investment type: stock
> > symbol: VALE5
> > country/region: Brazil (no symbol)
> > Most recent Price R$52.67
> > > 2. None of the country/regions listed have symbols, just name.
> > > 3. Money 2006 Deluxe

> > Version 15.0.120.513

> I reproduced the bug/anomaly. I suspect you had originally had the
> country for CVRD as US or that US was the default at the time you
> first entered CVRD into Money. Somehow, while it changes elsewhere,
> the Portfolio and AccountSummary remember the original currency when
> you change the stock's country later.
> The workaround with 2007, it could have been a little easier, but
> not a big difference. Here is my suggested workaround:
> In the details, remove (blank) the symbol, if any. Rename the
> existing stock to something you will never use. Let's suppose you
> choose czzzz (which will put it alphabetically close to CVRD).
> Create a new stock with the correct name, such as CVRD. I would
> leave the symbol blank for now. Select the proper country.
> Go back to investment czzzz and choose InvestmentActivities. If you
> have any Sell transactions in czzzz, first create a new fake
> AddShares of zzzz for many more shares than you ever held.
> Change each transaction to CVRD using the drop-down list. Start
> with the oldest transaction. Keep going until there are no more
> czzzz transactions remaining, except for the fake AddShares. Then
> Delete the fake AddShares.
> At that point you can Delete czzzz.
> > > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Bob wrote:
> > > > > > tks ... but I don't wish to change the currency for investment quotes.
> > > > My difficulty is when I show my portofolio, using Portfolio shortcut as you
> > > > suggested, and see a list of my holdings ALL of which are in local Brazilian
> > > > Real currency. For just ONE of the holdings, the "Last Price" (which I input
> > > > manually), "Cost Basis", "Market Value" amounts that show have the US$ symbol
> > > > even though in Tools > Settings > Program Settings > Currency, the Brazilian
> > > > Real is selected as the Base currency. This particular stock is quoted in
> > > > Brazilian Real on the Brazilian Stock Exchange and I input and update the
> > > > quotes prices always in R$
> > > > > You enter the price by hand?
> > > > > OK, we should be able to come up with a solution.
> > > > > 1. In the investment details, what is the country that is listed?
> > > You can right-click a reference to the investment and choose to go
> > > to the investment details.
> > > > > 2. Do you have a symbol on it?
> > > > > 3. What version of Money are you using? Help-> About should tell you.
> > > > > > > > > > > > > Also, since the Brazilian Real is my Base currency and the symbol is R$ why
> > > > doesn't the symbol appear in any of the reports? I just see the amounts
> > > > without any symbol
> > > > >
  #4  
Old 10-16-2007, 02:48 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MS Money - Investments - Acount Summary

In microsoft.public.money, Bob wrote:

- quote -

> 1. Investment details:
> Investment Name: CVRD (Companhia Vale Rio Doce)
> Investment type: stock
> symbol: VALE5
> country/region: Brazil (no symbol)
> Most recent Price R$52.67
> 2. None of the country/regions listed have symbols, just name.
> 3. Money 2006 Deluxe
> Version 15.0.120.513


I reproduced the bug/anomaly. I suspect you had originally had the
country for CVRD as US or that US was the default at the time you
first entered CVRD into Money. Somehow, while it changes elsewhere,
the Portfolio and AccountSummary remember the original currency when
you change the stock's country later.

The workaround with 2007, it could have been a little easier, but
not a big difference. Here is my suggested workaround:

In the details, remove (blank) the symbol, if any. Rename the
existing stock to something you will never use. Let's suppose you
choose czzzz (which will put it alphabetically close to CVRD).

Create a new stock with the correct name, such as CVRD. I would
leave the symbol blank for now. Select the proper country.

Go back to investment czzzz and choose InvestmentActivities. If you
have any Sell transactions in czzzz, first create a new fake
AddShares of zzzz for many more shares than you ever held.

Change each transaction to CVRD using the drop-down list. Start
with the oldest transaction. Keep going until there are no more
czzzz transactions remaining, except for the fake AddShares. Then
Delete the fake AddShares.


At that point you can Delete czzzz.




- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Bob wrote:
> > > > tks ... but I don't wish to change the currency for investment quotes.
> > > My difficulty is when I show my portofolio, using Portfolio shortcut as you
> > > suggested, and see a list of my holdings ALL of which are in local Brazilian
> > > Real currency. For just ONE of the holdings, the "Last Price" (which I input
> > > manually), "Cost Basis", "Market Value" amounts that show have the US$ symbol
> > > even though in Tools > Settings > Program Settings > Currency, the Brazilian
> > > Real is selected as the Base currency. This particular stock is quoted in
> > > Brazilian Real on the Brazilian Stock Exchange and I input and update the
> > > quotes prices always in R$
> > > You enter the price by hand?
> > > OK, we should be able to come up with a solution.
> > > 1. In the investment details, what is the country that is listed?

> > You can right-click a reference to the investment and choose to go
> > to the investment details.
> > > 2. Do you have a symbol on it?
> > > 3. What version of Money are you using? Help-> About should tell you.
> > > > > > > > Also, since the Brazilian Real is my Base currency and the symbol is R$ why
> > > doesn't the symbol appear in any of the reports? I just see the amounts
> > > without any symbol
> > >
  #3  
Old 10-16-2007, 12:30 AM
Bob
Guest
 
Posts: n/a
Default Re: MS Money - Investments - Acount Summary

1. Investment details:
Investment Name: CVRD (Companhia Vale Rio Doce)
Investment type: stock
symbol: VALE5
country/region: Brazil (no symbol)
Most recent Price R$52.67

2. None of the country/regions listed have symbols, just name.

3. Money 2006 Deluxe
Version 15.0.120.513


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Bob wrote:
> > tks ... but I don't wish to change the currency for investment quotes.
> > My difficulty is when I show my portofolio, using Portfolio shortcut as you
> > suggested, and see a list of my holdings ALL of which are in local Brazilian
> > Real currency. For just ONE of the holdings, the "Last Price" (which I input
> > manually), "Cost Basis", "Market Value" amounts that show have the US$ symbol
> > even though in Tools > Settings > Program Settings > Currency, the Brazilian
> > Real is selected as the Base currency. This particular stock is quoted in
> > Brazilian Real on the Brazilian Stock Exchange and I input and update the
> > quotes prices always in R$

> You enter the price by hand?
> OK, we should be able to come up with a solution.
> 1. In the investment details, what is the country that is listed?
> You can right-click a reference to the investment and choose to go
> to the investment details.
> 2. Do you have a symbol on it?
> 3. What version of Money are you using? Help-> About should tell you.
> > > Also, since the Brazilian Real is my Base currency and the symbol is R$ why

> > doesn't the symbol appear in any of the reports? I just see the amounts
> > without any symbol

>
  #2  
Old 10-15-2007, 10:39 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MS Money - Investments - Acount Summary

In microsoft.public.money, Bob wrote:

- quote -

> tks ... but I don't wish to change the currency for investment quotes.
> My difficulty is when I show my portofolio, using Portfolio shortcut as you
> suggested, and see a list of my holdings ALL of which are in local Brazilian
> Real currency. For just ONE of the holdings, the "Last Price" (which I input
> manually), "Cost Basis", "Market Value" amounts that show have the US$ symbol
> even though in Tools > Settings > Program Settings > Currency, the Brazilian
> Real is selected as the Base currency. This particular stock is quoted in
> Brazilian Real on the Brazilian Stock Exchange and I input and update the
> quotes prices always in R$


You enter the price by hand?

OK, we should be able to come up with a solution.

1. In the investment details, what is the country that is listed?
You can right-click a reference to the investment and choose to go
to the investment details.

2. Do you have a symbol on it?

3. What version of Money are you using? Help-> About should tell you.



- quote -

> Also, since the Brazilian Real is my Base currency and the symbol is R$ why
> doesn't the symbol appear in any of the reports? I just see the amounts
> without any symbol

  #1  
Old 10-15-2007, 09:17 PM
Bob
Guest
 
Posts: n/a
Default Re: MS Money - Investments - Acount Summary

Cal,
tks ... but I don't wish to change the currency for investment quotes.
My difficulty is when I show my portofolio, using Portfolio shortcut as you
suggested, and see a list of my holdings ALL of which are in local Brazilian
Real currency. For just ONE of the holdings, the "Last Price" (which I input
manually), "Cost Basis", "Market Value" amounts that show have the US$ symbol
even though in Tools > Settings > Program Settings > Currency, the Brazilian
Real is selected as the Base currency. This particular stock is quoted in
Brazilian Real on the Brazilian Stock Exchange and I input and update the
quotes prices always in R$

Also, since the Brazilian Real is my Base currency and the symbol is R$ why
doesn't the symbol appear in any of the reports? I just see the amounts
without any symbol


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Bob wrote:
> > All of several holdings listed in Account Summary are correctly listed in
> > local currency (Brazil Real) EXCEPT one that appears in US$ at an invalid
> > exchange rate. I would like ALL holdings listed in local currency, i.e., how
> > do I get this one holding to be displayed in local currency? I have used all
> > instructions for currency conversion, i.e., right click amount box and use
> > currency converter but no luck.
> > suggestions?

> I don't think you can change the currency for the investment quotes
> in the Account Summary or Portfolio without choosing a different
> symbol.
> In later versions
> Tools-> Settings-> ProgramSettings-> UpdateCurrencies lets you set
> exchange rates and determine if the rates are to be updated on line.
> I hope that if that is set up right, the correct Brazil Real totals
> will use the correct exchange rate.
> Incidentally, the Portfolio views are often a better way to look at
> your investments. You can configure in the columns most useful to
> you. I suggest enabling Portfolio Shortcut.

 
Old 10-15-2007, 03:23 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: MS Money - Investments - Acount Summary

In microsoft.public.money, Bob wrote:

- quote -

> All of several holdings listed in Account Summary are correctly listed in
> local currency (Brazil Real) EXCEPT one that appears in US$ at an invalid
> exchange rate. I would like ALL holdings listed in local currency, i.e., how
> do I get this one holding to be displayed in local currency? I have used all
> instructions for currency conversion, i.e., right click amount box and use
> currency converter but no luck.
> suggestions?


I don't think you can change the currency for the investment quotes
in the Account Summary or Portfolio without choosing a different
symbol.

In later versions
Tools-> Settings-> ProgramSettings-> UpdateCurrencies lets you set
exchange rates and determine if the rates are to be updated on line.
I hope that if that is set up right, the correct Brazil Real totals
will use the correct exchange rate.

Incidentally, the Portfolio views are often a better way to look at
your investments. You can configure in the columns most useful to
you. I suggest enabling Portfolio Shortcut.
  #-1  
Old 10-15-2007, 02:44 AM
Bob
Guest
 
Posts: n/a
Default MS Money - Investments - Acount Summary

All of several holdings listed in Account Summary are correctly listed in
local currency (Brazil Real) EXCEPT one that appears in US$ at an invalid
exchange rate. I would like ALL holdings listed in local currency, i.e., how
do I get this one holding to be displayed in local currency? I have used all
instructions for currency conversion, i.e., right click amount box and use
currency converter but no luck.
suggestions?
TIA

 

Tags
acount, investments, money, summary
Similar Threads
Thread Forum Replies Last Post
Removing Investments from Investment Summary
chatsphotogpilot@gmail.com: How do I remove Investments from the Investment Summary window in the MSMoney Home Page? e.g. I sell all my shares of Yahoo, and don't care about...
Microsoft Money 2 07-07-2005 02:03 AM
Hide closed investments on Home Page Investment Summary and Best and Worst Performers
Chuck Leven: How do I hide my closed/sold investments in the Home Page Investment Summary and Best and Worst Performers blocks? I would prefer that these blocks...
Microsoft Money 3 05-18-2005 07:50 PM
How do I set up an Income Acount?
Don Stowell: I get income from several companies; I want to set up income accounts in various categories; ie Securities Amazon Herb Co. Bonus Individual...
Microsoft Money 1 09-28-2003 08:15 PM
Adjusting the Value of an asset acount
Chris: When I try to adjust the value of an asset I am finding that the increase or decreased value is applied to either my income or expenses. Example:...
Microsoft Money 1 09-03-2003 11:50 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 11:42 PM.