This import format is specific to market value file received from Silica.

Import Market Values

 

The system does the following on importing:

[check_list]

  • Creates new Person and Investment account if one does not exist
  • Imports “Opening Balance Transaction” in UNITS for new investors
  • Updates UNIT balance via a “Movement Transaction” for existing investors
  • Updates a price on the instrument for the import date

[/check_list]

To display market values the system will take UNITS on the investor account * PRICE on the instrument

The import will FAIL if the instrument does not exist. The “ID” field in the import file is compared to the “Fund Code” on the system to link the instruments in the file to the system.

Last Updated on 12 years ago by Walther