Skip to content

Fund Manager

Overview

Fund manager is institutional that managed fund-certificates

Component

flowchart LR
  fm[Fund Manager]
  vsdc[VSDC]
  fs[Fund Certificates]

  fm -- contain -->  fs
  fm -- register --> vsdc
  vsdc -- managed information --> fs

  %% note: Source at https://vsd.vn/en/qlq?tab=1

Specification

Registration regulations

For the fund certificates, fund managers required register to VSDC with following metadata:

  • Information of fund certificate registration

  • Principles of managing fund certificate information

Procedures

Fund certificates are cancelled at VSDC when they are delisted as stipulated by Circular no.119/2020/TT-BTC dated 31st December 2020.

  • Processes and procedures of listed closed-ended fund certificates are specified in the Guideline on securities registration and ownership transfer issued with Decision no. 108/QĐ-HDTV dated 10/08/2023

Identifier

For the database layer, the following table

Table vsd_fund_manager_information

Field Type Description
fund_manager_id int The ID of fund managed by VSD
full_name text Name of fund
abbreviation text Short reference abbr of the fund
english_name text English name
address text
charter_capital bigint
actual_capital bigint
phone_number text
fax text
business_registration_certificate_or_licence_of_establishment text
currency_type varchar(3)
currency_unit int
reference_url text
language varchar(50)
id bigint SCD2 attribute
status varchar(1) SCD2 attribute
created_at datetime SCD2 attribute
updated_at datetime SCD2 attribute
deleted_at datetime SCD2 attribute
verified_at datetime SCD2 attribute
created_by text SCD2 attribute
updated_by text SCD2 attribute
deleted_by text SCD2 attribute
verified_by text SCD2 attribute

Table vsd_fund_manager_security

Field Type Description
fund_manager_id int
security_code text
isin_code text
security_status text
security_reference_url text
security_name text
security_type text
trading_market text
administration_place text
reference_url text
language varchar(50)
id bigint SCD2 attribute
status varchar(1) SCD2 attribute
created_at datetime SCD2 attribute
updated_at datetime SCD2 attribute
deleted_at datetime SCD2 attribute
verified_at datetime SCD2 attribute
created_by text SCD2 attribute
updated_by text SCD2 attribute
deleted_by text SCD2 attribute
verified_by text SCD2 attribute

Source Reference

Fix inno-basement (feat/vsd/fund-manager):

- Merge back when fetch resource

    # The hirallory component of the manager information
    # BUKCET-SNAPSHOT --> DETAIL --> INCLUDED_SECURITIES
    # |________________________|             |
    #             |                          |
    #  FUND_MANAGER_INFORMATION      INCLUDED_SECURITIES


- Write function to fetch total page

- Change while into for-loop

- Check the component by len() method

- Avoid list because list is ordered -> Change into dict to have the key control

- For request, control Connection by timeout with tuple of (None, None)

- [1] Connection first match

- [2] Fetching data (wait the web to fetch all data and send back

- Avoid using position method with schema -> Change into dict

- Method to update data

[1] Fetch the current data in database -> All fund manager with their information

a) Case 1: Non-exist fund-manager-id -> INSERT INTO

b) Case 2: Exist -> Check some attribute is changes? any change -> CHANGED INFO

(
Certificate of business registration/License of establishment,
Charter capital,
Actually contributed capital
)

If exist CHANGED -> Inactive old record -> Append new data

-> Total 2 table only.

- Change: `manager_id` into `vsd_fund_manager_id`-> VSD control

- Parse into interger -> Charter capital (ROUND về 0) -> convert to INT (exluded currency)

- Config to have the language [english, vietnamese]

-> lead to change the URL itself

- Write argument language -> parse into