/Use FTP to update my factsheets

Search Knowledge Base by Keyword

Use FTP to update my factsheets

It is possible to upload your data files to FTP and then have Topsheets automatically update your factsheets. The import is performed automatically once a day at 5 am GMT. To set up the FTP import go to Performance Data / Auto-Import (see image below). It has to be enabled at least for one program in order to work (no need to set it up for more). There are two basic options available: custom FTP server or our FTP server.

1. Import data from custom FTP

Any FTP server can be used. Please use sftp:// prefix for secure FTP connection. For more information about filenames conventions please see bottom of this topic.

Important note: All imported files are moved to “Processed” directory. This directory either has to be present in the target location (you will have to create it) or the user (see FTP Login on image below) must be granted privileges to create directories on your FTP.

2. Import data from our FTP

If you would like to upload the data to our FTP, please contact us so we can create an account for you. After receiving the login credentials upload your data (or have them automatically sent) to ftp.fundpeak.com. Please use passive transition mode.

Filenames

It is necessary to use the correct filenames otherwise the import will not be performed.

  • monthlyperformance.xlsx (or monthly performance.xlsx )
  • dailyperformance.xlsx
  • trades.xlsx
  • portfoliocomposition.xlsx (or portfoliocomposition.xlsx)
  • fundterms.xlsx (or fund terms.xlsx)
  • instruments.xlsx

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