/Common mistakes when importing fund´s performance data

Search Knowledge Base by Keyword

Common mistakes when importing fund´s performance data

When uploading performance data for your performance reports please be aware of these mistakes:

1) Uploading monthly performance data

  • Your file must be in .xlsx format.
  • Check your dates format. Download our sample file for best results. When editing the sample file  make sure not to change the dates formatting.
  • Use comma as a decimal point (to set up Excel go to Options – Advanced – Decimal separator)
  • The monthly returns must be in percentages

2) Uploading daily performance data

  • Your file must be in .xlsx or .csv format.
  • Use dot as decimal point (to set up Excel go to Options – Advanced – Decimal separator)
  • The daily returns must be numbers (not percentages). Use Excel function Find & Select to find percentage signs and replace them with empty space.
  • If you want to convert .txt file into .csv, please use OpenOffice Calc. When you use Excel, your data will be in incorrect format. If you insist on using .csv from Excel, see next point.
  • When using .csv check your file in a simple text editor and remove any unnecessary characters (e. g. quotation marks) or empty rows at the end.

Fund performance reports software - screenshot

  • Be aware of mistakes in data.

Fund performance reports production - screenshot

  • When using .csv make sure to select the date format and item separator you want to use (for further instructions, please see our video How to properly set the file format for uploading daily data).

3) Uploading AUM

  • Your file must be in .csv format
  • Your numbers must be transposed in a row
  • Add an inception date at the beginning of the file
  • When using .csv check your file in a simple text editor and remove any unnecessary characters (e. g. quotation marks), empty rows or empty spaces (for further instructions, please see our video tutorial below)

Fund performance reports automation - screenshot

Need help? Feel Free to Ask