Symbol and CUSIP

[paulstonge]

FM has the ability through the edit menu to view the symbol list and make global changes to symbols, CUSIPs and other items. I can't see where it is possible to export a list of symbols with associated CUSIPs. Am I missing something?

[Mark]

Hi paulstonge,

This isn't an export option currently available. I was thinking of suggesting to use a Custom report, and essentially export this way, but unfortunately we don't currently have CUSIP as an available custom report field. I'll see about getting this added. Would this meet your needs if CUSIP were available as a custom report field?

[paulstonge]

Yes, adding CUSIP as a custom field will help. While you are adding CUSIP maybe you could add the change in unrealized appreciation and begining tax basis. Thanks for your help.

[Mark]

Hi paulstonge,

For the "unrealized appreciation", do you mean the equivalent of "Gain (current)", but using the tax accounting method instead of the Out Of Pocket (OOP) accounting method? For example, one would be calculated as "End Value - Tax Basis, FIFO (ending).

[paulstonge]

The change in unrealized = (End MV - End Basis) - (Beg MV - Beg Basis).

[Mark]

Okay, thanks I understand.