A method and device for processing index data

Abstract

The present invention provides an indicator data processing method and device, which can be applied to the field of financial technology and other fields, including: obtaining the indicator data to be processed input by the user; parsing the indicator data, obtaining the indicator association information and each indicator in the indicator data, the indicator association information contains the reference relationship between each indicator; using the depth-first traversal algorithm to process the indicator association information, and judging whether there are repeated references in each indicator; when there are no repeated references, based on the indicator association information, the operation process of each indicator is visualized to obtain an indicator calculation tree. In the case that there are no repeated references for each indicator, the operation process of each indicator is visualized based on the indicator association information, so as to obtain an indicator calculation tree that can be displayed to the user. The user can intuitively understand the operation process of the indicator through the indicator calculation tree, reduce the time and energy spent on auditing the indicator, and improve work efficiency.

Description

Technical Field

[0001] The present invention relates to the technical field of index processing, and in particular to an index data processing method and device. Background Art

[0002] In investment-related businesses, it is usually necessary to organize a large amount of data, so that orderly data can be obtained, so that the relevant business can quickly call relevant data during the implementation process. Among the data that need to be organized, indicator data is particularly numerous and important.

[0003] At present, in the process of sorting out indicator data, multiple indicators are usually combined and then calculated to obtain the data required to implement the business. However, this process cannot intuitively present the relationship between the various indicators and the calculation process, which causes the staff to spend a lot of time and energy in checking whether the calculation process is correct. Summary of the invention

[0004] In view of this, the present invention provides an indicator data processing method and device, which can visualize the calculation process of the indicator, thereby facilitating the review by the staff and reducing the time and energy spent by the staff on the review.

[0005] To achieve the above objectives, the embodiments of the present invention provide the following technical solutions:

[0006] The first aspect of the present invention discloses an indicator data processing method, comprising:

[0007] Get the indicator data to be processed input by the user;

[0008] Parsing the indicator data to obtain indicator association information and each indicator in the indicator data, wherein the indicator association information includes a reference relationship between each of the indicators;

[0009] Using a preset depth-first traversal algorithm to process the indicator association information to determine whether there are repeated references in each of the indicators;

[0010] When it is determined that there is no repeatedly cited indicator among the indicators, the calculation process of each indicator is visualized based on the indicator association information to obtain an indicator calculation tree.

[0011] In the above method, optionally, the step of obtaining the indicator data to be processed input by the user includes:

[0012] Obtaining the indicator operation function input by the user;

[0013] The indicator operation data input by the user for the indicator operation function is obtained, and the indicator operation data is filled into the indicator operation function to obtain the indicator data to be processed.

[0014] In the above method, optionally, parsing the indicator data to obtain indicator association information and each indicator in the indicator data includes:

[0015] Obtaining description information of each indicator in the indicator data;

[0016] Determine the indicator to which each indicator description information belongs;

[0017] Determine the reference relationship of each indicator based on the reference relationship of each indicator description information;

[0018] Based on the reference relationship between the various indicators, indicator association information is generated.

[0019] In the above method, optionally, the method uses a preset depth-first traversal algorithm to process the indicator association information to determine whether there are repeated references in each of the indicators, including:

[0020] Based on the reference relationship between the various indicators in the indicator association information, a tree diagram corresponding to each of the indicators is generated;

[0021] Using the depth-first traversal algorithm to process the tree graph, obtaining a traversal result for each of the indicators;

[0022] Based on the traversal results of each of the indicators, it is determined whether there are any repeatedly referenced indicators among the indicators.

[0023] In the above method, optionally, based on the indicator association information, the calculation process of each indicator is visualized to obtain an indicator calculation tree, including:

[0024] Based on the associated information of each of the indicators, determining the level information of each of the indicators in the calculation process;

[0025] The hierarchical information of each of the indicators is recursively processed to generate a visual indicator calculation tree.

[0026] A second aspect of the present invention discloses an indicator data processing device, comprising:

[0027] A first acquisition unit, used to acquire the indicator data to be processed input by the user;

[0028] A second acquisition unit is used to parse the indicator data to acquire indicator association information and each indicator in the indicator data, wherein the indicator association information includes a reference relationship between each of the indicators;

[0029] A judgment unit, used to process the indicator association information using a preset depth-first traversal algorithm to judge whether there are repeated references in each of the indicators;

[0030] The visualization processing unit is used to visualize the calculation process of each of the indicators based on the indicator association information to obtain an indicator calculation tree when it is determined that there is no repeatedly referenced indicator among the indicators.

[0031] In the above device, optionally, the first acquisition unit includes:

[0032] A first acquisition subunit, used to acquire the indicator operation function input by the user;

[0033] The second acquisition subunit is used to acquire the indicator operation data input by the user for the indicator operation function, and fill the indicator operation data into the indicator operation function to obtain the indicator data to be processed.

[0034] In the above device, optionally, the second acquisition unit includes:

[0035] A third acquisition subunit is used to obtain description information of each indicator in the indicator data;

[0036] A first determining subunit is used to determine the indicator to which each indicator description information belongs;

[0037] A second determining subunit is used to determine the reference relationship of each of the indicators based on the reference relationship of each indicator description information;

[0038] The first generating subunit is used to generate indicator association information based on the reference relationship between each of the indicators.

[0039] In the above device, optionally, the judging unit includes:

[0040] A second generating subunit is used to generate a tree diagram corresponding to each of the indicators based on the reference relationship between the indicators in the indicator association information;

[0041] A processing subunit, used to process the tree graph using the depth-first traversal algorithm to obtain a traversal result for each of the indicators;

[0042] The judging subunit is used to judge whether there are any repeatedly referenced indicators among the indicators based on the traversal results of the indicators.

[0043] In the above device, optionally, the visualization processing unit includes:

[0044] A third determining subunit is used to determine the level information of each of the indicators in the calculation process based on the association information of each of the indicators;

[0045] The third generating subunit is used to recursively process the hierarchical information of each of the indicators to generate a visualized indicator calculation tree.

[0046] Compared with the prior art, the present invention has the following advantages:

[0047] The present invention provides an indicator data processing method and device, the method comprising: obtaining indicator data to be processed input by a user; parsing the indicator data, obtaining indicator association information and each indicator in the indicator data, wherein the indicator association information includes a reference relationship between each indicator; processing the indicator association information using a depth-first traversal algorithm, and then judging whether there are repeated referenced indicators in each indicator; when it is determined that there are no repeated referenced indicators in each indicator, based on the indicator association information, visualizing the operation process of each indicator to obtain an indicator calculation tree. In the case that there are no repeated references to each indicator, the operation process of each indicator is visualized based on the indicator association information, thereby obtaining an indicator calculation tree that can be displayed to the user, and the user can intuitively understand the operation process of the indicator through the indicator calculation tree, reducing the time and energy spent on auditing the indicator and improving work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

[0049] Figure 1 A method flow chart of an indicator data processing method provided by an embodiment of the present invention;

[0050] Figure 2 A flowchart of a method for obtaining indicator association information and each indicator in indicator data provided for the implementation of the present invention;

[0051] Figure 3 A flow chart of a method for determining whether there are repeated references in various indicators provided by an embodiment of the present invention;

[0052] Figure 4 An example diagram of an implementation architecture of an indicator data processing method provided in an embodiment of the present invention;

[0053] Figure 5 A schematic diagram of the structure of an indicator data processing device provided by an embodiment of the present invention;

[0054] Figure 6 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0055] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0056] In this application, the terms "comprises", "comprising" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device comprising a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprising a ..." does not exclude the presence of other identical elements in the process, method, article or device comprising the element.

[0057] At present, in the investment industry, the index values ​​of financial statements are mainly sorted out, and then the target index is obtained as the basis for investment banking through index combination calculation. Generally, this process is carried out on Excel, but this will result in the relationship between the indicators not being intuitive enough, and the indicator calculation process cannot be intuitively obtained, resulting in the staff having to spend a lot of energy to check whether the process of indicator calculation is correct. Therefore, effectively sorting out the indicator relationship and displaying it has become an urgent need in the industry. The method provided by the present invention is intended to solve the above problems.

[0058] The index data processing method and device provided by the present invention can be used in the financial field or other fields, for example, in the application scenario of the calculation process of the analytical index in the financial field. Other fields are any fields other than the financial field, for example, in the investment field. The above is only an example and does not limit the application field of the index data processing method and device provided by the present invention.

[0059] The present invention can be used in many general or special computing device environments or configurations, such as personal computers, server computers, handheld or portable devices, tablet devices, multi-processor devices, distributed computing environments including any of the above devices or equipment, etc. The execution subject of the present invention can be a server or a processor.

[0060] Reference Figure 1 , is a method flow chart of an indicator data processing method provided by an embodiment of the present invention, and is specifically described as follows:

[0061] S101: Obtaining the indicator data to be processed input by the user.

[0062] The indicator data includes but is not limited to the data of each indicator and the calculation formula for calculating each indicator.

[0063] The process of obtaining the indicator data to be processed input by the user is as follows:

[0064] Obtaining the indicator operation function input by the user;

[0065] The indicator operation data input by the user for the indicator operation function is obtained, and the indicator operation data is filled into the indicator operation function to obtain the indicator data to be processed.

[0066] Preferably, the indicator operation function can be an indicator operation formula. The user can input the indicator operation function according to the needs. The indicator operation function is an abstract module that completes a function, similar to the function in Excel.

[0067] The indicator operation function just input by the user does not have any operation parameters yet. For example, the indicator operation function input by the user is a summation function, and any operation parameters have not been input into the summation function.

[0068] The indicator operation data can be understood as the data applied to the indicator operation function during operation. The indicator operation data can be filled into the indicator operation function as the operation parameters of the indicator operation function, thereby obtaining the indicator data to be processed.

[0069] Preferably, the indicator operation data includes but is not limited to indicator names, numbers or words; further, when the indicator operation data is input into the indicator operation function, if it is a separate word, single quotes are required to surround the separate word.

[0070] In the method provided by the embodiment of the present invention, the user can input the index operation function and the index operation data into the input module, and the input module processes the index operation function and the index operation data to obtain the index data to be processed.

[0071] S102: Parse the indicator data to obtain indicator association information and each indicator in the indicator data.

[0072] In the method provided by the embodiment of the present invention, the indicator association information includes the reference relationship between the various indicators. For example, indicator 1 applies indicator 2 and indicator 3, indicator 2 is referenced by indicator 1, and indicator 3 is referenced by indicator 3.

[0073] Reference Figure 2, which is a flowchart of a method for obtaining indicator association information and each indicator in indicator data provided by the present invention, and is specifically described as follows:

[0074] S201: Obtain description information of each indicator in the indicator data.

[0075] The indicator data is intercepted, so that each indicator description information can be intercepted. The indicator description information may be the indicator name. Furthermore, the indicator description information also includes a subscript, which is used to indicate the year to which the data applied to the indicator to which the indicator name belongs belongs.

[0076] S202: Determine the indicator to which each indicator description information belongs.

[0077] According to the indicator name in each indicator description information, the indicator to which each indicator description information belongs is determined. Based on the subscript in the indicator description information, the data applied to the indicator can be determined. For example, assuming that the subscript is 2021, it means that the data applied to the indicator is the data of 2021, and the data of the indicator in 2021 is used as the applied data. Furthermore, each indicator has different data in different years. In the process of calculating the indicator, the data of the corresponding year needs to be applied for processing to obtain the expected results.

[0078] S203: Determine the reference relationship of each indicator based on the reference relationship of each indicator description information.

[0079] The reference relationship of each indicator description information can be determined according to the position of each indicator description information in the indicator operation function, thereby determining the reference relationship of each indicator.

[0080] S204: Generate indicator association information based on the reference relationship between each indicator.

[0081] For example, assuming that the indicator data is specifically a formula: a[n]=b[n]+c[n]+d[n]. After processing the indicator data, the indicator description information can be obtained as follows: a[n], b[n], c[n], and d[n]. Furthermore, the indicator to which a[n] belongs is a, the indicator to which b[n] belongs is b, the indicator to which c[n] belongs is c, and the indicator to which d[n] belongs is d. From the position of each indicator description information in the formula, it can be seen that a[n] references b[n], c[n], and d[n], b[n] is referenced by a[n], and c[n] is referenced by a[n]. ], d[n] is referenced by a[n]; therefore, indicator a references indicator b, indicator c and indicator d, indicator b is referenced by indicator a, indicator c is referenced by indicator a, and indicator d is referenced by indicator a; and the data used by indicators a, b, c and d are all data for year n. Furthermore, if n at this time represents the current year, it means that the data used by indicators a, b, c and d are all data for the current year; on this basis, the subscript of the indicator name may be [n-1], which means that the year of the data used by the indicator is last year's data.

[0082] Finally, indicator association information is generated based on the reference relationship between each indicator.

[0083] Preferably, a preset parsing module may be used to parse the indicator data, thereby obtaining various indicators and indicator-related information.

[0084] S103: Use a preset depth-first traversal algorithm to process the indicator association information to determine whether there are any repeatedly referenced indicators among the indicators; when it is determined that there are no repeatedly referenced indicators among the indicators, execute S104; when it is determined that there are repeatedly referenced indicators among the indicators, execute S105.

[0085] Reference Figure 3 , is a flow chart of a method for determining whether there are repeated references in various indicators provided by an embodiment of the invention, and is specifically described as follows:

[0086] S301: Generate a tree diagram corresponding to each indicator based on the reference relationship between each indicator in the indicator association information.

[0087] A tree map is an abstract conceptual map that contains the reference relationships between various indicators.

[0088] S302: Use a depth-first traversal algorithm to process the tree graph to obtain a traversal result for each indicator.

[0089] The traversal result includes the number of times the indicator is marked during the process of processing the tree graph by the depth-first traversal algorithm.

[0090] S303: Based on the traversal results of each index, determine whether there is a duplicated index among the indexes.

[0091] Determine whether there are traversal results marked more than once in each traversal result. If there are traversal results marked more than once in each traversal result, determine that there are duplicated indicators in each indicator. If there are no traversal results marked more than once in each traversal result, determine that there are no duplicated indicators in each indicator.

[0092] In the method provided by the embodiment of the present invention, the reference relationship between each indicator in the indicator management information is first used to construct a tree graph, and then the tree graph is processed using a depth-first traversal algorithm to obtain the traversal result of each indicator, and then it is determined based on the traversal result whether there are repeatedly referenced indicators in each indicator. In this way, it is possible to quickly screen whether there are repeatedly referenced indicators in each indicator, thereby improving the correctness of the indicator calculation process.

[0093] S104: Based on the indicator association information, the calculation process of each indicator is visualized to obtain an indicator calculation tree.

[0094] In the method provided by the embodiment of the present invention, a preset visualization module can be used to determine the calculation process of each indicator based on the indicator association information, and the calculation process can be visualized to obtain a visualized indicator calculation tree, and the indicator calculation tree can be displayed, so that the calculation process of each indicator and the reference relationship between each indicator can be displayed to the user.

[0095] Preferably, the process of visualizing the calculation process of each indicator can be described as follows:

[0096] Based on the associated information of each of the indicators, determining the level information of each of the indicators in the calculation process;

[0097] The hierarchical information of each of the indicators is recursively processed to generate a visual indicator calculation tree.

[0098] In the method provided by the embodiment of the present invention, the hierarchical relationship may include the steps of the operation to which the indicator belongs in the operation process.

[0099] The front-end code can be used to recursively process the hierarchical information to generate an indicator calculation tree for the indicator calculation process.

[0100] S105: Generate duplicate citation information, and feed back the duplicate citation information to the user.

[0101] The repeated citation information includes the indicators of the repeated citations. Feedback of the repeated citation information to the user can prompt the user that the indicators have been repeatedly cited, so that the user can make corrections quickly and accurately.

[0102] In the method provided by the embodiment of the present invention, the indicator data to be processed input by the user is obtained; the indicator data is parsed to obtain the indicator association information and each indicator in the indicator data, and the indicator association information contains the reference relationship between each indicator; the indicator association information is processed using the depth-first traversal algorithm, and then it is determined whether there are repeated referenced indicators in each indicator; when it is determined that there are no repeated referenced indicators in each indicator, based on the indicator association information, the operation process of each indicator is visualized to obtain an indicator calculation tree. By obtaining the indicator association information and each indicator in the indicator data, the indicator association information can be processed to determine whether there are repeated referenced indicators. If there are no repeated referenced indicators, the operation process of each indicator is visualized, so that a visualized indicator calculation tree can be obtained; the operation process of the indicator can be displayed to the user through the indicator calculation tree, so as to reduce the time and effort spent on checking whether the operation process of the indicator is correct; in addition, the indicator calculation tree can achieve the purpose of intuitive indicator calculation, fill the gap of no graphical indicator calculation process in the industry, and increase the data statistics at the indicator name level, so as to facilitate viewing the relationship between indicators and manual review.

[0103] Reference Figure 4 , which is an example diagram of the implementation architecture of the indicator data processing method provided in the embodiment of the present invention, refer to Figure 4 The method provided by the embodiment of the present invention is described, and the specific description is as follows:

[0104] The input module is used to receive indicator data input by the user. Optionally, the input module can display relevant pages to the user so that the user can enter indicator data in the page. Exemplarily, the indicator data can be an indicator operation function, which includes a function name and operation parameters, and the operation parameters include the indicator name. It should be noted that the indicator name is similar to the variable naming rules, but with the addition of mandatory subscripts and support for Chinese, and the indicator name satisfies regular expressions. The definition of the indicator name is as follows: 1. The indicator name must start with a letter or Chinese character, and the rest can be numbers, letters, Chinese characters and underscores; 2. The letters in the indicator name are not limited to uppercase and lowercase, but are case sensitive; 3. The indicator name must be followed by a subscript such as [n], [n+1] or [n-1] to indicate that the indicator is taken from the same year, the next year or the previous year. The definition of indicator operation function includes: 1. It consists of two parts: function name and parameters. The function name consists of uppercase letters and underscores, and the function name can be exhaustive. The parameter part is surrounded by parentheses, and multiple parameters are separated by commas; 2. The function parameter can be an indicator name, number or text. If it is a single text, it needs to be surrounded by single quotes; 3. The function name range can be referred to: Built-in functions|HyperFormula (v1.1.0) (handsontable.github.io).

[0105] The input module sends the indicator data to the parsing module, which parses the indicator data to obtain the indicator association information and each indicator in the indicator data; the parsing module sends the indicator association information and each indicator to the maintenance module, so that the maintenance module saves the indicator association information and each indicator; the duplicate reference detection module processes the indicator association information in the maintenance module to determine whether there are duplicated indicators in each indicator. If so, the generated duplicate reference information is fed back to the input module to prompt the user that there are duplicated indicators in each indicator; if not, the maintenance module sends the indicator association information to the visualization module.

[0106] The visualization module processes the indicator association information, and then visualizes the operation process of each indicator to obtain the indicator calculation tree, which can be displayed to the user, so that the user can intuitively understand the operation process of the indicator and the reference relationship between each indicator, which is convenient for the user to review the indicator and the operation process of the indicator. The indicator data processing method provided by the present invention is different from Excel, spreadJS, and handsonetable. Although they are all powerful data processing tools, Excel, spreadJS, handsonetable and other data processing tools process data at the cell level, and cannot summarize the data at the indicator level. Users cannot obtain indicator association information through tables. Using the method provided by the present invention, users can edit formulas online, configure formula functions, and perform cyclic application detection in real time to prevent the occurrence of indicator looping; different formulas for different years of an indicator can provide a selection method. By performing grammatical parsing on the formula input by the user, distinguishing operators, functions, indicator names and their subscripts, a tree structure is generated in the system, which is convenient for automatic updating of later data, and combined with data tables, the data editing function can be achieved. When a user modifies indicator data, it triggers iterative calculation of the indicator tree, and completes data update through sequential calculation from leaves to roots.

[0107] and Figure 1 Corresponding to the method shown in the figure, the present invention provides an indicator data processing device for supporting Figure 1 In the implementation of the method shown in real life, the device can be set in a processor of a computer or a server. Figure 5 , is a schematic diagram of the structure of an indicator data processing device provided by an embodiment of the present invention, and is specifically described as follows:

[0108] The first acquisition unit 501 is used to acquire the indicator data to be processed input by the user;

[0109] A second acquisition unit 502 is used to parse the indicator data to acquire indicator association information and each indicator in the indicator data, wherein the indicator association information includes a reference relationship between each indicator;

[0110] The judging unit 503 is used to process the indicator association information using a preset depth-first traversal algorithm to judge whether there are repeated reference indicators in each of the indicators;

[0111] The visualization processing unit 504 is used to visualize the calculation process of each of the indicators based on the indicator association information to obtain an indicator calculation tree when it is determined that there is no repeated reference indicator among the indicators.

[0112] In the device provided by the embodiment of the present invention, the indicator data to be processed input by the user is obtained; the indicator data is parsed to obtain the indicator association information and each indicator in the indicator data, and the indicator association information contains the reference relationship between each indicator; the indicator association information is processed using the depth-first traversal algorithm, and then it is determined whether there are repeated referenced indicators in each indicator; when it is determined that there are no repeated referenced indicators in each indicator, based on the indicator association information, the operation process of each indicator is visualized to obtain an indicator calculation tree. By obtaining the indicator association information and each indicator in the indicator data, the indicator association information can be processed to determine whether there are repeated referenced indicators. If there are no repeated referenced indicators, the operation process of each indicator is visualized, so that a visualized indicator calculation tree can be obtained; the operation process of the indicator can be displayed to the user through the indicator calculation tree, so as to reduce the time and effort spent on checking whether the operation process of the indicator is correct; in addition, the indicator calculation tree can achieve the purpose of intuitive indicator calculation, fill the gap of no graphical indicator calculation process in the industry, and increase the data statistics at the indicator name level, so as to facilitate viewing the relationship between indicators and manual review.

[0113] Based on the above embodiments, in the apparatus provided by the embodiments of the present invention, the first acquiring unit 501 may be configured as follows:

[0114] A first acquisition subunit, used to acquire the indicator operation function input by the user;

[0115] The second acquisition subunit is used to acquire the indicator operation data input by the user for the indicator operation function, and fill the indicator operation data into the indicator operation function to obtain the indicator data to be processed.

[0116] Based on the above embodiments, in the apparatus provided by the embodiments of the present invention, the second obtaining unit 502 may be configured as follows:

[0117] A third acquisition subunit is used to obtain description information of each indicator in the indicator data;

[0118] A first determining subunit is used to determine the indicator to which each indicator description information belongs;

[0119] A second determining subunit is used to determine the reference relationship of each of the indicators based on the reference relationship of each indicator description information;

[0120] The first generating subunit is used to generate indicator association information based on the reference relationship between each of the indicators.

[0121] Based on the above embodiments, in the apparatus provided by the embodiments of the present invention, the determining unit 503 may be configured as follows:

[0122] A second generating subunit is used to generate a tree diagram corresponding to each of the indicators based on the reference relationship between the indicators in the indicator association information;

[0123] A processing subunit, used to process the tree graph using the depth-first traversal algorithm to obtain a traversal result for each of the indicators;

[0124] The judging subunit is used to judge whether there are any repeatedly referenced indicators among the indicators based on the traversal results of the indicators.

[0125] Based on the above embodiments, in the apparatus provided by the embodiments of the present invention, the visualization processing unit 504 may be configured as follows:

[0126] A third determining subunit is used to determine the level information of each of the indicators in the calculation process based on the association information of each of the indicators;

[0127] The third generating subunit is used to recursively process the hierarchical information of each of the indicators to generate a visualized indicator calculation tree.

[0128] An embodiment of the present invention further provides a storage medium, which includes stored instructions, wherein when the instructions are executed, the device where the storage medium is located is controlled to execute the above-mentioned indicator data processing method.

[0129] The embodiment of the present invention further provides an electronic device, the structural diagram of which is shown in FIG. Figure 6 As shown, it specifically includes a memory 601 and one or more instructions 602, wherein the one or more instructions 602 are stored in the memory 601 and are configured to be executed by one or more processors 603 to execute the one or more instructions 602 to perform the above-mentioned indicator data processing method.

[0130] The specific implementation processes and derivative methods of the above-mentioned embodiments are all within the protection scope of the present invention.

[0131] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can refer to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system or system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can refer to the partial description of the method embodiment. The system and system embodiments described above are merely schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without creative work.

[0132] Professionals may further appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in the above description according to function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professionals and technicians may use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

[0133] The above description of the disclosed embodiments enables one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for processing index data, characterized in that: include: Get the indicator data to be processed input by the user; Obtaining description information of each indicator in the indicator data, wherein the indicator description information includes an indicator name and a subscript, wherein the subscript is used to indicate the year to which the data to which the indicator to which the indicator name belongs belongs belongs; Determine the indicator to which each indicator description information belongs; Determine the reference relationship of each indicator based on the reference relationship of each indicator description information; Based on the reference relationship between the indicators, generate indicator association information, wherein the indicator association information includes the reference relationship between the indicators; Using a preset depth-first traversal algorithm to process the indicator association information to determine whether there are repeated references in each of the indicators; When it is determined that there is no repeatedly cited indicator among the indicators, the calculation process of each indicator is visualized based on the indicator association information to obtain an indicator calculation tree.

2. The method according to claim 1, characterized in that The step of obtaining the indicator data to be processed input by the user includes: Obtaining the indicator operation function input by the user; The indicator operation data input by the user for the indicator operation function is obtained, and the indicator operation data is filled into the indicator operation function to obtain the indicator data to be processed.

3. The method according to claim 1, characterized in that The using of a preset depth-first traversal algorithm to process the indicator association information to determine whether there are repeated references in each of the indicators includes: Based on the reference relationship between the various indicators in the indicator association information, a tree diagram corresponding to each of the indicators is generated; Using the depth-first traversal algorithm to process the tree graph, obtaining a traversal result for each of the indicators; Based on the traversal results of each of the indicators, it is determined whether there are any repeatedly referenced indicators among the indicators.

4. The method according to claim 1, characterized in that: Based on the indicator association information, the calculation process of each indicator is visualized to obtain an indicator calculation tree, including: Based on the associated information of each of the indicators, determining the level information of each of the indicators in the calculation process; The hierarchical information of each of the indicators is recursively processed to generate a visual indicator calculation tree.

5. An indicator data processing device, characterized in that: include: A first acquisition unit, used to acquire the indicator data to be processed input by the user; A second acquisition unit is used to parse the indicator data to acquire indicator association information and each indicator in the indicator data, wherein the indicator association information includes a reference relationship between each of the indicators; A judgment unit, used to process the indicator association information using a preset depth-first traversal algorithm to judge whether there are repeated references in each of the indicators; A visualization processing unit, configured to, when it is determined that there is no duplicated index among the indexes, visualize the calculation process of each index based on the index association information to obtain an index calculation tree; The second acquisition unit includes: A third acquisition subunit is used to acquire description information of each indicator in the indicator data, wherein the indicator description information includes an indicator name and a subscript, and the subscript is used to indicate the year to which the data to which the indicator to which the indicator name belongs belongs belongs; A first determining subunit is used to determine the indicator to which each indicator description information belongs; A second determining subunit is used to determine the reference relationship of each of the indicators based on the reference relationship of each indicator description information; The first generating subunit is used to generate indicator association information based on the reference relationship between each of the indicators.

6. The device according to claim 5, characterized in that The first acquisition unit includes: A first acquisition subunit, used to acquire the indicator operation function input by the user; The second acquisition subunit is used to acquire the indicator operation data input by the user for the indicator operation function, and fill the indicator operation data into the indicator operation function to obtain the indicator data to be processed.

7. The device according to claim 5, characterized in that The judging unit comprises: A second generating subunit is used to generate a tree diagram corresponding to each of the indicators based on the reference relationship between the indicators in the indicator association information; A processing subunit, used to process the tree graph using the depth-first traversal algorithm to obtain a traversal result for each of the indicators; The judging subunit is used to judge whether there are any repeatedly referenced indicators among the indicators based on the traversal results of the indicators.

8. The device according to claim 5, characterized in that The visualization processing unit comprises: A third determining subunit is used to determine the level information of each of the indicators in the calculation process based on the association information of each of the indicators; The third generating subunit is used to recursively process the hierarchical information of each of the indicators to generate a visualized indicator calculation tree.

Images