CN110555082A - data processing method, data processing device, computer equipment and storage medium - Google Patents
data processing method, data processing device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110555082A CN110555082A CN201910666994.3A CN201910666994A CN110555082A CN 110555082 A CN110555082 A CN 110555082A CN 201910666994 A CN201910666994 A CN 201910666994A CN 110555082 A CN110555082 A CN 110555082A
- Authority
- CN
- China
- Prior art keywords
- financial
- data
- condition information
- analysis
- target
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title abstract description 19
- 238000004458 analytical method Methods 0.000 claims abstract description 217
- 238000000034 method Methods 0.000 claims abstract description 34
- 238000004590 computer program Methods 0.000 claims description 12
- 238000004364 calculation method Methods 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 10
- 238000007405 data analysis Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The application relates to the technical field of cloud services, and provides a data processing method and device, computer equipment and a storage medium. The method comprises the following steps: the method comprises the steps that a to-be-processed financial analysis table and basic financial data are obtained, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance; matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data; calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value; and generating and displaying a financial statement analysis report according to the target financial value. By adopting the method, the financial data processing efficiency can be improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data processing method and apparatus, a computer device, and a storage medium.
Background
when financial analysis reports are carried out in the traditional technology, the excel table in office software office is usually used for carrying out financial analysis reports, however, the method needs to be manually arranged, analyzed and calculated from tedious basic financial data, and then the financial analysis reports are generated according to the excel table, so that the efficiency of the financial analysis reports is easily low, and the accuracy of the financial analysis reports is easily low due to manual participation.
disclosure of Invention
in view of the above, it is necessary to provide a data processing method, an apparatus, a computer device and a storage medium for improving efficiency of financial data processing without manually calculating financial data.
A method of data processing, the method comprising:
The method comprises the steps that a to-be-processed financial analysis table and basic financial data are obtained, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance;
Matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data;
Calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value;
And generating and displaying a financial statement analysis report according to the target financial value.
In one embodiment, the method comprises the steps of acquiring a to-be-processed financial analysis table and basic financial data, wherein the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, and the vertical table head comprises second condition information, and the method comprises the following steps: acquiring a plurality of preset times from the basic financial data, and taking the preset times as first condition information; acquiring different types of financial text contents from the basic financial data, and taking the different types of financial text contents as second condition information; the method comprises the steps that a to-be-processed financial analysis table is determined according to a plurality of preset times and different types of financial text contents, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises a plurality of preset times, and the vertical table head comprises different types of financial text contents.
in one embodiment, matching the base financial data according to the first condition information and the second condition information to obtain corresponding target financial data comprises: matching the basic financial data according to the first condition information and the second condition information to obtain corresponding initial basic financial data; and acquiring a financial attribute value corresponding to the initial basic financial data from the basic financial data, and taking the financial attribute value as the target financial data.
In one embodiment, the to-be-processed financial analysis table is pre-associated with a financial analysis formula, which includes: determining a corresponding preset financial field according to the first condition information and the second condition information in the financial analysis table; determining a corresponding preset financial analysis formula according to the first condition information and the second condition information in the financial analysis table; and establishing an incidence relation according to the preset financial field and the preset financial analysis formula to obtain the incidence relation between the preset financial analysis formula and the financial analysis table.
in one embodiment, the method for calculating the target financial value by calling the corresponding financial analysis formula according to the target financial data includes: acquiring a target financial field corresponding to the target financial data; and acquiring a financial analysis formula corresponding to the target financial field according to the association relation, taking the target financial data as a variable corresponding to the financial analysis formula, and calculating to obtain a target financial value corresponding to the target financial data.
in one embodiment, generating and displaying a financial statement analysis report based on the target financial value includes: converting the target financial value into corresponding financial index webpage data; displaying a financial statement analysis report in a webpage according to the financial index webpage data; and/or converting the target financial value into corresponding financial index display data; and displaying the financial statement analysis report in the document according to the financial index display data.
A data processing apparatus, the apparatus comprising:
The system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring a to-be-processed financial analysis table and basic financial data, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and the to-be-processed financial analysis table is associated with a financial analysis formula in advance;
the matching module is used for matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data;
The calculation module is used for calling a corresponding financial analysis formula according to the target financial data to calculate and obtain a target financial value;
and the generating module is used for generating and displaying the financial statement analysis report according to the target financial value.
a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:
The method comprises the steps that a to-be-processed financial analysis table and basic financial data are obtained, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance;
Matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data;
Calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value;
And generating and displaying a financial statement analysis report according to the target financial value.
a computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
the method comprises the steps that a to-be-processed financial analysis table and basic financial data are obtained, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance;
matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data;
calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value;
And generating and displaying a financial statement analysis report according to the target financial value.
the data processing method, the data processing device, the computer equipment and the storage medium acquire a to-be-processed financial analysis table and basic financial data, wherein the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance; matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data; calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value; and generating and displaying a financial statement analysis report according to the target financial value.
therefore, when the financial analysis report is carried out, the corresponding to-be-processed financial analysis table can be determined according to the imported basic financial data, the target financial data required by the to-be-processed financial analysis table is obtained through matching in the basic financial data, the corresponding financial analysis formula is called based on the incidence relation between the preset financial analysis formula and the financial analysis table, the corresponding financial value is automatically calculated according to the financial analysis formula, and finally the financial statement analysis report is generated. In the whole financial data processing process, the complex financial data are not required to be manually arranged, analyzed and calculated, the financial data can be automatically calculated, the financial analysis report form can be generated, the efficiency of financial data analysis is improved, and the accuracy of the financial analysis data is improved.
Drawings
FIG. 1 is a diagram of an exemplary implementation of a data processing method;
FIG. 2 is a flow diagram illustrating a data processing method according to one embodiment;
FIG. 3 is a schematic flow chart of the pending financial analysis table and basic financial data processing steps in one embodiment;
FIG. 4 is a schematic flow chart diagram illustrating the steps for matching the target financial data in one embodiment;
FIG. 5 is a flow chart illustrating a financial analysis formula pre-associated with a to-be-processed financial analysis table in one embodiment;
FIG. 6 is a schematic flow chart diagram illustrating the steps for calculating a target financial value in one embodiment;
FIG. 7 is a flowchart illustrating the financial statement analysis report generation step in one embodiment;
FIG. 8 is a flowchart illustrating the financial statement analysis report generation step in another embodiment;
FIG. 9 is a block diagram showing the structure of a data processing apparatus according to an embodiment;
FIG. 10 is a block diagram of an acquisition module in one embodiment;
FIG. 11 is a block diagram of the structure of a matching module in one embodiment;
FIG. 12 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
the data processing method provided by the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
specifically, the terminal 102 may send the to-be-processed financial analysis table and the basic financial data to the server 104, the server 104 obtains the to-be-processed financial analysis table and the basic financial data, the to-be-processed financial analysis table includes a horizontal table head and a vertical table head, the horizontal table head includes first condition information, the vertical table head includes second condition information, and the to-be-processed financial analysis table is associated with a financial analysis formula in advance; matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data; calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value; and generating and displaying a financial statement analysis report according to the target financial value. Further, the server 104 may send the financial statement analysis report to the terminal 102, and the terminal 102 may display the financial statement analysis report for viewing by the terminal user.
In one embodiment, as shown in fig. 2, a data processing method is provided, which is described by taking the application of the method to the server in fig. 1 as an example, and includes the following steps:
Step 202, acquiring a to-be-processed financial analysis table and basic financial data, wherein the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance.
The to-be-processed financial analysis table is used for processing, and the financial analysis table is used for judging the financial condition of an enterprise and detecting the loss of the enterprise operation management. The to-be-processed financial analysis table is similar to an Excel table, and is shown as the following graph:
the financial table to be processed comprises a horizontal table head and a vertical table head, wherein the horizontal table head refers to a row of the financial table to be processed, the horizontal table head comprises first condition information, the first condition information is used for determining the content of the horizontal table head and can be a plurality of preset times, such as the row where each year is located in the figure, the vertical table head refers to a column of the financial table to be processed, the vertical table head comprises second condition information, the second condition information is used for determining the content of the vertical table head and can be different types of financial text contents, such as the column where business income, business cost and sales cost are located in the figure.
The basic financial data refers to basic data related to the finance of the enterprise, such as liability ratio, operating profit margin and the like. The underlying financial data may be the primary data on the annual newspaper of the enterprise, or may be financial-related data uploaded financially, or the like. The basic financial data comprises first condition information and second condition information, the first condition information and the second condition information can be obtained by determining from the basic financial data, namely different basic financial data can correspond to different to-be-processed financial analysis tables, and the basic financial data and the to-be-processed financial analysis tables have a certain relation.
the basic financial data comprises a data set corresponding to a plurality of dimension information, wherein the dimension information forms a dimension set, and the first condition information and the second condition information are true subsets of the dimension set, namely the dimension set comprises the first condition information and the second condition information.
and 204, matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data.
The basic financial data comprises first condition information and second condition information, so that corresponding target financial data can be obtained from the basic financial data in a matching mode according to the first condition information and the second condition information in the basic financial data. Specifically, the basic financial data that matches the first condition information and the second condition information simultaneously in the basic financial data may be used as the target financial data. Or screening the corresponding target financial data from the basic financial data according to the first condition information and the second condition information.
And step 206, calling a corresponding financial analysis formula according to the target financial data to calculate and obtain a target financial value.
The method comprises the steps of establishing an incidence relation between a financial analysis formula and a financial analysis table in advance, specifically, obtaining a preset financial field corresponding to the financial analysis table, establishing an incidence relation between the preset financial field and the corresponding financial analysis formula, and forming an incidence relation between the financial analysis formula and the financial analysis table. Specifically, after the target financial data are obtained, a financial analysis formula matched with the target financial data is called according to the incidence relation, and a target financial value corresponding to the target financial data is calculated according to the financial analysis formula. Specifically, the target financial data may be used as a variable of the financial analysis formula, and a target financial value corresponding to the target financial data is obtained through calculation.
And step 208, generating and displaying a financial statement analysis report according to the target financial value.
Specifically, after the target financial value is calculated, a financial statement analysis report is generated and displayed according to the target financial value. And automatically filling the target financial value into the content corresponding to the initial financial statement analysis report, thereby generating the financial statement analysis report. The financial statement analysis report can be displayed in a webpage form or a word document form.
According to the data processing method, the corresponding to-be-processed financial analysis table can be determined according to the imported basic financial data, the target financial data required by the to-be-processed financial analysis table is obtained through matching in the basic financial data, the corresponding financial analysis formula is called based on the incidence relation between the preset financial analysis formula and the financial analysis table, the corresponding financial value is automatically calculated according to the financial analysis formula, and finally the financial statement analysis report is generated. In the whole financial data processing process, the complex financial data are not required to be manually arranged, analyzed and calculated, the financial data can be automatically calculated, the financial analysis report form can be generated, the efficiency of financial data analysis is improved, and the accuracy of the financial analysis data is improved.
in one embodiment, as shown in fig. 3, the method includes obtaining a pending financial analysis table and basic financial data, where the pending financial table includes a horizontal table header and a vertical table header, the horizontal table header includes first condition information, and the vertical table header includes second condition information, including:
step 302, obtaining a plurality of preset times from the basic financial data, and using the plurality of preset times as first condition information.
the first condition information can be determined to be preset time according to actual business requirements or application scenarios, so that each preset time can be obtained from the basic financial data, and the obtained preset time is used as the first condition information. That is, the horizontal header in the pending financial analysis table is each preset time in the base financial data.
And step 304, acquiring different types of financial text contents from the basic financial data, and taking the different types of financial text contents as second condition information.
wherein, the second condition information can be financial text content of non-pain type according to the actual business requirement or application scene, and the financial text content can be information related to finance, such as profit and profit. Therefore, different types of financial text contents can be acquired from the basic financial data, and the acquired different types of financial text contents are used as the second condition information. That is, the vertical header in the pending financial analysis table is the financial text content of each type in the underlying financial data.
And step 306, determining to obtain a to-be-processed financial analysis table according to the financial text contents of the plurality of preset times and the different types, wherein the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises the plurality of preset times, and the vertical table head comprises the financial text contents of the different types.
specifically, after the preset time and the financial text contents of the types are obtained from the basic financial data, the preset time is used as a horizontal header of the to-be-processed financial analysis table, and the financial document handling contents of different types are used as a vertical header of the to-be-processed financial analysis table to form the to-be-processed financial analysis table. Specifically, it can be shown in the following table:
In one embodiment, as shown in fig. 4, matching the base financial data according to the first condition information and the second condition information to obtain corresponding target financial data includes:
And step 402, matching the basic financial data according to the first condition information and the second condition information to obtain corresponding initial basic financial data.
And 404, acquiring a financial attribute value corresponding to the initial basic financial data from the basic financial data, and taking the financial attribute value as target financial data. The basic financial data records basic financial data and corresponding financial attribute values, and the financial attribute values refer to numerical values corresponding to the basic financial data. Specifically, the corresponding initial basic financial data is obtained by matching from the basic financial data according to the first condition information and the second condition information, and specifically, the basic financial data that simultaneously satisfies the first condition information and the second condition information may be used as the initial basic financial data, for example, the first condition information is 2018, the second condition information is a loss rate, and then the initial basic financial data is the loss rate of 2018. Further, since the basic financial data and the corresponding financial attribute value are recorded in the basic financial data, the corresponding financial attribute value can be obtained from the basic financial data according to the initial basic financial data, and the financial attribute value is used as the target financial data. For example, if the first condition information is 2018 and the second condition information is a loss ratio, the initial base financial data is the loss ratio of 2018, and the loss ratio of 2018 described in the base financial data is 80%, and therefore the loss ratio of 2018 is 80% as the target financial data.
In one embodiment, as shown in fig. 5, the to-be-processed financial analysis table is pre-associated with a financial analysis formula, which includes:
Step 502, determining a corresponding preset financial field according to the first condition information and the second condition information in the financial analysis table.
And step 504, determining a corresponding preset financial analysis formula according to the first condition information and the second condition information in the financial analysis table.
step 506, establishing an association relationship according to the preset financial field and the preset financial analysis formula to obtain an association relationship between the preset financial analysis formula and the financial analysis table.
the preset financial field is used for marking each position in the financial analysis table, and each position of the financial analysis table is determined by the first condition information and the second condition information, so that the corresponding preset financial field is determined according to the first condition information and the second condition information in the financial analysis table. Marking each position in the financial analysis table according to the preset financial field, for example, the first condition information is each preset time, 2018 and 2019, the second condition information is total cost and profit, and then the pending financial analysis table formed by the first condition information and the second condition information is:
| 2018 years old | 2019 | |
| Total cost of | a | b |
| Profit | c | d |
Then, four positions a, b, c and d are determined according to the first condition information and the second condition information, and corresponding preset financial fields are respectively allocated to the 4 positions, so that corresponding preset financial fields exist in all of a, b, c and d.
Furthermore, because each position in the financial analysis table has a corresponding preset financial analysis formula, after the preset financial field corresponding to each position in the financial analysis table is determined, the preset financial analysis formula corresponding to each position in the financial analysis table is obtained, the incidence relation between the preset financial field and the preset financial analysis formula is established, and the incidence relation between the preset financial analysis formula and the financial analysis table is obtained.
for example, four positions are determined to be a, b, c and d according to the first condition information and the second condition information, corresponding preset financial fields are respectively allocated to the 4 positions, the corresponding preset financial fields exist in the positions a, b, c and d, the corresponding preset financial analysis formulas exist in the positions a, b, c and d, the association relationship between the preset financial fields and the preset financial analysis formulas is established, and the association relationship between the financial analysis table and the financial analysis formulas is obtained.
In one embodiment, as shown in fig. 6, the calculating the target financial value according to the target financial data by calling the corresponding financial analysis formula includes:
Step 602, a target financial field corresponding to the target financial data is obtained.
And step 604, acquiring a financial analysis formula corresponding to the target financial field according to the association relationship, taking the target financial data as a variable corresponding to the financial analysis formula, and calculating to obtain a target financial value corresponding to the target financial data.
The corresponding fields exist in each piece of basic financial data, so that the target financial fields corresponding to the target financial data can be obtained, the financial analysis formulas corresponding to the target financial fields are obtained according to the incidence relation between the financial analysis tables and the financial analysis formulas, the target financial data are used as variables corresponding to the financial analysis formulas, and the target financial values corresponding to the target financial data are automatically calculated according to the financial analysis formulas.
in one embodiment, as shown in FIG. 7, generating and displaying a financial statement analysis report based on the target financial value includes:
Step 702, converting the target financial value into corresponding financial index webpage data;
and step 704, displaying the financial statement analysis report in the webpage according to the financial index webpage data.
when the financial statement analysis report is generated and displayed according to the target financial value, the display data for displaying the financial statement analysis report needs to be processed and then can be displayed, and the target financial value needs to be converted into corresponding financial index webpage data. The financial index webpage data refers to financial statement data which can be displayed on a webpage. After the target financial value is converted into corresponding financial index webpage data, a financial statement analysis report can be displayed on the webpage according to the financial index webpage data, and financial related personnel can check the financial statement or perform the next work according to the financial index webpage data.
In one embodiment, as shown in FIG. 8, generating and displaying a financial statement analysis report based on the target financial value includes:
step 802, convert the target financial value into corresponding financial index display data.
And step 804, displaying a financial statement analysis report in the document according to the financial index display data.
The method comprises the steps that a financial statement analysis report can be displayed on a webpage, and the financial statement analysis report can be displayed on a document. The financial index display data refers to financial report data which can be displayed on a document, wherein the document can be but is not limited to a word document in office software office.
It should be understood that, although the steps in the above-described flowcharts are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in the above-described flowcharts may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or the stages is not necessarily sequential, but may be performed alternately or alternatingly with other steps or at least a portion of the sub-steps or stages of other steps.
In one embodiment, as shown in fig. 9, there is provided a data processing apparatus 900 comprising: the device comprises an acquisition module, a matching module, a calculation module and a generation module, wherein:
the acquisition module 902 is used for acquiring the to-be-processed financial analysis table and the basic financial data, the to-be-processed financial analysis table comprises a transverse table head and a longitudinal table head, the transverse table head comprises first condition information, the longitudinal table head comprises second condition information, and the to-be-processed financial analysis table is associated with a financial analysis formula in advance.
and a matching module 904, configured to match the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data.
and the calculating module 906 is used for calling a corresponding financial analysis formula according to the target financial data to calculate and obtain a target financial value.
And a generating module 908 for generating and displaying the financial statement analysis report according to the target financial value.
in one embodiment, as shown in FIG. 10, the obtaining module 902 includes:
The first condition information obtaining unit 902a is configured to obtain a plurality of preset times from the basic financial data, where the plurality of preset times are used as the first condition information.
a second condition information obtaining unit 902b, configured to obtain different types of financial text contents from the basic financial data, and use the different types of financial text contents as second condition information.
and the to-be-processed analysis table determining unit 902c is configured to determine to obtain the to-be-processed financial analysis table according to the plurality of preset times and the different types of financial text contents, where the to-be-processed financial analysis table includes a horizontal table header and a vertical table header, the horizontal table header includes the plurality of preset times, and the vertical table header includes the different types of financial text contents.
in one embodiment, as shown in FIG. 11, the matching module 904 includes:
and an initial basic financial data matching unit 904a, configured to match the basic financial data according to the first condition information and the second condition information to obtain corresponding initial basic financial data.
And a financial attribute value obtaining unit 904b, configured to obtain a financial attribute value corresponding to the initial basic financial data from the basic financial data, and use the financial attribute value as the target financial data.
In one embodiment, the data processing apparatus 900 is further configured to determine a corresponding preset financial field according to the first condition information and the second condition information in the financial analysis table; determining a corresponding preset financial analysis formula according to the first condition information and the second condition information in the financial analysis table; and establishing an incidence relation according to the preset financial field and the preset financial analysis formula to obtain the incidence relation between the preset financial analysis formula and the financial analysis table.
In one embodiment, the calculation module 906 is further configured to obtain a target financial field corresponding to the target financial data; and acquiring a financial analysis formula corresponding to the target financial field according to the association relation, taking the target financial data as a variable corresponding to the financial analysis formula, and calculating to obtain a target financial value corresponding to the target financial data.
In one embodiment, the generation module 908 is further configured to convert the target financial value into corresponding financial index web page data; displaying a financial statement analysis report in a webpage according to the financial index webpage data; and/or converting the target financial value into corresponding financial index display data; and displaying the financial statement analysis report in the document according to the financial index display data.
For specific limitations of the data processing apparatus, reference may be made to the above limitations of the data processing method, which are not described herein again. The various modules in the data processing apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 12. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing a target financial analysis table. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data processing method.
Those skilled in the art will appreciate that the architecture shown in fig. 12 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In an embodiment, a computer device is provided, comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to perform the steps of the data processing method described above. The steps of the data processing method herein may be steps in the data processing methods of the various embodiments described above.
In one embodiment, a computer-readable storage medium is provided, in which a computer program is stored which, when being executed by a processor, causes the processor to carry out the steps of the above-mentioned data processing method. The steps of the data processing method herein may be steps in the data processing methods of the various embodiments described above.
it will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. a method of data processing, the method comprising:
the method comprises the steps that a to-be-processed financial analysis table and basic financial data are obtained, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises first condition information, the vertical table head comprises second condition information, and a financial analysis formula is associated with the to-be-processed financial analysis table in advance;
matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data;
calling a corresponding financial analysis formula according to the target financial data to measure and calculate to obtain a target financial value;
and generating and displaying a financial statement analysis report according to the target financial value.
2. The method of claim 1, wherein the obtaining the pending financial analysis form and the base financial data comprises obtaining a horizontal form header and a vertical form header, the horizontal form header comprising first condition information, the vertical form header comprising second condition information, and the method comprises:
Acquiring a plurality of preset times from the basic financial data, and taking the preset times as the first condition information;
Acquiring different types of financial text contents from the basic financial data, and taking the different types of financial text contents as the second condition information;
According to the preset times and the different types of financial text contents, the to-be-processed financial analysis table is determined to be obtained and comprises a horizontal table head and a vertical table head, the horizontal table head comprises the preset times, and the vertical table head comprises the different types of financial text contents.
3. the method of claim 1, wherein matching the base financial data according to the first and second conditional information to obtain corresponding target financial data comprises:
Matching the basic financial data according to the first condition information and the second condition information to obtain corresponding initial basic financial data;
And acquiring a financial attribute value corresponding to the initial basic financial data from the basic financial data, and taking the financial attribute value as the target financial data.
4. The method according to claim 1, characterized in that said pending financial analysis table is pre-associated with a financial analysis formula comprising:
determining a corresponding preset financial field according to the first condition information and the second condition information in the financial analysis table;
Determining a corresponding preset financial analysis formula according to the first condition information and the second condition information in the financial analysis table;
And establishing an incidence relation according to the preset financial field and the preset financial analysis formula to obtain the incidence relation between the preset financial analysis formula and the financial analysis table.
5. the method according to claim 4, wherein said invoking a corresponding financial analysis formula based on said target financial data to obtain a target financial value comprises:
acquiring a target financial field corresponding to the target financial data;
and acquiring a financial analysis formula corresponding to the target financial field according to the incidence relation, taking the target financial data as a variable corresponding to the financial analysis formula, and calculating to obtain a target financial value corresponding to the target financial data.
6. The method of claim 1, wherein generating and displaying a financial statement analysis report based on the target financial value comprises:
converting the target financial value into corresponding financial index webpage data;
Displaying the financial statement analysis report in a webpage according to the financial index webpage data; and/or
Converting the target financial value into corresponding financial index display data;
And displaying the financial statement analysis report in a document according to the financial index display data.
7. A data processing apparatus, characterized in that the apparatus comprises:
the system comprises an acquisition module, a processing module and a processing module, wherein the acquisition module is used for acquiring a to-be-processed financial analysis table and basic financial data, the to-be-processed financial analysis table comprises a transverse table head and a longitudinal table head, the transverse table head comprises first condition information, the longitudinal table head comprises second condition information, and the to-be-processed financial analysis table is associated with a financial analysis formula in advance;
The matching module is used for matching the basic financial data according to the first condition information and the second condition information to obtain corresponding target financial data;
the calculation module is used for calling a corresponding financial analysis formula according to the target financial data to calculate and obtain a target financial value;
And the generating module is used for generating and displaying a financial statement analysis report according to the target financial value.
8. the apparatus of claim 7, wherein the obtaining module comprises:
A first condition information obtaining unit, configured to obtain a plurality of preset times from the basic financial data, where the preset times are used as the first condition information;
A second condition information acquiring unit, configured to acquire different types of financial text contents from the basic financial data, and use the different types of financial text contents as the second condition information;
And the to-be-processed analysis table determining unit is used for determining to obtain the to-be-processed financial analysis table according to the preset times and the different types of financial text contents, the to-be-processed financial analysis table comprises a horizontal table head and a vertical table head, the horizontal table head comprises the preset times, and the vertical table head comprises the different types of financial text contents.
9. a computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 6 when executing the computer program.
10. a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910666994.3A CN110555082B (en) | 2019-07-23 | 2019-07-23 | Data processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910666994.3A CN110555082B (en) | 2019-07-23 | 2019-07-23 | Data processing method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110555082A true CN110555082A (en) | 2019-12-10 |
| CN110555082B CN110555082B (en) | 2024-03-19 |
Family
ID=68735845
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910666994.3A Active CN110555082B (en) | 2019-07-23 | 2019-07-23 | Data processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110555082B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113723747A (en) * | 2021-07-16 | 2021-11-30 | 北京房江湖科技有限公司 | Analysis report generation method, electronic device and readable storage medium |
| CN117743383A (en) * | 2023-12-20 | 2024-03-22 | 哈尔滨商业大学 | Rapid searching and reading method and system for financial information |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN107833124A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | Financial analysis system and implementation method based on financial general ledger data |
| CN109447769A (en) * | 2018-09-07 | 2019-03-08 | 杭州小番网络科技有限公司 | A kind for the treatment of method and apparatus of financial data |
| CN109493048A (en) * | 2018-11-19 | 2019-03-19 | 金蝶软件（中国）有限公司 | Financial accounting method, apparatus, equipment and storage medium based on block chain |
| CN109558414A (en) * | 2018-10-15 | 2019-04-02 | 平安科技（深圳）有限公司 | Checking method, device, computer equipment and the storage medium of financial data |
| CN109816503A (en) * | 2019-01-04 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Financial details data creation method, device, computer equipment and storage medium |
-
2019
- 2019-07-23 CN CN201910666994.3A patent/CN110555082B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN107833124A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | Financial analysis system and implementation method based on financial general ledger data |
| CN109447769A (en) * | 2018-09-07 | 2019-03-08 | 杭州小番网络科技有限公司 | A kind for the treatment of method and apparatus of financial data |
| CN109558414A (en) * | 2018-10-15 | 2019-04-02 | 平安科技（深圳）有限公司 | Checking method, device, computer equipment and the storage medium of financial data |
| CN109493048A (en) * | 2018-11-19 | 2019-03-19 | 金蝶软件（中国）有限公司 | Financial accounting method, apparatus, equipment and storage medium based on block chain |
| CN109816503A (en) * | 2019-01-04 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Financial details data creation method, device, computer equipment and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113723747A (en) * | 2021-07-16 | 2021-11-30 | 北京房江湖科技有限公司 | Analysis report generation method, electronic device and readable storage medium |
| CN117743383A (en) * | 2023-12-20 | 2024-03-22 | 哈尔滨商业大学 | Rapid searching and reading method and system for financial information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110555082B (en) | 2024-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020186786A1 (en) | File processing method and apparatus, computer device and storage medium | |
| CN109766534B (en) | Report generation method and device, computer equipment and readable storage medium | |
| WO2020253357A1 (en) | Data product recommendation method and apparatus, computer device and storage medium | |
| CN109189799B (en) | Service data query method, device, computer equipment and storage medium | |
| CN109800335A (en) | Generation method, device, computer equipment and the storage medium of enterprise's map | |
| CN108804548B (en) | Test data query method, device, computer equipment and storage medium | |
| Engsted et al. | Testing for rational bubbles in a coexplosive vector autoregression | |
| CN110659298B (en) | Financial data processing method and device, computer equipment and storage medium | |
| CN108334625B (en) | User information processing method and device, computer equipment and storage medium | |
| CN109284920B (en) | Big data-based user information risk assessment method and system | |
| CN110489622B (en) | Sharing method and device of object information, computer equipment and storage medium | |
| CN110674131A (en) | Financial statement data processing method and device, computer equipment and storage medium | |
| CN112286934A (en) | Database table importing method, device, equipment and medium | |
| CN105989173B (en) | Data processing method and device | |
| CN111353286A (en) | Table file processing method and device, computer equipment and storage medium | |
| CN110555082B (en) | Data processing method, device, computer equipment and storage medium | |
| CN111191079A (en) | Document content acquisition method, device, equipment and storage medium | |
| CN110929994A (en) | Enterprise associated risk analysis method, device, equipment and storage medium | |
| CN109783788A (en) | Tables of data complementing method, device, computer equipment and storage medium | |
| CN110275703B (en) | Method and device for assigning key value to data, computer equipment and storage medium | |
| CN110647350A (en) | Interface document generation method and device, computer equipment and storage medium | |
| CN110321529B (en) | Frame text display method and device, computer equipment and storage medium | |
| CN109542947B (en) | Data statistical method, device, computer equipment and storage medium | |
| CN110795475A (en) | Report generation method and device, computer equipment and storage medium | |
| US20200258093A1 (en) | Compliance standards mapping |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |