Symbol consolidation

[clivusmul]

Mark, I notice another "aspect" of posting and reporting various aspects of portfolio holdings...

I have several Fund Brokers (Merrill/Wedbush/E-Trade/Scottrade, etc.) and each "downloads" and/or "reconciles" the same symbol with different alpha-numeric string names and/or name truncations. I have the exact symbol asset in 3 accounts and each account has a unique "name" for the same symbol. This 'quirk' demands 3 investment files for each of the 3 identically symbol'd but different "string-name"... Now when I create a report of "distributions" or "Income schedule", etc, you get multiple lines of output for each unique investment file name owning the same symbol...

Is there any work-around for this? I can see issues when doing broker downloads if the file can't find the name of the equity being reconciled in the sub-portfolio... Is there any way to consolidate under the ticker symbol? There could be a "alias" cross-reference that would allow the program to post to different investment holdings on data entries but print consolidated information under one symbol???

Thanks, bj

[Mark]

Hi bj,

Even if the names were identical, you would want/get 3 different investment (*.dat) files. Each file is so you can track independent transactions in these investments. We have a FAQ on this topic here:

https://www.fundmanagersoftware.com/faq ... tments.php

When reporting, you can often choose how to "List By" in your report. For example, in the Portfolio Value report, you can choose to list by quite a few different items, including "Investment", and "Symbol". The default is "Investment", but if you choose to list by "Symbol", all investments with the same symbol will be consolidated onto a single line in your report. Even if the names are different, as long as the symbols are the same, they will be consolidated.

[clivusmul]

Thanks Mark... Reporting by Symbol would solve the problem/observation... thanks again.