Method for constructing retail credit risk prediction model, credit card and special staged business Scorealpha2 model
By adopting a credit risk prediction method based on massive data from large banks in financial institutions, using statistical principles to extract risk laws, and classifying them through decision tree methods, the credit risk management problems in the existing technology are solved and credit risk prediction is improved accuracy and stability.
Patent Information
- Application Number
- CN202310940701.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-07-28
- Publication Date
- 2025-02-18
AI Technical Summary
现有金融机构在信用卡和专项分期业务中面临信用风险管理难题,尤其是在数据挖掘分析能力和风险建模技术方面存在不足,导致无法有效提高信用评分模型的精准度和稳定性。
The credit risk prediction method based on massive data from large banks is adopted, and the risk laws are extracted using statistical principles to build a credit scoring method that is more suitable for credit card business, and the prediction samples are classified through the decision tree method to determine the credit default probability sub-model.
It improves the distinction and stability of credit risk prediction, enhances the risk management capabilities of financial institutions in credit card business, and helps them make more accurate risk decisions in the process of digital transformation.
Smart Images

Figure SMS_1 
Figure SMS_2 
Figure SMS_3
Abstract
Description
Technical Field
[0001] The present application relates to a credit risk management system and method, which can assist financial institutions in making more accurate risk decisions and accelerate their digital transformation process. In detail, the present application relates to a retail credit risk prediction model. Background Art
[0002] Credit cards are special cards issued by commercial banks to organizations or individuals based on applications from borrowers. Credit cards can be used to shop at designated merchants, make purchases, and deposit and withdraw money from banks. Credit card installment services include renovation installments, merchant installments, consumer installments, bill installments, and cash installments. These are consumer lines provided in addition to the credit line of credit cards to meet the large-amount consumption needs of credit card holders. These installment services require users to repay on schedule.
[0003] Credit cards have become an important part of the modern financial industry, which can significantly reduce social transaction costs and play a positive role in promoting my country's economic development. However, my country's credit card market is now in a period of fierce competition, and Internet companies have seized the opportunity, so it is necessary to continue to develop in a variety of scenarios. At the same time, it is also necessary to pay attention to risk control. Credit cards are credit certificates given by banks to borrowers, and special installment business is more convenient and faster than personal loan business, and it is more prone to risks, so it is necessary to avoid risks as much as possible while the business is developing rapidly. This requires the use of tools that can predict customer credit card and special installment business risks to assist business development. Not only before the loan, but also during and after the loan, it is necessary to introduce comprehensive intelligent risk management tools.
[0004] In the current environment of booming consumer credit, the manual approval mechanism of some financial institutions can no longer cope with the increasing demand for credit, so there is an urgent need to improve the intelligent risk control capabilities of financial institutions. Financial institutions hope to build a risk mitigation mechanism for the entire credit process, from customer pre-screening, pre-loan review, loan approval, post-loan management to early collection stages.
[0005] If a scoring system can be developed based on the principles of early identification, early warning, early detection and early disposal, and credit business can be monitored and managed quickly and conveniently, the financial institutions' own business volume, competitive advantage and asset quality can be improved while risks are controllable.
[0006] However, the construction of a scoring system is highly dependent on data and technology. The diversity and coverage of data dimensions, modeling techniques and methodology directly affect the final stability and ranking of the scoring system. Some financial institutions have little experience in intelligent risk control of retail business and have weak risk control capabilities. In the actual application process, factors such as lack of data mining and analysis capabilities and weak risk modeling technology have led to financial institutions being unable to fully utilize the value of internal data and effectively improve the accuracy and stability of models, and other control and management technical difficulties. This is also one of the main obstacles faced by small and medium-sized financial institutions in the direction of digital transformation. Summary of the invention
[0007] In view of the above shortcomings in the prior art, this application is intended to provide a credit risk management system and method that can provide effective risk management for financial institutions. The credit risk prediction method and system of this application is based on the massive data of large banks and the risk rules extracted by statistical principles, which is essentially of promotional significance.
[0008] This application is applicable to credit risk management in credit business, especially for credit card and special installment business scenarios. Credit card business is the most important credit business of commercial banks, which can create huge profits and income for banks. It is also the most convenient and frequently used credit product by retail customers.
[0009] In order to avoid credit risk, a relatively objective evaluation of the borrower's creditworthiness should be made when granting credit services, for example, a credit scoring method can be used. The construction process of other popular scoring models on the market is often limited by unfavorable factors such as a small number of modeling samples, a relatively single data source, and high homogeneity of data dimensions. At the same time, since most of the risk assessment models on the market currently use data with weak financial attributes, that is, they are based on non-credit transaction data such as smart terminal device data, social platform data, online shopping mall data, and non-overdue prediction targets for modeling, their prediction results often have a large deviation from the actual credit overdue situation.
[0010] The method and system of this application are developed based on highly stable and high-coverage data samples, and systematically innovate the relatively mature credit risk control system. Credit samples containing various business forms are used to predict the potential credit risks of financial institutions in credit card business. Specifically, this application uses credit card customer sample modeling to mine the credit (including all credit such as credit cards and consumer loans) and asset characteristics of consumer loan customers, and construct a credit scoring method that is more suitable for commercial banks with credit cards as their main business type.
[0011] Specifically, the present application can further predict the probability of credit default in the future based on (1) the customer group whose account age for applying for credit business is less than G1 (for example, G1 is 3); (2) the customer group whose account age for applying for credit business is greater than or equal to G1 and is currently overdue; (3) the customer group whose account age for applying for credit business is greater than G1, who is not currently overdue and whose current repayment rate is less than a% (for example, a is 90); (4) the customer group whose account age for applying for credit business is greater than G1, who is not currently overdue and whose current repayment rate is greater than or equal to a%; (5) the customer group who has not applied for credit business and whose account age is less than G1; these five credit default probabilities are used as prediction targets (i.e., target variables) for research and development.
[0012] Compared with existing models on the market, the method and system of the present application have greatly improved the discrimination and stability in predicting credit delinquency of this specific customer group and serious delinquency (60 days or more).
[0013] This application involves the following technical solutions:
[0014] 1. A method for calculating retail credit risk, comprising:
[0015] A data collection step, which obtains retail credit prediction data of the sample to be predicted;
[0016] A step of classifying samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default;
[0017] The credit default probability calculation step is to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted, and preferably the credit default probability is the credit default probability.
[0018] 2. The method according to claim 1, further comprising:
[0019] After calculating the credit default probability, a step of calculating the credit score of the sample to be predicted is used to calibrate the calculated credit default probability to a standardized score of 0-1000 points.
[0020] 3. The method according to item 1 or 2, wherein:
[0021] The retail credit prediction data includes original retail credit prediction data of the sample to be predicted and derived retail credit prediction data processed based on the original retail credit prediction data;
[0022] Preferably, the original retail credit prediction data includes:
[0023] Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process.
[0024] Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users.
[0025] Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions.
[0026] Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
[0027] 4. The method according to any one of items 1 to 3, wherein
[0028] The derived retail credit prediction data processed based on the original retail credit prediction data refers to the data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension and statistical information dimension;
[0029] Preferably, the derived retail credit forecast data includes but is not limited to:
[0030] Derived retail credit forecast data obtained by processing based on sample relationship length,
[0031] Derivative retail credit forecast data obtained by processing time interval variables,
[0032] Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior,
[0033] Derivative retail credit forecast data obtained by processing the current time point of the sample,
[0034] Derivative retail credit forecast data obtained by processing based on sample continuous behavior,
[0035] Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
[0036] 5. The method according to any one of items 1 to 4, wherein
[0037] The retail credit prediction data is selected from one, two, three, four, five, six or seven of the following:
[0038] Average utilization rate of revolving loan in the past three months, average number of credit card cash withdrawals, number of months with credit card utilization rate > 90% in the past three months, current deposit account balance, number of months with credit card interest > 0 in the past three months, average monthly AUM (personal financial assets) in the past six months, number of times credit customers have overdue payments > 0 in the past six months, current month remaining available credit card balance, current month installment balance of credit card, number of months from now with minimum balance in deposit account in the past three months, number of months with credit card utilization rate > 90% in the past 12 months, maximum repayment amount in the past six months, maximum percentage of credit card (interest / limit) in the past three months, percentile level of the unit where payroll is paid, number of months from now with the last overdue payment > 0 of a credit customer in the past 12 months, current month remaining available credit card balance degree, current account age of credit customers, number of months in the past 6 months with a revolving loan limit utilization rate greater than 70%, minimum credit card repayment rate in the past 6 months, maximum credit card (interest / limit) percentage in the past 3 months, maximum number of consecutive months with overdue > 0 in the past 12 months for credit customers, remaining available credit limit of the credit card in the current month, current account age of credit customers, percentage of credit card interest / total amount of consumption and cash withdrawal in the past 12 months, average credit card installment limit utilization rate in the past 6 months, maximum number of consecutive months with a month-on-month decrease in AUM in the past 3 months, current deposit account balance, average monthly AUM (personal financial assets) in the past 6 months, number of months from today since the maximum balance of the deposit account at a point in time in the past 12 months, minimum deposit account balance at a point in time in the past 6 months, maximum balance of the investment and wealth management account in the past 12 months.
[0039] 6. The method according to any one of items 1 to 5, wherein
[0040] The step of classifying the sample to be predicted includes the following sub-steps:
[0041] Whether the sample to be tested is a customer who has applied for credit business from a financial institution;
[0042] Whether the sample to be tested has an age greater than or equal to G1;
[0043] Whether the sample to be tested is a customer with overdue credit;
[0044] Whether the current repayment rate of the sample to be tested is less than a%;
[0045] Based on the above sub-steps, the samples to be predicted are classified to determine the sub-model for calculating the probability of credit default. Under the premise of ensuring the rationality of business logic, the order of the above sub-steps can be set arbitrarily;
[0046] It is preferred to classify the predicted samples in the following order:
[0047] First, determine whether the sample to be tested is a customer who has applied for credit business at a financial institution;
[0048] Then determine whether the sample to be tested has an account age greater than or equal to G1;
[0049] Then, determine whether the credit of the sample to be tested is overdue;
[0050] Then determine whether the current repayment rate of the sample to be tested is less than a%.
[0051] 7. The method according to any one of items 1 to 6, wherein
[0052] After performing feature conversion on the retail credit prediction data, the data is substituted into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted. The feature conversion step includes:
[0053] Based on the feature type of the retail credit prediction data that needs to be substituted into the credit default probability sub-model, the WOE method, dummy feature method or continuous method is selected for feature conversion.
[0054] 8. The method according to claim 7, wherein:
[0055] The continuous method for feature conversion includes the following methods: directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data to perform continuous feature conversion.
[0056] 9. The method according to any one of items 1 to 8, wherein
[0057] The credit default probability sub-model is a model constructed based on sample retail credit prediction data and credit default probability using logistic regression based on the existing user population.
[0058] 10. The method according to any one of items 1 to 9, wherein
[0059] The retail credit prediction data is selected from: the average utilization rate of revolving loans in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the current deposit account balance, the number of months with a credit card interest rate > 0 in the past three months, and one, two, three, four, five or six of the average monthly AUM (personal financial assets) in the past six months.
[0060] 11. The method according to item 10, wherein the step of calculating the probability of credit default comprises:
[0061] The average utilization rate of revolving loans in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the current deposit account balance, the number of months with a credit card interest rate > 0 in the past three months, and the average monthly AUM (personal financial assets) in the past six months were converted into features;
[0062] Priority is given to converting the average utilization rate of revolving loans in the past three months in a continuous manner; the average number of credit card withdrawals is converted to WOE; the number of months in which the credit card utilization rate in the past three months is >90% is converted in a continuous manner; the current point in time deposit account balance is converted in a continuous manner; the number of months in which the credit card interest is >0 in the past three months is converted to WOE; the average monthly AUM (personal financial assets) in the past six months is converted in a continuous manner;
[0063] Further preferred is to convert the average value of the utilization rate of the revolving loan credit limit in the past three months into the average value of the utilization rate of the revolving loan credit limit in the past three months using a continuous method; to convert the number of months with a credit card credit limit utilization rate > 90% in the past three months into the original value of the number of months with a credit card credit limit utilization rate > 90% in the past three months using a continuous method; to convert the current point in time deposit account balance into the logarithm of the current point in time; and to convert the monthly average AUM (personal financial assets) in the past six months into the monthly average AUM in the past six months using a continuous method into the square root of the square root.
[0064] 12. The method according to claim 11, wherein:
[0065] The converted values of the six features, namely the average utilization rate of the revolving loan in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the current deposit account balance, the number of months with credit card interest > 0 in the past three months, and the average monthly AUM (personal financial assets) in the past six months, are brought into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
[0066] 13. The method according to claim 12, wherein:
[0067] The sub-model is shown in the following formula 1:
[0068]
[0069] Where k is the number of features entering the model, preferably k is 6,
[0070] α is the intercept term, its value range is (-2.4707, -2.1681), and the optimal value is -2.319.
[0071] β1 is the average utilization rate of the revolving loan in the past three months, with a value range of (-0.6497, -0.5694), and the optimal value is -0.61;
[0072] β2 is the average number of cash withdrawals from credit cards, with a value range of (-0.5801, -0.486) and an optimal value of -0.533;
[0073] β3 is the number of months in which the credit card limit utilization rate is greater than 90% in the past three months, with a value range of (-0.4247, -0.338) and an optimal value of -0.381;
[0074] β4 is the current deposit account balance, with a value range of (-0.9634, -0.747), and the optimal value is -0.855;
[0075] β5 is the number of months in which the credit card interest was > 0 in the past three months, with a value range of (-0.3326, -0.2401) and an optimal value of -0.286;
[0076] β6 is the average monthly AUM (personal financial assets) in the past 6 months, with a range of values of (-0.1607, -0.1019) and an optimal value of -0.131. (Note: The range of values comes from the 95% confidence interval, i.e., the 95% CI in the table below)
[0077] x1 is the square transformation value of the average utilization rate of the revolving loan in the past three months generated in the feature conversion step;
[0078] x2 is the WOE conversion value of the average number of credit card cash withdrawals generated in the feature conversion step;
[0079] x3 is the original value of the number of months in which the credit card limit utilization rate was > 90% in the past three months, generated by the feature conversion step;
[0080] x4 is the logarithmic transformation value of the deposit account balance at the current time point generated by the feature conversion step;
[0081] x5 is the WOE conversion value of the number of months with credit card interest > 0 in the past three months generated by the feature conversion step;
[0082] x6 is the square root transformed value of the average monthly AUM (personal financial assets) for the past 6 months generated in the feature transformation step.
[0083] 14. The method according to claim 13, wherein:
[0084] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0085]
[0086]
[0087] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0088] 15. The method according to any one of items 1 to 9, wherein
[0089] The retail credit prediction data is selected from: the number of overdue payments of credit customers in the past 6 months>0, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past 3 months, the number of months with a credit card credit limit utilization rate>90% in the past 12 months, the maximum repayment amount of the credit customer in the past 6 months, the maximum credit card (interest / limit) percentage in the past 3 months, and one, two, three, four, five, six, seven or eight of the unit quantile levels of wage payment.
[0090] 16. The method according to item 15, wherein the step of calculating the probability of credit default comprises:
[0091] The number of times that credit customers have overdue payments > 0 in the past 6 months, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past 3 months, the number of months with a credit card credit limit utilization rate > 90% in the past 12 months, the maximum repayment amount of credit customers in the past 6 months, the maximum percentage of credit cards (interest / limit) in the past 3 months, and the unit quantile level of wage payment are transformed.
[0092] It is preferred to use WOE conversion for the number of times that the credit customer has overdue payment > 0 in the past 6 months; use continuous conversion for the remaining available credit limit of the credit card in the current month; use continuous conversion for the installment balance of the credit card in the current month; use WOE conversion for the number of months from the minimum balance of the deposit account in the past 3 months; use continuous conversion for the number of months with credit card credit limit utilization rate > 90% in the past 12 months; use continuous conversion for the maximum repayment amount of the credit customer in the past 6 months; use continuous conversion for the maximum percentage of credit card (interest / credit limit) in the past 3 months; use continuous conversion for the unit quantile level of wage payment;
[0093] Further preferably, the continuous conversion of the current month's remaining available credit limit of the credit card is a calculation method of taking the cube root of the current month's remaining available credit limit of the credit card; the continuous conversion of the current month's installment balance of the credit card is a calculation method of taking the cube root; the continuous conversion of the number of months in which the credit limit utilization rate of the credit card in the past 12 months is >90% is a calculation method of taking the square of the number of months in which the credit limit utilization rate of the credit card in the past 12 months is >90%; the continuous conversion of the maximum repayment amount of the credit customer in the past 6 months is a calculation method of taking the square root of the maximum repayment amount of the credit customer in the past 6 months; the continuous conversion of the maximum percentage of the credit card in the past 3 months is a calculation method of taking the square of the maximum percentage of the credit card in the past 3 months; the continuous conversion of the unit quantile level of the wage agency payment unit is a calculation method of taking the original value of the unit quantile level of the wage agency payment unit.
[0094] 17. The method according to claim 15, wherein:
[0095] The converted values of eight features, including the number of overdue payments of credit customers > 0 in the past 6 months, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the present when the minimum balance of the deposit account in the past 3 months was the number of months with a credit card credit limit utilization rate > 90% in the past 12 months, the maximum repayment amount of the credit customer in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the quantile level of the unit where the wage payment is located, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
[0096] 18. The method according to claim 17, wherein:
[0097] The sub-model is shown in the following formula 2:
[0098]
[0099] Where k is the number of features entering the model, preferably k is 8;
[0100] α is the intercept, the value range is (2.6442, 2.6882), and the optimal value is 2.666;
[0101] β1 is the number of times the credit customer has overdue payments > 0 in the past 6 months, with a value range of (-0.5198, -0.5096) and an optimal value of -0.515;
[0102] β2 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.1685, -0.1641), and the optimal value is -0.166;
[0103] β3 is the current monthly installment balance of the credit card, with a value range of (-0.9329, -0.8981) and an optimal value of -0.916;
[0104] β4 is the number of months from the current minimum balance of the deposit account in the past three months, with a value range of (-0.2822, -0.2694), and the optimal value is -0.276;
[0105] β5 is the number of months in which the credit limit utilization rate of the credit card in the past 12 months is greater than 90%, with a value range of (-0.5523, -0.5247) and an optimal value of -0.539;
[0106] β6 is the maximum repayment amount of credit customers in the past 6 months, with a value range of (-0.0983, -0.0915) and an optimal value of -0.095;
[0107] β7 is the maximum percentage of (interest / limit) of the credit card in the past three months, with a value range of (-0.2917, -0.2705) and an optimal value of -0.281;
[0108] β8 is the unit quantile level of the wage payment unit, with a value range of (-0.4353, -0.3949), and the optimal value is -0.415. (Note: The value range comes from the 95% confidence interval, i.e., the 95% CI in the table below)
[0109] x1 is the logarithmic transformation value of the number of times a credit customer has overdue payments > 0 in the past 6 months generated in the feature transformation step;
[0110] x2 is the WOE conversion value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step;
[0111] x3 is the cube root conversion value of the current monthly installment balance of the credit card generated in the feature conversion step;
[0112] x4 is the WOE conversion value of the minimum balance of the deposit account in the past three months generated in the feature conversion step, which is the number of months from now;
[0113] x5 is the square transformation value of the number of months with a credit card limit utilization rate > 90% in the past 12 months generated by the feature transformation step;
[0114] x6 is the square root conversion value of the maximum repayment amount of the credit customer in the past 6 months generated in the feature conversion step;
[0115] x7 is the square conversion value of the maximum percentage of credit card (interest / limit) in the past three months generated by the feature conversion step;
[0116] x8 is the original value of the unit quantile level of the wage payment generated in the feature conversion step. The model performance of some features is shown in Table 3 below:
[0117] 19. The method according to claim 18, wherein:
[0118] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0119]
[0120]
[0121] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0122] 20. The method according to any one of items 1 to 9, wherein
[0123] The retail credit prediction data is selected from: the number of months since the last overdue payment of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70%, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months with overdue payments>0 for the credit customer in the past 12 months, one, two, three, four, five, six or seven.
[0124] 21. The method according to claim 20, wherein the step of calculating the probability of credit default comprises:
[0125] The features of the last overdue payment of the credit customer in the past 12 months > 0 are converted into the number of months from now, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70%, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months in which the credit customer was overdue > 0 in the past 12 months.
[0126] The preferred credit customers in the past 12 months have the last overdue payment > 0 months ago and use WOE conversion; the credit card's current month's remaining available credit limit is converted in a continuous manner; the credit customer's current account age is converted in a continuous manner; the current credit card's remaining available credit limit is converted in a continuous manner; the number of months in which the credit limit utilization rate of revolving loans in the past 6 months is greater than 70% is converted in a continuous manner; the minimum credit card repayment rate in the past 6 months is converted in a continuous manner; the maximum credit card (interest / limit) percentage in the past 3 months is converted in a WOE manner; the maximum number of consecutive months in which the credit customer has been overdue > 0 in the past 12 months is converted in a continuous manner;
[0127] Further preferably, the current month's remaining available credit limit of the credit card is converted in a continuous manner using a natural logarithm calculation method; the current account age of the credit customer is converted in a continuous manner using an original value calculation method; the current remaining available credit limit of the credit card is converted in a continuous manner using a logarithm calculation method; the number of months in which the utilization rate of the revolving loan limit in the past 6 months was greater than 70% is converted in a continuous manner using a cube root calculation method; the minimum repayment rate of the credit card in the past 6 months is converted in a continuous manner using a logarithm calculation method; the maximum consecutive number of months in which the credit customer is overdue > 0 in the past 12 months is converted in a continuous manner using an original value calculation method.
[0128] 22. The method according to claim 20, wherein:
[0129] The converted values of the seven features, namely, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70%, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months in which the credit customer had overdue payments>0 in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
[0130] 23. The method according to claim 22, wherein:
[0131] The sub-model is shown in Formula 3 below:
[0132]
[0133] Where k is the number of features entering the model, and k is preferably 7;
[0134] α is the intercept, the value range is (1.2929, 1.3799), and the optimal value is 1.336;
[0135] β1 is the number of months from the last overdue payment of the credit customer in the past 12 months > 0, with a value range of (-0.6139, -0.6007), and the optimal value is -0.607;
[0136] β2 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.1436, -0.1404), and the optimal value is -0.142;
[0137] β3 is the current account age of the credit customer, with a value range of (-0.6203, -0.6017) and an optimal value of -0.611;
[0138] β4 is the number of months in the past 6 months when the utilization rate of the revolving loan was greater than 70%, with a value range of (-0.3646, -0.348) and an optimal value of -0.356;
[0139] β5 is the minimum repayment rate of the credit card in the past 6 months, with a value range of (-0.3001, -0.2835) and an optimal value of -0.292;
[0140] β6 is the maximum percentage of (interest / limit) of the credit card in the past three months, with a value range of (-0.2388, -0.2248) and an optimal value of -0.232;
[0141] β7 is the maximum number of consecutive months in which credit customers have overdue payments > 0 in the past 12 months, with a value range of (-0.2806, -0.2624) and an optimal value of -0.272. (Note: The value range comes from the 95% confidence interval, i.e., the 95% CI in the table below)
[0142] x1 is the WOE conversion value of the credit customer whose most recent overdue payment > 0 in the past 12 months generated by the feature conversion step;
[0143] x2 is the original value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step;
[0144] x3 is the WOE conversion value of the current aging of the credit customer generated in the feature conversion step;
[0145] x4 is the logarithmic transformation value of the number of months in the past 6 months when the utilization rate of the revolving loan was greater than 70%, generated in the feature conversion step;
[0146] x5 is the original value of the minimum credit card repayment rate in the past 6 months generated by the feature conversion step;
[0147] x6 is the logarithmic transformation value of the maximum percentage of credit card (interest / limit) in the past three months generated in the feature conversion step;
[0148] x7 is the WOE conversion value generated by the feature conversion step for the maximum number of consecutive months of overdue payments > 0 for credit customers in the past 12 months.
[0149] 24. The method according to claim 23, wherein:
[0150] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0151]
[0152]
[0153] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0154] 25. The method according to any one of items 1 to 9, wherein
[0155] The retail credit prediction data is selected from: one, two, three, four or five of the following: the number of overdue payments of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, and the average utilization rate of the installment limit of the credit card in the past 6 months.
[0156] 26. The method according to item 25, wherein the step of calculating the probability of credit default comprises:
[0157] The number of times the credit customer has overdue payments > 0 in the past 12 months, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal of the credit card in the past 12 months, and the average utilization rate of the credit card installment limit in the past 6 months are transformed into features.
[0158] It is preferred to use WOE conversion for the number of overdue payments of credit customers in the past 12 months > 0; use continuous conversion for the remaining available credit limit of the credit card in the current month; use continuous conversion for the current account age of the credit customer; use continuous conversion for the percentage of interest / consumption and total cash withdrawal of the credit card in the past 12 months; use continuous conversion for the average utilization rate of the installment limit of the credit card in the past 6 months;
[0159] It is further preferred that the current month's remaining available credit limit of the credit card is converted in a continuous manner to a calculation method using the natural logarithm of the current month's remaining available credit limit of the credit card; the current account age of the credit customer is converted in a continuous manner to a calculation method using the cube root of the current account age of the credit customer; the percentage of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months is converted in a continuous manner to a calculation method using the square of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months; the average value of the installment limit utilization rate of the credit card in the past 6 months is converted in a continuous manner to a calculation method using the logarithm of the average value of the installment limit utilization rate of the credit card in the past 6 months.
[0160] 27. The method according to claim 25, wherein:
[0161] The converted values of the five features, namely, the number of overdue payments of the credit customer > 0 in the past 12 months, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal of the credit card in the past 12 months, and the average utilization rate of the installment limit of the credit card in the past 6 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
[0162] 28. The method according to claim 27, wherein:
[0163] The sub-model is shown in Formula 4 below:
[0164]
[0165] Where k is the number of features entering the model, and k is preferably 5;
[0166] α is the intercept, the value range is (1.6093, 1.6857), and the optimal value is 1.648;
[0167] β1 is the number of times a credit customer has overdue payments > 0 in the past 12 months, with a value range of (-0.6496, -0.6424) and an optimal value of -0.646;
[0168] β2 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.3222, -0.3164), and the optimal value is -0.319;
[0169] β3 is the current age of the credit customer, with a value range of (-0.6688, -0.6548) and an optimal value of -0.662;
[0170] β4 is the percentage of interest / total amount of consumption and cash withdrawal of credit card in the past 12 months, with a value range of (-0.3464, -0.338) and an optimal value of -0.342;
[0171] β5 is the average utilization rate of the credit card installment limit in the past 6 months, with a range of values of (-0.3199, -0.3109) and an optimal value of -0.315. (Note: The range of values comes from the 95% confidence interval, i.e., the 95% CI in the table below)
[0172] x1 is the WOE conversion value of the number of overdue payments of credit customers > 0 in the past 12 months generated by the feature conversion step;
[0173] x2 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step;
[0174] x3 is the logarithmic transformation value of the current age of the credit customer generated in the feature transformation step;
[0175] x4 is the cube root conversion value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step;
[0176] x5 is the square transformation value of the average credit card installment limit utilization rate in the past 6 months generated by the feature conversion step.
[0177] 29. The method according to claim 28, wherein:
[0178] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0179]
[0180]
[0181] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0182] 30. The method according to any one of items 1 to 9, wherein
[0183] The retail credit forecast data is selected from: the number of consecutive months with the largest month-on-month decrease in AUM value in the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) in the past six months, the number of months from the current point in time of the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past six months, and one, two, three, four, five or six of the maximum balance of the investment and wealth management account in the past 12 months.
[0184] 31. The method according to item 30, wherein the step of calculating the probability of credit default comprises:
[0185] The maximum number of consecutive months of decrease in AUM value over the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) over the past six months, the number of months from the maximum balance of the deposit account over the past 12 months, the minimum balance of the deposit account over the past six months, and the maximum balance of the investment and financial management account over the past 12 months are converted into features.
[0186] It is preferred to use WOE conversion for the maximum number of consecutive months of month-on-month decrease in AUM value in the past three months; use continuous conversion for the current deposit account balance; use continuous conversion for the average monthly AUM (personal financial assets) in the past six months; use continuous conversion for the number of months from the maximum balance of the deposit account in the past 12 months; use continuous conversion for the minimum balance of the deposit account in the past six months; use continuous conversion for the maximum balance of the investment and financial management account in the past 12 months;
[0187] Further preferably, the current deposit account balance is converted into the current deposit account balance using a continuous method by taking the logarithm; the monthly average AUM (personal financial assets) of the past 6 months is converted into the monthly average AUM (personal financial assets) of the past 6 months using a continuous method by taking the logarithm; the number of months from the maximum balance of the deposit account in the past 12 months is converted into the number of months from the maximum balance of the deposit account in the past 12 months using a continuous method by taking the original value. The minimum balance of the deposit account in the past 6 months is converted into the minimum balance of the deposit account in the past 6 months using a continuous method by taking the square; the maximum balance of the investment and financial management account in the past 12 months is converted into the maximum balance of the investment and financial management account in the past 12 months using a continuous method by taking the cube root.
[0188] 32. The method according to claim 30, wherein:
[0189] The converted values of the six features, namely, the number of consecutive months with the largest month-on-month decrease in AUM in the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) in the past six months, the number of months from the current maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past six months, and the maximum balance of the investment and wealth management account in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
[0190] 33. A method according to claim 32, wherein:
[0191] The sub-model is shown in Formula 5 below:
[0192]
[0193] Where k is the number of features entering the model, and k is preferably 6;
[0194] α is the intercept, the value range is (-2.2994, -2.0097), and the optimal value is -2.155;
[0195] β1 is the maximum number of consecutive months of decrease in AUM value over the past three months, ranging from (-2.8509, -2.0665), with the best value being -2.459;
[0196] β2 is the current deposit account balance, with a value range of (-0.0925, -0.0588) and an optimal value of -0.076;
[0197] β3 is the average monthly AUM (personal financial assets) in the past 6 months, with a range of (-0.147, -0.0902) and an optimal value of -0.119;
[0198] β4 is the number of months from the current point in time when the deposit account has the largest balance in the past 12 months, with a value range of (-1.1717, -0.6868), and the optimal value is -0.929;
[0199] β5 is the minimum balance of the deposit account in the past 6 months, with a value range of (-0.119, -0.0689) and an optimal value of -0.094;
[0200] β6 is the maximum balance of the investment and financial management account in the past 12 months, with a range of values (-0.634, -0.3404), and the optimal value is -0.487. (Note: The value range comes from the 95% confidence interval, i.e., the 95% CI in the table below)
[0201] x1 is the logarithmic transformation value of the maximum number of consecutive months of decrease in AUM values over the past three months generated in the feature conversion step;
[0202] x2 is the logarithmic transformation value of the deposit account balance at the current time point generated by the feature conversion step;
[0203] x3 is the WOE conversion value of the average monthly AUM (personal financial assets) of the past 6 months generated in the feature conversion step;
[0204] x4 is the original value of the maximum balance of the deposit account in the past 12 months generated by the feature conversion step;
[0205] x5 is the square transformation value of the minimum balance of the deposit account at a certain point in time in the past 6 months generated by the feature conversion step;
[0206] x6 is the cube root conversion value of the maximum balance of the investment and financial management account in the past 12 months generated by the feature conversion step.
[0207] 34. A method according to claim 33, wherein:
[0208] After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower:
[0209]
[0210]
[0211] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0212] 35. A device for calculating retail credit risk, comprising:
[0213] A data collection module, which is used to obtain retail credit prediction data of samples to be predicted;
[0214] A module for classifying samples to be predicted, which is used to classify the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default;
[0215] The credit default probability calculation module is used to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted.
[0216] 36. An apparatus according to item 35, wherein the apparatus executes the steps of the method for calculating retail credit risk described in any one of items 1 to 34.
[0217] 37. A system for calculating retail credit risk, characterized in that the system for calculating retail credit risk comprises: a memory, a processor, and a program for the method for calculating retail credit risk stored in the memory and executable on the processor, wherein the program for calculating retail credit risk implements the steps of the method for calculating retail credit risk as described in any one of items 1 to 34 when executed by the processor.
[0218] 38. A computer storage medium, characterized in that a program for calculating retail credit risk is stored on the computer storage medium, and when the program for calculating retail credit risk is executed by a processor, the steps of the method for calculating retail credit risk as described in any one of items 1 to 34 are implemented.
[0219] 39. A method for constructing a retail credit risk prediction model for credit card and special installment business, comprising:
[0220] A data collection step, which obtains the original retail credit prediction data of the sample used to build the model;
[0221] A data derivation step, which processes derived retail credit forecast data based on the original retail credit forecast data;
[0222] The feature initial screening step is to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening;
[0223] The initial screening data conversion step is to judge the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and use the best method to convert each feature after the initial screening;
[0224] The feature fine screening step is to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features;
[0225] The credit default probability modeling step is to select the logistic regression method to build the model based on the relationship between the carefully screened features and the probability of credit default, and confirm the method used to calculate the credit default probability;
[0226] The data samples obtained in the data collection step are samples of customers who have used credit card services and special installment services.
[0227] 40. The method according to claim 39, wherein:
[0228] In the data collection step, the original retail credit prediction data of the samples obtained for building the model include:
[0229] Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process.
[0230] Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users.
[0231] Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions.
[0232] Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
[0233] 41. The method according to claim 39, wherein:
[0234] In the data derivation step, the derived retail credit prediction data processed based on the original retail credit prediction data refers to data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension, and statistical information dimension;
[0235] Preferably, the derived retail credit forecast data includes but is not limited to:
[0236] Derived retail credit forecast data obtained by processing based on sample relationship length,
[0237] Derivative retail credit forecast data obtained by processing time interval variables,
[0238] Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior,
[0239] Derivative retail credit forecast data obtained by processing the current time point of the sample,
[0240] Derivative retail credit forecast data obtained by processing based on sample continuous behavior,
[0241] Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
[0242] 42. The method according to any one of items 39 to 41, wherein
[0243] The feature initial screening step includes the following steps:
[0244] The first preliminary screening step is to screen the features based on the missing data of each feature of the sample used to build the model.
[0245] The second initial screening step is to screen the features based on the fact that a single value of a feature sample is too high.
[0246] The third preliminary screening step is to calculate the information IV value of each feature to perform preliminary screening of the features;
[0247] The order of the first preliminary screening step, the second preliminary screening step and the third preliminary screening step can be any order.
[0248] The fourth preliminary screening step uses a stepwise discrimination algorithm to perform preliminary screening of features after the first to third preliminary screenings;
[0249] The fifth preliminary screening step is to conduct preliminary screening of the features after the fourth preliminary screening step based on the consistency between the risk characteristics of each feature itself and the actual real results of the samples used for model construction.
[0250] 43. The method according to any one of items 39 to 42, further comprising:
[0251] The sample selection step is used to screen all users before the data collection step and obtain samples of credit card business and special installment business for model construction.
[0252] Preferably, the sample selection step includes classifying all sample users based on a decision tree, and the classification basis includes but is not limited to:
[0253] Whether a user is a customer who has applied for credit registration at a financial institution;
[0254] Whether the account age of a certain user is greater than or equal to G1;
[0255] Whether a user is a customer with overdue credit loans;
[0256] Whether the current repayment rate of a certain user is less than a%.
[0257] 44. A method according to any one of items 39 to 43, wherein, in the initial screening data conversion step, the conversion method of the features after the initial screening is determined based on the concentration and data type of the features after the initial screening.
[0258] 45. A method according to claim 44, wherein:
[0259] The initial screening data conversion step includes the following steps based on the judgment of concentration and data type:
[0260] Classify the data type of each feature into character variables and numeric variables.
[0261] For character variables, dummy feature conversion is used to perform initial screening data conversion.
[0262] The process of further classifying numerical variables includes the following sub-steps:
[0263] If the value of the numeric variable is less than n, the WOE conversion method is used to convert the initial screening data.
[0264] If the value of the numerical variable is more than n, further judge if the value of the continuous variable is large and the concentration of a single value is greater than m%, then the WOE conversion method is used; if the concentration of a single value is less than or equal to m%, then the continuous conversion method is used.
[0265] Preferably, n and m are both positive integers, wherein n=5-10, and m=90-99.
[0266] 46. The method according to item 45, further comprising:
[0267] For the features that are confirmed to adopt the continuous conversion method, the optimal conversion method is selected based on the correlation between the feature and credit default under different continuous conversion methods to perform the continuous feature conversion of the feature.
[0268] Preferably, the continuous feature conversion is performed by directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data.
[0269] 47. The method according to any one of items 39 to 46, wherein the feature fine screening step comprises:
[0270] The first fine screening step is to screen the features based on the stepwise regression algorithm, the F test and the T test to determine the significance of the features.
[0271] The second fine screening step is to calculate the variance inflation factor based on each feature and eliminate the features with higher variance inflation factors to screen the features.
[0272] The third fine screening step is to analyze whether the characteristic coefficients conform to the trend of the prediction results for credit default based on logistic regression of the characteristics after the first fine screening step and the second fine screening step, so as to further perform feature screening.
[0273] 48. A method according to any one of items 39 to 47, wherein the credit default probability modeling step substitutes the features screened in the feature fine screening step into the Sigmoid function to perform logistic regression to calculate the credit default probability model.
[0274] 49. A device for constructing a retail credit risk prediction model for credit card business and special installment business, characterized in that the device comprises:
[0275] A data collection module, which is used to obtain raw retail credit prediction data of samples used to build a model;
[0276] A data derivation module, which is used to process derived retail credit forecast data based on the original retail credit forecast data;
[0277] A feature initial screening module, which is used to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening;
[0278] The initial screening data conversion module is used to determine the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and to use the best method for feature conversion for each feature after the initial screening;
[0279] A feature fine screening module is used to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features;
[0280] The credit default probability modeling module is used to select the logistic regression method to build a model based on the probability relationship between the finely screened features and credit default, and confirm the method used to calculate the credit default probability.
[0281] The data samples obtained by the data collection module are customer samples who have used credit card services and special installment services.
[0282] 50. An apparatus according to item 49, wherein the apparatus executes the steps of the method for constructing a retail credit risk prediction model described in any one of items 39 to 48.
[0283] 51. A system for constructing a retail credit risk prediction model for credit card business, characterized in that the system comprises: a memory, a processor, and a program for constructing a retail credit risk prediction model method stored in the memory and executable on the processor, wherein the program for constructing a retail credit risk prediction model method, when executed by the processor, implements the steps of constructing a retail credit risk prediction model method as described in any one of items 39 to 48.
[0284] Effects of the Invention
[0285] The method and system for constructing a retail credit risk prediction model in this application combines a large number of samples from a large financial institution when constructing the model, and deeply processes and derives the original data obtained from the samples. It uses advanced statistical analysis methods and explainable machine learning technology to construct a general scoring model for retail credit based on the characteristics of the original data and derived data and the strong financial attribute information contained in the data that is difficult to obtain on the market.
[0286] In addition, this application uses the decision tree method to classify samples in the most reasonable way at the beginning of model construction and builds a sub-classification model based on the classified samples. Combining decision trees to build financial models can effectively classify samples according to executable categories, thereby better covering the credit risk characteristics of different customer groups and avoiding the problem of using all samples to build models, resulting in the model lacking sub-group representativeness.
[0287] Furthermore, when constructing the risk prediction model in this application, the overall efficiency of model development is fully improved by using the stepwise discriminant analysis method for the preliminary screening of model features. The stepwise discriminant method can better select more important feature variables under the same dimension, greatly reducing the workload of developers in the next step who need to judge and screen one by one according to the trend of the variables, and fully improving the efficiency of model development without affecting the overall model effect, making the initial screening of variables more efficient and accurate.
[0288] This application innovatively combines continuous conversion, WOE conversion, and dummy feature conversion when building a model, reprocesses some features that have passed the initial screening, combines the advantages and disadvantages of the three conversion methods, and creatively designs a conversion judgment method. According to parameters such as feature data attributes, missing rate, concentration, etc., supplemented by business logic judgment, the optimal feature conversion method is selected. Through such a model building method, it is possible to avoid the technical shortcomings of overfitting when building a model with complete WOE variables and the inability to adapt to categorical variables when building a model with complete continuous variables.
[0289] In addition, the method and system for calculating credit risk probability or scoring credit risk constructed using the model of the present application, namely the Alpha model (Alpha series scoring cards) (including Alpha1 to Alpha5 sub-models or sub-scoring cards), because its model is first split based on the decision tree when it is constructed, so the credit risk is initially calculated by effectively classifying the customer samples and selecting the most suitable sub-model or sub-scoring card for processing. At the same time, because the model construction method used in the sub-model or sub-scoring card is the method described in the present application, the construction process also avoids the technical shortcomings of overfitting when constructing a model with complete WOE variables and the inability to adapt to categorical variables when constructing a model with complete continuous variables. Therefore, it has a significantly better effect than existing models in predicting credit risk.
[0290] This application is applicable to credit business, focusing on credit card business and special installment business scenarios. It is based on the analysis and design of 130 million customers who have applied for credit business registration, especially using the customer sample of those who applied for credit card business registration for model development, so as to more specifically build a retail risk prediction model for credit card business that is more suitable for commercial banks and other financial institutions. In view of the shortcomings of the existing scoring model, such as the small number of modeling samples, the relatively single data source, the high homogeneity of data dimensions, and the use of mostly weak financial attribute data, which leads to large deviations in prediction results, the model of this application is developed based on highly stable and high coverage data samples. In view of the actual characteristics of the credit card business, more significantly related characteristic variables and more reasonable numerical conversion methods are used to construct the model, so that commercial banking institutions, especially commercial banks with more credit card business, can strengthen credit management and risk control more scientifically and effectively, while also reducing the economic cost of personal credit assessment. BRIEF DESCRIPTION OF THE DRAWINGS
[0291] Figure 1 This is a KS curve diagram for Example 10 where the KS value is 58.
[0292] Figure 2 A typical flow chart for classifying all users in a sample based on a decision tree is shown.
[0293] Figure 3 An example of binning to confirm whether the data conforms to business trends is shown. DETAILED DESCRIPTION
[0294] Credit risk is the risk caused by the borrower's reduced willingness to repay or inability to perform the loan contract due to changes in economic ability, rather than the risk of default caused by the borrower's deliberate fraud. Credit default occurs in all kinds of retail credit business scenarios, and is particularly related to the borrower's personal economic situation. The reasons for borrowers' credit defaults can be divided into four categories: 1. Short credit history, such borrowers have little experience in financial management; 2. Borrowers temporarily forget to repay; 3. Over-borrowing, such borrowers have relatively low repayment ability due to a large amount of debt; 4. Affected by major negative factors, such borrowers have long-term impacts on their repayment ability due to major factors such as reduced income, unemployment or divorce. The above different reasons will more or less cause borrowers to default, which may lead to more serious defaults. The purpose of credit risk scoring is to dig out the inherent mathematical relationship between various historical information of customers and the probability of future default, and convert it into a scoring method to quantify the probability of default.
[0295] At present, the credit risk scoring in the existing technology is mainly developed using credit history data and multi-head data (multi-head data refers to the statistical data of borrowers' behavior of applying for loan demands from multiple financial institutions. It is generally believed that the greater the number of multi-heads in a short period of time, the greater the probability of future overdue payments), which reflects their payment behavior and willingness to pay. The data of the samples used to build the model in this application not only includes transaction behavior information of credit business, but also adds asset data that is usually difficult to obtain. While reflecting the borrower's payment behavior and willingness to pay, it also conducts a more comprehensive measurement of their debt repayment ability, personal qualifications, etc., thereby providing more accurate prediction results.
[0296] <Overall description of model building method>
[0297] Specifically, the present application relates to a method for constructing a retail credit risk prediction model, which includes: a data collection step, which obtains the original retail credit prediction data of the sample used to construct the model; a data derivation step, which processes the derived retail credit prediction data based on the original retail credit prediction data; a feature initial screening step, which performs preliminary screening on all categories including the original retail credit prediction data and the derived retail credit prediction data, that is, all features, to obtain the features after the preliminary screening; a preliminary screening data conversion step, which determines the conversion method of the features after the preliminary screening to confirm that one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method is used for feature conversion, and the best method is used for feature conversion for each feature after the preliminary screening; a feature fine screening step, which performs in-depth screening on the features after the preliminary screening after feature conversion to obtain the finely screened features; a credit default probability modeling step, which selects the logistic regression method for model construction based on the finely screened features combined with the probability relationship between the features and the credit default, and confirms the method for calculating the credit default probability.
[0298] In a specific manner, the method for building a retail credit risk prediction model involved in the present application may further include a sample selection step before the data collection step, which is used to screen all users before the data collection step to obtain samples for model building. Those skilled in the art understand that based on the total number and data of users who can build the model, those skilled in the art can choose whether to remove user data that does not meet the requirements for building the model. In addition, those skilled in the art may also first select some users as samples, and then continuously increase the samples for modeling according to corresponding rules.
[0299] <Sample selection steps>
[0300] In a specific implementation, the sample selection step is to screen all users before the data collection step to obtain samples for model construction. Specifically, the sample selection step includes classifying all sample users based on a decision tree, and the classification basis includes but is not limited to: whether a user is a customer who has applied for credit business registration at a financial institution; whether a user has an account age greater than or equal to G1; whether a user is overdue for credit; whether a user's current repayment rate is less than a%.
[0301] Furthermore, all sample users are classified based on the decision tree. Since performance variables are required for modeling, the analysis samples are further divided into whether they have applied for credit business registration at the relevant bank, that is, users can be divided into those who have applied for registration and those who have not.
[0302] Credit business is a basic and important asset business of banks. It recovers the principal and interest by issuing bank loans and obtains profits after deducting costs. Generally speaking, bank credit business is an important means for banks to make profits. From the classification of bank credit business, it can be divided into corporate credit business and personal credit business. Among them, corporate credit business includes project loans, working capital loans, small business loans, real estate enterprise loans, etc.; personal credit business includes personal housing loans, personal consumption loans, personal business loans, etc.
[0303] Credit card business is the most important credit business of commercial banks. It can create huge profits and revenues for banks. It is also the most convenient and frequently used credit product by retail customers.
[0304] A decision tree is a decision analysis method that uses a decision tree to obtain the probability that the expected value of the net present value is greater than or equal to zero, evaluate project risks, and judge its feasibility based on the known probabilities of various situations. It is a graphical method that intuitively uses probability analysis. When constructing a model, this application uses a decision tree to classify samples used for modeling based on the characteristics of data from large financial institutions. After distinguishing between samples that have applied for credit business and samples that have not applied for credit business, it can further classify whether the samples that have applied for credit business are new customers, and classify the samples that have applied for credit business into two categories: new customers and non-new customers. The decision on whether a customer is a new customer can be determined based on the needs of technical personnel in this field. For example, users who have applied for credit business within m months are decided to be new customers, and customers who have applied for credit business for more than m months are non-new customers.
[0305] In a specific implementation, m may be set to, for example, 3, 6, 9 or 12. In the present application, m may also be referred to as account age.
[0306] Those skilled in the art can fully understand that other splitting methods can also be selected when performing sample splitting. For example, all samples can be first split into customer groups with credit cards and customer groups without credit cards. The customer sample splitting method when building the model can be completely considered and carried out according to the needs of modeling.
[0307] In this application, a sample of consumer loan customers is first selected for modeling. Using such a sample group can effectively identify the characteristics of such samples, explore the credit (including all credits such as credit cards and consumer loans) and asset characteristics of consumer loan customers, and build a credit scoring method that is more suitable for commercial banks with credit cards as the main business type. The model built using such a sample can better provide prediction basis for commercial banks.
[0308] <Original Retail Credit Forecast Data>
[0309] When constructing the model for this application, firstly, based on the basic data of financial institutions, about 120 types of original retail credit prediction data (i.e. more than 120 basic features) can be obtained, and the retail credit risk points are split or processed as much as possible according to different dimensions under the premise of optimal effect, generating more than 3,000 derivative features in total.
[0310] When constructing the model, first of all, based on all historical data of large financial institutions, the credit card application and behavior data, personal loan application and behavior data, personal financial asset transaction data and personal customer information data of all retail customers over the past four years were initially collected when constructing the model of this application, totaling 730 million people, of which each person has corresponding data to be processed every month. It can be seen that the data system used to construct the model of this application is comprehensive and the data volume is very large. When constructing a model based on such a data system, it is necessary to consider the modeling methodology, otherwise it will be trapped in the huge data, resulting in the special sample groups that need to be paid attention to being covered in the huge data volume and unable to be effectively identified, causing the computer program to run slowly or even unable to run, so that the most suitable prediction model cannot be accurately constructed.
[0311] In the data collection step, the original retail credit prediction data of the sample obtained for building the model include: basic data of credit cards, which are all available data based on the sample's credit card creation process and use process (i.e., retail customers' credit card application and behavior data); basic data of personal loans, which are all available data based on the sample's loan application and usage behavior (i.e., personal loan application and behavior data); basic data of basic customer information, which are data based on the attributes of the sample itself but not directly related to the behavior in the financial institution (i.e., personal customer information data); or basic data of personal financial assets, which are all other financial assets and financial transaction data of the sample in the financial institution that are not related to credit cards and loans (personal financial asset transaction data).
[0312] In a specific implementation, the basic data of credit cards include, but are not limited to: credit card bills, credit card cash withdrawals, credit card installments, interest generated by credit cards, and other information such as accounts, overdue, balances, credit limits, due payments, and actual payments under different dimensions (e.g., time dimension, space dimension, and frequency dimension). The above basic data is not limited to the specific categories listed. With the changes in the credit card business, those skilled in the art can further cover new data types in implementation, that is, all types of data that can be obtained during the user's credit card creation and use process can be used as basic data of credit cards.
[0313] In a specific implementation, basic data of personal loans include but are not limited to: personal loan accounts, overdue personal loans, balances of personal loans, total amount of personal loans, repayments due and actual repayments of personal loans, etc. The above basic data are not limited to the specific categories listed. With the changes in personal loan business, those skilled in the art can further cover new data types in implementation, that is, all types of data that can be obtained based on the user's loan application and behavior can be used as basic data of personal loans.
[0314] In a specific implementation, according to the requirements of the Personal Privacy Protection Act, the basic data of the basic information category of customers only includes: basic information of customers, including gender, age and administrative region information of the business. The above basic data is not limited to the specific categories listed. With the development of customer conditions and social relations, technical personnel in this field can also further cover other or emerging data types in the implementation within the scope of the business application scenario, that is, all types of data based on the attributes of the user sample itself but not directly related to the behavior in the financial institution can be used as basic data of the basic information category of customers.
[0315] In a specific implementation, basic data of personal financial assets include but are not limited to: AUM (i.e., asset management scale), deposits, financial management, and payroll information. The above basic data are not limited to the specific categories listed. With the changes in financial assets, those skilled in the art can also further cover new data types in implementation, that is, all other financial assets and financial transaction data that are not related to credit cards and loans in financial institutions based on samples can be used as basic data of personal financial assets.
[0316] In a specific embodiment, the original retail credit prediction data of the samples obtained for building the model are based on more than 120 data types (i.e., basic variables or basic features) obtained from 730 million people, including but not limited to: credit card bills, credit card withdrawals, special installment situations of credit cards, interest generated by credit cards, and other information on accounts, overdue, balances, amounts, repayments due, actual repayments, etc. in different dimensions (e.g., time dimension, space dimension, frequency dimension); personal loan accounts, overdue situations of personal loans, balances of personal loans, total amounts of personal loans, repayments due, actual repayments, etc.; basic customer information including gender, age, and administrative region to which the business belongs; basic information such as AUM (i.e., asset management scale), deposits, wealth management, and payroll payment.
[0317] <Derived Retail Credit Forecast Data>
[0318] In the present application, in the data derivation step, the derived retail credit prediction data processed based on the original retail credit prediction data refers to the data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension, and statistical information dimension.
[0319] In a specific embodiment, the derived retail credit prediction data includes, but is not limited to: derived retail credit prediction data obtained by processing based on the sample relationship length, derived retail credit prediction data obtained by processing based on time interval variables, derived retail credit prediction data obtained by processing based on the frequency of sample behavior, derived retail credit prediction data obtained by processing based on the current time point of the sample, derived retail credit prediction data obtained by processing based on the continuous behavior of the sample, or derived retail credit prediction data obtained by processing sample data based on statistical information dimensions. For example, the monthly data of the customer can be obtained and processed based on the monthly data. In this application, processing based on statistical information dimensions includes obtaining the maximum value, minimum value, average value, etc. of the data to describe the data situation.
[0320] In a specific implementation, for example, starting from the time dimension, such as customer relationship length variables: such as the customer account opening time, customer maximum account age, etc. are used as types of derived retail credit prediction data, that is, as derived features or derived variables.
[0321] In a specific implementation, for example, starting from the time dimension, time intervals are considered, such as the number of months from the customer's most recent repayment to the current time point, the number of months from the customer's most recent overdue payment to the current time point, etc. as derived features or derived variables.
[0322] In a specific implementation, for example, starting from the frequency level, the behavior frequency level variable is considered: such as the number of times the customer has repaid > N in the last X months, the number of times the customer's credit limit utilization rate > N in the last X months, etc. as derived features or derived variables. There is no limit on X and N, and they can be any positive integer greater than 0 as long as the business logic is reasonable.
[0323] In a specific implementation, for example, starting from the time dimension, the current point in time variables are considered: the customer's current monthly credit limit, the customer's current monthly balance, etc. as derived features or derived variables.
[0324] In a specific approach, starting from the time dimension, continuous behavior variables are considered as derived features or derived variables, such as the maximum number of consecutive overdue payments of a customer > N in the last X months, the number of consecutive repayment rates of a customer > N in the last X months, etc.
[0325] In a specific method, starting from the dimension of statistical information, statistical variables are considered, such as the maximum number of overdue payments of a customer in the last X months, the average credit limit utilization rate of a customer in the last X months, etc. as derived features or derived variables.
[0326] It is clear to those skilled in the art that the above methods for processing derived variables are merely enumerated and can be selected arbitrarily. For example, 120 types of basic data can be processed into more than 3,000 derived data. In this application, data, data types, data types, variables or features are sometimes mixed, and those skilled in the art can understand them based on common sense in statistics.
[0327] In this application, the derivative data can be derived data obtained by simple processing of the original retail credit forecast data, or it can be derived data obtained by complex processing. The simply processed derivative data, such as the current variables such as the salary of the current month and the balance of the current month, can be used directly after the data is aggregated. The complex processed derivative data needs to be based on the variables of the current class based on time slicing and logical processing, and can generate derivative variables such as the maximum salary in the past 3 months and the minimum balance in the past 12 months.
[0328] <Preliminary feature screening>
[0329] In the initial screening data conversion step of the present application, the judgment of the conversion method of the features after the initial screening is based on the concentration and data type of the features after the initial screening. The initial screening data conversion step includes the following steps based on the judgment of the concentration and data type: classify each feature into character variables and numerical variables according to the data type of each feature, use the dummy feature conversion method to perform initial screening data conversion on the character variables, and further classify the numerical variables. The process includes the following sub-steps: if the value of the numerical variable is less than n, use the WOE conversion method to perform initial screening data conversion, if the value of the numerical variable is more than n, further judge if the value of the continuous variable is more and the concentration of the single value is greater than m%, then use the WOE conversion method, if the concentration of the single value is less than or equal to m%, then use the continuous conversion method, preferably, n and m are both positive integers, where n = 5 to 10, m = 90 to 99.
[0330] For example, n is 5, 6, 7, 8, 9 or 10, and m is 90, 91, 92, 93, 94, 95, 96, 97, 98 or 99.
[0331] Specifically, in this application, a variety of different feature initial screening methods are used to screen a large number of features, so that the screening can be effectively performed from the largest dimension of features. Existing credit risk scoring often uses missing rate, concentration and information value IV for feature initial screening.
[0332] In a specific method, features are screened based on the data missingness of each feature of the sample used to build the model. When screening the missing rate, it is generally considered to delete variables with a missing rate greater than 90%, 91%, 92%, 93%, 94%, or 95%. For example, features with a data missing rate exceeding 95% can be eliminated, and features with a data missing rate exceeding 90% can also be eliminated.
[0333] In a specific method, features are screened based on the fact that a single value of a feature sample is too high. When screening by concentration, it is generally considered to delete variables whose single values account for more than 99%, 98%, 97%, 96%, or 95%. For example, features whose single values exceed 99% can be eliminated, and features whose single values exceed 95% can also be eliminated.
[0334] In a specific method, the information IV value of each feature is calculated to perform preliminary screening of the features. During IV screening, the IV value can be used to measure the predictive power of the feature. The larger the IV value, the stronger the predictive power of the feature. The calculation method of the IV value of a single feature is as follows:
[0335]
[0336] Where k is the number of groups after this feature is discretized; y i is the number of non-defaulting customers in group i; s is the total number of customers who have not defaulted; n i is the total number of defaulting customers in group i; n s The quantitative index of IV has the following meanings: when the calculated value of IV is less than 0.02, it means that the predictive power of this feature is very weak; when the calculated value of IV is above 0.02 and below 0.1, it means that the predictive power of this feature is weak; when the calculated value of IV is above 0.1 and below 0.3, it means that the predictive power of this feature is good; when the calculated value of IV is above 0.3, it means that the predictive power of this feature is strong.
[0337] Of course, the IV calculated value deletion threshold may also be set to 0.03, 0.04, 0.05, etc.
[0338] In the model building method of the present application, the step of using missing rate, concentration and information value IV for feature initial screening can be performed in any order, for example, the screening can be performed based on the missing rate first, then based on the concentration, and finally based on the information value IV for feature initial screening. It is also possible to first screen based on the concentration, then screen based on the missing rate, and finally based on the information value IV for feature initial screening. It is also possible to first screen based on the missing rate, then screen based on the information value IV, and finally based on the concentration for feature initial screening. It is also possible to first screen based on the information value IV, then screen based on the missing rate, and finally based on the concentration for feature initial screening. It is also possible to first screen based on the information value IV, then screen based on the missing rate, and finally based on the concentration for feature initial screening. It is also possible to first screen based on the information value IV, then screen based on the concentration, and finally based on the missing rate for feature initial screening. It is also possible to first screen based on the concentration, then screen based on the information value IV, and finally based on the missing rate for feature initial screening. Those skilled in the art can make a choice based on the data situation of the sample, so based on these three methods, features with obvious defects in one aspect can be effectively removed, which can effectively reduce the data dimension and improve the effect of model building.
[0339] In a specific method, after the features have been screened using missing rate, concentration and information value IV respectively, a stepwise discriminant algorithm is used to perform preliminary screening of the features, and then preliminary screening of the features is performed based on the consistency between the risk characteristics of each feature itself and the actual real results of the samples used to build the model.
[0340] On this basis, the technical solution of the present application introduces a stepwise discriminant method to make the initial screening of variables more efficient and accurate in order to improve the overall efficiency of model development. In actual data, there may be a close distribution of good and bad samples on a certain variable, and the ability to distinguish between good and bad is weak. There may also be a class of variables, each of which can distinguish good and bad samples well, but if all are included in the model, they will be redundant due to the duplication of data dimensions covered by the variables. In this regard, a stepwise discriminant analysis method is used in this application, and WILKS'S LAMBDA value is used as the statistical criterion for entry and removal, and variables with weak or redundant discriminant effects in the data are deleted.
[0341] The stepwise discrimination method uses the WILKS'S LAMBDA criterion to measure the strength of feature capabilities and eliminates features that do not meet the set threshold among the remaining features after three rounds of screening. In the stepwise discrimination process, the variable with the strongest discriminant ability is added first. As the variables in the model gradually increase, the discriminant ability of the variables introduced earlier may also change. If the discriminant ability of a variable in the model is less than the threshold, the variable is removed, and then the process is repeated until the variables contained in the model meet the WILKS'S LAMBDA similarity ratio criterion and other variables do not meet the criteria for entering the model.
[0342] In this application, the step of screening using the stepwise discriminant method is a more critical step. For the purpose of capturing as many credit risk points as possible, the model involved in this application uses a huge amount of data and many data dimensions, so variable screening must be performed to further reduce the time cost of model development. In the existing financial risk model evaluation, the variable importance method is generally used to reduce variables, such as calculating the importance of variables through algorithms such as the Gini index and information entropy, and selecting variables with high importance. The modeling method of screening using the stepwise discriminant method is rarely used. Compared with the variable importance screening scheme commonly used in the industry, the methodology used in this application can retain a large number of variables with relatively weak importance but relatively independent information dimensions.
[0343] In a specific way, more than 3,000 derivative data can be processed based on, for example, 120 types of basic data. After three rounds of screening of missing rate, concentration and information value IV, about 20-30% of the features with poor data can be deleted, but more than 2,000 features will still be retained. If subsequent variable fine screening is performed based on all the above features, it will seriously affect the development efficiency. Therefore, after comparing and testing a variety of different variable deletion schemes, it was finally determined that stepwise discrimination was the best choice.
[0344] For the important features selected by the stepwise discrimination algorithm, further feature selection is performed based on the risk characteristics of each risk point itself (system preset) and the actual bad debt rate of the sample. Determine whether the actual bad debt rate distribution of the remaining features is consistent with the business trend, and eliminate the features whose actual bad debt rate distribution does not conform to the business trend. Specifically, (1) Divide the remaining target features into 10-20 boxes according to the quantile points, and calculate the median value of each box and the corresponding bad debt rate. (2) Use the median value of each box and the previous box and the corresponding bad debt rate to calculate the rate of change (slope). (3) Count the number of boxes greater than 0 and non-0 boxes (non-greater than 0 boxes) in the rate of change between two adjacent boxes, and calculate the percentage of the number of boxes greater than 0 in the rate of change to the number of non-0 boxes in the rate of change. (4) Obtain the risk characteristics preset for this feature, and based on the percentage of the number of boxes greater than 0 in the rate of change to the number of non-0 boxes in the rate of change, check whether the actual bad debt rate change trend is approximately consistent with the business logic bad debt rate change trend. The criteria for whether they are approximately consistent are as follows: First, if the business logic trend of this feature should be: as the value of this feature increases, the bad debt rate increases (such as the credit line utilization rate, etc.). In this module, the features whose number of boxes greater than 0 in the above calculated slope accounts for less than 70% of the number of boxes with a slope other than 0 are eliminated, that is, the features whose feature performance does not conform to the business trend are eliminated. Second, if the business logic trend of this feature should be: as the value of this feature increases, the bad debt rate decreases (such as the deposit amount, etc.). In this module, the features whose number of boxes greater than 0 in the above calculated slope accounts for more than 30% of the number of boxes with a slope other than 0 are eliminated, that is, the features whose feature performance does not conform to the business trend are eliminated.
[0345] For example, the following table gives an example of binning. In this example, the feature values are divided into 10 bins. The value ranges of the bins are also summarized in the following table. At the same time, based on the data in the following table, a graph of the bad debt rate of the feature bins versus the median of the feature bins is drawn, as shown in the following figure: Figure 3 As shown. Figure 3 In the example, there are 7 with slopes greater than 0 and 2 with slopes less than 0. Through the above method, the features can be further screened based on the risk characteristics of each risk point itself (system preset) and the actual bad debt rate of the sample. By further screening features using such a binning method, the features that best match the business development trend can be effectively screened out, thereby further obtaining features suitable for modeling.
[0346]
[0347] <Conversion of eigenvalues>
[0348] The initial feature processing of existing credit risk scoring methods mainly uses WOE conversion (multi-classification) and dummy feature conversion (binary classification) to discretize continuous features (such as age, account age, etc.). The WOE conversion method is an optimal binning scheme based on modeling samples. It discretizes continuous features according to the optimal cutting point and embeds the data of good and bad samples into the WOE value. Therefore, it performs better in model construction, but the binning results may overfit the modeling samples, resulting in a serious decline in model effect when applied to the whole (poor generalization ability). At the same time, due to the normalization operation used in binning, the original features falling into different bins are converted into a single value corresponding to each bin, thus losing the ability to distinguish the risks of people falling into the same interval. The dummy feature conversion method is mainly applied to grouping features. Its advantage is that it can eliminate the difference between good and bad values of different feature values, but it will become extremely complex and redundant when processing continuous variables.
[0349] In the model building method of the present application, the conversion method of the features after preliminary screening is judged to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and the optimal method is used to perform feature conversion for each feature after preliminary screening.
[0350] The initial screening data conversion step includes the following steps based on the judgment of concentration and data type: classifying each feature into character variables and numeric variables according to the data type of each feature, using dummy feature conversion method to perform initial screening data conversion on character variables, and further classifying the numeric variables includes the following sub-steps: if the value of the numeric variable is less than n, the WOE conversion method is used for initial screening data conversion; if the value of the numeric variable is more than n, further judging that if the value converted to a continuous variable is large and the concentration of a single value is greater than m%, the WOE conversion method is used; if the concentration of a single value is less than or equal to m%, a continuous conversion method is used; preferably, n and m are both positive integers, wherein n=5-10, m=90-99.
[0351] Specifically, taking the character variable as education level, the value of this feature variable can be primary school, middle school, university, graduate school, etc. For numeric variables, if the numeric variable is the number of overdue months in the past three months, the value is 0, 1, 2, 3.
[0352] In the present application, the above n can be 5, 6, 7, 8, 9 or 10, and m can be 90, 91, 92, 93, 94, 95, 96, 97, 98 or 99.
[0353] In a specific implementation, m is selected as 5 and n is selected as 95.
[0354] Specifically, the WOE conversion method is: find the optimal cutting point of the feature, divide the value range of the original feature into multiple bins, calculate the WOE conversion value corresponding to each bin after segmentation according to the good or bad situation in each bin and output it, divide the original feature according to the binning result and output the WOE conversion value. For each bin, the WOE value is calculated as follows:
[0355]
[0356] where y i is the number of non-defaulting customers in group i; s is the total number of customers who have not defaulted; n i is the total number of defaulting customers in group i; n s is the total number of defaulting customers.
[0357] Let's take age as an example to introduce the WOE binning process. The original feature age includes values from 18 to 50 years old. After binning, 5 bins are obtained, namely 18 to 24 years old, 25 to 30 years old, 31 to 35 years old, 36 to 42 years old, and 43 to 50 years old. Then, the WOE conversion value of each bin is calculated according to the number of good and bad customers in each bin. Finally, each user data in each bin is output according to the corresponding conversion value of each bin. For example, 23 years old outputs the WOE conversion value corresponding to the 18 to 24 bins, and 46 years old outputs the WOE conversion value corresponding to the 43 to 50 bins.
[0358] The conversion method of dummy features is: convert a single classification feature into an equal number of dummy features according to the number of values it contains. If a customer belongs to the corresponding value of the generated dummy feature, the corresponding dummy feature value is 1, and the remaining dummy feature values are 0.
[0359] Taking gender as an example, we will introduce the method of dummy feature conversion. The original features include: male, female. After dummy feature conversion, two dummy features, 'gender-male' and 'gender-female', are generated. If the customer's gender is male, 'gender-male' is recorded as 1, and 'gender-female' is recorded as 0. If we take education as an example, the original features include: junior college and below, undergraduate, master and above. After dummy feature conversion, three dummy features, 'education-junior college and below', 'education-bachelor', and 'education-master and above', are generated. If the customer's education is undergraduate, 'education-junior college and below' is recorded as 0, 'education-bachelor' is recorded as 1, and 'education-master and above' is recorded as 0.
[0360] The continuous conversion method is: perform a variety of continuous conversions on the original features (continuous conversion methods include but are not limited to: directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, and calculating the natural logarithm of the original data). Calculate the correlation coefficient r (Correlation Coefficient) between the feature value and the overdue label after continuous conversion, select the conversion method with the largest absolute value of the correlation coefficient, and output the conversion method corresponding to the original feature. The calculation formula of the correlation coefficient is as follows:
[0361]
[0362] Where Σ is the summation symbol in mathematics; n is the total number of observations; x i is the conversion value of the original feature of the i-th observation after continuous conversion; This is the average of the transformed values; where y i is a binary feature indicating whether the i-th observation is in default; It is the average value of this binary feature. The closer the absolute value of the correlation coefficient is to 1, the more relevant the converted value is to the default situation, and the better the effect of this conversion method. The quantitative index of the correlation coefficient r has the following meanings: when the absolute value of the correlation coefficient is above 0 and less than 0.3, it indicates a low correlation; when the absolute value of the correlation coefficient is above 0.3 and less than 0.8, it indicates a moderate correlation; when the absolute value of the correlation coefficient is above 0.8 and less than 1, it indicates a high correlation.
[0363] In the model construction of the present application, for the features that are confirmed to adopt a continuous conversion method, the optimal conversion method is selected to perform continuous feature conversion of the feature based on the correlation of the feature with credit default under different continuous conversion methods. Preferably, the continuous feature conversion is performed by directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data.
[0364] Take age as an example to introduce the continuous conversion method. The original feature age contains values from 18 to 50 years old. The continuous conversion obtains the original value, square, square root, cube root, natural logarithm, etc. of age, and then calculates the WOE value and the absolute value of the correlation coefficient between each conversion value and the good or bad label (prediction result). The conversion method with the largest absolute value of the correlation coefficient is selected for conversion and output. If the cube root of the age feature has the largest absolute value of the correlation coefficient with the good or bad label compared with other conversion methods, the cube root of age is output as the conversion value.
[0365] In the prior art solutions, one of the feature conversion methods, WOE and dummy features, is mainly selected for model construction. For example, in the Chinese patent CN112686749B, the WOE method is used to convert the feature values. The WOE conversion method is an optimal binning scheme based on the modeling sample. It discretizes the continuous features according to the optimal cutting point, so it performs better in model construction, but the binning results may overfit the modeling samples, resulting in a serious decrease in the model effect when applied to the whole (poor generalization ability). At the same time, due to the normalization operation used in the binning, the original features falling into different bins are converted into a single value corresponding to each bin, so the risk differentiation ability of people falling into the same interval is lost.
[0366] The conversion method of dummy features is mainly used for grouping features. Its advantage is that it can eliminate the difference between good and bad values of different feature values. For example, for the industry in which the customer is located, because there is no obvious advantage or disadvantage between the retail industry and the wholesale industry, it is more suitable to use the dummy feature processing method; there is a hierarchical difference between junior colleges and undergraduates, so although dummy features can be used, it is actually more appropriate to use the WOE processing method.
[0367] On the other hand, the continuous conversion method can avoid the overfitting of the modeling samples in the WOE conversion method, has a strong generalization ability for the overall sample, and because no interval mapping is performed, most customer groups rarely fall into a single value. However, it cannot be applied to some features with poor monotonicity or discrete characteristics (such as occupation, position, etc.).
[0368] As described above, the technical solution of the present application takes a different approach and creatively combines three methods: continuous conversion, WOE conversion, and dumb feature conversion. It reprocesses some carefully screened features, combines the advantages and disadvantages of the three conversion methods, and creatively designs a conversion judgment method. It selects the optimal feature conversion method based on parameters such as feature data attributes, missing rate, concentration, and business logic judgment.
[0369] <Logistic regression and deep feature screening based on logistic regression>
[0370] In existing credit risk scoring, due to the requirement of model interpretability, logistic regression model is mainly used for model development, and the software that can be used are generally: SAS, R, Python, etc.
[0371] In a specific embodiment, the present application develops models based on SAS software.
[0372] Specifically, the Sigmoid function is used in logistic regression to fit the probability of predicted default. The Sigmoid function is:
[0373]
[0374] Where Z is a linear combination of the model coefficients and the feature transformation values, and Z is defined as follows:
[0375] Z=α+β1x1+β2x2+…+β k-1 x k-1 +β k x k
[0376] The predicted probability of default is:
[0377] P=P(Y=1|x1,x2,x3,...,x k-1 , x k )
[0378] The fitted prediction for the probability of default is:
[0379]
[0380] From the above formula we can further deduce:
[0381] Substituting the Z value into the above formula can calculate the probability P of predicted default.
[0382] The core of logistic regression model construction is feature screening. The steps of feature screening are as follows: First, batch screen the features according to missing rate, concentration and information value IV. Second, screen all remaining features one by one according to whether the features are in line with business trends, and retain the features with correct business trends. For example: if it is found that the bad debt rate of the customer group decreases with the increase of the characteristic loan balance, it is considered that this feature does not conform to the business trend. In the understanding of credit business, the higher the loan balance, the higher the customer's default risk exposure (EAD) level, and the greater the risk. At this time, this feature will be removed from the feature list. Third, use the stepwise regression function of logistic regression to eliminate the less important features that are highly correlated with other features. Fourth, filter the coefficients according to the positive and negative signs of the training coefficients and the business trend of the feature conversion value, and retain the features whose feature coefficient signs conform to the business logic. In the case where 0 is defined as a good customer and 1 is defined as a bad customer in the Y label, for a feature whose bad debt rate increases monotonically with the increase of the feature value (such as loan balance), the sign of its training coefficient should be positive; conversely, for a feature whose bad debt rate decreases monotonically with the increase of the feature value (such as deposit balance), the sign of its training coefficient should be negative. If it does not meet the above standards, it should be eliminated. Fifth, use variance inflation factor (VIF), correlation coefficient, etc. to further eliminate features with high correlation: for variance inflation factor, eliminate features with the highest VIF and greater than 4 one by one; for features with high correlation, eliminate features with low IV values in the feature group with the highest correlation coefficient and greater than 0.80 one by one. Sixth, use the population stability index (PSI) to eliminate features with large distribution differences at different time points, which lead to instability. For features with PSI>0.25, directly eliminate them, and for features with 0.25>PSI>0.1, prudently eliminate them according to the impact of eliminating this feature on the model's distinguishing ability.
[0383] This application strictly adheres to the above rules to screen features, ensuring the model's interpretability, stability, and ability to distinguish between good and bad customers.
[0384] The feature fine-screening steps of the present application include: a first fine-screening step, based on a stepwise regression algorithm, to screen features based on the F test and the T test for the significance of features; a second fine-screening step, to screen features based on calculating the variance inflation factor for each feature and eliminating features with higher variance inflation factors; a third fine-screening step, based on logistic regression, to analyze whether the feature coefficients of the features after the first fine-screening step and the second fine-screening step are in line with the trend of the prediction results for credit default so as to further perform feature screening.
[0385] Feature fine screening step 1, based on the stepwise regression algorithm, based on the F test and T test method, introduces features in order from high to low significance. Each time a feature is introduced, the selected features are tested one by one. When the originally introduced feature becomes no longer significant due to the introduction of the subsequent features, it is eliminated. This process is repeated until no features above the significance threshold are selected into the equation, and no features below the significance threshold are eliminated from the regression equation.
[0386] Feature fine-screening step 2 is based on the method of eliminating features with high variance inflation factors to further reduce multicollinearity in the model.
[0387] Feature fine screening step 3, based on the risk characteristics of each risk point itself (system preset) and the positive and negative signs of the model training coefficient, determines whether the feature coefficients of the remaining features in the model in the feature fine screening step 3 are consistent with the business trend, removes the features whose model coefficients do not meet the business trend, and iterates again. The specific implementation plan of feature fine screening module 3 is as follows: 1. For features whose feature conversion method is WOE type, the corresponding model training coefficient should be a negative value, and the WOE conversion type features with positive training coefficients should be eliminated. 2. For continuous conversion methods, if the value of this feature increases in business logic, the bad debt rate should increase (such as the credit line utilization rate, etc.), then the corresponding model training coefficient should be a positive value, and such continuous conversion type features with negative training coefficients should be eliminated; if the value of this feature increases in business logic, the bad debt rate should decrease (such as the deposit amount, etc.), then the corresponding model training coefficient should be a negative value, and such continuous conversion type features with positive training coefficients should be eliminated. 3. For the dummy feature conversion method, it is necessary to determine the bad debt rate when the value is 1 and the value is 0. If the bad debt rate when the value is 1 is greater than the bad debt rate when the value is 0, the coefficient should be positive, otherwise it should be negative.
[0388] Feature fine screening step 4, data stability monitoring step, is used to evaluate whether the distribution of individual features and overall scores at different time points has obvious deviations. In this embodiment, features with PSI>0.25 are directly eliminated, and features with 0.25>PSI>0.1 are carefully eliminated based on the impact of eliminating this feature on the model's distinguishing ability.
[0389] Based on the above steps 3 and 4, the feature list is iterated multiple times until no new features are added or removed from the model, and the iteration is stopped to obtain the final feature list and its conversion value. After the above steps, the input variables for constructing the model of this application can be finally obtained.
[0390] The credit default probability modeling step of the present application substitutes the features screened in the feature fine screening step into the Sigmoid function to perform logistic regression to calculate the credit default probability model.
[0391] In the prior art, the core of all scoring models built is whether the data they use is representative. For the existing scoring models in the prior art, due to information security and cost reasons, the sample size and bad labels of most models are small, and the stability of the model cannot be guaranteed, let alone independent modeling of a certain type of customer. At the same time, because the scoring models on the market can obtain information dimensions in the modeling process, mostly multi-loan data and weak financial attribute data (such as smart terminal device data, social platform data, online shopping mall data and other non-credit transaction data), it is impossible to accurately reflect the customer's asset status and repayment ability. The data source used in this application is the full business data of large banks, and the data volume of modeling samples and bad labels is very large. This application designs modeling samples based on different sample groups, which can more finely distinguish the risk differences between such customers, and at the same time ensure the stability of data and models based on cross-time verification and PSI verification. This application uses personal credit history data and asset data for model development, so it has a good reflection of the borrower's repayment willingness and repayment ability.
[0392] For some small and medium-sized financial institutions, the internally built scoring models are relatively small or started late in their retail credit business, and the accumulated historical data is insufficient to develop a credit risk model with stable data and strong differentiation ability. Therefore, they are highly dependent on manual approval when used for credit review business. The efficiency limitations of manual approval have restricted the development of their retail credit business. At the same time, the subjectivity of manual approval has increased the operational risks in the credit review process. The model constructed in this application can assist such financial institutions in making digital decisions, enhance their approval accuracy and speed, and reduce the above-mentioned adverse effects.
[0393] In terms of feature conversion, compared with the traditional WOE conversion method, it is necessary to roughly bin and discretize continuous features according to data performance and the experience of modelers. The results of rough binning are greatly affected by the subjective factors of modelers; and the process of discretizing continuous features may result in too many customers falling into the same interval, which leads to more single values of the calculated scores. This application combines the continuous conversion method, the WOE conversion method and the dummy feature conversion method to encode the original features, which reduces the impact of human factors and single values while enhancing the ability to distinguish scores.
[0394] <Methodology for calculating retail credit risk>
[0395] The present application further relates to a method for calculating the retail credit risk of a sample to be tested using the retail credit risk model constructed in the present application.
[0396] In this application, retail credit risk refers to the probability of credit default in the sample to be tested. In a specific manner, the probability of credit default refers to the probability of credit default, specifically, for example, whether a credit default of more than 60 days will occur.
[0397] The present application relates to a method for calculating retail credit risk, which comprises: a data collection step, which obtains retail credit prediction data of samples to be predicted; a step of classifying the samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default; a step of calculating the probability of credit default, which substitutes the retail credit prediction data into the credit default probability sub-model to calculate the probability of credit default of the samples to be predicted.
[0398] In the present application, the sample to be predicted may be a sample used to build a model, that is, when the model is built, the sample is already a customer of a certain financial institution holding a credit business (including but not limited to a credit card or personal loan business), and the method for calculating retail credit risk of the present application can be used to calculate its potential retail credit risk in the future. In the present application, the sample to be predicted may be a sample that is not used to build a model, that is, when the model is built, it is not a customer of a certain financial institution holding a credit business, but now it is a customer of a certain financial institution holding a credit business, and the method for calculating retail credit risk of the present application can be used to calculate its potential retail credit risk in the future. In the present application, the sample may also be a customer who was not and is not a customer of the financial institution holding a credit business when the model was built in the past, but is a customer of the financial institution that already holds other financial asset businesses, and the method for calculating retail credit risk of the present application can be used to calculate its potential retail credit risk in the future.
[0399] The present application relates to a method for calculating retail credit risk, which comprises: a data collection step, which obtains retail credit prediction data of samples to be predicted; a step of classifying the samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the credit default probability; a credit default probability calculation step, which substitutes the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the samples to be predicted; and after calculating the credit default probability, a step of calculating the credit score of the samples to be predicted.
[0400] The step of calculating the credit score of the sample to be predicted is used to calibrate the calculated credit default probability to a standardized score of 0-1000 points.
[0401] In the method of the present application, the retail credit prediction data includes the original retail credit prediction data of the sample to be predicted and the derivative retail credit prediction data processed based on the original retail credit prediction data. The descriptions of the original retail credit prediction data and the derivative retail credit prediction data are consistent with those in the model construction section.
[0402] In the present application, the steps of classifying the sample to be predicted include the following sub-steps: whether the sample to be tested is a customer who has applied for a credit service at a financial institution; whether the sample to be tested has an account age greater than or equal to G1; whether the credit of the sample to be tested is overdue; whether the current repayment rate of the sample to be tested is less than a%; classifying the sample to be predicted based on the above sub-steps to determine the sub-model for calculating the credit default probability, and the order of the above sub-steps can be set arbitrarily.
[0403] In the present application, Figure 2 shows a flowchart for classifying the sample to be predicted. Based on the classification of this step, the sub-model for calculating the credit default probability can be selected. As Figure 2 shown, the sample to be predicted is classified in the following order: first, it is judged whether the sample to be tested is a customer who has applied for a registered credit service at a financial institution; then, it is judged whether the sample to be tested has an account age greater than or equal to G1 (G1 can be, for example, 1, 2, 3, 4, 5, 6, 7, 8, 9, preferably 3); then, it is judged whether the sample to be tested has a credit loan overdue; then, it is judged whether the current repayment rate of the sample to be tested is < a% (for example, a can be 50, 60, 70, 80, 90, 95, 96, 97, 98, 99, 100, preferably 90). Using such a step classification can confirm the most suitable sub-model for predicting the sample to be tested.
[0404] In the present application, after the retail credit prediction data is subjected to feature transformation, it is substituted into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted. The feature transformation step includes selecting the WOE method or the continuous type method for feature transformation based on the feature type of the retail credit prediction data to be substituted into the credit default probability sub-model.
[0405] The methods for feature transformation for the WOE method or the continuous type method are well-known to those skilled in the art. The specific transformation methods can refer to the description in the model construction section of the present application. However, the existing models in the art only use the WOE method for parameter transformation.
[0406] The WOE conversion method is an optimal binning scheme based on the modeling sample. It discretizes the continuous features according to the optimal cutting point. Therefore, it performs better in model construction, but the binning results may overfit the modeling sample, resulting in a serious decline in the model effect when applied to the overall population (poor generalization ability). At the same time, due to the normalization operation used in binning, the original features falling into different bins are converted into a single value corresponding to each bin, thus losing the ability to distinguish the risks of people falling into the same interval. The conversion method of dummy features is mainly applied to grouping features. Its advantage is that it can eliminate the difference between good and bad values of features. For example: for the industry in which the customer is located, because there is no obvious advantage or disadvantage between the retail industry and the wholesale industry, it is more suitable for the dummy feature processing method; there is a hierarchical difference between junior colleges and undergraduates, so although dummy features can be used, it is actually more appropriate to use the WOE processing method. The continuous conversion method can avoid the overfitting of the modeling sample in the WOE conversion method, and has a strong generalization ability for the overall sample. Since no interval mapping is performed, most customer groups rarely fall into a single value. However, it cannot be applied to some features with poor monotonicity or discreteness (such as occupations, positions, etc.). The present application uses a combination of continuous conversion and WOE conversion to process the initial features, combines the advantages and disadvantages of the two conversion methods, designs a conversion judgment module, and selects the optimal feature conversion method based on the parameters such as feature data attributes, missing rate, and concentration, supplemented by business logic judgment. The technical solution of the present application takes a different approach, creatively combining the three methods of continuous conversion, WOE conversion, and dummy feature conversion, reprocesses some carefully screened features, combines the advantages and disadvantages of the three conversion methods, and creatively designs a conversion judgment method, and selects the optimal feature conversion method based on the parameters such as feature data attributes, missing rate, and concentration, supplemented by business logic judgment. The feature conversion method determined in this way is then substituted into the model for calculating retail credit risk, which can more accurately predict the retail credit risk of the sample.
[0407] The sub-model used in the present application to calculate the probability of credit default is a model constructed based on sample retail credit prediction data and the probability of credit default using logistic regression based on an existing user population, that is, a model constructed using the method described in the present application.
[0408] <Device, system and computer storage medium for calculating retail credit risk>
[0409] The present application relates to a device for calculating retail credit risk, which includes: a data acquisition module, which is used to obtain retail credit prediction data of samples to be predicted; a module for classifying samples to be predicted, which is used to classify samples to be predicted based on a decision tree method to determine a sub-model for calculating credit default probability; a credit default probability calculation module, which is used to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the samples to be predicted.
[0410] The device for calculating retail credit risk of the present application can execute the steps of the method for calculating retail credit risk of the present application.
[0411] The present application also relates to a system for calculating retail credit risk, characterized in that the system for calculating retail credit risk comprises: a memory, a processor, and a program for calculating retail credit risk stored in the memory and executable on the processor, wherein the program for calculating retail credit risk implements the steps of the method for calculating retail credit risk as described in the present application when executed by the processor.
[0412] The present application relates to a computer storage medium, characterized in that a program for a method for calculating retail credit risk is stored on the computer storage medium, and when the program for the method for calculating retail credit risk is executed by a processor, the steps of the method for calculating retail credit risk as described in the present application are implemented.
[0413] All the contents described above for the method for calculating retail credit risk can be fully applied to the device, system and computer storage medium for calculating retail credit risk.
[0414] The method for calculating retail credit risk in the present application can avoid the technical shortcomings of overfitting when building a model with complete WOE variables and the inability to adapt well to categorical variables when building a model with complete continuous variables. Therefore, when the model is used for retail credit risk calculation, it can better cover the retail credit risk prediction needs of various types of customer groups and meet the demand for obtaining more accurate prediction results when predicting credit risk as a general score.
[0415] Example
[0416] Example 1 Collection of modeling samples
[0417] In the process of constructing this embodiment, credit card application and behavior data, personal loan application and behavior data, personal financial asset transaction data, and personal customer information data of all retail customers of China Construction Bank between 2017 and 2021 were collected, totaling 730 million people. The modeling sample was confirmed through a professional model design scheme, and 620 million data in 2018 and 650 million data in 2019 were selected as analysis samples. Since performance variables are required for modeling and the performance period of credit cards and special installment businesses is relatively short, 2019 was selected as the observation period, and the 650 million analysis samples were divided into two parts: registered credit business and unregistered credit business, with sample sizes of 130 million and 520 million people respectively.
[0418] The specific Alpha2 model is a scenario scoring for credit cards and special installment services. When designing the model, 110 million customers who have applied for credit cards and special installment services are analyzed and designed among the 130 million customers who have applied. After the model is developed and put online, the results will be applied to the total number of 730 million people who have applied and those who have not applied, or all other potential customer groups.
[0419] The model design includes 1) exclusion rules: such as excluding customer data that has been settled, closed, has no performance, or has special circumstances. After exclusion, the modeling population is 58.59 million customers; 2) time window setting: determine the sample to use 2019 data as the modeling sample, and use the next 15 months as the performance period of Y; 3) sample sampling: use a good / bad sample number of 10:1 for sampling modeling. Different segmentation schemes are designed through the decision tree method, and the parent-child model comparison method is used to confirm the final model segmentation plan, and then each segmentation model is modeled separately. The model segmentation scheme of this application is designed by dividing the customer into whether the customer has applied, whether the customer is a new customer, whether there is an overdue payment, and the customer's repayment rate level. It fully reflects the control variables that are closely related to risk characteristics in the business process, and can more comprehensively match various customer groups in the market.
[0420] In this embodiment, the modeling samples are first divided into the following sub-samples based on the decision tree for the subsequent construction of sub-models. When determining the modeling samples, the first level of the decision tree makes a judgment based on whether the customer's account age is less than 3 (the customer has applied for a registered credit business but the application has not exceeded 3 months). If the account age is less than 3, the customer is classified as a new customer and is classified into the Alpha2 seg1 model. If the account age is greater than or equal to 3, it is further subdivided. In this embodiment, customers with an account age greater than or equal to 3 will be divided according to whether the customer's current credit business is overdue. The customer group with overdue current credit business will be classified into the Alpha2 seg2 model, and the customer group with no overdue current credit business will be further subdivided.
[0421] For existing customers whose account age is greater than or equal to 3 and whose current credit business has not been overdue, they will be divided according to the repayment rate of their credit cards in the current month. If the repayment rate of the credit card in the current month is <90%, this customer group will be classified as Alpha2seg3, otherwise this customer group will be classified as Alpha2 seg4.
[0422] In addition, in this embodiment, in order to build a model for the sample group that has not applied for credit business registration, new customers with an account age of less than 3 months are selected from the overall sample as the approximate customer group and enter the Alpha2 seg5 segment for model training.
[0423] Specifically, the sample size of the sub-customer group used to build the Alpha2 seg1 segmentation model is about 430,000. The customer group is mainly new customers who have applied for credit business but the application period has not exceeded 3 months. The model is used to predict the probability of credit arrears of more than 60 days in this group of people.
[0424] Specifically, the sample size of the sub-customer group used to build the Alpha2 seg2 segmentation model is about 400,000. Its customer base mainly consists of existing customers who have applied for registered credit business for more than 3 months and whose current credit business is overdue. The model is used to predict the probability of their credit being overdue for more than 60 days.
[0425] Specifically, the sample size of the sub-customer group used to build the Alpha2 seg3 segmentation model is about 4.47 million. The customer group mainly consists of existing customers who have applied for registered credit business for more than 3 months, have no overdue credit business, and have a current monthly credit card repayment rate of less than 90%. The model is used to predict the probability of credit overdue for more than 60 days in this group of people.
[0426] Specifically, the sample size of the sub-customer group used to build the Alpha2 seg4 segmentation model is about 53.29 million. Its customer base mainly consists of existing customers who have applied for registered credit business for more than 3 months, have no overdue credit business, and have a current monthly credit card repayment rate of more than 90%. The model is used to predict the probability of credit overdue for more than 60 days in this group of people.
[0427] Specifically, the sample size of the sub-customer group used to build the Alpha2 seg5 segmentation model is about 430,000. The customer group is mainly new customers with an account age of less than 3 months who have applied for credit business. The model is used to predict the probability of credit overdue for more than 60 days in the future for the sample group that has not applied for registered credit business.
[0428] Based on the different customer samples of each sub-model confirmed above, historical data information of borrowers is obtained: 1) Credit card category, basic fields include account, overdue, balance, quota, repayment, actual repayment and other information under different dimensions such as bills, cash withdrawals, installments, interest, etc.; 2) Personal loan category, including account, overdue, balance, quota, repayment, actual repayment and other information; 3) Customer basic information, including gender, age and administrative region information of the business; 4) Personal financial assets, including AUM, deposits, wealth management and payroll information.
[0429] According to various risk points in the credit business, macro credit risk is split according to information dimensions, time slices, etc. Variables are derived through professional characteristic variable construction methods. The basic methods are: 1) Customer relationship length variables: such as customer account opening time, customer maximum account age, etc. 2) Time interval variables: such as the number of months from the customer's last repayment to the observation point, the number of months from the customer's last overdue payment, etc.; 3) Behavior frequency degree variables: such as the number of times the customer's repayments are > N in the last X months, the number of times the customer's credit utilization rate is > N in the last X months, etc.; 4) Current time point variables: customer's current monthly credit limit, customer's current monthly balance, etc.; 5) Statistical value variables: such as the customer's maximum number of overdue periods in the last X months, the customer's average credit utilization rate in the last X months; 6) Continuous behavior variables: such as the maximum number of consecutive overdue periods > N in the last X months, the number of consecutive repayment rates > N in the last X months, and other characteristic variables. Finally, 3067 features with potential predictive power for customer overdue payment were derived, such as 'current repayment amount', 'average number of overdue periods in the past 6 months', and 'number of credit card installments in the past 12 months'. In this article, observation point refers to the time point when samples are collected until modeling, and current also refers to the sampling cutoff time. Observation point and current have the same meaning.
[0430] Table 1 Summary of basic variables and derived variables used in the examples
[0431]
[0432] Example 2 Feature Screening
[0433] A preliminary screening was performed on the 3067 features (variables) collected in Example 1 that have potential predictive power for customer overdue payments.
[0434] The preliminary screening of the features of the four sub-models Alpha2 seg1 to Alpha2 seg4 divided in Example 1 is performed according to the following method:
[0435] In the first round of preliminary screening, the features with a missing rate of more than 95% in the data collected in Example 1 were first eliminated, and a total of 206 variables were deleted, leaving 2861 variables.
[0436] In the second round of preliminary screening, for the 2861 features that passed the first round of preliminary screening, the features with single values exceeding 99% among the remaining features were eliminated, and a total of 350 variables were eliminated, leaving 2511 variables.
[0437] In the third round of preliminary screening, the 2511 features after the second round of preliminary screening are sorted according to the feature values (the sorting method is specifically that if the feature is a character variable, each value is a separate box, if the feature is a numeric variable, it is sorted from small to large according to the value size), and then divided into 10-20 boxes according to the quantile point, and the feature IV value is calculated. If the feature IV value is lower than 0.02, it is eliminated. In this embodiment, since the variable attributes are strong financial and asset variables, the prediction effect is strong. Here, variables with IV values lower than 0.05 are eliminated. A total of 1209 features are eliminated, and 1302 feature variables remain.
[0438] In the fourth round of preliminary screening, for the 1302 features after the third round of screening, the features are further screened based on the stepwise discrimination algorithm. After this round of screening, 268 important feature variables can be quickly screened out. The following is an introduction to the stepwise discrimination method. In actual data, there may be little difference in the mean values of different categories on a certain variable. In this case, the effect of using this variable for classification will not be very good; there is also a type of variable that can indeed distinguish different categories in the data well when considered independently, but after including these variables in the model variables, they may appear redundant. Therefore, the embodiment pioneered the use of the stepwise discrimination method to better select more important feature variables under the same dimension, greatly reducing the workload of judging and screening one by one according to the trend of the variables in the fifth round of screening, and fully improving the efficiency of model development without affecting the overall model effect.
[0439] The stepwise discrimination method uses the WILKS'S LAMBDA criterion to measure the strength of feature capabilities and eliminates features that do not meet the set threshold among the remaining features after three rounds of screening. In the stepwise discrimination process, the variable with the strongest discriminant ability is added first. As the variables in the model gradually increase, the discriminant ability of the variables introduced earlier may also change. If the discriminant ability of a variable in the model is less than the threshold, the variable is removed, and then the process is repeated until the variables contained in the model meet the WILKS'S LAMBDA similarity ratio criterion and other variables do not meet the criteria for entering the model.
[0440] The fifth round of preliminary screening is to further screen the 268 important features after the fourth round of screening based on the risk characteristics of each risk point itself (system preset) and the actual bad debt rate of the sample.
[0441] Determine whether the actual bad debt rate distribution of the remaining features is consistent with the business trend, and remove the features whose actual bad debt rate distribution of the samples does not conform to the business trend. Specifically,
[0442] (1) Divide the remaining target features into 10-20 boxes according to the quantiles, and calculate the median of each box and the corresponding bad debt rate.
[0443] (2) Calculate the rate of change (slope) using the median of the values of each box compared to the previous box and the corresponding bad debt rate.
[0444] (3) Count the number of boxes with a change rate greater than 0 and the number of boxes with a change rate greater than 0 between two adjacent boxes, and calculate the percentage of boxes with a change rate greater than 0 to the number of boxes with a change rate greater than 0.
[0445] (4) Obtain the risk characteristics preset for this feature, and based on the percentage of the number of boxes greater than 0 in the above-calculated change rate to the number of non-zero boxes in the change rate, determine whether the actual bad debt rate change trend is approximately consistent with the business logic bad debt rate change trend.
[0446] The criteria for approximate consistency are as follows:
[0447] First, if the business logic trend of this feature is: as the value of this feature increases, the bad debt rate increases (such as the credit line utilization rate, etc.), in this module, the features whose number of boxes with slope greater than 0 in the above calculation accounts for less than 70% of the number of boxes with slope non-0 are eliminated, that is, the features that do not conform to the business trend are eliminated.
[0448] Second, if the business logic trend of this feature is: as the value of this feature increases, the bad debt rate decreases (for example, the amount of deposits, etc.), in this module, the features whose number of boxes with slope greater than 0 in the above calculation accounts for more than 30% of the number of boxes with slope not 0 are eliminated, that is, the features that do not conform to the business trend are eliminated.
[0449] After the fifth round of screening, 121 features were eliminated, leaving 147 features.
[0450] For the Alpha2 seg5 sub-model divided in Example 1, the selected variables are customer basic information and personal financial asset variables (a total of 316 feature variables) used to approximately predict the probability of credit defaults in the future for customers who have not registered for credit applications. The feature initial screening step and subsequent steps are the same as other sub-models.
[0451] Example 3 Conversion of features after initial screening
[0452] In the feature judgment step, the optimal conversion method is selected according to the concentration of features after the initial feature screening step, data type, etc. When judging the conversion method, data types are generally divided into two categories, one is character variables, and the other is numeric variables. For character variables, the dummy variable conversion method is generally used for variable conversion; for numeric variables, if the variable value is less than 5 or so, the WOE conversion method will be used. If the variable value is more, the WOE or continuous conversion method will be used (the optimal conversion form is selected by the correlation with the target variable). In this process, it is necessary to comprehensively consider the situation of variable concentration. For example, if the continuous variable has many values, but the concentration of a single value exceeds 95%, the continuous processing will not be performed, and the WOE conversion method can be used directly. Features using different conversion methods are grouped and divided into different data sets. Specifically,
[0453] First, the remaining 147 features in Example 2 are used to determine the conversion methods of these features, and the following three methods are selected based on the concentration of the features, data types, etc.
[0454] Feature conversion method 1 is used to perform WOE conversion on the features obtained in the data acquisition module and judged in the feature judgment module that the optimal conversion method is WOE conversion.
[0455] Feature conversion method 2 is used to perform dummy feature conversion on the features obtained in the data acquisition module and judged in the feature judgment module that the optimal conversion method is dummy feature conversion.
[0456] Feature conversion method 3 is used to obtain the features in the data acquisition module that are determined to be optimal for continuous conversion in the feature judgment module, select the optimal continuous conversion method, and perform continuous conversion.
[0457] The feature merging module is used to horizontally splice the data of feature conversion mode 1, feature conversion mode 2 and feature conversion mode 3.
[0458] Through this embodiment, 147 features were converted, of which 55 features were converted to WOE, 12 features were converted to dummy features (expanded to 26 variables), and 80 features were converted to continuous types, totaling 161 features. The conversion of the post-primary screening features of the Alpha2 seg5 sub-model is also basically similar.
[0459] Example 4 Feature Depth Screening (Feature Fine Screening Step)
[0460] The feature fine screening step mainly includes the following four steps in this embodiment. Steps 1 and 2 are based on stepwise regression and calculation of variance inflation factor to eliminate features with large multicollinearity in the feature merging module to enhance the robustness of the model. Step 3 eliminates features whose positive and negative signs of the training coefficients in the model do not conform to the business trend. Step 4 uses the population stability coefficient (PSI) to eliminate unstable features. This embodiment uses the LOGISTIC process in SAS for deep screening.
[0461] Feature fine screening step 1, based on the stepwise regression algorithm, based on the F test and T test method, introduces features in order from high to low significance. Each time a feature is introduced, the selected features are tested one by one. When the originally introduced feature becomes no longer significant due to the introduction of the subsequent features, it is eliminated. This process is repeated until no features above the significance threshold are selected into the equation, and no features below the significance threshold are eliminated from the regression equation. After this step, 161 features are eliminated to 73 features.
[0462] Feature refinement step 2, which further reduces multicollinearity in the model by removing features with high variance inflation factors. After this step, 73 features were eliminated to 65 features.
[0463] Feature fine screening step 3 compares the risk characteristics of each risk point itself (system preset) with the positive and negative signs of the model training coefficients to determine whether the feature coefficients of the remaining features in the model in step 3 are consistent with the business trend, eliminates the features whose model coefficients do not conform to the business trend, and iterates again.
[0464] The specific implementation scheme of the feature fine screening module 3 is as follows:
[0465] 1. For features whose feature conversion method is WOE type, the corresponding model training coefficient should be a negative value, and the WOE conversion type features with positive training coefficients should be eliminated.
[0466] 2. For continuous conversion methods, if the value of this feature increases in business logic, the bad debt rate should increase (such as the credit limit utilization rate, etc.), then the corresponding model training coefficient should be positive, and such continuous conversion features with negative training coefficients should be eliminated; if the value of this feature increases in business logic, the bad debt rate should decrease (such as the deposit amount, etc.), then the corresponding model training coefficient should be negative, and such continuous conversion features with positive training coefficients should be eliminated.
[0467] 3. For the dummy feature conversion method, it is necessary to determine the bad debt rate when the value is 1 and the value is 0. If the bad debt rate when the value is 1 is greater than the bad debt rate when the value is 0, the coefficient should be positive, otherwise it should be negative.
[0468] Feature fine screening step 4, data stability monitoring step, is used to evaluate whether the distribution of individual features and overall scores at different time points has obvious deviations. In this embodiment, features with PSI>0.25 are directly eliminated, and features with 0.25>PSI>0.1 are carefully eliminated based on the impact of eliminating this feature on the model's distinguishing ability.
[0469] Based on the above steps 3 and 4, the feature list is iterated multiple times until no new features are added or removed from the model, and the iteration is stopped to obtain the final feature list and its conversion value. After the above steps, 65 features are eliminated as the feature variables finally entered into the model, for example, 5 features, 6 features, 7 features, and 8 features.
[0470] Example 5 Construction of Alpha2 seg1 model
[0471] Generally speaking, the stronger the correlation between the feature variable and the target variable, the more accurate the final model will be. In this embodiment, Alpha2 seg1 is used as a sub-model of the segmentation model. The above decision tree method is adopted to obtain a sample size of about 430,000. Its customer base is mainly new customers who have applied for credit business but have not applied for more than 3 months. The model is constructed to predict the probability of credit overdue for more than 60 days (target variable).
[0472] In this embodiment 5, it is finally confirmed that the six features of the average utilization rate of the revolving loan in the past 3 months, the average number of cash withdrawals from credit cards, the number of months with a credit card utilization rate of >90% in the past 3 months, the current deposit account balance, the number of months with interest >0 on credit cards in the past 3 months, and the average monthly AUM (personal financial assets) in the past 6 months are used as examples to describe the final modeling results. In the feature conversion step, the conversion method selection has been carried out on the 6 modeling variables according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 6 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) for logistic regression to calculate the model of credit default probability.
[0473] The average utilization rate of the revolving loan in the past three months reflects the borrower's credit demand. For new customers who have applied for credit business but have not applied for more than three months, a large amount of credit demand in the short term may lead to excessive debt. The manifestation of revolving loans is that the utilization rate of the credit line is often too high in the short term, and the possibility of overdue payment in the future will be very high. The relationship between this variable and customer risk is that the smaller the average utilization rate of the revolving loan in the past three months, the lower the borrower's credit demand, and the lower the possibility of serious default in the future; conversely, the larger the average utilization rate of the revolving loan in the past three months, the higher the borrower's credit demand, and the possibility of serious default will also increase. The conversion method is square conversion.
[0474] The average number of cash withdrawals from credit cards reflects the borrower's credit demand. For new customers who have applied for credit business but have not applied for more than 3 months, a large amount of credit demand over a period of time may lead to excessive debt, which is reflected in the use of credit cards for cash withdrawals and consumption, eventually leading to overdue payments. The relationship between this variable and customer risk is that the lower the average number of cash withdrawals from credit cards, the lower the borrower's short-term credit demand, and the lower the possibility of serious default; conversely, the higher the average number of cash withdrawals from credit cards, the higher the borrower's short-term credit demand, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0475] The number of months in which the credit card credit limit utilization rate is > 90% in the past three months reflects the borrower's recent credit demand. For new customers who have applied for credit business but have not applied for more than three months, in short-term credit behavior, if a large amount of credit demand frequently leads to excessive credit limit utilization, the possibility of overdue payment in the future will be greater. The relationship between this variable and customer risk is that the more months in which the credit card credit limit utilization rate is > 90% in the past three months, the greater the repayment pressure of the customer, and the higher the possibility of serious default; conversely, the fewer months in which the credit card credit limit utilization rate is > 90% in the past three months, the lower the possibility of serious default. The conversion method is to convert the original value.
[0476] The current deposit account balance reflects the borrower's deposit level and repayment ability. For new customers who have applied for credit business but have not applied for more than 3 months, the smaller the deposit balance in the past period of time, the more pressure the borrower will have to repay the debt, resulting in a higher possibility of overdue. The relationship between this variable and customer risk is that the larger the deposit account balance at the current time, the better the borrower's deposit level and the stronger the repayment ability, and the lower the possibility of serious default; conversely, the smaller the deposit account balance at the current time, the worse the borrower's deposit level and the weaker the repayment ability, and the higher the possibility of serious default. The conversion method is logarithmic conversion.
[0477] The number of months with a credit card interest rate > 0 in the past three months reflects the borrower's credit demand. For new customers who have applied for credit business but have not applied for more than three months, a large amount of interest on the credit card means that the customer has used the credit card for non-interest-free business more frequently recently, and the credit demand is large, which may lead to overdue payments in the future. The fewer the number of months with a credit card interest rate > 0 in the past three months, the smaller the borrower's credit demand and repayment pressure, and the lower the possibility of a serious default; conversely, the more the number of months with a credit card interest rate > 0 in the past three months, the greater the borrower's credit demand and repayment pressure, and the higher the possibility of a serious default. The conversion method is WOE conversion.
[0478] The average monthly AUM (personal financial assets) in the past 6 months reflects the borrower's repayment ability. For new customers who have applied for credit business but have not applied for more than 3 months, the average monthly AUM in the short term reflects the borrower's recent economic ability. The larger the average monthly AUM, the more sufficient the economic ability is, and the lower the possibility of future overdue payments. The relationship between this variable and customer risk is that the higher the average monthly AUM (personal financial assets) in the past 6 months, the higher the borrower's repayment ability and the lower the possibility of serious default; conversely, the lower the average monthly AUM (personal financial assets) in the past 6 months, the weaker the borrower's repayment ability and the higher the possibility of serious default. The conversion method is square root conversion.
[0479] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0480]
[0481] Where k is the number of features entering the model, and in Formula 1, k is 6.
[0482] α is the intercept term, with a range of values of (-2.4707, -2.1681), and the optimal value is -2.319; β1 is the average utilization rate of the revolving loan in the past three months, with a range of values of (-0.6497, -0.5694), and the optimal value is -0.61; β2 is the average number of credit card withdrawals, with a range of values of (-0.5801, -0.486), and the optimal value is -0.533; β3 is the number of months in which the credit card utilization rate is > 90% in the past three months, with a range of values of (-0.4247 ,-0.338), the optimal is -0.381; β4 is the current deposit account balance, the value range is (-0.9634,-0.747), the optimal is -0.855; β5 is the number of months with credit card interest > 0 in the past 3 months, the value range is (-0.3326,-0.2401), the optimal is -0.286; β6 is the average monthly AUM (personal financial assets) in the past 6 months, the value range is (-0.1607,-0.1019), the optimal is -0.131. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0483] x1 is the WOE conversion value of the average utilization rate of the revolving loan in the past three months generated by the feature conversion step; x2 is the square conversion value of the average number of credit card withdrawals generated by the feature conversion step; x3 is the original value of the number of months with a credit card utilization rate > 90% in the past three months generated by the feature conversion step; x4 is the logarithmic conversion value of the deposit account balance at the current time point generated by the feature conversion step; x5 is the WOE conversion value of the number of months with interest > 0 on the credit card in the past three months generated by the feature conversion step; x6 is the square root conversion value of the average monthly AUM (personal financial assets) in the past six months generated by the feature conversion step. The model performance of some features is shown in Table 2 below.
[0484] Table 2
[0485]
[0486] The P values of all model features are less than 0.05, indicating that the above features are significantly correlated with default performance. The Alpha2seg1 model predicts borrowers with credit demand and low serious default risk through three aspects of information: credit demand, deposit level, and repayment ability.
[0487] Example 6 Construction of Alpha2 seg2 model
[0488] In this embodiment 6, the final modeling result is described by eight features, namely, the number of times the credit customer has been overdue for more than 0 in the past 6 months, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past 3 months, the number of months with a credit card credit limit utilization rate of more than 90% in the past 12 months, the maximum repayment amount of the credit customer in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the unit quantile level of the wage payment. In the feature conversion step, the 8 modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 8 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) for logistic regression to calculate the credit default probability model.
[0489] The number of times a credit customer has overdue payments > 0 in the past 6 months reflects the borrower's repayment habits and credit performance. For existing customers who have applied for registered credit business for more than 3 months and whose current credit business has overdue payments, if any credit business has been overdue in the past period of time, it means that the borrower can no longer balance income and debt, and the possibility of overdue payments in the future will be very high. The relationship between this variable and customer risk is that the smaller the number of times a credit customer has overdue payments > 0 in the past 6 months, the better the borrower's historical credit performance, and the lower the possibility of serious default in the future; conversely, the greater the number of times a credit customer has overdue payments > 0 in the past 6 months, the worse the borrower's historical credit performance, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0490] The remaining available credit limit of the credit card in the current month reflects the borrower's credit demand. For existing customers who have applied for credit business for more than 3 months and whose current credit business is overdue, a large amount of credit demand in the near future may lead to excessive debt, which is directly reflected in the credit card as the continuous reduction of the remaining available credit limit, which eventually leads to overdue. The relationship between this variable and customer risk is that the lower the remaining available credit limit of the credit card in the current month, the stronger the borrower's credit demand, the greater the repayment pressure, and the higher the possibility of serious default; conversely, the higher the remaining available credit limit of the credit card in the current month, the weaker the borrower's credit demand, the smaller the repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0491] The current monthly installment balance of a credit card reflects the borrower's credit demand and repayment pressure. For existing customers who have applied for credit business for more than 3 months and whose current credit business is overdue, using the credit card installment business means that the customer has recently used the credit card for non-interest-free business more frequently. The larger the installment balance, the greater the credit demand, which may lead to overdue payments in the future. The relationship between this variable and customer risk is that the higher the current monthly installment balance of the credit card, the stronger the borrower's credit demand and repayment pressure, and the higher the possibility of serious default; conversely, the lower the current monthly installment balance of the credit card, the weaker the borrower's credit demand and repayment pressure, and the lower the possibility of serious default. The conversion method is cube root conversion.
[0492] The number of months from the minimum balance of the deposit account in the past three months reflects the change in the borrower's capital level. For existing customers who have applied for registered credit business for more than three months and whose current credit business is overdue, the longer the time from the minimum balance of the deposit occurred in the past period of time, the more sufficient the borrower's current funds are than before, and the lower the possibility of future loan overdue. The relationship between this variable and customer risk is that the greater the number of months from the minimum balance of the deposit account in the past three months, the better the borrower's capital level is, and the lower the possibility of serious default; conversely, the greater the number of months from the minimum balance of the deposit account in the past three months, the worse the borrower's capital level is, and the possibility of serious default will also increase. The conversion method is WOE conversion.
[0493] The number of months in which the credit card credit limit utilization rate is >90% in the past 12 months reflects the borrower's medium- and long-term credit demand. For existing customers who have applied for registered credit business for more than 3 months and whose current credit business is overdue, the borrower's large credit demand in the medium and long term may lead to excessive debt, which is directly reflected in the credit card as the continuous increase in credit limit utilization rate, which eventually leads to overdue. The lower the number of months in which the credit card credit limit utilization rate is >90% in the past 12 months, the lower the borrower's demand for funds and the lower the possibility of serious default; conversely, the greater the number of months in which the credit card credit limit utilization rate is >90% in the past 12 months, the higher the borrower's demand for funds and the higher the possibility of serious default. The conversion method is square conversion.
[0494] The maximum repayment amount of a credit customer in the past six months reflects the repayment habits and credit performance of the borrower. For existing customers who have applied for credit business registration for more than three months and whose current credit business is overdue, the good repayment habits of the borrower in the short and medium term represent the borrower's balanced credit performance behavior, and the possibility of future overdue is very low. The relationship between this variable and customer risk is that the lower the maximum repayment amount of the credit customer in the past six months, the worse the repayment habits and credit performance of the borrower, and the higher the possibility of serious default; conversely, the higher the maximum repayment amount of the credit customer in the past six months, the stronger the repayment habits and credit performance of the borrower, and the lower the possibility of serious default. The conversion method is square root conversion.
[0495] The maximum percentage of the credit card (interest / credit limit) in the past three months reflects the borrower's credit demand. For existing customers who have applied for credit business for more than three months and whose current credit business is overdue, the large amount of interest generated by the credit card means that the customer has recently used the credit card for non-interest-free business more frequently, and the credit demand is large, which may lead to overdue payments in the future. The smaller the maximum percentage of the credit card (interest / credit limit) in the past three months, the smaller the borrower's credit demand and repayment pressure, and the lower the possibility of serious default; conversely, the larger the maximum percentage of the credit card (interest / credit limit) in the past three months, the greater the borrower's credit demand and repayment pressure, and the higher the possibility of serious default. The conversion method is square conversion.
[0496] The unit quantile level of the payroll agency reflects the income level and repayment ability of the borrower. For existing customers who have applied for credit business registration for more than 3 months and whose current credit business is overdue, the unit quantile level of the payroll agency reflects the average level of the borrower's income and repayment ability. The relationship between this variable and customer risk is that the smaller the unit quantile level of the payroll agency, the lower the borrower's income level and repayment ability, and the higher the possibility of serious default; conversely, the larger the unit quantile level of the payroll agency, the higher the borrower's income level and repayment ability, and the lower the possibility of serious default. The conversion method is raw value conversion.
[0497] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0498]
[0499] Where k is the number of features entering the model, and in Formula 2, k is 8.
[0500] α is the intercept, with a range of values from (2.6442, 2.6882) and an optimal value of 2.666; β1 is the number of times the credit customer has been overdue for more than 0 in the past 6 months, with a range of values from (-0.5198, -0.5096) and an optimal value of -0.515; β2 is the remaining available credit limit of the credit card in the current month, with a range of values from (-0.1685, -0.1641) and an optimal value of -0.166; β3 is the installment balance of the credit card in the current month, with a range of values from (-0.9329, -0.8981) and an optimal value of -0.916; β4 is the number of months from the minimum balance of the deposit account in the past 3 months, with a range of values from (-0.2822, -0.2694 ), the optimal value is -0.276; β5 is the number of months with a credit card limit utilization rate of >90% in the past 12 months, with a range of values of (-0.5523, -0.5247), and the optimal value is -0.539; β6 is the maximum repayment amount of credit customers in the past 6 months, with a range of values of (-0.0983, -0.0915), and the optimal value is -0.095; β7 is the maximum percentage of credit card (interest / limit) in the past 3 months, with a range of values of (-0.2917, -0.2705), and the optimal value is -0.281; β8 is the unit quantile level of wage payment, with a range of values of (-0.4353, -0.3949), and the optimal value is -0.415. (Note: The numerical range comes from the 95% confidence interval, i.e., the 95% CI in the table below)
[0501] x1 is the logarithmic conversion value of the number of times the credit customer has overdue payment > 0 in the past 6 months generated by the feature conversion step; x2 is the WOE conversion value of the remaining available credit limit of the credit card in the current month generated by the feature conversion step; x3 is the cube root conversion value of the installment balance of the credit card in the current month generated by the feature conversion step; x4 is the WOE conversion value of the number of months from the minimum balance of the deposit account in the past 3 months generated by the feature conversion step; x5 is the square conversion value of the number of months with a credit card credit limit utilization rate > 90% in the past 12 months generated by the feature conversion step; x6 is the square root conversion value of the maximum repayment amount of the credit customer in the past 6 months generated by the feature conversion step; x7 is the square conversion value of the maximum percentage of the credit card (interest / limit) in the past 3 months generated by the feature conversion step; x8 is the original value of the unit quantile level of the payroll generated by the feature conversion step. The model performance of some features is shown in Table 3 below:
[0502] Table 3
[0503]
[0504] The P values of all model characteristics are less than 0.05, indicating that the above characteristics are significantly correlated with default performance.
[0505] The Alpha2 seg2 model predicts borrowers with credit needs and a lower risk of serious default through information such as borrowers' repayment habits, credit performance, credit demand, repayment pressure, changes in borrowers' capital levels, and medium- and long-term credit needs.
[0506] Example 7 Construction of Alpha2 seg3 model
[0507] For Alpha2 seg3 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained by classification is about 4.47 million. Its customer base is mainly existing customers who have applied for registered credit business for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate is less than 90%. The model is built to predict the probability of credit overdue for more than 60 days in this group (target variable).
[0508] In this embodiment 7, the final modeling result is described by taking seven features as examples: the number of months from the last overdue payment of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months with a credit limit utilization rate greater than 70% in the past 6 months of the revolving loan, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months with overdue payment>0 of the credit customer in the past 12 months. In the selection of the conversion method in the feature conversion step, the 7 modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 7 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of the SAS software) to perform logistic regression to calculate the credit default probability model.
[0509] The number of months since the last overdue payment of a credit customer in the past 12 months>0 reflects the repayment habits and credit performance of the borrower. For existing customers who have applied for registered credit business for more than 3 months and have no overdue credit business and the current monthly credit card repayment rate is less than 90%, if any credit business has been overdue in the past period of time, it means that the borrower has been unable to balance income and debt, and the possibility of overdue payment in the future will be very high. The performance relationship between this variable and customer risk is that the smaller the number of months since the last overdue payment of a credit customer in the past 12 months>0, the better the historical credit performance of the borrower, and the lower the possibility of serious default in the future; conversely, the larger the number of months since the last overdue payment of a credit customer in the past 12 months>0, the worse the historical credit performance of the borrower, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0510] The remaining available credit limit of the credit card in the current month reflects the borrower's credit demand. For existing customers who have applied for credit business for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate is less than 90%, a large amount of credit demand in the near future may lead to excessive debt, which is directly reflected in the credit card as the continuous reduction of the remaining available credit limit, which eventually leads to overdue. The relationship between this variable and customer risk is that the lower the remaining available credit limit of the credit card in the current month, the stronger the borrower's credit demand, the greater the repayment pressure, and the higher the possibility of serious default; conversely, the higher the remaining available credit limit of the credit card in the current month, the weaker the borrower's credit demand, the smaller the repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0511] The current account age of a credit customer reflects the borrower's stickiness and recognition with the bank. For existing customers who have applied for credit business registration for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate is less than 90%, the longer the borrower's account age, the better the credit business's service life and repayment habits, and the lower the possibility of overdue. The lower the current account age of the credit customer, the better the borrower's money usage habits, and the lower the possibility of serious default; conversely, the older the current account age of the credit customer, the borrower's good money usage habits have not been formed, and the possibility of serious default increases accordingly. The conversion method is raw value conversion.
[0512] The number of months in which the credit utilization rate of the revolving loan in the past 6 months was greater than 70% reflects the borrower's medium-term credit demand. For existing customers who have applied for registered credit business for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate is less than 90%, the borrower's large credit demand in the medium term may lead to excessive debt, which is directly reflected in the credit card as the continuous increase in credit utilization rate, and eventually leads to overdue. The lower the number of months in which the credit utilization rate of the revolving loan in the past 6 months is greater than 70%, the lower the borrower's demand for funds and the lower the possibility of serious default; conversely, the greater the number of months in which the credit utilization rate of the revolving loan in the past 6 months is greater than 70%, the higher the borrower's demand for funds and the higher the possibility of serious default. The conversion method is cube root conversion.
[0513] The minimum credit card repayment rate in the past 6 months reflects the borrower's repayment habits and credit performance. For existing customers who have applied for credit business registration for more than 3 months, have no overdue credit business, and have a credit card repayment rate of less than 90% in the current month, the borrower's good repayment habits in the short and medium term represent the borrower's balanced credit performance behavior, and the possibility of future overdue is very low. The relationship between this variable and customer risk is that the lower the minimum credit card repayment rate in the past 6 months, the worse the borrower's repayment habits and credit performance, and the higher the possibility of serious default; conversely, the higher the minimum credit card repayment rate in the past 6 months, the stronger the borrower's repayment habits and credit performance, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0514] The maximum percentage of the credit card (interest / credit limit) in the past three months reflects the borrower's credit demand. For existing customers who have applied for registered credit business for more than three months and whose current credit business has not been overdue and whose current monthly credit card repayment rate is less than 90%, the large amount of interest generated by the credit card means that the customer has recently used the credit card for non-interest-free business more frequently, and the credit demand is large, which may lead to overdue payments in the future. The smaller the maximum percentage of the credit card (interest / credit limit) in the past three months, the smaller the borrower's credit demand and repayment pressure, and the lower the possibility of serious default; conversely, the larger the maximum percentage of the credit card (interest / credit limit) in the past three months, the greater the borrower's credit demand and repayment pressure, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0515] The maximum number of consecutive months in which a credit customer has been overdue for more than 0 in the past 12 months reflects the borrower's repayment habits and credit performance. For existing customers who have applied for registered credit business for more than 3 months and have no overdue credit business and the current monthly credit card repayment rate is less than 90%, if any credit business has been overdue in the past period of time, it means that the borrower has been unable to balance income and debt, and the possibility of overdue in the future will be very high. The performance relationship between this variable and customer risk is that the smaller the maximum number of consecutive months in which a credit customer has been overdue for more than 0 in the past 12 months, the better the historical credit performance of the borrower, and the lower the possibility of serious default in the future; conversely, the larger the maximum number of consecutive months in which a credit customer has been overdue for more than 0 in the past 12 months, the worse the historical credit performance of the borrower, and the higher the possibility of serious default. The conversion method is raw value conversion.
[0516] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0517]
[0518] Where k is the number of features entering the model, and in Formula 3, k is 7.
[0519] α is the intercept, with a range of values from (1.2929, 1.3799) and an optimal value of 1.336; β1 is the number of months from the last overdue payment of the credit customer in the past 12 months > 0, with a range of values from (-0.6139, -0.6007) and an optimal value of -0.607; β2 is the remaining available credit limit of the credit card in the current month, with a range of values from (-0.1436, -0.1404) and an optimal value of -0.142; β3 is the current account age of the credit customer, with a range of values from (-0.6203, -0.6017) and an optimal value of -0.611; β4 is the utilization rate of the revolving loan in the past 6 months greater than 70% of the months, the range is (-0.3646, -0.348), the best is -0.356; β5 is the minimum repayment rate of the credit card in the past 6 months, the range is (-0.3001, -0.2835), the best is -0.292; β6 is the maximum percentage of the credit card (interest / amount) in the past 3 months, the range is (-0.2388, -0.2248), the best is -0.232; β7 is the maximum number of consecutive months with overdue > 0 for credit customers in the past 12 months, the range is (-0.2806, -0.2624), the best is -0.272. (Note: The range of values comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0520] x1 is the WOE conversion value of the number of months from the last overdue payment of the credit customer in the past 12 months > 0 generated in the feature conversion step; x2 is the original value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step; x3 is the WOE conversion value of the current account age of the credit customer generated in the feature conversion step; x4 is the logarithmic conversion value of the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70% generated in the feature conversion step; x5 is the original value of the minimum repayment rate of the credit card in the past 6 months generated in the feature conversion step; x6 is the logarithmic conversion value of the maximum percentage of the credit card (interest / limit) in the past 3 months generated in the feature conversion step; x7 is the WOE conversion value of the maximum number of consecutive months in which the credit customer has overdue payments > 0 in the past 12 months generated in the feature conversion step.
[0521] The model performance of some features is shown in Table 4 below:
[0522] Table 4
[0523]
[0524] The P values of all model features are less than 0.05, indicating that the above features are significantly correlated with default performance. The Alpha2seg3 model predicts borrowers with credit demand and low serious default risk through information such as borrowers' repayment habits, credit performance, credit demand, borrowers' stickiness and recognition with banks, and medium- and long-term credit demand.
[0525] Example 8 Alpha2 seg4 model construction
[0526] For Alpha2 seg4 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained by classification is about 53.29 million. Its customer base is mainly existing customers who have applied for registered credit business for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate exceeds 90%. The model is built to predict the probability of credit overdue for more than 60 days in this group (target variable).
[0527] In Example 8, it is finally confirmed that the final modeling results are described by taking five features as examples: the number of overdue payments of credit customers in the past 12 months > 0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, and the average utilization rate of the installment limit of the credit card in the past 6 months. In the selection of the conversion method in the feature conversion step, the 5 modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the 5 features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) for logistic regression to calculate the model of credit default probability.
[0528] The number of times a credit customer has overdue payments > 0 in the past 12 months reflects the borrower's repayment habits and credit performance. For existing customers who have applied for registered credit business for more than 3 months and have no overdue credit business and whose current monthly credit card repayment rate exceeds 90%, if any credit business has been overdue in the past period of time, it means that the borrower has been unable to balance income and debt, and the possibility of overdue payments in the future will be very high. The relationship between this variable and customer risk is that the smaller the number of overdue payments > 0 in the past 12 months for credit customers, the better the historical credit performance of the borrower, and the lower the possibility of serious default in the future; conversely, the greater the number of overdue payments > 0 in the past 12 months for credit customers, the worse the historical credit performance of the borrower, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0529] The remaining available credit limit of the credit card in the current month reflects the borrower's credit demand. For existing customers who have applied for credit business for more than 3 months, whose current credit business has not been overdue, and whose current credit card repayment rate exceeds 90%, a large amount of credit demand in the near future may lead to excessive debt, which is directly reflected in the credit card as the continuous reduction of the remaining available credit limit, which eventually leads to overdue. The relationship between this variable and customer risk is that the lower the remaining available credit limit of the credit card in the current month, the stronger the borrower's credit demand, the greater the repayment pressure, and the higher the possibility of serious default; conversely, the higher the remaining available credit limit of the credit card in the current month, the weaker the borrower's credit demand, the smaller the repayment pressure, and the lower the possibility of serious default. The conversion method is logarithmic conversion. The conversion method is natural logarithm conversion.
[0530] The current account age of a credit customer reflects the borrower's stickiness and recognition with the bank. For existing customers who have applied for credit business registration for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate exceeds 90%, the longer the borrower's account age, the better the credit business usage and repayment habits, and the lower the possibility of overdue. The lower the current account age of the credit customer, the better the borrower's money usage habits, and the lower the possibility of serious default; conversely, the older the current account age of the credit customer, the borrower's good money usage habits have not been formed, and the possibility of serious default increases accordingly. The conversion method is cube root conversion.
[0531] The percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months reflects the credit demand of borrowers. For existing customers who have applied for credit business for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate exceeds 90%, a large amount of interest on credit cards means that customers have recently used credit cards for non-interest-free business frequently, and their credit demand is large, which may lead to overdue payments in the future. The smaller the percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months, the smaller the credit demand and repayment pressure of the borrower, and the lower the possibility of serious default; conversely, the larger the percentage of interest / total amount of consumption and cash withdrawal of credit cards in the past 12 months, the greater the credit demand and repayment pressure of the borrower, and the higher the possibility of serious default. The conversion method is square conversion.
[0532] The average utilization rate of the installment limit of the credit card in the past 6 months reflects the credit demand and repayment pressure of the borrower. For existing customers who have applied for registered credit business for more than 3 months, whose current credit business has not been overdue, and whose current monthly credit card repayment rate exceeds 90%, using the credit card installment business means that the customer has recently used the credit card for non-interest-free business more frequently. The larger the installment balance, the greater the credit demand, which may lead to overdue payments in the future. The relationship between this variable and customer risk is that the higher the average utilization rate of the installment limit of the credit card in the past 6 months, the stronger the credit demand and repayment pressure of the borrower, and the higher the possibility of serious default; conversely, the lower the average utilization rate of the installment limit of the credit card in the past 6 months, the weaker the credit demand and repayment pressure of the borrower, and the lower the possibility of serious default. The conversion method is logarithmic conversion.
[0533] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0534]
[0535] Where k is the number of features entering the model. In Formula 4, k is 5.
[0536] α is the intercept, with a range of values of (1.6093, 1.6857) and an optimal value of 1.648; β1 is the number of times the credit customer has overdue payments > 0 in the past 12 months, with a range of values of (-0.6496, -0.6424) and an optimal value of -0.646; β2 is the remaining available credit limit of the credit card in the current month, with a range of values of (-0.3222, -0.3164) and an optimal value of -0.319; β3 is the current account balance of the credit customer. Age, the range is (-0.6688, -0.6548), the best is -0.662; β4 is the percentage of interest / consumption and cash withdrawal in the past 12 months of the credit card, the range is (-0.3464, -0.338), the best is -0.342; β5 is the average utilization rate of the installment limit of the credit card in the past 6 months, the range is (-0.3199, -0.3109), the best is -0.315. (Note: The range of values comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0537] x1 is the WOE conversion value of the number of overdue payments > 0 for the credit customer in the past 12 months generated in the feature conversion step; x2 is the logarithmic conversion value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step; x3 is the logarithmic conversion value of the current account age of the credit customer generated in the feature conversion step; x4 is the cube root conversion value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step; x5 is the square conversion value of the average installment limit utilization rate of the credit card in the past 6 months generated in the feature conversion step.
[0538] The model performance of some features is shown in Table 5 below:
[0539] Table 5
[0540]
[0541] The P values of all model features are less than 0.05, indicating that the above features are significantly correlated with default performance. The Alpha2seg4 model predicts borrowers with credit demand and low serious default risk through information such as borrowers' repayment habits, credit performance, credit demand, borrowers' stickiness and recognition with banks, and repayment pressure.
[0542] Example 9 Alpha2 seg5 model construction
[0543] For Alpha2 seg5 as a sub-model of the segmentation model, the above-mentioned decision tree method is adopted, and the sample size obtained by classification is about 430,000. Its customer base is mainly new customers with an account age of less than 3 months who have applied for credit business. The model is built to predict the probability (target variable) of the sample group that has not applied for registered credit business to be overdue for more than 60 days in the future.
[0544] In Example 10, it is finally confirmed that the final modeling results are described by taking six features as examples: the maximum number of consecutive months of decrease in AUM value over the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) over the past six months, the number of months from the maximum balance of the deposit account over the past 12 months, the minimum balance of the deposit account over the past six months, and the maximum balance of the investment and financial management account over the past 12 months. In the selection of the conversion method in the feature conversion step, the six modeling variables have been converted in a corresponding form according to the correlation between the feature and the target variable. In the credit default probability modeling step, the six features screened by the feature fine screening step are substituted into the Sigmoid function (using the LOGISTIC process of SAS software) to perform logistic regression to calculate the credit default probability model.
[0545] The maximum number of consecutive months of decrease in AUM over the past three months reflects the asset level and repayment ability of the borrower. For new users who have not applied for credit business registration, the AUM value reflects the recent changes in the borrower's economic ability. If the economic ability is insufficient, the possibility of overdue payment in the future is very high. The relationship between this variable and customer risk is that the lower the maximum number of consecutive months of decrease in AUM over the past three months, the stronger the borrower's asset level and repayment ability, and the lower the possibility of serious default; conversely, the higher the maximum number of consecutive months of decrease in AUM over the past three months, the weaker the borrower's asset level and repayment ability, and the higher the possibility of serious default. The conversion method is WOE conversion.
[0546] The current deposit account balance reflects the borrower's deposit level and repayment ability. For new users who have not applied for credit business, the more pressure the borrower has to repay the debt, the higher the possibility of overdue payment. The relationship between this variable and customer risk is that the larger the current deposit account balance, the better the borrower's deposit level and repayment ability, and the lower the possibility of serious default; conversely, the smaller the current deposit account balance, the worse the borrower's deposit level and repayment ability, and the higher the possibility of serious default. The conversion method is logarithmic conversion.
[0547] The average monthly AUM (personal financial assets) in the past six months reflects the borrower's repayment ability. For new users who have not applied for credit business registration, the average monthly AUM in the short term reflects the borrower's recent economic ability. The larger the average monthly AUM, the more sufficient the economic ability is, and the lower the possibility of future overdue payments. The relationship between this variable and customer risk is that the higher the average monthly AUM (personal financial assets) in the past six months, the higher the borrower's repayment ability and the lower the possibility of serious default; conversely, the lower the average monthly AUM (personal financial assets) in the past six months, the weaker the borrower's repayment ability and the higher the possibility of serious default. The conversion method is logarithmic conversion.
[0548] The number of months from the maximum balance of the deposit account in the past 12 months to the present reflects the change in the borrower's capital level. For new users who have not applied for credit business registration, if the maximum balance of the deposit in the past period of time is smaller than the present month, the borrower's current capital level is more sufficient than before, and the possibility of future loan default is lower. The relationship between this variable and customer risk is that the further the maximum balance of the deposit account in the past 12 months is from the present month, the lower the borrower's recent income level and repayment ability, and the higher the possibility of serious default; conversely, the closer the maximum balance of the deposit account in the past 12 months is to the present month, the higher the borrower's recent income level and repayment ability, and the lower the possibility of serious default. The conversion method is raw value conversion.
[0549] The minimum balance of the deposit account at a certain point in time in the past six months reflects the borrower's capital level and repayment ability. For new users who have not applied for credit business registration, the larger the minimum balance of the deposit in the past period of time, the more sufficient the borrower's capital level is, and the lower the possibility of future loan defaults. . The relationship between this variable and customer risk is that the larger the minimum balance of the deposit account at a certain point in time in the past six months, the more sufficient the borrower's capital level is, and the lower the possibility of serious default; conversely, the larger the minimum balance of the deposit account at a certain point in time in the past six months, the weaker the borrower's capital level and repayment ability are, and the possibility of serious default will also increase. The conversion method is the square conversion in the continuous conversion.
[0550] The maximum balance of the investment and financial management account in the past 12 months reflects the borrower's investment level and repayment ability. For new users who have not applied for credit business registration, the maximum balance of the investment and financial management account in the past 12 months reflects the adequacy of the borrower's second repayment source. The larger the balance, the stronger the repayment ability and the lower the possibility of future default. The relationship between this variable and customer risk is that the smaller the maximum balance of the investment and financial management account in the past 12 months, the lower the borrower's investment level and repayment ability, and the higher the possibility of serious default; conversely, the larger the maximum balance of the investment and financial management account in the past 12 months, the higher the borrower's investment level and repayment ability, and the lower the possibility of serious default. The conversion method is the cube root conversion in the continuous conversion.
[0551] In the step of calculating the probability of credit default, based on the data and coefficients obtained in the feature conversion step, the following model formula is used to predict the probability (P) that the borrower is in default:
[0552]
[0553] Where k is the number of features entering the model. In Formula 6, k is 6.
[0554] α is the intercept, with a range of values of (-2.2994, -2.0097), and the optimal value is -2.155; β1 is the maximum number of consecutive months of decrease in AUM value over the past three months, with a range of values of (-2.8509, -2.0665), and the optimal value is -2.459; β2 is the current point in time deposit account balance, with a range of values of (-0.0925, -0.0588), and the optimal value is -0.076; β3 is the average monthly AUM (personal financial assets) over the past six months, with a range of values of (-0.147, - 0.0902), the optimal value is -0.119; β4 is the number of months from the maximum balance of the deposit account in the past 12 months, the value range is (-1.1717, -0.6868), the optimal value is -0.929; β5 is the minimum balance of the deposit account in the past 6 months, the value range is (-0.119, -0.0689), the optimal value is -0.094; β6 is the maximum balance of the investment and financial management account in the past 12 months, the value range is (-0.634, -0.3404), the optimal value is -0.487. (Note: The value range comes from the 95% confidence interval, that is, the 95% CI in the table below)
[0555] x1 is the logarithmic transformation value of the maximum number of consecutive months of decrease in AUM value over the past three months generated by the feature conversion step; x2 is the logarithmic transformation value of the deposit account balance at the current time point generated by the feature conversion step; x3 is the WOE conversion value of the average monthly AUM (personal financial assets) over the past six months generated by the feature conversion step; x4 is the original value of the number of months from the maximum balance of the deposit account at a point in time over the past 12 months generated by the feature conversion step; x5 is the square transformation value of the minimum balance of the deposit account at a point in time over the past six months generated by the feature conversion step; x6 is the cube root transformation value of the maximum balance of the investment and wealth management account over the past 12 months generated by the feature conversion step.
[0556] The model performance of some features is shown in Table 7 below:
[0557] Table 6
[0558]
[0559] The P values of all model features are less than 0.05, indicating that the above features are significantly correlated with default performance. The Alpha2seg5 model predicts borrowers with credit needs and low serious default risk through information on borrowers' asset levels and repayment capabilities, deposit levels, and changes in funding levels.
[0560] Example 10
[0561] The P values calculated by the above formulas can be further used to calculate the score of any customer.
[0562] The scoring calculation step is used to convert the calculated credit default probability into a score of 0-1000 using a pre-stored default score conversion code.
[0563] In the scoring calculation module, the following formula is used to calculate and generate the credit score used to characterize the borrower:
[0564]
[0565]
[0566] Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
[0567] In this embodiment, the P value calculated in the above embodiments can be substituted to calculate the score.
[0568] The KS (Kolmogorov-Smirnov) statistic was proposed by two Soviet mathematicians, ANKolmogorov and NVSmirnov. In risk control, KS is often used to evaluate the discrimination of models. The greater the discrimination, the stronger the risk ranking ability of the model.
[0569] The KS statistic is based on the empirical cumulative distribution function (ECDF), which is generally defined as:
[0570] KS=max(|cum(bad_rate)-cum(good_rate)|)
[0571] According to the prediction model, the KS curve is drawn. The KS of this embodiment is 76.33. It can be seen that the model constructed in this embodiment performs well in assessing customer credit risk. Figure 1 An example of a KS graph is shown with a KS value of 58.
[0572] The following shows the results of the KS values of the model applied to the development sample and the reserved validation sample. From Table 14, it can be seen that the model has good discrimination effect in the training set and validation set (where the sample size ratio of the training set and validation set is 6:4) and the overall sample, that is, the discrimination effect is very good in all sub-models.
[0573] Table 7
[0574]
Claims
1. A method for calculating retail credit risk, comprising: A data collection step, which obtains retail credit prediction data of the sample to be predicted; A step of classifying samples to be predicted, which classifies the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default; The credit default probability calculation step is to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted, and preferably the credit default probability is the credit default probability.
2. The method according to claim 1, further comprising: After calculating the credit default probability, a step of calculating the credit score of the sample to be predicted is used to calibrate the calculated credit default probability to a standardized score of 0-1000 points.
3. The method according to claim 1 or 2, wherein: The retail credit prediction data includes original retail credit prediction data of the sample to be predicted and derived retail credit prediction data processed based on the original retail credit prediction data; Preferably, the original retail credit prediction data includes: Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process. Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users. Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions. Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
4. The method according to any one of claims 1 to 3, wherein: The derived retail credit prediction data processed based on the original retail credit prediction data refers to the data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension and statistical information dimension; Preferably, the derived retail credit forecast data includes but is not limited to: Derived retail credit forecast data obtained by processing based on sample relationship length, Derivative retail credit forecast data obtained by processing time interval variables, Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior, Derivative retail credit forecast data obtained by processing the current time point of the sample, Derivative retail credit forecast data obtained by processing based on sample continuous behavior, Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
5. The method according to any one of claims 1 to 4, wherein: The retail credit prediction data is selected from one, two, three, four, five, six or seven of the following: Average utilization rate of revolving loan in the past three months, average number of credit card cash withdrawals, number of months with credit card utilization rate > 90% in the past three months, current deposit account balance, number of months with credit card interest > 0 in the past three months, average monthly AUM (personal financial assets) in the past six months, number of times credit customers have overdue payments > 0 in the past six months, current month remaining available credit card balance, current month installment balance of credit card, number of months from now with minimum balance in deposit account in the past three months, number of months with credit card utilization rate > 90% in the past 12 months, maximum repayment amount in the past six months, maximum percentage of credit card (interest / limit) in the past three months, percentile level of the unit where payroll is paid, number of months from now with the last overdue payment > 0 of a credit customer in the past 12 months, current month remaining available credit card balance degree, current account age of credit customers, number of months in the past 6 months with a revolving loan limit utilization rate greater than 70%, minimum credit card repayment rate in the past 6 months, maximum credit card (interest / limit) percentage in the past 3 months, maximum number of consecutive months with overdue > 0 in the past 12 months for credit customers, remaining available credit limit of the credit card in the current month, current account age of credit customers, percentage of credit card interest / total amount of consumption and cash withdrawal in the past 12 months, average credit card installment limit utilization rate in the past 6 months, maximum number of consecutive months with a month-on-month decrease in AUM in the past 3 months, current deposit account balance, average monthly AUM (personal financial assets) in the past 6 months, number of months from today since the maximum balance of the deposit account at a point in time in the past 12 months, minimum deposit account balance at a point in time in the past 6 months, maximum balance of the investment and wealth management account in the past 12 months.
6. The method according to any one of claims 1 to 5, wherein: The step of classifying the sample to be predicted includes the following sub-steps: Whether the sample to be tested is a customer who has applied for credit business from a financial institution; Whether the sample to be tested has an age greater than or equal to G1; Whether the sample to be tested is a customer with overdue credit; Whether the current repayment rate of the sample to be tested is less than a%; Based on the above sub-steps, the samples to be predicted are classified to determine the sub-model for calculating the probability of credit default. Under the premise of ensuring the rationality of business logic, the order of the above sub-steps can be set arbitrarily; It is preferred to classify the predicted samples in the following order: First, determine whether the sample to be tested is a customer who has applied for credit business at a financial institution; Then determine whether the sample to be tested has an account age greater than or equal to G1; Then, determine whether the credit of the sample to be tested is overdue; Then determine whether the current repayment rate of the sample to be tested is less than a%.
7. The method according to any one of claims 1 to 6, wherein: After performing feature conversion on the retail credit prediction data, the data is substituted into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted. The feature conversion step includes: Based on the feature type of the retail credit prediction data that needs to be substituted into the credit default probability sub-model, the WOE method, dummy feature method or continuous method is selected for feature conversion.
8. The method according to claim 7, wherein: The continuous method for feature conversion includes the following methods: directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data to perform continuous feature conversion.
9. The method according to any one of claims 1 to 8, wherein: The credit default probability sub-model is a model constructed based on sample retail credit prediction data and credit default probability using logistic regression based on the existing user population.
10. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: the average utilization rate of revolving loans in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the current deposit account balance, the number of months with a credit card interest rate > 0 in the past three months, and one, two, three, four, five or six of the average monthly AUM (personal financial assets) in the past six months.
11. The method according to claim 10, wherein: The steps to calculate the probability of credit default include: The average utilization rate of revolving loans in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the current deposit account balance, the number of months with a credit card interest rate > 0 in the past three months, and the average monthly AUM (personal financial assets) in the past six months were converted into features; Priority is given to converting the average utilization rate of revolving loans in the past three months in a continuous manner; the average number of credit card withdrawals is converted to WOE; the number of months in which the credit card utilization rate in the past three months is >90% is converted in a continuous manner; the current point in time deposit account balance is converted in a continuous manner; the number of months in which the credit card interest is >0 in the past three months is converted to WOE; the average monthly AUM (personal financial assets) in the past six months is converted in a continuous manner; Further preferred is to convert the average value of the utilization rate of the revolving loan credit limit in the past three months into the average value of the utilization rate of the revolving loan credit limit in the past three months using a continuous method; to convert the number of months with a credit card credit limit utilization rate > 90% in the past three months into the original value of the number of months with a credit card credit limit utilization rate > 90% in the past three months using a continuous method; to convert the current point in time deposit account balance into the logarithm of the current point in time; and to convert the monthly average AUM (personal financial assets) in the past six months into the monthly average AUM in the past six months using a continuous method into the square root of the square root.
12. The method according to claim 11, wherein: The converted values of the six features, namely the average utilization rate of the revolving loan in the past three months, the average number of credit card cash withdrawals, the number of months with a credit card utilization rate > 90% in the past three months, the current deposit account balance, the number of months with credit card interest > 0 in the past three months, and the average monthly AUM (personal financial assets) in the past six months, are brought into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
13. The method according to claim 12, wherein: The sub-model is shown in the following formula 1: Where k is the number of features entering the model, preferably k is 6, α is the intercept term, its value range is (-2.4707, -2.1681), and the optimal value is -2.
319. β1 is the average utilization rate of the revolving loan in the past three months, with a range of (-0.6497, -0.5694), and the optimal value is -0.61; β2 is the average number of cash withdrawals from credit cards, with a value range of (-0.5801, -0.486) and an optimal value of -0.533; β3 is the number of months in which the credit card limit utilization rate is greater than 90% in the past three months, with a value range of (-0.4247, -0.338) and an optimal value of -0.381; β4 is the current deposit account balance, with a value range of (-0.9634, -0.747), and the optimal value is -0.855; β5 is the number of months in which the credit card interest was > 0 in the past three months, with a value range of (-0.3326, -0.2401) and an optimal value of -0.286; β6 is the average monthly AUM (personal financial assets) in the past 6 months, with a range of values of (-0.1607, -0.1019) and an optimal value of -0.
131. (Note: The range of values comes from the 95% confidence interval, i.e., the 95% CI in the table below) x1 is the square transformation value of the average utilization rate of the revolving loan in the past three months generated in the feature conversion step; x2 is the woe conversion value of the average number of credit card cash withdrawals generated in the feature conversion step; x3 is the original value of the number of months in which the credit card limit utilization rate was > 90% in the past three months, generated by the feature conversion step; x4 is the logarithmic transformation value of the deposit account balance at the current time point generated by the feature conversion step; x5 is the WOE conversion value of the number of months with credit card interest > 0 in the past three months generated in the feature conversion step; x6 is the square root transformed value of the average monthly AUM (personal financial assets) for the past 6 months generated in the feature transformation step.
14. The method according to claim 13, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
15. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: the number of overdue payments of credit customers in the past 6 months>0, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past 3 months, the number of months with a credit card credit limit utilization rate>90% in the past 12 months, the maximum repayment amount of the credit customer in the past 6 months, the maximum credit card (interest / limit) percentage in the past 3 months, and one, two, three, four, five, six, seven or eight of the unit quantile levels of wage payment.
16. The method according to claim 15, wherein: The steps to calculate the probability of credit default include: The number of times that credit customers have overdue payments > 0 in the past 6 months, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the minimum balance of the deposit account in the past 3 months, the number of months with a credit card credit limit utilization rate > 90% in the past 12 months, the maximum repayment amount of credit customers in the past 6 months, the maximum percentage of credit cards (interest / limit) in the past 3 months, and the unit quantile level of wage payment are transformed. It is preferred to use WOE conversion for the number of times that the credit customer has overdue payment > 0 in the past 6 months; use continuous conversion for the remaining available credit limit of the credit card in the current month; use continuous conversion for the installment balance of the credit card in the current month; use WOE conversion for the number of months from the minimum balance of the deposit account in the past 3 months; use continuous conversion for the number of months with credit card credit limit utilization rate > 90% in the past 12 months; use continuous conversion for the maximum repayment amount of the credit customer in the past 6 months; use continuous conversion for the maximum percentage of credit card (interest / credit limit) in the past 3 months; use continuous conversion for the unit quantile level of wage payment; Further preferably, the continuous conversion of the current month's remaining available credit limit of the credit card is a calculation method of taking the cube root of the current month's remaining available credit limit of the credit card; the continuous conversion of the current month's installment balance of the credit card is a calculation method of taking the cube root; the continuous conversion of the number of months in which the credit limit utilization rate of the credit card in the past 12 months is >90% is a calculation method of taking the square of the number of months in which the credit limit utilization rate of the credit card in the past 12 months is >90%; the continuous conversion of the maximum repayment amount of the credit customer in the past 6 months is a calculation method of taking the square root of the maximum repayment amount of the credit customer in the past 6 months; the continuous conversion of the maximum percentage of the credit card in the past 3 months is a calculation method of taking the square of the maximum percentage of the credit card in the past 3 months; the continuous conversion of the unit quantile level of the wage agency payment unit is a calculation method of taking the original value of the unit quantile level of the wage agency payment unit.
17. The method according to claim 15, wherein: The converted values of eight features, including the number of overdue payments of credit customers > 0 in the past 6 months, the remaining available credit limit of the credit card in the current month, the installment balance of the credit card in the current month, the number of months from the present when the minimum balance of the deposit account in the past 3 months was the number of months with a credit card credit limit utilization rate > 90% in the past 12 months, the maximum repayment amount of the credit customer in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the quantile level of the unit where the wage payment is located, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data to calculate the default probability of the sample to be predicted.
18. The method according to claim 17, wherein: The sub-model is shown in the following formula 2: Where k is the number of features entering the model, preferably k is 8; α is the intercept, the value range is (2.6442, 2.6882), and the optimal value is 2.666; β1 is the number of times the credit customer has overdue payments > 0 in the past 6 months, with a value range of (-0.5198, -0.5096) and an optimal value of -0.515; β2 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.1685, -0.1641), and the optimal value is -0.166; β3 is the current monthly installment balance of the credit card, with a value range of (-0.9329, -0.8981) and an optimal value of -0.916; β4 is the number of months from the current minimum balance of the deposit account in the past three months, with a value range of (-0.2822, -0.2694), and the optimal value is -0.276; β5 is the number of months in which the credit limit utilization rate of the credit card in the past 12 months is greater than 90%, with a value range of (-0.5523, -0.5247) and an optimal value of -0.539; β6 is the maximum repayment amount of credit customers in the past 6 months, with a value range of (-0.0983, -0.0915) and an optimal value of -0.095; β7 is the maximum percentage of (interest / limit) of the credit card in the past three months, with a value range of (-0.2917, -0.2705) and an optimal value of -0.281; β8 is the unit quantile level of the wage payment unit, with a value range of (-0.4353, -0.3949), and the optimal value is -0.
415. (Note: The value range comes from the 95% confidence interval, i.e., the 95% CI in the table below) x1 is the logarithmic transformation value of the number of credit customers with overdue payments > 0 in the past 6 months generated in the feature conversion step; x2 is the WOE conversion value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step; x3 is the cube root conversion value of the current monthly installment balance of the credit card generated in the feature conversion step; x4 is the WOE conversion value of the minimum balance of the deposit account in the past three months generated in the feature conversion step, which is the number of months from now; x5 is the square transformation value of the number of months with a credit card limit utilization rate > 90% in the past 12 months generated by the feature conversion step; x6 is the square root conversion value of the maximum repayment amount of the credit customer in the past 6 months generated in the feature conversion step; x7 is the square conversion value of the maximum percentage of credit card (interest / limit) in the past three months generated by the feature conversion step; x8 is the original value of the unit quantile level of the wage payment generated in the feature conversion step. The model performance of some features is shown in Table 3 below.
19. The method according to claim 18, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
20. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: the number of months since the last overdue payment of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70%, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months with overdue payments>0 for the credit customer in the past 12 months, one, two, three, four, five, six or seven.
21. The method according to claim 20, wherein: The steps to calculate the probability of credit default include: The features of the last overdue payment of the credit customer in the past 12 months > 0 are converted into the number of months from now, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70%, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months in which the credit customer was overdue > 0 in the past 12 months. The preferred credit customers in the past 12 months have the last overdue payment > 0 months ago and use WOE conversion; the credit card's current month's remaining available credit limit is converted in a continuous manner; the credit customer's current account age is converted in a continuous manner; the current credit card's remaining available credit limit is converted in a continuous manner; the number of months in which the credit limit utilization rate of revolving loans in the past 6 months is greater than 70% is converted in a continuous manner; the minimum credit card repayment rate in the past 6 months is converted in a continuous manner; the maximum credit card (interest / limit) percentage in the past 3 months is converted in a WOE manner; the maximum number of consecutive months in which the credit customer has been overdue > 0 in the past 12 months is converted in a continuous manner; Further preferably, the current month's remaining available credit limit of the credit card is converted in a continuous manner using a natural logarithm calculation method; the current account age of the credit customer is converted in a continuous manner using a cube root calculation method; the current remaining available credit limit of the credit card is converted in a continuous manner into a logarithm calculation method; the number of months in which the credit limit utilization rate of the revolving loan is greater than 70% in the past 6 months is converted in a continuous manner into a cube root calculation method; the minimum repayment rate of the credit card in the past 6 months is converted in a continuous manner into a logarithm calculation method; the maximum consecutive number of months in which the credit customer is overdue > 0 in the past 12 months is converted in a continuous manner using the original value calculation method.
22. The method according to claim 20, wherein: The converted values of the seven features, namely, the number of months since the last overdue payment of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the number of months in the past 6 months when the credit limit utilization rate of the revolving loan was greater than 70%, the minimum repayment rate of the credit card in the past 6 months, the maximum percentage of the credit card (interest / limit) in the past 3 months, and the maximum number of consecutive months in which the credit customer had overdue payments>0 in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
23. The method according to claim 22, wherein: The sub-model is shown in Formula 3 below: Where k is the number of features entering the model, and k is preferably 7; α is the intercept, the value range is (1.2929, 1.3799), and the optimal value is 1.336; β1 is the number of months from the last overdue payment of the credit customer in the past 12 months > 0, with a value range of (-0.6139, -0.6007), and the optimal value is -0.607; β2 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.1436, -0.1404), and the optimal value is -0.142; β3 is the current age of the credit customer, with a value range of (-0.6203, -0.6017) and an optimal value of -0.611; β4 is the number of months in the past 6 months when the utilization rate of the revolving loan was greater than 70%, with a value range of (-0.3646, -0.348) and an optimal value of -0.356; β5 is the minimum repayment rate of the credit card in the past 6 months, with a value range of (-0.3001, -0.2835) and an optimal value of -0.292; β6 is the maximum percentage of (interest / limit) of the credit card in the past three months, with a value range of (-0.2388, -0.2248) and an optimal value of -0.232; β7 is the maximum number of consecutive months in which credit customers have overdue payments > 0 in the past 12 months, with a value range of (-0.2806, -0.2624) and an optimal value of -0.
272. (Note: The value range comes from the 95% confidence interval, i.e., the 95% CI in the table below) x1 is the WOE conversion value of the credit customer whose most recent overdue payment > 0 in the past 12 months, generated in the feature conversion step; x2 is the original value of the remaining available credit limit of the credit card in the current month generated in the feature conversion step; x3 is the WOE conversion value of the current aging of the credit customer generated in the feature conversion step; x4 is the logarithmic transformation value of the number of months in the past 6 months when the utilization rate of the revolving loan was greater than 70%, generated in the feature conversion step; x5 is the original value of the minimum credit card repayment rate in the past 6 months generated by the feature conversion step; x6 is the logarithmic transformation value of the maximum percentage of credit card (interest / limit) in the past three months generated in the feature conversion step; x7 is the WOE conversion value generated by the feature conversion step for the maximum number of consecutive months of overdue payments > 0 for credit customers in the past 12 months.
24. The method according to claim 23, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
25. The method according to any one of claims 1 to 9, wherein: The retail credit prediction data is selected from: one, two, three, four or five of the following: the number of overdue payments of the credit customer in the past 12 months>0, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months, and the average utilization rate of the installment limit of the credit card in the past 6 months.
26. The method according to claim 25, wherein: The steps to calculate the probability of credit default include: The number of times the credit customer has overdue payments > 0 in the past 12 months, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal of the credit card in the past 12 months, and the average utilization rate of the credit card installment limit in the past 6 months are transformed into features. It is preferred to use WOE conversion for the number of overdue payments of credit customers in the past 12 months > 0; use continuous conversion for the remaining available credit limit of the credit card in the current month; use continuous conversion for the current account age of the credit customer; use continuous conversion for the percentage of interest / consumption and total cash withdrawal of the credit card in the past 12 months; use continuous conversion for the average utilization rate of the installment limit of the credit card in the past 6 months; It is further preferred that the current month's remaining available credit limit of the credit card is converted in a continuous manner to a calculation method using the natural logarithm of the current month's remaining available credit limit of the credit card; the current account age of the credit customer is converted in a continuous manner to a calculation method using the cube root of the current account age of the credit customer; the percentage of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months is converted in a continuous manner to a calculation method using the square of the total amount of interest / consumption and cash withdrawal of the credit card in the past 12 months; the average value of the installment limit utilization rate of the credit card in the past 6 months is converted in a continuous manner to a calculation method using the logarithm of the average value of the installment limit utilization rate of the credit card in the past 6 months.
27. The method according to claim 25, wherein: The converted values of the five features, namely, the number of overdue payments of the credit customer > 0 in the past 12 months, the remaining available credit limit of the credit card in the current month, the current account age of the credit customer, the percentage of interest / consumption and total cash withdrawal of the credit card in the past 12 months, and the average utilization rate of the installment limit of the credit card in the past 6 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
28. The method according to claim 27, wherein: The sub-model is shown in Formula 4 below: Where k is the number of features entering the model, and k is preferably 5; α is the intercept, the value range is (1.6093, 1.6857), and the optimal value is 1.648; β1 is the number of times a credit customer has overdue payments > 0 in the past 12 months, with a value range of (-0.6496, -0.6424) and an optimal value of -0.646; β2 is the remaining available credit limit of the credit card in the current month, with a value range of (-0.3222, -0.3164), and the optimal value is -0.319; β3 is the current age of the credit customer, with a value range of (-0.6688, -0.6548) and an optimal value of -0.662; β4 is the percentage of interest / total amount of consumption and cash withdrawal of credit card in the past 12 months, with a value range of (-0.3464, -0.338) and an optimal value of -0.342; β5 is the average utilization rate of the credit card installment limit in the past 6 months, with a range of values of (-0.3199, -0.3109) and an optimal value of -0.
315. (Note: The range of values comes from the 95% confidence interval, i.e., the 95% CI in the table below) x1 is the WOE conversion value of the number of overdue payments of credit customers > 0 in the past 12 months generated by the feature conversion step; x2 is the logarithmic transformation value of the remaining available credit limit of the credit card in the current month generated in the feature transformation step; x3 is the logarithmic transformation value of the current age of the credit customer generated in the feature transformation step; x4 is the cube root conversion value of the percentage of interest / consumption and total cash withdrawal amount of the credit card in the past 12 months generated in the feature conversion step; x5 is the square transformation value of the average credit card installment limit utilization rate in the past 6 months generated by the feature conversion step.
29. The method according to claim 28, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
30. The method according to any one of claims 1 to 9, wherein: The retail credit forecast data is selected from: the number of consecutive months with the largest month-on-month decrease in AUM value in the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) in the past six months, the number of months from the current point in time of the maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past six months, and one, two, three, four, five or six of the maximum balance of the investment and wealth management account in the past 12 months.
31. The method according to claim 30, wherein: The steps to calculate the probability of credit default include: The maximum number of consecutive months of decrease in AUM value over the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) over the past six months, the number of months from the maximum balance of the deposit account over the past 12 months, the minimum balance of the deposit account over the past six months, and the maximum balance of the investment and financial management account over the past 12 months are converted into features. It is preferred to use WOE conversion for the maximum number of consecutive months of month-on-month decrease in AUM value in the past three months; use continuous conversion for the current deposit account balance; use continuous conversion for the average monthly AUM (personal financial assets) in the past six months; use continuous conversion for the number of months from the maximum balance of the deposit account in the past 12 months; use continuous conversion for the minimum balance of the deposit account in the past six months; use continuous conversion for the maximum balance of the investment and financial management account in the past 12 months; Further preferably, the current deposit account balance is converted into the current deposit account balance using a continuous method by taking the logarithm; the monthly average AUM (personal financial assets) of the past 6 months is converted into the monthly average AUM (personal financial assets) of the past 6 months using a continuous method by taking the logarithm; the number of months from the maximum balance of the deposit account in the past 12 months is converted into the number of months from the maximum balance of the deposit account in the past 12 months using a continuous method by taking the original value. The minimum balance of the deposit account in the past 6 months is converted into the minimum balance of the deposit account in the past 6 months using a continuous method by taking the square; the maximum balance of the investment and financial management account in the past 12 months is converted into the maximum balance of the investment and financial management account in the past 12 months using a continuous method by taking the cube root.
32. The method of claim 30, wherein: The converted values of the six features, namely, the number of consecutive months with the largest month-on-month decrease in AUM in the past three months, the current deposit account balance, the average monthly AUM (personal financial assets) in the past six months, the number of months from the current maximum balance of the deposit account in the past 12 months, the minimum balance of the deposit account in the past six months, and the maximum balance of the investment and wealth management account in the past 12 months, are substituted into the sub-model constructed by logistic regression based on the sample retail credit prediction data and credit default probability to calculate the default probability of the sample to be predicted.
33. The method of claim 32, wherein: The sub-model is shown in Formula 5 below: Where k is the number of features entering the model, and k is preferably 6; α is the intercept, the value range is (-2.2994, -2.0097), and the optimal value is -2.155; β1 is the maximum number of consecutive months of decrease in AUM value over the past three months, ranging from (-2.8509, -2.0665), with the best value being -2.459; β2 is the current deposit account balance, with a value range of (-0.0925, -0.0588) and an optimal value of -0.076; β3 is the average monthly AUM (personal financial assets) in the past 6 months, with a range of (-0.147, -0.0902) and an optimal value of -0.119; β4 is the number of months from the current point in time when the deposit account has the largest balance in the past 12 months, with a value range of (-1.1717, -0.6868), and the optimal value is -0.929; β5 is the minimum balance of the deposit account in the past 6 months, with a value range of (-0.119, -0.0689) and an optimal value of -0.094; β6 is the maximum balance of the investment and financial management account in the past 12 months, with a range of values (-0.634, -0.3404), and the optimal value is -0.
487. (Note: The value range comes from the 95% confidence interval, i.e., the 95% CI in the table below) x1 is the logarithmic transformation value of the maximum number of consecutive months of decrease in AUM values over the past three months generated in the feature conversion step; x2 is the logarithmic transformation value of the deposit account balance at the current time point generated by the feature conversion step; x3 is the WOE conversion value of the average monthly AUM (personal financial assets) of the past 6 months generated in the feature conversion step; x4 is the original value of the maximum balance of the deposit account in the past 12 months generated by the feature conversion step. x5 is the square transformation value of the minimum balance of the deposit account at a certain point in time in the past 6 months generated by the feature conversion step; x6 is the cube root conversion value of the maximum balance of the investment and financial management account in the past 12 months generated by the feature conversion step.
34. The method of claim 33, wherein: After calculating the credit default probability, the step of calculating the credit score of the sample to be predicted is to use the following formula to calculate and generate a credit score for characterizing the borrower: Among them, P is the borrower's default probability (P) generated in the credit default probability calculation module, A is 443.9036; B is -72.1348, and the round function rounds the calculated score to the integer value; finally, the score greater than 1000 is set to 1000 points, and the score less than 0 is set to 0 points.
35. A device for calculating retail credit risk, comprising: A data collection module, which is used to obtain retail credit prediction data of samples to be predicted; A module for classifying samples to be predicted, which is used to classify the samples to be predicted based on a decision tree method to determine a sub-model for calculating the probability of credit default; The credit default probability calculation module is used to substitute the retail credit prediction data into the credit default probability sub-model to calculate the credit default probability of the sample to be predicted.
36. The device according to claim 35, wherein The device executes the steps of the method for calculating retail credit risk according to any one of claims 1 to 34.
37. A system for calculating retail credit risk, characterized in that: The system for calculating retail credit risk comprises: a memory, a processor, and a program for the method for calculating retail credit risk stored in the memory and executable on the processor. When the program for calculating retail credit risk is executed by the processor, the steps of the method for calculating retail credit risk as described in any one of claims 1 to 34 are implemented.
38. A computer storage medium, characterized in that The computer storage medium stores a program for calculating the retail credit risk method, and when the program for calculating the retail credit risk method is executed by the processor, the steps of the method for calculating the retail credit risk according to any one of claims 1 to 34 are implemented.
39. A method for constructing a retail credit risk prediction model for credit card and special installment business, comprising: A data collection step, which obtains the original retail credit prediction data of the sample used to build the model; A data derivation step, which processes derived retail credit forecast data based on the original retail credit forecast data; The feature initial screening step is to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening; The initial screening data conversion step is to judge the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and use the best method to convert each feature after the initial screening; The feature fine screening step is to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features; The credit default probability modeling step is to select the logistic regression method to build the model based on the relationship between the carefully screened features and the probability of credit default, and confirm the method used to calculate the credit default probability; The data samples obtained in the data collection step are samples of customers who have used credit card services and special installment services.
40. The method of claim 39, wherein: In the data collection step, the original retail credit prediction data of the samples obtained for building the model include: Credit card basic data, which is based on all available data during the sample user's credit card creation and usage process. Basic data on personal loans, which is all available data based on the loan application and usage behavior of sample users. Basic customer information data, which is based on the attributes of the sample users themselves but is not directly related to their behavior in financial institutions. Basic data on personal financial assets, which includes all other financial assets and financial transaction data of sample users in financial institutions that are not related to credit cards and loans.
41. The method of claim 39, wherein: In the data derivation step, the derived retail credit prediction data processed based on the original retail credit prediction data refers to data obtained by processing the collected original retail credit prediction data based on the time dimension, space dimension, frequency dimension, and statistical information dimension; Preferably, the derived retail credit forecast data includes but is not limited to: Derived retail credit forecast data obtained by processing based on sample relationship length, Derivative retail credit forecast data obtained by processing time interval variables, Derivative retail credit forecast data obtained by processing based on the frequency of sample behavior, Derivative retail credit forecast data obtained by processing the current time point of the sample, Derivative retail credit forecast data obtained by processing based on sample continuous behavior, Derived retail credit forecast data obtained by processing sample data based on statistical information dimensions.
42. The method according to any one of claims 39 to 41, wherein: The feature initial screening step includes the following steps: The first preliminary screening step is to screen the features based on the missing data of each feature of the sample used to build the model. The second initial screening step is to screen the features based on the fact that a single value of a feature sample is too high. The third preliminary screening step is to calculate the information IV value of each feature to perform preliminary screening of the features; The order of the first preliminary screening step, the second preliminary screening step and the third preliminary screening step can be any order. The fourth preliminary screening step uses a stepwise discrimination algorithm to perform preliminary screening of features after the first to third preliminary screenings; The fifth preliminary screening step is to conduct preliminary screening of the features after the fourth preliminary screening step based on the consistency between the risk characteristics of each feature itself and the actual real results of the samples used for model construction.
43. The method according to any one of claims 39 to 42, wherein: Also includes: The sample selection step is used to screen all users before the data collection step and obtain samples of credit card business and special installment business for model construction. Preferably, the sample selection step includes classifying all sample users based on a decision tree, and the classification basis includes but is not limited to: Whether a user is a customer who has applied for credit registration at a financial institution; Whether the account age of a certain user is greater than or equal to G1; Whether a user is a customer with overdue credit loans; Whether the current repayment rate of a certain user is less than a%.
44. The method according to any one of claims 39 to 43, wherein: In the initial screening data conversion step, the conversion method of the features after the initial screening is determined based on the concentration and data type of the features after the initial screening.
45. The method of claim 44, wherein: The initial screening data conversion step includes the following steps based on the judgment of concentration and data type: Classify the data type of each feature into character variables and numeric variables. For character variables, dummy feature conversion is used to perform initial screening data conversion. The process of further classifying numerical variables includes the following sub-steps: If the value of the numeric variable is less than n, the WOE conversion method is used to convert the initial screening data. If the value of the numerical variable is more than n, further judge if the value of the continuous variable is large and the concentration of a single value is greater than m%, then the WOE conversion method is used; if the concentration of a single value is less than or equal to m%, then the continuous conversion method is used. Preferably, n and m are both positive integers, wherein n=5-10, and m=90-99.
46. The method of claim 45, wherein: Also includes: For the features that are confirmed to adopt the continuous conversion method, the optimal conversion method is selected based on the correlation between the feature and credit default under different continuous conversion methods to perform the continuous feature conversion of the feature. Preferably, the continuous feature conversion is performed by directly selecting the original value, calculating the square of the original data, calculating the square root of the original data, calculating the cube root of the original data, or calculating the natural logarithm of the original data.
47. The method according to any one of claims 39 to 46, wherein: The feature fine screening steps include: The first fine screening step is to screen the features based on the stepwise regression algorithm, the F test and the T test to determine the significance of the features. The second fine screening step is to calculate the variance inflation factor based on each feature and eliminate the features with higher variance inflation factors to screen the features. The third fine screening step is to analyze the characteristics after the first fine screening step and the second fine screening step based on logistic regression to see whether the characteristic coefficients are consistent with the trend of the prediction results for credit default so as to further perform feature screening.
48. The method according to any one of claims 39 to 47, wherein: The credit default probability modeling step substitutes the features selected in the feature fine screening step into the Sigmoid function to perform logistic regression to calculate the credit default probability model.
49. A device for constructing a retail credit risk prediction model for credit card business and special installment business, characterized in that: The device comprises: A data collection module, which is used to obtain raw retail credit prediction data of samples used to build a model; A data derivation module, which is used to process derived retail credit forecast data based on the original retail credit forecast data; A feature initial screening module, which is used to perform initial screening on all categories, that is, all features, including the original retail credit forecast data and the derived retail credit forecast data, to obtain features after initial screening; The initial screening data conversion module is used to determine the conversion method of the features after the initial screening to confirm whether to use one of the WOE conversion method, the dummy feature conversion method and the continuous conversion method for feature conversion, and to use the best method for feature conversion for each feature after the initial screening; A feature fine screening module is used to perform in-depth screening on the initially screened features after feature conversion to obtain finely screened features; The credit default probability modeling module is used to select the logistic regression method to build a model based on the probability relationship between the finely screened features and credit default, and confirm the method used to calculate the credit default probability. The data samples obtained by the data collection module are customer samples who have used credit card services and special installment services.
50. The apparatus of claim 49, wherein: The device executes the steps of the method for constructing a retail credit risk prediction model as described in any one of claims 39 to 48.
51. A system for constructing a retail credit risk prediction model for credit card business, characterized in that: The system includes: a memory, a processor, and a program for constructing a retail credit risk prediction model stored in the memory and executable on the processor. When the program for constructing a retail credit risk prediction model is executed by the processor, the steps of constructing a retail credit risk prediction model as described in any one of claims 39 to 48 are implemented.
Citation Information
Patent Citations
A credit risk assessment method and apparatus based on logistic regression technology
CN112686749B