Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 07-09-2006, 07:49 PM
Jeff M
Guest
 
Posts: n/a
Default Re: Unrealized gans/losses by investment lot

Excellent! That's exactly what I was looking for.

Thanks very much.

Jeff

Cal Learner-- MVP wrote:
- quote -

> In microsoft.public.money, Jeff M wrote:
> > Thanks. I should have been clearer.
> > > I'm looking for a way to view gains or losses by individual investment

> > lot. For example, if you have a mutual fund with regular monthly
> > investments, in the portfolio view it shows the fund as one line with
> > an average purchase price. If you click on the + symbol to the left of
> > the fund name in the portfolio view it will show the individual lots
> > along with the date, activity, quantity, price and amount. However,
> > this view doesn't show the gain or loss. I also can't find a report
> > which will break it down by lot.

> In Money 2005 or 2006, see
> Investing-> InvestingTools-> CapitalGainsEstimator-> EstimateCapitalGains.
> In the left column, UpdatePrices-> UpdatePricesOnline
> Note the UnrealizedGain column. Click the [+] in front of a security
> to expand into lots for a given security.
> Optionally, you can select a Distribution Method at the top. Enter a
> value into the QuantityToSell column to the right of an investment
> name, and it will allocate the lots according to the method.
> At the bottom it will report the summation of the "proposed sales".


  #2  
Old 07-09-2006, 06:57 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Unrealized gans/losses by investment lot

In microsoft.public.money, Jeff M wrote:

- quote -

> Thanks. I should have been clearer.
> I'm looking for a way to view gains or losses by individual investment
> lot. For example, if you have a mutual fund with regular monthly
> investments, in the portfolio view it shows the fund as one line with
> an average purchase price. If you click on the + symbol to the left of
> the fund name in the portfolio view it will show the individual lots
> along with the date, activity, quantity, price and amount. However,
> this view doesn't show the gain or loss. I also can't find a report
> which will break it down by lot.


In Money 2005 or 2006, see
Investing-> InvestingTools-> CapitalGainsEstimator-> EstimateCapitalGains.

In the left column, UpdatePrices-> UpdatePricesOnline

Note the UnrealizedGain column. Click the [+] in front of a security
to expand into lots for a given security.

Optionally, you can select a Distribution Method at the top. Enter a
value into the QuantityToSell column to the right of an investment
name, and it will allocate the lots according to the method.

At the bottom it will report the summation of the "proposed sales".

  #1  
Old 07-09-2006, 05:59 PM
Jeff M
Guest
 
Posts: n/a
Default Re: Unrealized gans/losses by investment lot

Thanks. I should have been clearer.

I'm looking for a way to view gains or losses by individual investment
lot. For example, if you have a mutual fund with regular monthly
investments, in the portfolio view it shows the fund as one line with
an average purchase price. If you click on the + symbol to the left of
the fund name in the portfolio view it will show the individual lots
along with the date, activity, quantity, price and amount. However,
this view doesn't show the gain or loss. I also can't find a report
which will break it down by lot.

Jeff

Cal Learner-- MVP wrote:
- quote -

> In microsoft.public.money, Jeff M wrote:
> > Is there a way to view the unrealized gains or losses per investment by
> > each lot? I understand that Gainskeeper will provide this, but is
> > there a way to create such a report or view this detail within Money?

> There is more than one way. The easy way is to configure the
> PriceAppreciation column into your favorite Portfolio view.
> ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns


 
Old 07-09-2006, 05:45 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Unrealized gans/losses by investment lot

In microsoft.public.money, Jeff M wrote:

- quote -

> Is there a way to view the unrealized gains or losses per investment by
> each lot? I understand that Gainskeeper will provide this, but is
> there a way to create such a report or view this detail within Money?


There is more than one way. The easy way is to configure the
PriceAppreciation column into your favorite Portfolio view.

ChangePortfolioView-> CustomizeCurrentView-> PortfolioColumns
  #-1  
Old 07-09-2006, 05:41 PM
Jeff M
Guest
 
Posts: n/a
Default Unrealized gans/losses by investment lot

Is there a way to view the unrealized gains or losses per investment by
each lot? I understand that Gainskeeper will provide this, but is
there a way to create such a report or view this detail within Money?

Thanks.

Jeff

 

Tags
gans or losses, investment, lot, unrealized
Similar Threads
Thread Forum Replies Last Post
unrealized gains doubled
Elizabeth: re M2005 premium: when recording a spin-off, need help understanding how or why all prior parent company unrealized gain values double.
Microsoft Money 8 03-25-2005 02:41 PM
Investment accounts shows the gains / losses only
rvsw: Hi My problem can be stated thus: Objective: To find out my total net worth. Problem: Let's say I have an investment account 'A'. If I have...
Microsoft Money 1 11-28-2004 12:59 PM
Net Worth Report NOT including unrealized gains
Rob Blackburn: I need to produce a net worth report in Money and I would like to be able to run this report both including and not including unrealized gains and...
Microsoft Money 2 09-04-2004 08:32 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 08:16 PM.