CN103092549A - Representing method and device for fund change situation - Google Patents

Abstract

The invention relates to a representing method and a representing device for a fund change situation. The method comprises the following steps of: 1) acquiring income, expense and balance data from a system with fund change data; 2) calculating an initial balance, a maximum available sum, a minimum available sum and an end balance in each data period according to the income, expense and balance data, and respectively setting the initial balance, the maximum available sum, the minimum available sum and the end balance to be four parameters, namely a quotation opening number, a highest number, a lowest number and a quotation closing number, of a K-line chart; and 3) drawing the K-line chart capable of representing the fund change situation by a K-line chart drawing tool according to the four parameters of the K-line chart in the step 2). By the method, a user can comprehensively and conveniently learn about the fund change situation.

Description

The method for expressing of fund variation statement and device

[technical field]

The present invention relates to the method about the pattern exhibiting of data in finance and financial class software, particularly about the resources flow data, or other have simultaneously a methods of exhibiting of the data that increase, subtract two kinds of variation of quantity directions in one-period.

[background technology]

At present to the pattern exhibiting mode of the income of the fund in one period/increases, expenditure/minimizing, remaining sum/data on stock, the typical case as: scheme one: a plurality of broken line graphs, scatter diagram, histogram are showed respectively the data of income, expenditure, remaining sum; As shown in Figure 1, scheme two: the data of showing simultaneously income, expenditure, remaining sum in a statistical graph with a cover coordinate axis system; Scheme three: with the multi-coordinate axial system, show simultaneously the data of income, expenditure, remaining sum in a statistical graph, usually income, expenditure can be placed in a cover coordinate axis, remaining sum is placed in an other cover coordinate axis.

For scheme one, because the data of same period are arranged in a plurality of charts, when paying close attention to data, can not the data of decorrelation, easily cause reading, the difficulty in analyzing, for example: the disbursement of one day increases suddenly, the remaining sum of employing the previous day on earth, or the same day a large amount of incomes is arranged, remaining sum is had great impact, just be difficult to quick judgement; When a plurality of charts can not be showed in a screen or space of a whole page fully, this inconvenience can be more outstanding.

For scheme two, if when the absolute value of income, expenditure, balance data differs larger, partial data can occur and concentrate near coordinate axis, the defective that inconvenience is read; If when showing in the broken line graph mode, normally be divided into receipts,, an excess-three system, be difficult for showing influencing each other of the interior revenue and expenditure remainder certificate of one-period.

For scheme three, use many covers (being generally 2 covers) coordinate axis system, the small amount data can show to get relatively good reading, but be appreciated that the implication of data, also need the reader to know the corresponding relation of data and coordinate, the reader is had certain experience requirement, need a study procedure of adaptation.

Above-mentioned three kinds of schemes all exist and are not easy to read and understand, need to increase the extra study procedure of adaptation, thereby affect work efficiency.And, the pattern analysis personnel of fund incremental data, the senior executive of enterprise often, they can not drop into too many reading time for one or a cover chart, the more impossible particularly knowledge of computer graphics software of special study statistical graph that for this reason needs, therefore, improving the displaying of fund incremental data is necessary.

In addition, present fund change chart just directly will be received, prop up, remaining factual data will be graphical, not do more multi-processing, form more derivative index; Analytical work is all carried out in reader's brains, and the effect of computer aided decision making is not given full play to.

[summary of the invention]

The technical problem to be solved in the present invention is to provide a kind of method for expressing of fund variation statement, and it can allow the user recognize comprehensively, easily fund variation statement.

Above-mentioned technical matters is achieved through the following technical solutions:

A kind of method for expressing of fund variation statement comprises the following steps:

1) from the system that has the fund incremental data, obtain the data of income, expenditure, remaining sum;

2) calculate from the data of income, expenditure, remaining sum, beginning balance, maximum avail, minimum avail, ending balance in each data cycle, and beginning balance, maximum avail, minimum avail, ending balance are set to respectively four parameters of K line chart: opening quotation number, the highest number, minimum, closing quotation number; The ending balance in beginning balance=upper data cycle, the beginning balance in first data cycle is prevalue, the income in the beginning balance in maximum avail=notebook data cycle+notebook data cycle, the expenditure in the beginning balance in minimum avail=notebook data cycle-notebook data cycle, the expenditure in the income notebook data cycle in the beginning balance in ending balance=notebook data cycle+notebook data cycle;

3) integrating step 2) in four parameters of K line chart, and call the K line chart that K line chart drawing tool is drawn out the expression fund variation statement.

The present invention also provides a kind of indication device of realizing the fund variation statement of said method, comprising:

Data acquisition module is used for from there being the system of fund incremental data, obtains the data of income, expenditure, remaining sum;

The data processing module, be used for calculating from the data of income, expenditure, remaining sum, beginning balance, maximum avail, minimum avail, ending balance in each data cycle, and beginning balance, maximum avail, minimum avail, ending balance are set to respectively four parameters of K line chart: opening quotation number, the highest number, minimum, closing quotation number; The ending balance in beginning balance=upper data cycle, the beginning balance in first data cycle is prevalue, the income in the beginning balance in maximum avail=notebook data cycle+notebook data cycle, the expenditure in the beginning balance notebook data cycle in minimum avail=notebook data cycle, the expenditure in the income in the beginning balance in ending balance=notebook data cycle+notebook data cycle-notebook data cycle;

Drafting module for four parameters of the K line chart that draws in conjunction with data manipulation devices, and calls the K line chart that K line chart drawing tool is drawn out the expression fund variation statement.

By such scheme as can be known, the present invention draws out the K line chart of expression fund variation statement by four parameters that beginning balance, maximum avail, minimum avail, ending balance are set to respectively the K line chart, in conjunction with the K line chart be easily understood and the characteristics of reflection comprehensively realize in a simple and clear and the chart that is easy to read more than showing revenue and expenditure etc. the factual data on basis, also increase maximum/minimum and can employ the indexs such as the balance of funding, current clean revenue and expenditure volume, enriched the content of fund variation analysis chart.Therefore, the present invention can allow the user recognize comprehensively, easily fund variation statement.

[description of drawings]

Fig. 1 shows the schematic diagram of the data of income, expenditure, remaining sum with a cover coordinate axis system in a statistical graph in background technology simultaneously;

Fig. 2 is for drawing out the K line chart of expression fund state change by thinking of the present invention;

Fig. 3 increases the schematic diagram of mark on the basis of Fig. 2.

[embodiment]

A kind of method for expressing of fund variation statement comprises the following steps:

1) from the system's (for example financial software or internet banking system, securities exchange system) that has the fund incremental data, obtain the data of income, expenditure, remaining sum;

2) calculate from the data of income, expenditure, remaining sum, the beginning balance in each data cycle, maximum avail, minimum avail, ending balance, and beginning balance, maximum avail, minimum avail, ending balance are set to respectively four parameters of K line chart: opening quotation number, the highest number, minimum, closing quotation number; The ending balance in beginning balance=upper data cycle, the beginning balance in first data cycle are that the data prevalue (this prevalue is from step 1) provide); The income in the beginning balance in maximum avail=notebook data cycle+notebook data cycle, namely suppose fund everyone in the situation that notebook data only gathering and not paying the bill in the cycle finally can be employed the maximum amount of fund; The expenditure in the beginning balance in minimum avail=notebook data cycle-notebook data cycle, namely suppose fund everyone in the situation that notebook data only payment and not receiving in the cycle finally can be possessed the minimum amount of fund; The expenditure in the income in the beginning balance in ending balance=notebook data cycle+notebook data cycle-notebook data cycle;

3) integrating step 2) in four parameters of K line chart, and call the K line chart that K line chart drawing tool is drawn out the expression fund variation statement.

The above-mentioned data cycle can take every day or weekly as a data cycle, also can arrange the length in receipt cycle as required.

The below states application of the present invention with concrete a utilization:

The fund variation statement in certain company in July, 2012 to be showed, be specially:

1) from Financial Software System, obtain the data that comprise income, expenditure, remaining sum, data such as table one, wherein, 1. the code name of income, expenditure, remaining sum be respectively, 2., 3.;

Table one comes the particular content of source data

2) as table two, calculate from each data of table one, the beginning balance in each data cycle, maximum avail, minimum avail, ending balance, 4. the code name of beginning balance, maximum avail, minimum avail, ending balance be respectively, 5., 6., 7., the data cycle is 1, wherein, 7. also can=proxima luce (prox. luc) 3.+this day 1.-Ben Ri 2., and beginning balance, maximum avail, minimum avail, ending balance are set to respectively four parameters of K line chart: opening quotation number, the highest number, minimum, closing quotation number;

Table two

Date	Beginning balance	Maximum avail	Minimum avail	Ending balance
						4.=proxima luce (prox. luc) 3.	⑤＝④+①	⑥＝④-②	⑦＝③
12-6-30
					12-7-1	10,020.15	14,421.36	9,330.57	13,731.78
12-7-2	13,731.78	30,747.86	13,150.10	30,166.18
					12-7-3	30,166.18	41,850.39	19,210.99	30,895.20

12-7-4	30,895.20	36,914.82	19,992.53	26,012.15
					12-7-5	26,012.15	33,009.25	12,697.05	19,694.15
12-7-6	19,694.15	28,855.00	16,095.57	25,256.42
					12-7-7	25,256.42	37,213.42	19,437.70	31,394.70
12-7-8	31,394.70	51,279.42	23,322.60	43,207.32
					12-7-9	43,207.32	45,771.38	29,207.18	31,771.24
12-7-10	31,771.24	44,523.35	23,801.49	36,553.60
					12-7-11	36,553.60	48,649.76	21,308.33	33,404.48
12-7-12	33,404.48	40,786.58	27,174.93	34,557.02
					12-7-13	34,557.02	36,266.76	27,838.89	29,548.62
12-7-14	29,548.62	47,134.52	24,783.55	42,369.45
					12-7-15	42,369.45	58,848.96	25,637.72	42,117.23
12-7-16	42,117.23	58,722.58	30,986.45	47,591.80
					12-7-17	47,591.80	53,487.07	39,346.69	45,241.95
12-7-18	45,241.95	49,095.07	28,836.32	32,689.45
					12-7-19	32,689.45	35,035.40	19,883.35	22,229.30
12-7-20	22,229.30	29,779.62	11,235.59	18,785.91
					12-7-21	18,785.91	34,216.94	2,162.84	17,593.87
12-7-22	17,593.87	23,105.57	15,698.25	21,209.95
					12-7-23	21,209.95	29,689.50	5,019.20	13,498.75
12-7-24	13,498.75	22,818.37	-2,718.84	6,600.78
					12-7-25	6,600.78	23,431.52	-9,521.41	7,309.34
12-7-26	7,309.34	18,813.05	-3,095.99	8,407.72
					12-7-27	8,407.72	22,707.73	1,805.73	16,105.75
12-7-28	16,105.75	20,449.96	-1,712.43	2,631.78
					12-7-29	2,631.78	9,403.49	-5,197.22	1,574.49
12-7-30	1,574.49	16,094.83	-464.04	14,056.29

3) as shown in Figures 2 and 3, in conjunction with four parameters of the K line chart in above-mentioned drawing, and call the K line chart that K line chart drawing tool is drawn out the expression fund variation statement; From the K line chart of drawing out, can simply, clearly read more information, be convenient to the financial information that the user understands company.

The present invention is not limited to above-described embodiment, based on above-described embodiment, simple replacement that do not make creative work, should belong to the scope that the present invention discloses.

Claims (2)

1. the method for expressing of a fund variation statement comprises the following steps:

1) from the system that has the fund incremental data, obtain the data of income, expenditure, remaining sum;

2) calculate from the data of income, expenditure, remaining sum, beginning balance, maximum avail, minimum avail, ending balance in each data cycle, and beginning balance, maximum avail, minimum avail, ending balance are set to respectively four parameters of K line chart: opening quotation number, the highest number, minimum, closing quotation number; The ending balance in beginning balance=upper data cycle, the beginning balance in first data cycle is prevalue, the income in the beginning balance in maximum avail=notebook data cycle+notebook data cycle, the expenditure in the beginning balance notebook data cycle in minimum avail=notebook data cycle, the expenditure in the income in the beginning balance in ending balance=notebook data cycle+notebook data cycle-notebook data cycle;

3) integrating step 2) in four parameters of K line chart, and call the K line chart that K line chart drawing tool is drawn out the expression fund variation statement.

2. the indication device of a fund variation statement comprises:

Data acquisition module is used for from there being the system of fund incremental data, obtains the data of income, expenditure, remaining sum;

The data processing module, be used for calculating from the data of income, expenditure, remaining sum, the beginning balance in each data cycle, maximum avail, minimum avail, ending balance, and beginning balance, maximum avail, minimum avail, ending balance are set to respectively four parameters of K line chart: opening quotation number, the highest number, minimum, closing quotation number; The ending balance in beginning balance=upper data cycle, the beginning balance in first data cycle is prevalue, the income in the beginning balance in maximum avail=notebook data cycle+notebook data cycle, the expenditure in the beginning balance in minimum avail=notebook data cycle-notebook data cycle, the expenditure in the income notebook data cycle in the beginning balance in ending balance=notebook data cycle+notebook data cycle;

Drafting module for four parameters of the K line chart that draws in conjunction with data manipulation devices, and calls the K line chart that K line chart drawing tool is drawn out the expression fund variation statement.

Images