Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 03-01-2005, 03:03 AM
Wally
Guest
 
Posts: n/a
Default RE: How to see position subtotaled by account

Remember, this is a report, not a portfolio view.

"Miles" wrote:

- quote -

> Not what I'm after.
> Imagine a report or view looking like this:
> Oracle
> Apple
> Microsoft 100 Shares
> Account 1 50 Shares
> Account 2 50 Shares
> That's not what I see. Money shows all transactions for the position but
> doesn't subtotal them. So, if I bought 10 shares in Account 1, then sold 5,
> then bought 20 and sold 10, bought 30, sold 20....I'd have to total them all
> or go directly to that account to see the subtotal. I want to see my total
> position in a stock and each account's share of that position.
> Miles
> "Wally" wrote:
> > Unless I am misunderstanding your question, the Value by Investment Account
> > report should do exactly what you want. Right click on the investment in a
> > particular account and select View Transactions, and it will show you only
> > the transactions from that account.
> > > "Miles" wrote:
> > > > In MS Money 2005 Premium, when I look at my Portfolio, Select View =
> > > Holdings, Group By = Position, each equity position appears. If I click on
> > > the plus sign, I see the buys and sells for that position. If I have have
> > > several buys and sells in multiple accounts for this one position, this
> > > expanded view has little value.
> > > > > Is there a view that shows the position subtotaled by Account? Ex. if I
> > > have 50 shares of MSFT in Account A and 50 shares of MSFT in Account B, the
> > > view above shows Microsoft 100 shares and if I press the + sign to the left
> > > of Microsoft, it shows the transactions that lead to 50 shares in each
> > > account. I would prefer to see a subtotal for each account. Even better
> > > would be a subtotal by each account and then another plus sign that shows me
> > > each open transaction so I can see unrealized gains and losses for each
> > > position for tax purposes.
> > > > > Thanks,
> > > > > Miles

  #2  
Old 03-01-2005, 02:59 AM
Wally
Guest
 
Posts: n/a
Default RE: How to see position subtotaled by account

I am using Money 2005 standard, so there could be some difference in the
reports.
My Porfolio Value by Investment Account report does not show any
transactions. It shows the total number of shares for each investment in
each account for a given date. It also shows the total unrealized gain/loss
in each account for each investment among other things. You only see the
transactions if you right click on the investment and select View
Transactions. However, it will not give you the total number of shares in
all accounts for a particular investment. You could customize this report to
show just the one investment. You could then get the total unrealized
gain/loss for that investment, but the number of shares column does not get
totalled.

"Miles" wrote:

- quote -

> Not what I'm after.
> Imagine a report or view looking like this:
> Oracle
> Apple
> Microsoft 100 Shares
> Account 1 50 Shares
> Account 2 50 Shares
> That's not what I see. Money shows all transactions for the position but
> doesn't subtotal them. So, if I bought 10 shares in Account 1, then sold 5,
> then bought 20 and sold 10, bought 30, sold 20....I'd have to total them all
> or go directly to that account to see the subtotal. I want to see my total
> position in a stock and each account's share of that position.
> Miles
> "Wally" wrote:
> > Unless I am misunderstanding your question, the Value by Investment Account
> > report should do exactly what you want. Right click on the investment in a
> > particular account and select View Transactions, and it will show you only
> > the transactions from that account.
> > > "Miles" wrote:
> > > > In MS Money 2005 Premium, when I look at my Portfolio, Select View =
> > > Holdings, Group By = Position, each equity position appears. If I click on
> > > the plus sign, I see the buys and sells for that position. If I have have
> > > several buys and sells in multiple accounts for this one position, this
> > > expanded view has little value.
> > > > > Is there a view that shows the position subtotaled by Account? Ex. if I
> > > have 50 shares of MSFT in Account A and 50 shares of MSFT in Account B, the
> > > view above shows Microsoft 100 shares and if I press the + sign to the left
> > > of Microsoft, it shows the transactions that lead to 50 shares in each
> > > account. I would prefer to see a subtotal for each account. Even better
> > > would be a subtotal by each account and then another plus sign that shows me
> > > each open transaction so I can see unrealized gains and losses for each
> > > position for tax purposes.
> > > > > Thanks,
> > > > > Miles

  #1  
Old 02-28-2005, 11:59 PM
Miles
Guest
 
Posts: n/a
Default RE: How to see position subtotaled by account

Not what I'm after.

Imagine a report or view looking like this:

Oracle
Apple
Microsoft 100 Shares
Account 1 50 Shares
Account 2 50 Shares

That's not what I see. Money shows all transactions for the position but
doesn't subtotal them. So, if I bought 10 shares in Account 1, then sold 5,
then bought 20 and sold 10, bought 30, sold 20....I'd have to total them all
or go directly to that account to see the subtotal. I want to see my total
position in a stock and each account's share of that position.

Miles

"Wally" wrote:

- quote -

> Unless I am misunderstanding your question, the Value by Investment Account
> report should do exactly what you want. Right click on the investment in a
> particular account and select View Transactions, and it will show you only
> the transactions from that account.
> "Miles" wrote:
> > In MS Money 2005 Premium, when I look at my Portfolio, Select View =
> > Holdings, Group By = Position, each equity position appears. If I click on
> > the plus sign, I see the buys and sells for that position. If I have have
> > several buys and sells in multiple accounts for this one position, this
> > expanded view has little value.
> > > Is there a view that shows the position subtotaled by Account? Ex. if I

> > have 50 shares of MSFT in Account A and 50 shares of MSFT in Account B, the
> > view above shows Microsoft 100 shares and if I press the + sign to the left
> > of Microsoft, it shows the transactions that lead to 50 shares in each
> > account. I would prefer to see a subtotal for each account. Even better
> > would be a subtotal by each account and then another plus sign that shows me
> > each open transaction so I can see unrealized gains and losses for each
> > position for tax purposes.
> > > Thanks,
> > > Miles

 
Old 02-28-2005, 11:21 PM
Wally
Guest
 
Posts: n/a
Default RE: How to see position subtotaled by account

Unless I am misunderstanding your question, the Value by Investment Account
report should do exactly what you want. Right click on the investment in a
particular account and select View Transactions, and it will show you only
the transactions from that account.

"Miles" wrote:

- quote -

> In MS Money 2005 Premium, when I look at my Portfolio, Select View =
> Holdings, Group By = Position, each equity position appears. If I click on
> the plus sign, I see the buys and sells for that position. If I have have
> several buys and sells in multiple accounts for this one position, this
> expanded view has little value.
> Is there a view that shows the position subtotaled by Account? Ex. if I
> have 50 shares of MSFT in Account A and 50 shares of MSFT in Account B, the
> view above shows Microsoft 100 shares and if I press the + sign to the left
> of Microsoft, it shows the transactions that lead to 50 shares in each
> account. I would prefer to see a subtotal for each account. Even better
> would be a subtotal by each account and then another plus sign that shows me
> each open transaction so I can see unrealized gains and losses for each
> position for tax purposes.
> Thanks,
> Miles

  #-1  
Old 02-28-2005, 10:35 PM
Miles
Guest
 
Posts: n/a
Default How to see position subtotaled by account

In MS Money 2005 Premium, when I look at my Portfolio, Select View =
Holdings, Group By = Position, each equity position appears. If I click on
the plus sign, I see the buys and sells for that position. If I have have
several buys and sells in multiple accounts for this one position, this
expanded view has little value.

Is there a view that shows the position subtotaled by Account? Ex. if I
have 50 shares of MSFT in Account A and 50 shares of MSFT in Account B, the
view above shows Microsoft 100 shares and if I press the + sign to the left
of Microsoft, it shows the transactions that lead to 50 shares in each
account. I would prefer to see a subtotal for each account. Even better
would be a subtotal by each account and then another plus sign that shows me
each open transaction so I can see unrealized gains and losses for each
position for tax purposes.

Thanks,

Miles
 

Tags
account, position, subtotaled
Similar Threads
Thread Forum Replies Last Post
Money 2005 - Display full account number in account list?
Hank Oredson: -- ... Hank http://horedson.home.att.net http://w0rli.home.att.net
Microsoft Money 1 01-01-2005 01:12 PM
Money 2005 - how to display full account number in account list?
Hank Oredson: -- ... Hank http://horedson.home.att.net http://w0rli.home.att.net
Microsoft Money 1 01-01-2005 01:11 PM
Stock Position Updates
igorx: I have 3 accounts with Smith Barney. When I update these accounts in Money 2003 I get a box that is titled Position Matching. This box shows my...
Microsoft Money 1 08-28-2004 08:44 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 07:57 AM.