M05 Portfolio Avg Cost Changes

#5 03-21-2006, 03:17 PM

In microsoft.public.money, Apteryx wrote:

- quote -

> Just the initial purchase, the average should be the share price plus the
> commissions divided by the no. of shares. Which to my mind means that the avg
> cost should remain the same until such time as another transaction is made.
> Mark (refer other reply to this thread) thought it may be due to exchange
> rate changes.
> The base currency is New Zealand dollars (NZ$) , how ever the exchange rate
> fluctuates daily and there has only been the one change. If money works as
> the layout seems to suggest, then all the the calculations are done in the
> market currency (US$) and converted as a separate set of totals. Then again
> who ever heard of MS writing intuitive software :-)

Many countries have a capital gains tax. When you pay that tax in
your home country, you generally pay on the value you received in
your home currency minus what you paid in your home currency.

I suspect that is the reason for adjusting the basis to reflect the
current exchange rate.

#4 03-21-2006, 06:20 AM

Just the initial purchase, the average should be the share price plus the
commissions divided by the no. of shares. Which to my mind means that the avg
cost should remain the same until such time as another transaction is made.

Mark (refer other reply to this thread) thought it may be due to exchange
rate changes.

The base currency is New Zealand dollars (NZ$) , how ever the exchange rate
fluctuates daily and there has only been the one change. If money works as
the layout seems to suggest, then all the the calculations are done in the
market currency (US$) and converted as a separate set of totals. Then again
who ever heard of MS writing intuitive software :-)

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Apteryx wrote:
> > No transactions other than the original purchase. Average cost has dropped
> > over $15 per share but only for the one entry. I saw it change while updating
> > share prices.
> > If my broker will agree that he over charged me $15 per share (yeah right)
> > I'm quite happy to left it the way it is :-)
> Was there a split? When you click the [+] in front of the investment
> name, is there an "s" on the right of the price?
> *One* transaction? There is not much to average in that case. Does
> this "average" differ from the amount paid divided by quantity in
> that one transaction? When you say one transaction, there is no
> capital gains reinvestment or dividend reinvestment transaction, and
> for that matter not even a dividend? Only one transaction for real?
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Apteryx wrote:
> > > > > > The average cost of one investment in the portfolio changed for no apparent
> > > > reason. This throws all of the extended calculations out for that investment
> > > > which is abit annoying
> > > > > See if you have had any recent transactions for that investment. One
> > > handy way to look for that is to right-click the holding in the
> > > portfolio, and choose SeeInvestmentActivities.
> > > > > >

#3 03-20-2006, 03:32 PM

Is this investment in some other currency than the default currency for the
Money file?
If so, then the difference may be due to exchange rate changes, since Money
does not record historical exchange rates.

-Mark
"Apteryx" <Apteryx[at]discussions.microsoft.com> wrote in message
news:4F8B9527-49B2-4F0B-B771-AAF6D913107F[at]microsoft.com...
- quote -

> No transactions other than the original purchase. Average cost has dropped
> over $15 per share but only for the one entry. I saw it change while
updating
> share prices.
> If my broker will agree that he over charged me $15 per share (yeah
right)
> I'm quite happy to left it the way it is :-)
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Apteryx wrote:
> > > > The average cost of one investment in the portfolio changed for no
apparent
> > > reason. This throws all of the extended calculations out for that
investment
> > > which is abit annoying
> > > See if you have had any recent transactions for that investment. One
> > handy way to look for that is to right-click the holding in the
> > portfolio, and choose SeeInvestmentActivities.
> >

#2 03-19-2006, 04:09 PM

In microsoft.public.money, Apteryx wrote:

- quote -

> No transactions other than the original purchase. Average cost has dropped
> over $15 per share but only for the one entry. I saw it change while updating
> share prices.
> If my broker will agree that he over charged me $15 per share (yeah right)
> I'm quite happy to left it the way it is :-)

Was there a split? When you click the [+] in front of the investment
name, is there an "s" on the right of the price?

*One* transaction? There is not much to average in that case. Does
this "average" differ from the amount paid divided by quantity in
that one transaction? When you say one transaction, there is no
capital gains reinvestment or dividend reinvestment transaction, and
for that matter not even a dividend? Only one transaction for real?

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Apteryx wrote:
> > > > The average cost of one investment in the portfolio changed for no apparent
> > > reason. This throws all of the extended calculations out for that investment
> > > which is abit annoying
> > > See if you have had any recent transactions for that investment. One
> > handy way to look for that is to right-click the holding in the
> > portfolio, and choose SeeInvestmentActivities.
> > >

#1 03-19-2006, 06:19 AM

No transactions other than the original purchase. Average cost has dropped
over $15 per share but only for the one entry. I saw it change while updating
share prices.
If my broker will agree that he over charged me $15 per share (yeah right)
I'm quite happy to left it the way it is :-)

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Apteryx wrote:
> > The average cost of one investment in the portfolio changed for no apparent
> > reason. This throws all of the extended calculations out for that investment
> > which is abit annoying
> See if you have had any recent transactions for that investment. One
> handy way to look for that is to right-click the holding in the
> portfolio, and choose SeeInvestmentActivities.

03-18-2006, 08:35 PM

In microsoft.public.money, Apteryx wrote:

- quote -

> The average cost of one investment in the portfolio changed for no apparent
> reason. This throws all of the extended calculations out for that investment
> which is abit annoying

See if you have had any recent transactions for that investment. One
handy way to look for that is to right-click the holding in the
portfolio, and choose SeeInvestmentActivities.

#-1 03-18-2006, 08:10 AM

The average cost of one investment in the portfolio changed for no apparent
reason. This throws all of the extended calculations out for that investment
which is abit annoying

Thanks in advance

Similar Threads
Thread	Forum	Replies	Last Post
Portfolio Manager displays cost with the wrong totals blkane: I have Money 2006 and I set up my investments in portfolio manager. The cost totals for my investments do not add correctly. I don't have a...	Microsoft Money	2	10-09-2005 01:29 PM
portfolio value vs cost basis Su Bapat: In Money (2003 or higher), is there any way to generate a portfolio cost basis vs value graph over a certain period of time? TIA Su.	Microsoft Money	1	05-17-2005 10:14 AM
cost basis/avg cost per share David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost...	Microsoft Money	2	03-03-2004 11:00 AM
XP M2003 Investment cost basis not showing up in portfolio view Peter Filipski: I have M2003 standard (came with Dell) on XP. For some investments (shares), in the portfolio view nothing shows up in the Cost Basis column. There...	Microsoft Money	4	11-20-2003 03:38 AM
Money 2003 - Portfolio View Average Cost Per Share Darrell: Hi, I'm using Money 2003, and when I'm in Portfolio view, I can't seem to add the column Average Cost Per Share. It appeared at one time, and...	Microsoft Money	1	08-15-2003 07:40 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode