CN114764412A - Data processing method and device - Google Patents

Data processing method and device Download PDF

Info

Publication number
CN114764412A
CN114764412A CN202110046980.9A CN202110046980A CN114764412A CN 114764412 A CN114764412 A CN 114764412A CN 202110046980 A CN202110046980 A CN 202110046980A CN 114764412 A CN114764412 A CN 114764412A
Authority
CN
China
Prior art keywords
bond
data
day
code data
code
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110046980.9A
Other languages
Chinese (zh)
Inventor
黄树林
徐叶润
刘佩金
齐晓磊
陈思华
戴伟
张利平
吴锦伟
赵珠慧
万自强
常玉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jingdong Technology Holding Co Ltd
Original Assignee
Jingdong Technology Holding Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Jingdong Technology Holding Co Ltd filed Critical Jingdong Technology Holding Co Ltd
Priority to CN202110046980.9A priority Critical patent/CN114764412A/en
Publication of CN114764412A publication Critical patent/CN114764412A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2428Query predicate definition using graphical user interfaces, including menus and forms
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/10Complex mathematical operations
    • G06F17/18Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/06Asset management; Financial planning or analysis

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Mathematical Physics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Business, Economics & Management (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Mathematical Analysis (AREA)
  • Operations Research (AREA)
  • Software Systems (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Accounting & Taxation (AREA)
  • Computational Mathematics (AREA)
  • Pure & Applied Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Optimization (AREA)
  • Human Computer Interaction (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Algebra (AREA)
  • Fuzzy Systems (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Evolutionary Biology (AREA)
  • Game Theory and Decision Science (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application provides a data processing method and a data processing device, which are applied to the technical field of data processing, wherein the method comprises the following steps: receiving a first operation of a user on a computing control; responding to the first operation, displaying a first user interface, wherein the first user interface comprises a first input box for receiving code class data input and a second input box for receiving time class data input; receiving first code data input by a user in a first input box; receiving first time data input by a user in a second input box; determining a computational model of the first code data; and obtaining a calculation result according to the first time data and the calculation model. Therefore, the user can determine the calculation models corresponding to different investment projects by inputting the first code data related to the investment projects to be inquired, so that for different investment projects, the electronic equipment can automatically calculate corresponding calculation results by using different calculation models, and the calculation efficiency of the data and the accuracy of the calculation results are improved.

Description

Data processing method and device
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data processing method and apparatus.
Background
With the increasing of the economy of China, the living of residents changes day by day, with the increasing of the income of money, the personal economy and the capital economy are rapidly increased, and the financial management is also advanced to the living of the residents. In order to better increase the value of own money, people search for new investment projects. In the early stage of project investment, data analysis of the investment project is an important step, for example, calculating the corresponding interest and return rate due to the investment project.
Currently, investment project-based data is numerous and data types are very rich. People need to download data related to investment projects and perform calculation manually.
However, the method needs people to manually calculate the data related to the investment projects, the calculation efficiency is low, and the obtained calculation result is inaccurate.
Disclosure of Invention
The embodiment of the application provides a data processing method and a data processing device, a user can determine computing models corresponding to different investment projects by inputting first code data related to investment projects to be inquired, so that for different investment projects, electronic equipment can use different computing models to automatically compute corresponding computing results, and the computing efficiency of data and the accuracy of the computing results are improved.
In a first aspect, an embodiment of the present application provides a data processing method, including:
receiving a first operation of a user on a computing control;
responding to the first operation, displaying a first user interface, wherein the first user interface comprises a first input box for receiving code class data input and a second input box for receiving time class data input;
receiving first code data input by a user in the first input box;
receiving user-input first time data in the second input box;
determining a computational model of the first code data;
and obtaining a calculation result according to the first time data and the calculation model.
In one possible embodiment, the determining the computational model of the first code data comprises: and determining a calculation model of the first code data according to the data type of the first code data.
In one possible implementation, the receiving, in the first input box, first code data input by a user includes:
and receiving a coupon code, a balance bond code, a closed property support bond code, a closed bond code, a coupon code, an authorized bond code or an advance payment bond code input by a user in the first input box.
In a possible implementation, obtaining a calculation result according to the first time data and the calculation model includes:
inputting the first time data into a computational model of the first code data;
outputting the calculation result by utilizing a calculation model of the first code data;
wherein the calculation comprises one or more of: interest accrued, bond full price, return to maturity rate.
In a possible embodiment, the receiving, in the second input box, the first time data input by the user includes:
receiving a second operation of the user on the second input box;
displaying a calendar interface for a user to select a date in response to the second operation;
receiving a selection operation of a user on first time data in the calendar interface;
in response to the selection operation, displaying the first time data in the second input box.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type of the first code data is a coupon, determining a calculation model of the first code data as:
Figure BDA0002897652020000021
the AI is the accrued interest amount of the attached information bond per hundred yuan of face value, the C is annual interest per hundred yuan of face value, the t is the actual days from the rest day or the last paying day to the settlement day, the settlement day is the first time data, the f is annual paying frequency, and the TS is the actual days of the paying period.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type corresponding to the first code data is a null-information bond, determining that a calculation model of the first code data is as follows:
Figure BDA0002897652020000022
the method comprises the steps of obtaining a balance of interest of a balance bond, obtaining a balance of interest of the balance bond, obtaining AI and TY, obtaining the balance of interest of the balance bond, obtaining the AI and the balance of interest of the balance bond, obtaining the T and the balance of the balance bond, and obtaining the TY and the balance of the balance bond.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type corresponding to the first code data is a cash-attached bond, determining a calculation model of the first code data as
Figure BDA0002897652020000031
Wherein the AI is the accrued interest amount of the close bond per hundred yuan face value; m is the due cash payment amount of the face value of each hundred yuan, t is the actual days from the rest date or the last rest date to the settlement date, the settlement date is the first time data, and P isdAnd T is the actual days from the rest date to the due exchange date for issuing the bond.
In one possible embodiment, the determining a computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is the coupon, determining a calculation model of the first code data as
Figure BDA0002897652020000034
The AI is the accrued interest amount of the closed bond per hundred yuan of face value, the C is annual interest per hundred yuan of face value, the t is the actual days from the rest day or the last interest day to the settlement day, the settlement day is the first time data, the TY is the actual days of the rest year of the rest period, and the m is the current residual principal value of the face value per hundred yuan.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type corresponding to the first code data is a coupon in the last paying cycle, a zero-information bond with a waiting period within one year and less and/or a discount bond with a waiting period within one year and less, determining that the calculation model of the first code data is as follows:
Figure BDA0002897652020000032
wherein, the y is the return rate due, and the FV is the sum of the bond instinct due and redeemed on the day; when the data type corresponding to the first code data is the coupon in the last paying period, the first code data is used for storing the coupon
Figure BDA0002897652020000033
When the data type corresponding to the first code data is a zero-information bond with the waiting period within one year, the FV is M + NxC; when the data type corresponding to the first code data is a discount bond with the waiting-for-payment period within one year, the FV is M; the D is the remaining number of circulation days from the bond settlement date to the bond redemption date, the PV is the bond full price, the f is the annual payment frequency, the TY is the actual number of days of the interest bearing year, and the M is the bond face value of the coupon at the last payment cycle, the receipt within one year and less and/or the close bond within one year and less.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type corresponding to the first code data is a zero-information bond with a waiting period of more than one year and a discount bond with a waiting period of more than one year, determining a calculation model of the first code data as follows:
Figure BDA0002897652020000041
wherein, the y is the return rate due, and the FV is the sum of the intrinsic money of the bond on the due cash-out date; when the data type corresponding to the first code data is a zero-information bond with the waiting period within one year, the FV is M + NxC; when the data type corresponding to the first code data is a closed bond with a waiting period of more than one year, FV is M, M is the whole year from a settlement date to an expired redemption date, the settlement date is the first time data, PV is the full price of the bond, and TY is the actual days of the interest-counting year.
In one possible embodiment, the determining a computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is the coupon which is not in the last paying period, determining the calculation model of the first code data as
Figure BDA0002897652020000042
Figure BDA0002897652020000043
The method comprises the steps of obtaining a total price of the attached bonds which are not in the last paying period, obtaining a face value annual interest per hundred yuan, obtaining a annual paying frequency, obtaining a TS (transport stream) of the paying period, obtaining a d of the attached bonds from a settlement day to the next paying day, obtaining a n of the paid bonds from the settlement day to an expired redemption day, obtaining a first time data from the settlement day, and obtaining an expiration rate of the attached bonds which are not in the last paying period.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type corresponding to the first code data is a right-bearing bond, determining that a calculation model of the first code data is as follows:
Figure BDA0002897652020000044
the method comprises the steps of obtaining a right-bearing bond, PV, n, TS, d and C, wherein PV is the bond full price of the right-bearing bond, y is the return rate due to the right-bearing bond, C is annual interest per hundredth of face value, n is the bond paying times of the next paying day from a settlement day to a right-of-way day, the settlement day is first time data, TS is the actual days of a paying cycle, and d is the days from the settlement day to the next paying day.
In a possible embodiment, the determining a computational model of the first code data according to the data type of the first code data includes:
when the data type corresponding to the first code data is the bond paid in advance, determining that the calculation model of the first code data is as follows:
Figure BDA0002897652020000051
wherein the AI is the accrued interest amount of the bond paid back in advance per hundred yuan face value, and the AI is0V is the sum of the issued advance payment bond, Vj is the payment amount of each paying day, and Σ V isjIs the sum of all the repayment amounts of the repayment days which are less than or equal to the settlement days.
Alternatively, the first and second electrodes may be,
Figure BDA0002897652020000052
PV is bond full price of the bond for paying the bond in advanceM is the face value of the prior-payment bond for field maintenance, Vi is the payment amount of the ith paying day from the settlement day, V is the total amount issued by the bond for field maintenance, and CiFor the nominal annual interest corresponding to the ith paying day from the settlement day,
Figure BDA0002897652020000053
wherein, the Ci0The nominal annual interest of the ith paying cycle calculated according to the calculation rule without the prior payment bond, V is the total amount of issued bonds, Σ Vj is the sum of all the paying amounts of the paying days smaller than the paying day, y is the return rate of the prior payment bond, C is the annual interest per hundred yuan, n is the paying times of the bonds on the next paying day from the settlement day to the right of execution day, the settlement day is the first time data, TS is the actual days of the paying cycle, and d is the days from the settlement day to the next paying day.
In one possible implementation, the calculation result includes: interest accrued, full rate, and/or return to maturity rate.
In a second aspect, an embodiment of the present application provides a data processing apparatus, where the apparatus includes: the device comprises a processing module and a display module;
the processing module is used for receiving a first operation of a user on the computing control;
the processing module is further configured to respond to the first operation;
the display module is used for displaying a first user interface, and the first user interface comprises a first input box used for receiving code class data input and a second input box used for receiving time class data input;
the processing module is further used for receiving first code data input by a user in the first input box;
the processing module is further used for receiving first time data input by a user in the second input box;
the processing module is further used for determining a calculation model of the first code data;
the processing module is further configured to obtain a calculation result according to the first time data and the calculation model.
In a possible implementation, the processing module is further configured to determine a calculation model of the first code data according to a data type of the first code data.
In a possible implementation, the processing module is further configured to receive a coupon code, a closed bond code, a closed property support bond code, a closed bond code, an authorized bond code, or a pre-paid bond code, which is input by a user, in the first input box.
In a possible embodiment, the processing module is further configured to input the first time data into a calculation model of the first code data;
the processing module is further used for outputting the calculation result by utilizing the calculation model of the first code data;
wherein the calculation comprises one or more of: interest accrued, bond full price, return rate due.
In a possible implementation manner, the processing module is further configured to receive a second operation of the second input box by the user;
the processing module is further configured to respond to the second operation;
the display module is also used for displaying a calendar interface used for selecting a date by a user;
the processing module is further used for receiving selection operation of a user on first time data in the calendar interface;
the processing module is further configured to display the first time data in the second input box in response to the selection operation.
In a possible implementation, the processing module is further configured to determine, when the data type of the first code data is a coupon, that the calculation model of the first code data is:
Figure BDA0002897652020000061
the AI is the accrued interest amount of the attached information bond per hundred yuan of face value, the C is annual interest per hundred yuan of face value, the t is the actual days from the rest day or the last paying day to the settlement day, the settlement day is the first time data, the f is annual paying frequency, and the TS is the actual days of the paying period.
In a possible implementation manner, the processing module is further configured to determine, when the data type corresponding to the first code data is a null bond, that the calculation model of the first code data is:
Figure BDA0002897652020000062
the method comprises the steps of obtaining a balance bond, wherein AI is the accrued interest amount of the balance bond per hundred yuan of face value, C is annual interest per hundred yuan of face value, t is the actual days from the interest starting date or the last interest paying date to the settlement date, K is the whole years from the interest starting date to the settlement date of the bond, and TY is the actual days of the accrued years.
In a possible implementation manner, the processing module is further configured to determine that the calculation model of the first code data is "closed bond" when the data type corresponding to the first code data is closed bond
Figure BDA0002897652020000071
Wherein the AI is the accrued interest amount of the close bond per hundred yuan face value; m is the due exchange payment amount of the face value of each hundred yuan, t is the actual days from the rest day or the last rest day to the settlement day, the settlement day is the first time data, and PdAnd T is the actual days from the rest date to the due exchange date for issuing the bond.
In a possible implementation manner, the processing module is further configured to determine that the calculation model of the first code data is "data type" when the data type corresponding to the first code data is a coupon
Figure BDA0002897652020000072
The AI is the accrued interest amount of the closed bond per hundred yuan of face value, the C is annual interest per hundred yuan of face value, the t is the actual days from the rest day or the last interest day to the settlement day, the settlement day is the first time data, the TY is the actual days of the rest year of the rest period, and the m is the current residual principal value of the face value per hundred yuan.
In a possible embodiment, the processing module is further configured to determine that the calculation model of the first code data is:
Figure BDA0002897652020000073
wherein, the y is the return rate due, and the FV is the sum of the bond instinct due and redeemed on the day; when the data type corresponding to the first code data is the coupon in the last paying period, the first code data is used for storing the coupon
Figure BDA0002897652020000074
When the data type corresponding to the first code data is a zero-information bond with the waiting period within one year, the FV is M + NxC; when the data type corresponding to the first code data is a discount bond with the waiting-for-payment period within one year, the FV is M; d is the remaining circulation days from the settlement date of the bonds to the redemption date of the bonds, the settlement date is the first time data, PV is the full price of the bonds, f is the annual paying frequency, TY is the actual days of the interest-bearing years, and M is the bond face value of the coupon in the last paying period, the zero-information bonds with the period to be paid within one year and less and/or the close-up bonds with the period to be paid within one year and less.
In a possible implementation manner, the processing module is further configured to, when the data types corresponding to the first code data are a zero-coupon bond with a paid-out period of more than one year and a close-up bond with a paid-out period of more than one year, determine that the calculation model of the first code data is:
Figure BDA0002897652020000075
wherein, the y is the return rate due, and the FV is the sum of the bond instinct due and redeemed on the day; when the data type corresponding to the first code data is a zero-information bond with the waiting period within one year, the FV is M + NxC; when the data type corresponding to the first code data is a closed bond with a waiting period more than one year, the FV is M, the M is the whole year from a settlement date to an expired redemption date, the PV is the full price of the bond, and the TY is the actual days of the interest-bearing year.
In a possible embodiment, the processing module is further configured to determine that the calculation model of the first code data is a calculation model of a data type of a coupon that is not in a last paying cycle when the data type corresponding to the first code data is a coupon
Figure BDA0002897652020000081
The method comprises the steps of obtaining a total price of the attached bonds which are not in the last paying period, obtaining a face value annual interest per hundred yuan, obtaining a annual paying frequency, obtaining a TS (transport stream) of the paying period, obtaining a d of the attached bonds from a settlement day to the next paying day, obtaining a n of the paid bonds from the settlement day to an expired redemption day, obtaining a first time data from the settlement day, and obtaining an expiration rate of the attached bonds which are not in the last paying period.
In a possible implementation manner, the processing module is further configured to determine, when the data type corresponding to the first code data is a bond with a right, that the calculation model of the first code data is:
Figure BDA0002897652020000082
the PV is the bond full price of the entitled bond, the y is the return rate due to the entitled bond, the C is annual interest per hundredth, the n is the bond paying times of the next paying day from the settlement day to the right-of-way day, the TS is the actual days of the paying cycle, and the d is the days from the settlement day to the next paying day.
In a possible implementation manner, the processing module is further configured to, when the data type corresponding to the first code data is an early bond payment, determine that a calculation model of the first code data is:
Figure BDA0002897652020000083
wherein the AI is the accrued interest amount of the bond paid back in advance per hundred yuan face value, and the AI is0V is the sum of the issued advance payment bond, Vj is the payment amount of each paying day, and Σ V isjIs the sum of all the repayment amounts of the repayment days which are less than or equal to the settlement days.
Alternatively, the first and second electrodes may be,
Figure BDA0002897652020000084
PV is the bond full price of the prior repayment bond, M is the face value of the prior repayment bond maintained by the field affairs, Vi is the repayment amount of the ith paying day from the settlement day, V is the total amount issued by the bond maintained by the field affairs, and CiFor the nominal annual interest corresponding to the ith paying day from the settlement day,
Figure BDA0002897652020000085
wherein, the Ci0The nominal annual interest of the ith paying period calculated according to the calculation rule without the prior repayment bond, V is the total amount issued by the bond, sigma Vj is the sum of all repayment amounts of the paying day smaller than the paying day, y is the rate of return due of the prior repayment bond, C is the annual interest of the face value of each hundred yuan, and n is the settlement day to the nominal annual interest of the settlement dayAnd paying times of bonds on a paying day next to the right-of-bank day, wherein the settlement day is the first time data, TS is the actual days of the paying cycle, and d is the days from the settlement day to the next paying day.
In one possible implementation, the calculation result includes: interest accrued, full rate, and/or return to maturity.
In a third aspect, an embodiment of the present application provides an electronic device, including: a memory and a processor. A memory for storing program instructions; a processor for calling and executing program instructions in said memory to perform a method as described in any of the above.
In a fourth aspect, the present application provides a computer-readable storage medium, in which a computer program is stored, and when the computer program is executed by a processor, the method is implemented as described in any one of the above.
The embodiment of the application provides a data processing method and device, and after receiving and responding to a first operation of a user on a computing control, a first user interface comprising a first input box for receiving code class data input and a second input box for receiving time class data input can be displayed. Determining a calculation model of the first code data by receiving the user-input first code data in the first input box and receiving the user-input first time data in the second input box. The user can determine the calculation models corresponding to different investment projects by inputting the first code data related to the investment projects to be inquired, so that the electronic equipment can automatically calculate corresponding calculation results by using different calculation models for different investment projects, and the calculation efficiency of the data and the accuracy of the calculation results are improved.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and, together with the description, serve to explain the principles of the disclosure.
Fig. 1 is a schematic diagram of an application scenario provided in an embodiment of the present application;
fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present application;
fig. 3 is a schematic diagram of a user login interface according to an embodiment of the present application;
FIG. 4 is a schematic diagram of a user interface provided by an embodiment of the present application;
FIG. 5 is a schematic diagram of a user interface provided by an embodiment of the present application;
FIG. 6 is a schematic diagram of a first user interface provided by an embodiment of the present application;
FIG. 7 is a schematic diagram of a first user interface provided by an embodiment of the present application;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
With the foregoing drawings in mind, certain embodiments of the disclosure have been shown and described in more detail below. The drawings and written description are not intended to limit the scope of the disclosed concepts in any way, but rather to illustrate the disclosed concepts to those skilled in the art by reference to specific embodiments.
Detailed Description
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. The following description refers to the accompanying drawings in which the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.
With the increasing of the economy of China, the living of residents also changes day by day, and with the increasing of the income of money, the personal economy and the stockmaking economy are rapidly increased, and the financial management is also carried forward to the living of the residents. In order to better increase the value of own money, people search for new investment projects. Data analysis of an investment project is an important step in the early stages of project investment, for example, calculation of the interest due and return rate due for the investment project.
Currently, investment project-based data is numerous and data types are very rich. People need to download data related to investment projects by themselves and perform calculation manually.
However, the method needs people to manually calculate the data related to the investment projects, the calculation efficiency is low, and the obtained calculation result is inaccurate.
In view of the foregoing problems, embodiments of the present application provide a data processing method that, after receiving and responding to a first operation of a computing control by a user, may display a first user interface including a first input box for receiving input of code class data and a second input box for receiving input of time class data. A calculation model of the first code data is determined by receiving the first code data input by a user in a first input box and receiving the first time data input by the user in a second input box. The user can determine the calculation models corresponding to different investment projects by inputting the first code data related to the investment projects to be inquired, so that the electronic equipment can automatically calculate corresponding calculation results by using different calculation models for different investment projects, and the calculation efficiency of data and the accuracy of the calculation results are improved.
Fig. 1 is a schematic diagram of an application scenario provided in an embodiment of the present application. As shown in fig. 1, the application scenario provided by this embodiment may include: a user 101, a terminal 102, a server 103, and a data center 104; the data center stores basic information of various types of bonds, such as annual paying frequency of the bonds, bond issuing price and the like. The method comprises the steps that a terminal 102 receives an instruction of a user 101 for opening a first user interface, the first user interface comprising a first input box for receiving code class data and a second input box for receiving time class data input is displayed, after first code data input in the first input box by the user 101 and first time data input in the second input box are received, a data acquisition request is sent to a data center 104 by a server 103, so that basic information of bonds is acquired in the data center, the server 103 processes the acquired data by using a corresponding calculation model to obtain a calculation result, and the processed result is displayed in the terminal 102. The terminal 102 may be: cell-phone, desktop computer, desk-top all-in-one, panel computer, intelligent wrist-watch, intelligent bracelet, smart glasses and other terminal equipment that possess the display screen etc. this embodiment of this application does not limit to.
The technical solution of the present application will be described in detail by specific examples. It should be noted that the following specific embodiments may be combined with each other, and the same or similar concepts or processes may not be described in detail in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
Fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present disclosure. As shown in fig. 2, the data processing method may include the steps of:
s201: a first operation of a computing control by a user is received.
In a possible implementation manner, the first operation may be a single-click operation or a double-click operation after the user moves the mouse cursor to the computation control, and the computation control may be triggered by the first operation. It is understood that the first operation may include other contents according to an actual scenario, which is not limited in the embodiment of the present application.
In a possible implementation, the user may find the computation control through some operations. For example, the user may log in to the system through an account number, a password, or other manners, where fig. 3 is a schematic diagram of a system login interface. After the user finishes logging in with a certain account, the electronic device may display a user interface as shown in fig. 4, where the user interface includes a menu 401, where the menu 401 includes a consulting research menu 4011, a video menu 4012, an intelligent data menu 4013, a policy tool menu 4014, an analysis calculation menu 4015, a trading center menu 4016, and the like).
As shown in fig. 4, the first user interface may include other controls or modules besides the menu 401, such as: a modification control 402, a user control 404, an all display control 404, a module 405, a module 406, a module 407, a module 408, a module 409, or a module 410.
The modification control 402 is used for executing various types of operations such as deleting, adding or changing the sequence of the title content in the menu 401 according to the user requirement. For example, the user may adjust the order of the title contents in the menu 411 by mouse dragging.
User controls 403 are used to implement other functions such as displaying user information, changing the system skin, or exiting the system.
The modules 405, 406, 407, 408, 409 and 410 are used to display the graphics context information corresponding to each function provided by the system.
Upon receiving a user operation on the parse calculation menu 4015, a user interface, as shown in fig. 5, may be displayed in which the calculation control may be the bond calculator 501.
S202: in response to the first operation, a first user interface is displayed.
In a possible implementation manner, the calculation control is provided with a jump link, and after responding to a first operation of a user on the calculation control, the electronic device may display a first user interface.
In the embodiment of the application, the first user interface comprises a first input box for receiving code class data input and a second input box for receiving time class data input.
For example, fig. 6 is a schematic diagram of a first user interface provided in an embodiment of the present application. As shown in fig. 6, the first user interface includes a first input box 601 and a second input box 602. Wherein, the first input box 601 can be used for receiving the input of the bond code data to be queried, and the second input box 602 can be used for inputting the time class data.
As shown in fig. 6, the first user interface may include other menu bars and display boxes besides the first input box 601 and the second input box 602, for example: a bond calculator menu bar 603, a basic information menu bar 604, a risk measurement menu bar 605, a settlement information menu bar 606, a bond abbreviation display box 603 and the like.
The menu bar 603 of the bond calculator includes a plurality of display frames for displaying the calculation results. For example, the due rate display box 608 is used for displaying the calculation result of the due rate of the bond corresponding to the first code data, and the accrued interest display box 609 is used for displaying the calculation result of the emergency interest of the bond corresponding to the first code data.
The basic information menu bar 604 includes a plurality of display frames for displaying basic information of the bond corresponding to the first code data, such as the date of interest, interest rate type, nominal interest rate, due date, latest face value, etc. of the bond, the basic information is data obtained from the official after the bond is issued, each type of bond corresponds to respective basic information, for example, the date of interest of 16 ford car 01 is 2016, 8, 4, 8, the nominal interest rate is 0.0318, the date of due is 2019, 8, 4, and the latest face value is 100. After the data are acquired, the data are stored in the database, so that after the first code data input by the user are received, the database can be inquired for the relevant data of the bond corresponding to the first code data.
The risk measurement menu bar 605 includes a plurality of display boxes for displaying data corresponding to bonds, such as mai jiu, correction jiu and credit line difference.
The settlement information menu bar 606 includes a plurality of display boxes for displaying data such as settlement net price, calculation full price, total amount of emergency interest, intermediary fee, total amount of settlement and transaction fee.
The bond abbreviation display box 607 is used for displaying the bond name corresponding to the first code data.
It can be understood that, in addition to the display frame, the input frame, and the menu bar, the first user interface may further include other display frames, input frames, and menu bars, which are not described in detail in this embodiment of the present application.
S203: first code data input by a user is received in a first input box.
In the embodiment of the present application, the first code data may be code data corresponding to a bond to be queried by the user, for example, a coupon code, a loose bond code, a closed asset support bond code, a closed bond code, an authorized bond code, or an advance repayment bond code.
In a possible implementation, the electronic device may receive a coupon code, a closed bond code, a closed asset support bond code, a closed bond code, a coupon code, a right bond code, or a pay-ahead bond code, which is input by the user, in the first input box.
For example, if the user wants to query the data corresponding to the bond a, if the bond a is a bond paid back in advance and the corresponding code data is 1621005.IB, the user input first code data 1621005.IB may be received in the first input box. In a possible implementation manner, a user may input the first code data into the first input box by a keyboard input or a voice input, which may be understood that the user may also input the first code data into the first input box by other manners, and the embodiment of the present application is not limited in particular.
In a possible implementation manner, after receiving the first code data input by the user, the bond abbreviation display box 607 may display a bond name corresponding to the first code data, for example, as shown in fig. 7, if the first code data input by the user in the first input box 601 is 1622011.IB, the bond abbreviation display box 603 displays a bond name B.
S204: first time data input by a user is received in a second input box.
In a possible implementation manner, after receiving and responding to the second operation of the second input box 602 by the user, the electronic device may display a calendar interface for the user to select a date, and after receiving and responding to the selection operation of the first time data in the calendar interface by the user, the electronic device may display the first time data in the second input box.
Illustratively, upon receiving and responding to a second operation by the user on the second input box 602, the electronic device may display a calendar interface 611 for the user to select a date, as shown in FIG. 7. When the user selects the first time data in the calendar interface 611 as 2019, 8, month and 2, the electronic device receives and responds to the selection operation of the user on the first time data in the calendar interface 611, and the electronic device can display the first time data 2019-08-02 in the second input box.
In a possible implementation manner, the second operation may be a single-click operation or a double-click operation after the user moves the mouse cursor to the second input box, and the second input box may be triggered by the first operation. It is understood that the first operation may include other contents according to an actual scenario, which is not limited in the embodiment of the present application.
In this embodiment, the first time data may be a date that the user wants to query. For example, if the user wants to query for interest accrued on 9/8 day bonds, the first time data may be 9/8 day.
In a possible implementation manner, the user can click the date to be queried through a mouse and input the first time data in the second input box. The user may also input the first time data into the second input box in other manners, which is not limited in this application embodiment.
S205: a computational model of the first code data is determined.
In a possible implementation, the calculation model of the first code data may be determined according to a data type of the first code data.
For example, if the first code data input by the user in the first input frame is 1622011.IB, it may be determined that the bond corresponding to 1622011.IB is a coupon bond, and it is determined that the calculation model of the first code data is the calculation model corresponding to the coupon bond.
S206: and obtaining a calculation result according to the first time data and the calculation model.
In the embodiment of the present application, the calculation result includes: accrued interest, bond full price, and/or return to maturity. Wherein, the bond full price is bond net price + accrued interest.
In a possible implementation, the first time data is input into the calculation model of the first code data, and the calculation result is output by using the calculation model of the first code data.
It can be understood that, by obtaining the basic information of the bond corresponding to the first code data and the calculation model in the database, the calculation result is obtained according to the first time data input by the user.
In a possible implementation, the user may view the calculation result through a visualization interface.
Illustratively, as shown in fig. 7, the first code data input by the user in the first input box is 1622011.IB, the calculation result of the return rate due of the bond corresponding to the first code data can be displayed in the return rate due display box 608 as 208599%, the calculation result of the emergency interest of the bond corresponding to the first code data can be displayed in the interest accrued display box 609 as 3.61233, and the calculation result of the full price of the bond corresponding to the first code data is displayed in the full price display box 610 as 103.1638 ten thousand yuan.
In a possible implementation manner, the accuracy of the calculation result is related to the interest level, and in order to obtain the calculation result more accurately, the interest level provided by the present application is introduced below.
In a possible implementation manner, the interest bearing reference may be an actual number of interest bearing days/actual basis of interest bearing, for example, if the date of interest bearing is 1/2012, the date of first payment is 5/1/2012, and the total 366 days in leap year is 2012, the reference of interest bearing is 121/366.
In a possible implementation, the interest base may be the actual number of days/365 of interest, where the number is calculated every year for 365 days. For example, if the date of the rest is 2012, 1 month and 1 day, the date of the first payment is 2012, 5 months and 1 day, and 2012 is leap year for 366 days, the rest count is 121/365.
In a possible implementation, the interest base may be an actual number of days/360 of interest, where 360 days are counted each year. For example, if the date of rest is 1/2012, the date of first payment is 5/1/2012, and the year of 2012 is leap year for 366, the rest criterion is 121/360.
In a possible implementation, the rest criteria may be (actual rest-1 days)/365 f, where the day of leap year 2 month 29 is removed from the actual rest days. For example, the date of the rest is 2/29/2012, the date of the first payment is 3/6/2012, and the dates from 29/3 to 6/7, but the leap year is 2012, and the rest is (7-1)/360.
In a possible implementation, the resting criterion is 30/360 if the actual number of resting days is one month. And when the actual number of the rest days is less than one month, the rest reference is the actual number of the rest days/360.
In an embodiment of the application, after receiving and responding to a first operation of a computing control by a user, a first user interface including a first input box for receiving code class data input and a second input box for receiving time class data input may be displayed. By receiving the user-input first code data in the first input box and the user-input first time data in the second input box, a calculation model of the first code data can be determined. Therefore, the user can determine the calculation models corresponding to different investment projects by inputting the first code data related to the investment projects to be inquired, so that the corresponding calculation results can be automatically calculated according to the calculation models corresponding to the different investment projects, and the calculation efficiency of the data and the accuracy of the calculation results are improved.
On the basis of the corresponding embodiment of fig. 2, in one possible implementation manner, when the data type of the first code data is a coupon, the calculation model of the first code data is determined to be
Figure BDA0002897652020000151
In the embodiment of the present application, the coupon bonds may include a coupon bond in the last payment cycle and a coupon bond not in the last payment cycle, wherein the coupon bonds include a fixed rate bond and a floating rate bond.
In the embodiment of the application, AI is the accrued interest amount of the per-hundredth face value attaching bond, C is the annual interest of the per-hundredth face value, t is the actual days from the rest day or the last interest day to the settlement day, the settlement day is the first time data, f is the annual interest paying frequency, and TS is the actual days of the interest paying period.
In a possible implementation, if the first code data type is a payment bond in the last payment cycle, the calculation model of the first code data may be determined as
Figure BDA0002897652020000161
Wherein the content of the first and second substances,
Figure BDA0002897652020000162
d is the remaining number of days of circulation from the date of bond settlement to the date of bond redemption, the date of settlement is the first time data, PV is the bond full price, f is the annual pay frequency, TY is the number of days in the interest bearing year, and M is the bond face value of the bond in the last interest bearing cycle.
Illustratively, if the first code data input by the user in the first input box is 1622011.IB, it can be determined that the data type of the first code data is a payment bond for the last payment cycle, and is a fixed rate bond, basic information of the 16 ford car 01 corresponding to the first code data 1622011.IB can be obtained in the database, for example, when the interest-starting date is 2016, 8, 4, and the due date is 2019, 8, 4, and the buying date is 2019, 3, 21, and the annual interest frequency f is 1, the bond face value M is 100, and when the interest-calculating basis is 30/360, the number of actual days TS of the paying cycle is 360, the number of actual days TY of the interest-bearing year is 360, the number of remaining days D of circulation from the bond buying date to the bond expiration date is 133 days, the number of actual days t from the interest starting date to the settlement date is 227 days, from the foregoing data, it can be seen that the accrued interest AI is 2.005166667 and the return to maturity y is 5.8282%. Among them, official supply of accrued interest 2.00517 and return to maturity rate 5.8282%.
In a possible implementation manner, if the type of the first code data is the payment bond not in the last payment period and the payment bond belongs to the bond with the fixed interest rate, the calculation model of the first code data can be determined as
Figure BDA0002897652020000163
Wherein PV is the total price of the attached bonds not in the last paying period, C is annual interest per hundred yuan, f is annual paying frequency, TS is the actual days of the paying period, d is the days from the settlement day to the next paying day, n is the paying times of the bonds from the settlement day to the due exchange day, and y is the return rate due to the attached bonds not in the last paying period.
Illustratively, if the first code data entered by the user in the first input box is 1722017.IB, it can be determined that the data type of the first code data is a payment bond for a non-last payment period, and is a fixed rate bond, the basic information of the 17 ford car 02 corresponding to the first code data 1722017.IB can be obtained in the database, for example, the daily interest-bearing date is 2017, 6 and 12, the due date is 2020, 6 and 12, the buying date is 2019, 3 and 21, the annual interest-paying frequency f is 1, the bond face value M is 100, if the interest-bearing basis is 30/360, the number of actual days TS of the payoff cycle is 360, the number of actual days TY of the due year is 360, the number of days d from the settlement day to the next payoff day is 81 days, the number of actual days t from the settlement day to the origin day is 229 days, from the foregoing data, it can be seen that the accrued interest AI is 4.1695 and the return to maturity y is 6.2281%. Among them, official supply of accrued interest 4.1695 and return to maturity rate 6.2281%.
In a possible implementation manner, if the data type corresponding to the first code data is a payment bond not in the last payment period, and the payment bond belongs to a floating rate bond, the calculation model of the first code data may be determined as:
Figure BDA0002897652020000171
wherein PV is the full price of the coupon not in the last payoff cycle, CiThe annual interest per hundredth of face value, f the annual paying frequency, TS the actual days of the paying cycle, d the days from the settlement day to the next paying day, n the paying times of bonds from the settlement day to the due exchange day, the settlement day is the first time data, and y the due yield of the attached bonds not in the last paying cycle.
In a possible understanding, because the bond interest rate of a floating-rate bond will periodically float with the market interest rate, it is understood that the bond interest rate may be varied and adjusted during the payback period, and the interest rate of a floating-rate bond is typically determined based on the market-referenced interest rate plus some margin. Following several different CiThe calculation of (a) is described.
In a possible implementation, the nominal interest rate of the payoff period can be calculated using the latest effective reference interest rate value in the system based on the value displayed in the reference interest rate window under the current logic, and the nominal interest rate and the initial interest rate C are calculated1On the basis of which the nominal annual interest C of the payment period is calculated2-Cn. In the calculation process, related factors such as the upper and lower limits of interest rate, the reference interest rate precision and the like need to be considered,
in a possible implementation, if C1The payment day is equal to the payment day of the payment period of the current transaction day, the current nominal interest rate is used for calculating nominal annual interest Ci
In a possible implementation, if C1If the payment day of (1) is greater than the payment day of the payment period of the current transaction day, the same calculation as above is used2-CnThe same rules are used to calculate the nominal interest rate value for the nominal annual interest, for example, the nominal interest rate for the payoff period is calculated using the most recently validated nominal interest rate value in the system, which is based on the value displayed in the current logical nominal interest rate window. In this case, the calculation of interest accrued requires modification using C as determined by the present rules1Replacing C in the original accrued interest formula.
In the embodiment of the application, the coupon bonds are divided into the coupon bonds in the last payment period and the coupon bonds not in the last payment period, and different calculation models are used for calculating different types of the coupon bonds, so that the obtained calculation result is approximate to data provided by an official party, and the accuracy is high.
On the basis of the embodiment corresponding to fig. 2, in a possible implementation manner, when the data type corresponding to the first code data is a null bond, determining a calculation model of the first code data as:
Figure BDA0002897652020000172
the method comprises the steps of obtaining a total amount of interest of a bond, wherein AI is the accrued interest amount of the bond, C is annual interest, t is the actual days from the rest day or the last interest day to the settlement day, the settlement day is first time data, K is the whole year from the rest day to the settlement day, and TY is the actual days of the accrued year.
In the embodiment of the application, the loose bonds can comprise loose bonds with a period of payment more than one year and loose bonds with a period of payment within one year.
In a possible implementation manner, when the pending payment period is more than one year of the retail bond, the calculation model for determining the first code data is as follows:
Figure BDA0002897652020000181
wherein y is the return rate due, FV is the sum of the money of the bond on the redemption date due, FV is M + NxC, M is the whole year from the settlement date to the redemption date due, PV is the full price of the bond, and TY is the actual days of the interest-bearing year.
In a possible implementation manner, when the data type corresponding to the first code data is a retail bond with a waiting period within one year, determining a calculation model of the first code data as follows:
Figure BDA0002897652020000182
wherein, y is the return rate due, FV is the sum of the bond instinct on the due redemption date; FV + N × C; (ii) a D is the remaining circulation days from the bond settlement date to the bond redemption date, the settlement date is the first time data, C is the annual interest per hundred yuan face value, PV is the bond full price, f is the annual interest frequency, TY is the actual days of the interest bearing year, and M is the bond face value of the free bond with the period to be paid more than one year.
For example, if the first code data input by the user in the first input box is 111417003.IB, and the data type of the first code data is determined to be a zero-interest bond whose waiting period is within one year, basic information of CD003 optically large to the bond 14 corresponding to the first code data 111417003.IB, for example, the rest date is 2014, 7, 30, the expiration date is 2015, 1, 30, the buy date is 2015, 1, 22, the face value M of the bond is 100, the whole number of years K from the rest date to the settlement date of the bond is 0, the annual interest C per hundred yuan is 4.72, if the rest base is actual number of interest/360, the actual number of days TS of the rest period is 360, the actual number of days of rest from the buy date to the expiration date of the bond is 176, and the rest number of days t from the purchase date to the expiration date of the bond is 8 days, the actual number of days of rest day t to 176, according to the foregoing data, the accrued interest AI can be found to be 2.307555556 and the return to maturity y is 49.7599%. Among them, official supply of accrued interest 2.307556 and return to maturity rate 49.7599%.
In the embodiment of the application, the loose bonds are divided into the loose bonds with the waiting period within one year and less and the loose bonds with the waiting period more than one year, and different calculation models are used for calculating different types of loose bonds, so that the obtained calculation result is approximate to data provided by an official, and the accuracy is high.
On the basis of the embodiment corresponding to fig. 2, in a possible implementation manner, when the data type corresponding to the first code data is a closed bond, determining a calculation model of the first code data as:
Figure BDA0002897652020000183
wherein, AI is the accrued interest amount of each hundred yuan face value of the closed bond; m is the face value due exchange payment per hundred yuan, t is the actual days from the rest day or the last rest day to the settlement day, the settlement day is the first time data, PdT is the actual number of days from the rest date to the due redemption date for the bond issuance price.
In the embodiment of the present application, the discount bonds may include discount bonds whose pending payment is more than one year and discount bonds whose pending payment is within one year.
In a possible implementation manner, when the data type corresponding to the first code data is a closed bond with a waiting period of more than one year, determining a calculation model of the first code data as follows:
Figure BDA0002897652020000191
wherein, y is the return rate due, FV is the sum of the bond instinct on the due redemption date; the method comprises the following steps that FV is M, M is the whole year from a settlement day to an expired redemption day, the settlement day is first time data, M is an expired redemption amount of each hundred yuan face value, PV is a bond full price, and TY is the actual days of the interest-bearing year.
In a possible implementation manner, when the data type corresponding to the first code data is a discount bond with a waiting period within one year, determining a calculation model of the first code data as follows:
Figure BDA0002897652020000192
wherein y is the return rate due, FV is the sum of the intrinsic and the rest of the bond on the due cash-out day; and FV is M, M is the face value due exchange payment per hundred yuan, PV is the bond full price, and TY is the actual days of the interest-bearing year.
For example, if the first code data input by the user in the first input box is 111990361.IB, and the data type of the first code data is determined to be a closed bond whose pending period is within one year, the basic information of the bond 19 filter bank CD002 corresponding to the first code data 111990361.IB, such as the actual interest date of 2019, 1, 16, the due date of 2019, 4, 16, the buy date of 2019, 3, 26, the bond face value M of 100, the annual interest C of each hundredth, 4.72, if the interest base is actual interest number/360, the actual number of days in interest is TY 365, the remaining number of circulation days D from the bond buy date to the bond due date is 21 days, the actual number of days from the interest date to the due date is 90 days, the actual number of days from the interest date to 69 days, the price of PV of the bond is 99.55361, and the data is calculated according to the foregoing, the accrued interest AI is 0.55361 and the return to maturity y is 7.7935%. Among them, official supply of accrued interest 2.307556 and return to maturity rate 7.7935%.
In the embodiment of the application, the discount bonds are divided into discount bonds with the waiting-for-payment period within one year and discount bonds with the waiting-for-payment period more than one year, different calculation models are used for calculating different types of discount bonds, so that the obtained calculation result is approximate to data provided by an official, and the accuracy is high.
On the basis of the embodiment corresponding to fig. 2, in a possible implementation manner, when the data type corresponding to the first code data is the attached asset support security, the calculation model of the first code data is determined as
Figure BDA0002897652020000193
The method comprises the steps of obtaining a nominal value of each hundredth of a bond, obtaining a nominal value of each hundredth of the bond, and obtaining a nominal value of each hundredth of the bond.
Illustratively, if the first code data input by the user in the first input box is 111692998.IB, and it may be determined that the data type of the first code data is a dividend-type asset support security, basic information of the bond 16 nanjing bank CD057 corresponding to the first code data 111692998.IB may be acquired in the database, for example, 2016, 5, and 2019, 5, and 2019, 3, 25, and 2019, a bond denomination M is 100, an annual interest C per hundred dollar value is 4.72, if the dividend basis is actual annual days/360, an actual number of days TY is 365, a current remaining principal value M per hundred dollar value is 100, a remaining circulation D from a bond purchase date to a bond expiration date is 41 days, an actual number of days T from the dividend date to the redemption date is 90 days, an actual number of days T from the dividend date to the bond date is 69, and a total settlement of the bond is 99.44666667, from the foregoing data, an AI of accrued interest of 0.451685393 can be obtained. Wherein the accrued interest offered by the official is 0.44667.
In the embodiment of the application, the interest accrued is calculated by using the corresponding calculation model for the data of the asset support securities of which the data types are attached information type, so that the obtained calculation result is approximate to the data provided by the official party, and the accuracy is higher.
On the basis of the embodiment corresponding to fig. 2, in a possible implementation manner, when the data type corresponding to the first code data is a right-bearing bond, determining a calculation model of the first code data as follows:
Figure BDA0002897652020000201
PV is the bond full price of the entitled bond, y is the return rate due to the entitled bond, C is the annual interest per hundred yuan, n is the bond paying times from the settlement date to the next paying date of the right-carrying date, TS is the actual days of the paying period, d is the days from the settlement date to the next paying date, and the settlement date is the first time data.
In the embodiment of the application, for the data of which the data type is the authorized bond, the corresponding calculation model is used for calculating the interest accrued, so that the obtained calculation result is approximate to the data provided by the official, and the accuracy is high.
On the basis of the embodiment corresponding to fig. 2, in a possible implementation manner, when the data type corresponding to the first code data is an early bond payment, determining a calculation model of the first code data as:
Figure BDA0002897652020000202
wherein, AI is the accrued interest amount of the bond paid back in advance per hundred yuan face value0V is sum of issued amount of bond in advance paid back, Vj is amount of paid back on each paying day, and Sigma VjIs the sum of all the repayment amounts of the repayment days which are less than or equal to the settlement days.
When the data type corresponding to the first code data is that the bond is paid back in advance, the calculation model of the first code data can be determined as follows:
Figure BDA0002897652020000211
PV is the bond full price of the bond paid in advance, M is the face value of the bond paid in advance maintained by the field affairs, Vi is the amount of the balance on the ith paying day from the settlement day, Vn is the amount of the money paid on the last paying day, and V is the amount of the money paid on the last paying daynV-SIGMA V, V being the bond issuing total for field maintenance, CiThe nominal annual interest corresponding to the ith paying day from the settlement day,
Figure BDA0002897652020000212
wherein, Ci0The nominal annual interest of the ith paying cycle calculated according to the calculation rule without the prior payment bond, V is the total issued amount of the bond, Σ Vj is the sum of all the paying amounts of the paying days smaller than the paying day, y is the return yield rate of the prior payment bond, C is the annual interest per hundredth of face, n is the paying number of the bond from the settlement day to the next paying day of the right-of-way day, the settlement day is first time data, TS is the actual number of days of the paying cycle, and d is the number of days from the settlement day to the next paying day.
In a possible implementation manner, for bonds with fixed interest rate and floating interest rate in the last payment cycle of the settlement day, the influence of advance payback is only considered in the FV corresponding to the bond in the last payment cycle described in the foregoing embodiment, so that the formula can be used for calculating the FV of the corresponding bond in the final payment cycle
Figure BDA0002897652020000213
In the method, the face value M of the due payment is replaced by the principal payment amount M multiplied by Vn/V of the last period, and the interest C/f of the last payment period of the due payment is replaced by the interest C/f of the due payment
Figure BDA0002897652020000214
In a possible implementation, when calculating the return rate due to the right-bearing debt without right-passing date, the difference is that C in the above formula is used for calculatingiC of (A)i0Before and after the right of way day are calculated using different nominal interest rates/differences. When calculating the return rate due to the right-bearing debt after the right date, the difference lies in C in the above formulaiC of (A)i0After using the row rightThe nominal interest rate/interest difference obtained is calculated instead of the current interest rate/interest difference. For a particular pay-per-day, calculate CiThe periodic nominal annual interest calculated without prior consideration of the return of the current system may be used, multiplied by the ratio of the remaining principal to the total amount issued.
In a possible implementation manner, the calculation model of the yield rate of the right to go of the final payment period when the settlement day is not before the right to go is as follows:
Figure BDA0002897652020000215
wherein, the settlement date is in the line right earning rate calculation model of the last paying period before the line right, the calculation formula of FV is changed into
Figure BDA0002897652020000216
P is the right price, n is the number of bond payments from the settlement date to the right date, Sigma VjN is the number of bond payings from the settlement day to the next payday of the right-of-way day, TS is the actual number of days in the paycycle, C is the annual interest per hundredth dollar, and d is the number of days from the settlement day to the next payday.
In a possible implementation manner, when the data type corresponding to the first code data is a bond paid in advance, it may be further determined that a calculation model of the first code data is:
Figure BDA0002897652020000221
wherein, pc0A net price for the first transaction; ai0Interest should be charged for the first delivery day; p is the first transaction full price; r is the repurchase interest rate; d is the actual number of days of money; d is the number of days from the pay-to-due date; c is a hundred yuan denomination pay (c is a nominal interest rate x 100/pay frequency); p is the full price of the due transaction; ai1Interest should be charged for due delivery days; pc (personal computer)1A net price for the due transaction; v is the total amount of issued bonds; Σ Vj is all that have a return date less than the payoff date during the buybackAnd the sum of the amounts; vi is the amount of payoff on the days of the buyback, and Vi is 0 if the buyback is not paid in advance.
In the embodiment of the application, the interest accrued is calculated by using the corresponding calculation model for the data with the data type of the bond paid back in advance, so that the obtained calculation result is approximate to the data provided by the official, and the accuracy is high.
The calculation results obtained by the calculation method provided in the embodiment of the present application are analyzed in conjunction with table 1 below.
TABLE 1
Figure BDA0002897652020000222
Figure BDA0002897652020000231
The embodiment of the application calculates various types of bonds by using the corresponding calculation models respectively, and as shown in table 1, the calculation results (interest accrued and return to maturity rate) obtained by the embodiment of the application are very close to the data provided by the authorities, and the accuracy is high. Therefore, before acquiring official data, a user can calculate by the method provided by the embodiment of the application, and the obtained calculation result has a good reference value.
According to another aspect of the embodiments of the present disclosure, an electronic device is further provided, and fig. 8 is a schematic diagram of a hardware structure of the electronic device provided in the embodiments of the present disclosure. As shown in fig. 8, the table creation statement generating device 80 provided in the present embodiment includes: at least one processor 801 and a memory 802. The table building sentence generating apparatus 80 further comprises a communication section 803. The processor 801, the memory 802, and the communication unit 803 are connected by a bus 804.
In a specific implementation, the at least one processor 801 executes the computer-executable instructions stored in the memory 802, so that the at least one processor 801 executes the above table building statement generation method.
For the specific implementation process of the processor 801, reference may be made to the above method embodiments, which implement principles and technical effects similar to each other, and details are not described herein again.
In the embodiment shown in fig. 8, it should be understood that the Processor may be a Central Processing Unit (CPU), other general purpose processors, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of a method disclosed in connection with the present invention may be embodied directly in a hardware processor, or in a combination of the hardware and software modules within the processor.
The memory may comprise high speed RAM memory, and may also include non-volatile storage NVM, such as at least one disk memory.
The bus may be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, an Extended ISA (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, the buses in the figures of the present application are not limited to only one bus or one type of bus.
The present application also provides a computer-readable storage medium, in which computer-executable instructions are stored, and when a processor executes the computer-executable instructions, the above table building statement generation method is implemented.
The computer-readable storage medium may be implemented by any type of volatile or non-volatile memory device or combination thereof, such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disk. Readable storage media can be any available media that can be accessed by a general purpose or special purpose computer.
An exemplary readable storage medium is coupled to the processor such the processor can read information from, and write information to, the readable storage medium. Of course, the readable storage medium may also be an integral part of the processor. The processor and the readable storage medium may reside in an Application Specific Integrated Circuits (ASIC). Of course, the processor and the readable storage medium may also reside as discrete components in the apparatus.
The reader should understand that in the description of this specification, reference to the description of the terms "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the elements may be selected according to actual needs to achieve the objectives of the embodiments of the present disclosure.
In addition, functional units in the embodiments of the present disclosure may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present disclosure may be substantially or partially contributed by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method of the embodiments of the present disclosure. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, and various media capable of storing program codes.
It should also be understood that, in the embodiments of the present disclosure, the sequence numbers of the above-mentioned processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present disclosure.
While the present disclosure has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the disclosure. Therefore, the protection scope of the present disclosure shall be subject to the protection scope of the claims.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the elements may be selected according to actual needs to achieve the objectives of the embodiments of the present disclosure.
In addition, functional units in the embodiments of the present disclosure may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present disclosure may be substantially or partially contributed by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method of the embodiments of the present disclosure. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
It should also be understood that, in the embodiments of the present disclosure, the sequence numbers of the above-mentioned processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present disclosure.
While the present disclosure has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the disclosure. Therefore, the protection scope of the present disclosure shall be subject to the protection scope of the claims.

Claims (17)

1. A data processing method, comprising:
receiving a first operation of a user on a computing control;
responding to the first operation, displaying a first user interface, wherein the first user interface comprises a first input box for receiving code class data input and a second input box for receiving time class data input;
receiving first code data input by a user in the first input box;
receiving first time data input by a user in the second input box;
determining a computational model of the first code data;
and obtaining a calculation result according to the first time data and the calculation model.
2. The method of claim 1, wherein determining the computational model of the first code data comprises: and determining a calculation model of the first code data according to the data type of the first code data.
3. The method of claim 2, wherein receiving user-entered first code data in the first input box comprises:
and receiving a coupon code, a balance bond code, a closed property support bond code, a closed bond code, a coupon code, an authorized bond code or an advance payment bond code input by a user in the first input box.
4. The method of claim 3, wherein obtaining a calculation based on the first time data and the calculation model comprises:
inputting the first time data into a computational model of the first code data;
outputting the calculation result by utilizing a calculation model of the first code data;
wherein the calculation comprises one or more of: interest accrued, bond full price, return rate due.
5. The method according to any one of claims 2-4, wherein receiving user-entered first time data in the second input box comprises:
receiving a second operation of the user on the second input box;
displaying a calendar interface for a user to select a date in response to the second operation;
receiving a selection operation of a user on first time data in the calendar interface;
displaying the first time data in the second input box in response to the selection operation.
6. The method of any of claims 2-4, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type of the first code data is a coupon, determining a calculation model of the first code data as:
Figure FDA0002897652010000021
the AI is the accrued interest amount of the attached bond per hundred yuan of face value, the C is the annual interest per hundred yuan of face value, the t is the actual days from the rest day or the last rest day to the settlement day, the settlement day is the first time data, the f is the annual rest frequency, and the TS is the actual days of the rest period.
7. The method of any of claims 2-4, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is a null bond, determining a calculation model of the first code data as follows:
Figure FDA0002897652010000022
the method comprises the steps of obtaining a balance of interest of a balance bond, obtaining a balance of interest of the balance bond, obtaining AI and TY, obtaining the balance of interest of the balance bond, obtaining the AI and the balance of interest of the balance bond, obtaining the T and the balance of the balance bond, and obtaining the TY and the balance of the balance bond.
8. The method of any of claims 2-4, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the first generationWhen the data type corresponding to the code data is a bond, determining a calculation model of the first code data as
Figure FDA0002897652010000023
Wherein the AI is the accrued interest amount of the close bond per hundred yuan face value; m is the due exchange payment amount of the face value of each hundred yuan, t is the actual days from the rest day or the last rest day to the settlement day, the settlement day is the first time data, and PdAnd T is the actual days from the rest date to the due cash-out date for the issued price of the bond.
9. The method of any of claims 2-4, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is the attached asset support security, determining the calculation model of the first code data as
Figure FDA0002897652010000024
The AI is the accrued interest amount of the closed bond per hundred yuan of face value, the C is annual interest per hundred yuan of face value, the t is the actual days from the rest day or the last interest day to the settlement day, the settlement day is the first time data, the TY is the actual days of the rest year of the rest period, and the m is the current residual principal value of the face value per hundred yuan.
10. The method of claim 2, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is an accessory bond in the last paying cycle, a loose bond with a paid date within one year and less and/or a closed bond with a paid date within one year and less, determining the counter of the first code dataThe calculation model is as follows:
Figure FDA0002897652010000031
wherein, the y is the return rate due, and the FV is the sum of the bond instinct due and redeemed on the day; when the data type corresponding to the first code data is the coupon in the last paying period, the first code data is used for storing the coupon
Figure FDA0002897652010000032
When the data type corresponding to the first code data is a zero-information bond with the waiting period within one year, the FV is M + NxC; when the data type corresponding to the first code data is a discount bond with the waiting-for-payment period within one year, the FV is M; the D is the remaining circulation days from the settlement day to the bond redemption day, the settlement day is the first time data, the PV is the bond full price, the f is the annual payment frequency, the TY is the actual days of the interest-bearing year, the C is the annual interest per hundred yuan, and the M is the bond face value of the coupon in the last payment cycle, the coupon with the period to be paid within one year and less and/or the bond face value of the coupon with the period to be paid within one year and less.
11. The method of claim 2, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is a zero-information bond with a waiting period of more than one year and a discount bond with a waiting period of more than one year, determining a calculation model of the first code data as follows:
Figure FDA0002897652010000033
wherein, the y is the return rate due, and the FV is the sum of the bond instinct due and redeemed on the day; when the data type corresponding to the first code data is a zero-information bond with the waiting period within one year, the FV is M + NxC; when the data type corresponding to the first code data is a closed bond with a waiting period of more than one year, FV is M, M is the whole year from a settlement date to an expired redemption date, the settlement date is the first time data, PV is the full price of the bond, M is an expired redemption amount per hundred yuan, and TY is the actual days of the interest-counting year.
12. The method of claim 2, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is the coupon which is not in the last paying period, determining the calculation model of the first code data as
Figure FDA0002897652010000034
Figure FDA0002897652010000035
The PV is the total price of the attached bonds not in the last paying cycle, C is annual interest per hundred yuan, f is annual paying frequency, TS is actual days of the paying cycle, d is days from a settlement day to the next paying day, n is the number of bond paying times from the settlement day to an expired cash day, the settlement day is the first time data, and y is the return rate due to the attached bonds not in the last paying cycle.
13. The method of claim 2, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is a right-bearing bond, determining that a calculation model of the first code data is as follows:
Figure FDA0002897652010000041
the method comprises the steps of obtaining a right-bearing bond, PV, n, TS, d and C, wherein PV is the bond full price of the right-bearing bond, y is the return rate due to the right-bearing bond, C is annual interest per hundredth of face value, n is the bond paying times of the next paying day from a settlement day to a right-of-way day, the settlement day is first time data, TS is the actual days of a paying cycle, and d is the days from the settlement day to the next paying day.
14. The method of claim 2, wherein determining the computational model of the first code data based on the data type of the first code data comprises:
when the data type corresponding to the first code data is the bond paid in advance, determining that the calculation model of the first code data is as follows:
Figure FDA0002897652010000042
wherein the AI is the accrued interest amount of the bond paid back in advance per hundred yuan face value, and the AI is0V is the sum of the issued advance payment bond, Vj is the payment amount of each paying day, and Σ V isjThe sum of all the repayment amount of the repayment date is less than or equal to the settlement date;
alternatively, the first and second electrodes may be,
Figure FDA0002897652010000043
PV is the bond full price of the bond paid in advance, M is the face value of the bond paid in advance maintained by the field affairs, Vi is the amount of the balance on the ith paying day from the settlement day, Vn is the amount of the fund redeemed on the last paying day, and V is the amount of the fund redeemed on the last paying daynV-SIGMA V, V is the total amount issued by the bonds maintained by the field affairs, CiFor the nominal annual interest corresponding to the ith paying day from the settlement day,
Figure FDA0002897652010000044
wherein, the Ci0The nominal annual interest of the ith paying cycle calculated according to the calculation rule without the prior payment bond, the sigma Vj is the sum of all the payment amounts of the paying day which is smaller than the paying day, the y is the return rate of the prior payment bond, the C is annual interest of the face value of each hundred yuan, the n is the paying frequency of the bond from the settlement day to the next paying day of the right-of-way day, the settlement day is the first time data, the TS is the actual number of days of the paying cycle, and the d is the number of days from the settlement day to the next paying day.
15. A data processing apparatus, characterized in that the apparatus comprises: the device comprises a processing module and a display module;
the processing module is used for receiving a first operation of a user on the computing control;
the processing module is further configured to respond to the first operation;
the display module is used for displaying a first user interface, and the first user interface comprises a first input box used for receiving code class data input and a second input box used for receiving time class data input;
the processing module is further used for receiving first code data input by a user in the first input box;
the processing module is further used for receiving first time data input by a user in the second input box;
the processing module is further used for determining a calculation model of the first code data;
the processing module is further configured to obtain a calculation result according to the first time data and the calculation model.
16. An electronic device, comprising:
a memory for storing program instructions;
a processor for invoking and executing program instructions in said memory for performing the method of any of claims 1-14.
17. A computer-readable storage medium, characterized in that the storage medium stores a computer program which, when executed by a processor, implements the method according to any one of claims 1-14.
CN202110046980.9A 2021-01-14 2021-01-14 Data processing method and device Pending CN114764412A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110046980.9A CN114764412A (en) 2021-01-14 2021-01-14 Data processing method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110046980.9A CN114764412A (en) 2021-01-14 2021-01-14 Data processing method and device

Publications (1)

Publication Number Publication Date
CN114764412A true CN114764412A (en) 2022-07-19

Family

ID=82364300

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110046980.9A Pending CN114764412A (en) 2021-01-14 2021-01-14 Data processing method and device

Country Status (1)

Country Link
CN (1) CN114764412A (en)

Similar Documents

Publication Publication Date Title
CN110415119B (en) Model training method, bill transaction prediction method, model training device, bill transaction prediction device, storage medium and equipment
McConnell et al. Rational prepayments and the valuation of collateralized mortgage obligations
Lo et al. Assets on the blockchain: An empirical study of Tokenomics
US20100169193A1 (en) Conversion engine and financial reporting system using the conversion engine
Rutherford et al. From an input-output table to a general equilibrium model: assessing the excess burden of indirect taxes in Russia
US20130332324A1 (en) Investment, trading and accounting management system
CN106910129B (en) Asset data processing method, client and server
JP6794431B2 (en) Initial Margin Methods and systems for calculating and providing initial margin based on the Standard Model
US8229822B2 (en) Computer-implemented method for financial analysis
Schmidt Interest rate term structure modelling
JP2006500692A (en) Method and apparatus for public information dynamic financial analysis
US20160019646A1 (en) Computer systems and methods for balancing indexes
US20070100743A1 (en) Computer system for the management of loans
US20090319380A1 (en) Facilitating Real Estate Transaction Collaboration
AU773465B2 (en) Global investor client access system
JP2002175395A (en) Accounting processing system, accounting processing method and medium having program for executing the program recorded thereon
US20070100723A1 (en) System and method for structuring and facilitating financial transactions
CN114764412A (en) Data processing method and device
US20210065308A1 (en) Systems and Methods for Administering Index-Linked Financial Products
CN101826196A (en) Secular data metering system for interest rate risk monitoring
Carlberg Business Analysis: Microsoft Excel 2010
Jackson et al. Which financial architecture can protect environmental commons?
Carlberg Business Analysis with Microsoft Excel
CN201607771U (en) Duration data calculation system for monitoring interest risk
Hagan et al. Girsanov, Numeraires, and All That

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination