Select 2 out of various sub-portfolios for reporting

[rojeg]

Hi
Assuming I have the following structure

Main Portfolio
-sub-portfolio 1
-sub-portfolio 2
-sub-portfolio 2.1
-sub-portfolio 2.2

and so on.

Can I create a custom report consolidating, let's say,

sub-portfolio 1
sub-portfolio 2.1

or any other combination of portfolios and sub-portfolios?

Thanks for your help!

rojeg

[Mark]

Hi rojeg,

Not as you have defined there... When you report, you must select 1 sub-portfolio and the report includes everything at that level and beneath. If you wanted to create a report with your 1 and 2.1 you could do this by creating link sub-portfolios. You would do something like this:

Code: Select all

Main Portfolio
  -sub-portfolio 1
  -sub-portfolio 2
    -sub-portfolio 2.1
    -sub-portfolio 2.2
  - My Group
    - Link to sub-portfolio 1
    - Link to sub-portfolio 2.1

Now, you can report on "My Group", and it will include the 2 you wanted. Link sub-portfolios are a special type of sub-portfolio that just mirror image any other real sub-portfolio that you select.

[rojeg]

Hi Mark

Thanks, this is what I was looking for.

BR

rojeg

[rojeg]

Hi Mark

I have tried as you described to create a special "my group" structure which has a sub-portfolio linked to an existing sub-portfolio the way you described (and the sub-portfolio is appearing in purple color).

When I do a total portfolio value report it is still adding the "linked to" (mirrored) sub-portfolio into my total portfolio value (and therefore double counting). What am I missing?

Thanks for your help.

rojeg

[Mark]

Hi rojeg,

When you create the Portfolio Value report, are you reporting at the "Main Portfolio" level, or at the "My Group" level? If you create it at the "My Group" level, it will only include what is in the "My Group" sub-portfolio.

Maybe what you want is to create your hierarchy like this:

Code: Select all

Main Portfolio
  - My Holdings
    -sub-portfolio 1
    -sub-portfolio 2
      -sub-portfolio 2.1
      -sub-portfolio 2.2
  - My Group
    - Link to sub-portfolio 1
    - Link to sub-portfolio 2.1

So, you can report at "My Holdings" to get all your accounts, or at "My Group" to get just the combination you want. If you reported at "Main Portfolio" it would not be appropriate, as you'll get "sub-portfolio 1" and "sub-portfolio 2.1" included twice.

[rojeg]

Hi Mark

Right, I did the report at the "Main Portfolio" level. I need to do the structure exactly as you mentioned in your reply by using the "My Holdings" (for all sub-portfolios) and "My Group" (for part of the sub's) as the structure (under the "Main Portfolio").

Thanks! Should have seen this myself!

Best

rojeg