Do.Finance.MonetaryFinancialInstitution

• Get the latest Monetary Financial Institutions (MFIs) from https://www.ecb.europa.eu
• Additional support of national bank sort code

ECB User guide https://www.ecb.europa.eu/stats/financial_corporations/list_of_financial_institutions/html/mfi_userguide.en.html

General download information website https://www.ecb.europa.eu/stats/financial_corporations/list_of_financial_institutions/html/elegass.en.html

National Bank sort code support

Additional support of national bank sort code

Support:

• Deutsche Bundesbank

   var germanySortCodeHelper = new GermanyBankSortCodeHelper();
   var result = await germanySortCodeHelper.GetCurrentBankSortList(download: true);

Requirement

Check if the csv files are available at the url:

https://www.ecb.europa.eu/stats/financial_corporations/list_of_financial_institutions/html/daily_list-MID.en.html

Website structure:

Monetary Financial Institutions (MFIs): Download area

The EU population of MFIs

	compressed	uncompressed
Full Database	mfi_csv_201005.csv.gz	mfi_csv_201005.csv
Update	mfi_csv_update_201005.csv.gz	mfi_csv_update_201005.csv

https://www.ecb.europa.eu/stats/financial_corporations/list_of_financial_institutions/html/monthly_list-MID.en.html

Monetary Financial Institutions (MFIs) subject to the Eurosystem's minimum reserve requirement (monthly data): Download area

The EU population of MFIs

	compressed	uncompressed
Full Database	mfi_mrr_csv_200930.csv.gz	mfi_mrr_csv_200930.csv
Update	mfi_mrr_csv_update_200930.csv.gz	mfi_mrr_csv_update_200930.csv

Usage

• Download the latest csv from the ecb website

  var result = await monetaryFinancialInstitution.GetCurentListAsync(true);

• Use supplied csv files mfi_csv_201001.csv / mfi_csv_update_201001.csv

   var result = await monetaryFinancialInstitution.GetCurentListAsync(false);

• Download the latest minimum reserve requirement csv. This csv includes the BIC

  var result = await monetaryFinancialInstitution.GetCurentMrrListAsync(true);

• Use supplied csv files mfi_mrr_csv_200930.csv / mfi_mrr_csv_update_200930.csv

   var result = await monetaryFinancialInstitution.GetCurentMrrListAsync(false);

Tooling

• Generate class from csv header https://toolslick.com/generation/code/class-from-csv

• CsvHelper https://joshclose.github.io/CsvHelper/

• ClosedXML for reading excel files https://github.com/ClosedXML/ClosedXML

TODOs

• Find a better name for GermanBankSortCodeHelper -> Naming: Country + SortCodeHelper = GermanyBankSortCodeHelper
• Merge the files to one BankAccount list
• Better file handling. Current: download files in the main project folder
• Support non european bank sort codes

Contribution

Create more national bank sort core helper. Use the class GermanyBankSortCodeHelper as example.

Helpful description for contribute: https://github.com/MarcDiethelm/contributing/blob/master/README.md