Home/Calculate portfolio composition from trades or instruments
Search Knowledge Base by Keyword

Calculate portfolio composition from trades or instruments

1) Calculate from trades

  • You can simply upload your trades from a file (see here for more information) and then let TopSheets to calculate portfolio composition data (such as Geography Exposure, Holdings, etc.) automatically from trades.
  • When uploading your file, tick the “Calculate portfolio composition from trades” checkbox and then click “Save” (see picture below).
  • Please note that trades must not have CloseDate values entered in order to successfully import weights. If CloseDate is entered, the values are stored in history.

2) Calculate from Instruments

The same option is also available for instruments in the Portfolio Composition section. You can find the same checkbox on the very bottom of this section (see pictures below).

Previous Available fields for Mass Portfolio Composition Import
Next Creating Import file / Mass import file

Need help? Feel Free to Ask

Go to Top