Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 07-26-2007, 04:06 AM
honka
Guest
 
Posts: n/a
Default RE: Canadian Portfolio with Currency Issues

Marnie, what you say makes sense, but even if I buy it today and there is no
fx fluctuation it still shows a gain as soon as it is entered.

"DB Rusted" wrote:

- quote -

> "Marnie" wrote:
> > I own Microsoft money 2006 Canadian Edition. I am having problems with the
> > account summary section of my portfolio when I buy a us investment. the cost
> > basis and profit just dont make sense, always showing a bigger gain then is
> > actually relized. I was wondering if there was a gain in the currency which
> > increased the value of the investment would it show as a gain in the
> > invesment ?--
> > m

> Seems to take the original foreign cost, convert it to base currency at time
> of purchase, then on date of report apply latest fx rate to base currency
> amount to convert back into foreign currency. Doesn't make any sense but the
> calculations match.
> Ex
> Purch $1000us (foreign) [at] .75 = $1333aud (Base)
> Report when fx is .8, cost shown as $1067us ($1333 * .8)
> Whereas, might otherwise expect to see 1000 [at] .8 or $1250.

  #2  
Old 07-12-2007, 09:52 AM
DB Rusted
Guest
 
Posts: n/a
Default RE: Canadian Portfolio with Currency Issues



"Marnie" wrote:

- quote -

> I own Microsoft money 2006 Canadian Edition. I am having problems with the
> account summary section of my portfolio when I buy a us investment. the cost
> basis and profit just dont make sense, always showing a bigger gain then is
> actually relized. I was wondering if there was a gain in the currency which
> increased the value of the investment would it show as a gain in the
> invesment ?--
> m

Seems to take the original foreign cost, convert it to base currency at time
of purchase, then on date of report apply latest fx rate to base currency
amount to convert back into foreign currency. Doesn't make any sense but the
calculations match.
Ex
Purch $1000us (foreign) [at] .75 = $1333aud (Base)
Report when fx is .8, cost shown as $1067us ($1333 * .8)
Whereas, might otherwise expect to see 1000 [at] .8 or $1250.

  #1  
Old 07-11-2007, 06:18 AM
Ronald
Guest
 
Posts: n/a
Default Re: Canadian Portfolio with Currency Issues

I am not too sure about this, I believe it is not entirely because of the
currency difference.

We are using Money 2006 Small business version and having problems with the
cost basis for HK shares. The cost basis are always more than it should be
(even on single transactions. When you think about cost basis for a share
with only one single transaction, the cost basis should be the same as the
total cost for that transaction, but money does not think so). Even if the
currency plays a factor, because HK dollar is stronger after we purchased the
share, the cost basis should be less than what it was when purchased. There
might be another reason behind the strange cost basis we are observing.

Could any of you shed any light on this problem or do any of you experience
the same frustration?

Thanks in advance,
Ronald

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Marnie wrote:
> > I own Microsoft money 2006 Canadian Edition. I am having problems with the
> > account summary section of my portfolio when I buy a us investment. the cost
> > basis and profit just dont make sense, always showing a bigger gain then is
> > actually relized. I was wondering if there was a gain in the currency which
> > increased the value of the investment would it show as a gain in the
> > invesment ?--

> I think it works that way. Multiple currencies can be confusing.
> Prices are recorded in terms of the account currency.

 
Old 07-03-2007, 02:52 PM
Rich L.
Guest
 
Posts: n/a
Default Re: Canadian Portfolio with Currency Issues

I have the same problem. My cost basis changes daily when it shouldn't be
changing at all.

Base currency is Canadian

I have an investment account in USD, and I have purchased some stocks in USD
in this account. On my portfolio view, my cost basis is being displayed in
USD so it should not be changing on a daily basis.... it should never change
since everything was done in USD.

Does anyone have an idea how to fix this?

Thanks,

Rich

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Marnie wrote:
> > I own Microsoft money 2006 Canadian Edition. I am having problems with the
> > account summary section of my portfolio when I buy a us investment. the cost
> > basis and profit just dont make sense, always showing a bigger gain then is
> > actually relized. I was wondering if there was a gain in the currency which
> > increased the value of the investment would it show as a gain in the
> > invesment ?--

> I think it works that way. Multiple currencies can be confusing.
> Prices are recorded in terms of the account currency.

  #-1  
Old 03-12-2007, 02:43 PM
Marnie
Guest
 
Posts: n/a
Default Canadian Portfolio with Currency Issues

I own Microsoft money 2006 Canadian Edition. I am having problems with the
account summary section of my portfolio when I buy a us investment. the cost
basis and profit just dont make sense, always showing a bigger gain then is
actually relized. I was wondering if there was a gain in the currency which
increased the value of the investment would it show as a gain in the
invesment ?--
m
 

Tags
canadian, currency, issues, portfolio
Similar Threads
Thread Forum Replies Last Post
Changing Currency in Portfolio Manager
arcfrankye: i recently migrated from Money 2004 to 2006, because 2004 did not have my country and currency i.e Nigeria, i modified and used Ghana. Problem is...
Microsoft Money 1 03-21-2006 07:06 PM
Adding currency-rate to portfolio
Eric: Hello, I would like to add the USD/EUR - rate to my portfolie, as I succesfully did wit the indices Nasdaq and Dow. I see that the symbol is...
Microsoft Money 3 08-24-2005 06:04 AM
US stocks, Canadian currency
Lulu: I am using Microsoft Money 2003 (Canadian Edition). I have bought US stocks. How do I tract these? I have looked at the help "Convert foreign...
Microsoft Money 2 05-06-2004 09:25 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 09:22 PM.