The FundsXML initiative has published a new version of the FundsXML scheme. The new version 4.1.7 contains additional data fields for the exchange of information on discretionary mandates. The new fields are based on the EFAMA Asset Management questionnaire. Thereby the new version will once more help the European fund management industry in fulfilling pan-European reporting requirements in an efficient and easy way.
Author: andychan
-
FundsXML FundsXML GET INSIDE EVENT at BVI in Frankfurt
For the first time, the FundsXML initiative organized a FundsXML Get Inside Event on the premises of BVI in Frankfurt am Main. The keynote speaker was Rudolf Siebel the Managing Director of the BVI, who vehemently advocated the crucial role of the standardized FundsXML format for exchanging funds data information within Europe. Once more, the FundsXML initiative was able to present well-known speakers, which had a lively exchange with the audience of around 65 interested persons. The selected speakers consisted of Karl Kauc (Erste Asset Management), Thomas Koop (BVI), Peter Raffelsberger (Amundi Austria) and Fabrice Puziak (KNEIP).
In the presence of numerous guests, the structure of the FundsXML Organization, as well as fundamental features of the format itself, were discussed. It was stressed that in an ever-changing environment, asset managers more than ever require efficient structures to process information and data. This is where the idea of FundsXML as a Europe-wide standardized data format for exchanging fund data comes in. The FundsXML Format facilitates the structured information exchange between investment companies, data vendors, authorities, insurance companies and many more.
-
Invitation: FundsXML GET INSIDE EVENT in FRANKFURT
The FundsXML event will give you an overview of the basics and application possibilities for automated data exchange with FundsXML.
Location GET INSIDE EVENT: BVI Bockenheimer Anlage 15,
60322 Frankfurt am Main, GERMANYPlease register here for your attendance
The event is free of charge. -
Open-source FundsXML <-> CSV Converter
To convert a FundsXML to CSV and vice versa the mechanism has never been as easy as it is with the new open source C ++ based FundsXML <-> CSV Converter. Listening to users’ challenges in creating FundsXML documents, the tool was designed to allow interested parties an easy conversion of files between the two different formats.
Currently the FundsXML <-> CSV converter can be used as a command-line tool which is useful for both interactive and batch processing. To perform the conversion, the FundsXML <-> CSV Converter needs compulsorily an input file (FundsXML or CSV), the matching mapping-definition as well as an appropriate template file. At the moment the tool comes with ready-to-use mapping definitions for EMT, TPT, holdings data and NAV data. To name but a few features, the tool is logging content and format errors of the input files (either CSV or FundsXML format) and the names of the processed files along with status information when working in batch mode.
For data other than represented in the above listed mapping-definitions, additional structural information and parameters can to be supplied respectively in the mapping-definition and the template file. While the template file (in CSV format) is defining the order of columns, the column delimiters and the format of the numbers, modifying the mapping-definition file (in CSV format) allows interested parties to customize the behavior for their specific application.
Please visit our New FundsXML-TOOLS site:
http://www.xml-tools.net/fundsxml/fundsxml-csv-converter.html
http://www.xml-tools.net/index.html
-
FundsXML at the FundConnect conference on Regulatory Reporting
FundsXML was invited to two conferences on the complex regulatory reporting obligations for European asset management companies. These conferences, hosted by FundConnect, took place in Stockholm and Oslo on the 20th and 21st November 2018.In the presence of numerous guests from politics, business and academia, scenarios and approaches to facilitate the growing reporting burden were presented. The programme focused on fund data standardization initiatives, but also aspects on the sustainable development of financial instruments were discussed from the viewpoint of investors. The FundsXML Initiative was represented by Andy Chan from Robeco Netherlands and Peter Raffelsberger from Amundi Austria. While Andy Chan spoke about the organization of FundsXML and its usage at Robeco, Peter Raffelsberger presented the technical structure and why FundsXML is a perfect solution for efficient and high-quality transfer of fund related data.
-
New TPT 4.0 Data items integrated
The new version of FundsXML 4.1.3 has integrated all changes and adaptations of the Tripartite Template (TPT) 4.0 of 3 April 2018. There are also some changes in the EMT section. All “indicative” data items are changed from optional to mandatory. Users of the regulatory reportings should always use only the latest FundsXML version, which reproduces the latest status of the respective templates.
-
Changes in EMT section
Due to practical experience there was a need in the EMT section to change some items from mandatory to optional. Therefore the FundsXML Working Group Content/Technique by order of the FundsXML Standards Committee has worked out the new version. The new FundsXML version 4.1.2 is now available for download.
The changes In detail:For Funds, to switch to optional (as conditional), in the node “CostsAndChargesExAnte”:
– 07020_One-off_cost_Financial_Instrument_entry_cost
– 07030_One-off_cost_Financial_Instrument_maximum_entry_cost_fixed_amount_Italy
– 07040_One-off_cost_Financial_Instrument_maximum_entry_cost_acquired
– 07050_One-off_costs_Financial_Instrument_maximum_exit_cost
– 07060_One-off_costs_Financial_Instrument_maximum_exit_cost_fixed_amount_Italy
– 07070_One-off_costs_Financial_Instrument_maximum_exit_cost_acquired
In addition, the following data fields and the full node “CostsAndChargesExPost” should be switched to optional:
– 08030_Financial_Instrument_Ongoing_costs_ex_post (for Funds and Structured securities, in two node)
– 08050_Financial_Instrument_Management_fee_ex_post (only for funds)
– 08070_Financial_Instrument_Transaction_costs_ex_post
– 08080_Financial_Instrument_Incidental_costs_ex_post -
Validation of FundsXML files
By enabling interested parties to validate their FundsXML documents we are further simplifying the use of the FundsXML format. The validation process ensures that your FundsXML document respects the rules dictated by the corresponding FundsXML schema. Beyond that, this process also confirms that your document meets the W3C requirements for being XML and is therefore considered well-formed.
Many xml tools offer a very simple method for checking XML documents against a XML schema. By referencing the corresponding XML schema as an attribute in the root node your XML tool is able to load the XML Schema. In this way it validates the FundsXML document automatically.
Simply add this information to the root node:
Validation against an XML schema includes the following checks:
– XML document is well-formed (e.g. only one root node, correct closing of open tags, … )
– All XML nodes exist in the XML schema (and are used in the correct order)
– All mandatory XML nodes exist in the XML document
– The content of an XLM field is valid according to the defined format (e.g. valid numbers, valid dates)
– All UniqueIDs (within positions and transactions) exist in the AssetMasterData section
