/Creating Import file / Mass import file
Search Knowledge Base by Keyword

Creating Import file / Mass import file

When using our import or mass import tools the data is imported from an excel file. The file must be formatted correctly, otherwise the import will not work. Follow the steps below in order to make sure the format is correct:

1. Single program import file

1a) Download a sample file
It is well advised to start with downloading a sample file. There is one available for each type of import.

1b) Enter program identifier

Programs are identified by a program identifier so it is vital that the identifier in Topsheets (either program´s code or ID) matches the identifier in your spreadsheet. Please note that program code must not be longer than 35 characters.

1c) Do not change cell format
When adjusting the file make sure to change only values. Do not to change formatting of the cells. We recommend to use Excel AutoFill when copying dates into our excel sample files. Please see Using Excel AutoFill for dates for more information.

2. Mass import file

All points from above apply here as well.

In mass imports programs are identified by program identifiers too. Typically each column represents one program.

Previous Calculate portfolio composition from trades or instruments
Next Import Custom Instruments / Calculate Instruments from Trades

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