/Mass Portfolio Composition Import

Search Knowledge Base by Keyword

Mass Portfolio Composition Import

1) Prepare a file with your data

  • This file needs to be a *.xlsx file and it should only contain dates and columns with your fund´s data.
  • We highly recommend to start with downloading a sample file from Topsheets.
  • When you open the file, it looks as on the image below. Please leave the first column as it is.
  • Adjust dates in the second column according to your needs or remove the column. Please note that in some cases (e. g. market cap allocation values) the date column has to be removed otherwise the values are imported as historical and do not show up.
  • Third and fourth column represent two separate portfolios. You can add as many columns as you wish. Just keep in mind that every column (portfolio) must have a unique title (e.g. ProgramCode1, ProgramCode2 etc.). Please note, that the program code must not be longer than 20 characters. These codes will be linked to funds in the next step.

2) Add codes to your programs (funds)

  • Select an investment program in the left menu and then in the right menu go to Program Terms / Program Name
  • Add codes (unique titles) to your programs.

3) Upload your file

  • Go to Company Profile / Mass Imports and click “Mass Portfolio Composition Import” (see picture below).
  • Select a file and click save.

Need help? Feel Free to Ask

To make this site work properly, we sometimes place small data files called cookies on your device. Most big websites do this too. Show details Ok

About cookies

What are cookies?
Cookies are small text files that are placed on your computer by websites that you visit. Websites use cookies to help users navigate efficiently and perform certain functions. Cookies that are required for the website to operate properly are allowed to be set without your permission. All other cookies need to be approved before they can be set in the browser.

How to control cookies?
You can control and delete the cookies that are stored on your computer. Please see aboutcookies.org for more information.

Marketing/Tracking

_gat_gtag_UA_*_1 This cookie is used by Google Analytics to store and track conversions.
Retention period: 1 hour.
Domain: www.fundpeak.com

Statistics (anonymous)

_ga This cookie is used by Google Analytics to count and track pageviews.
Retention period: 2 years.
Domain: www.fundpeak.com

_gid This cookie is used by Google Analytics to count and track pageviews.
Retention period: 1 day.
Domain: www.fundpeak.com

Functional

privacy_embeds This cookie is used by Fundpeak to store user privacy preferences.
Retention period: at least one session.
Domain: www.fundpeak.com

Third party

_GRECAPTCHA This cookie is used by Google. reCAPTCHA sets a necessary cookie when executed for the purpose of providing its risk analysis.
Retention period: 6 months.
Domain: www.google.com