Updating net asset values (NAVs) on a website is a crucial operation for many companies in the financial sector, such as fund management companies and investment platforms. There are several ways to accomplish this task, each with its advantages and disadvantages. We propose to explore three approaches: manual entry into a table, importing files, and retrieving VLs from a provider.
1. Manual entry of net asset values in a table
Benefits
Manual entry of LVs directly into the site administration interface is a simple and immediate method. It allows total control over the data entered, with the possibility of checking and correcting errors directly. This method is ideal for small structures handling a limited number of vehicles.
Disadvantages
However, this method is very time-consuming, especially when the number of LVs to be updated is large. It is also prone to human error, such as typos or omissions, which can lead to inaccuracies in the published data. Finally, it requires constant vigilance to ensure that all data is up to date, which can represent a considerable workload.
2. Importing CSV/JSON files
Benefits
Importing CSV or JSON files is faster and more efficient than manual entry. It enables large quantities of data to be imported en masse with a single click, considerably reducing the time needed to update net asset values. What’s more, these files can be generated automatically by an external system, limiting the risk of human error.
Disadvantages
Importing files is not without its challenges. First of all, it’s crucial to ensure that the file format is correct and that the data is well structured. An error in the file, such as the wrong column or incorrect formatting, can lead to import errors.
3. Net asset value retrieval from a provider
Benefits
Automatic VL retrieval from an external provider is the most advanced and automated method. It ensures that data is always up to date, without the need for human intervention. Using APIs supplied by providers such as Funds 360, Morningstar or Quantalys, NAVs can be updated in real time, ensuring maximum data reliability.
Disadvantages
This solution requires extensive technical integration, which can represent a substantial initial cost. In addition, it depends on the availability and stability of the provider’s service. Finally, the use of external services can also entail recurring costs linked to data subscription.
The expertise of Agence SAND
Each method of updating VLs has its own advantages and disadvantages, and the choice of the best approach depends on the specific needs of each company (see our page on performance graphs). Whether you prefer the simplicity of manual entry, the efficiency of file import or advanced automation via providers, the SAND agency masters all three methods perfectly. We are also able to develop tailor-made solutions, adapted to the unique requirements of our customers. Please contact us to discuss your VL updating needs and find out how we can help you optimize your processes.
