M05 Portfolio Avg Cost Changes

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

Cal
Sat Mar 18 15:35:49 CST 2006

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.

Apteryx
Sun Mar 19 01:19:26 CST 2006

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

Cal
Sun Mar 19 11:09:02 CST 2006

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

Mark
Mon Mar 20 10:32:47 CST 2006

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@discussions.microsoft.com> wrote in message
news:4F8B9527-49B2-4F0B-B771-AAF6D913107F@microsoft.com...
> 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.
> >
> >
> >

Apteryx
Tue Mar 21 01:20:28 CST 2006

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:

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

Cal
Tue Mar 21 10:17:04 CST 2006

In microsoft.public.money, Apteryx wrote:

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