JP2001319049A - Portfolio management and evaluation system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a portfolio management and evaluation system which is reduced in cost and has a high computing function. SOLUTION: This portfolio management and evaluation system which generates a portfolio from data generated as a financial article is sold or bought and presents it to the customer. This system is equipped with a rule book 25A which stores rules necessary for processing the data by at least types of business or customers, means (steps S2 (S2a, S2b), S4 (S4a, S4b)) which select a rule needed for data processing from the rule book 25A, and means (steps S3, S5) generating the portfolio of the customer according to the selected rule.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a portfolio management / evaluation system that creates a portfolio from trading data of financial products and presents it to customers.

[0002]

2. Description of the Related Art In recent years, systems for managing a fund by combining a plurality of financial products with different risks and liquidities in accordance with the purpose of managing the fund and forming a portfolio have been actively proposed.

[0003] For example, the apparatus described in Japanese Patent Application Laid-Open No. 6-295300 is an apparatus aiming to enable quick trading order and settlement based on market price data and to prevent trading errors due to input errors. Means for accumulating data necessary for fund management, performing portfolio formulation calculation based on the accumulated data, ordering products in accordance with the result of the formulation, and performing settlement after the sale is completed. . Also, JP-A-11-110
According to the system operated on a computer described in Japanese Patent No. 447, an investment target amount is calculated in accordance with an investor's life plan based on personal data, an investment return rate is calculated in consideration of an investment period, and further, research data is calculated. The risk acceptance level of the investor is determined based on the result, and a model portfolio is created based on the calculation result of the target rate of return and the determination result of the risk acceptance level.

[0004]

However, the above-mentioned system has the following unsolved problems.

[0005] First, processing conditions and processing parameters for portfolio management and evaluation vary greatly depending on the industry (banking industry, securities industry, etc.) and customers (company, individual, etc.). For this reason, in order to make the conventional portfolio management system described in the above-mentioned publication effective for each customer (such as a securities company or an investment advisory company: a user), the processing content must be managed and evaluated by each customer. Various processing conditions / parameters (number of rounding digits at the time of data calculation, rounding method, etc.) must be set for each customer, that is, customized so as to match the business content.

In other words, the overall flow of portfolio management / evaluation, which involves buying and selling financial products, calculating balance data from the trade data, and creating a portfolio from the balance data, is basically the same. Regardless, a provider (software maker) that provides a portfolio management / evaluation system must separately provide a system that performs processing in which processing conditions and parameters relating to management / evaluation of each customer are changed. Also, if the processing conditions or parameters change during the operation of the system, the program or table must be changed.

[0007] Therefore, for a system provider that provides such a system, the conventional method of constructing and providing a system for each customer requires time and effort in system startup and subsequent system operation, and as a result, provides the system to the customer. The cost of the system to do so rises accordingly. Of course, this is not welcome for customers.

Second, in the conventional portfolio management / evaluation system, trading of financial products, calculation of balance data,
In order to create portfolio review data, only a transaction database is provided. For this reason,
When calculating the balance data and creating the portfolio review data, the balance data and the portfolio review data so far are created from the transaction database.

However, a method of creating such data is as follows.
Since the calculation processing becomes heavy and the calculation takes time, the CP
There is a need to increase the computing capacity of U, which also increases the manufacturing cost of the computing device.

[0010] The present invention has been made in view of the above-mentioned problems of the prior art, and has been made to enable a customer to use a portfolio management / evaluation system having a low calculation cost and a high calculation function. With that purpose.

[0011] Another object of the present invention is to provide a system management / evaluation system to a customer, in which a system provider maintains a high arithmetic function and reduces costs.

[0012]

According to one aspect of the present invention, a portfolio is created from data generated by buying and selling financial instruments and presented to customers. A portfolio management and evaluation system is provided. The system includes a rule book in which rules required for processing the data are stored separately for at least one of an industry and a customer; a rule selecting means for selecting a rule required for processing the data from the rule book; Portfolio creating means for creating the portfolio of the customer according to the rule selected by the rule selecting means.
By using the rule book in this manner, various types of processing conditions require processing parameters (rules), and various customers can be handled by one management / evaluation program.

According to another aspect of the present invention, referring to a transaction database storing data necessary for trading, a trading means for processing the trading and a balance database storing past balances are referred to. Balance data creating means for creating current balance data from the trading data generated by the trading, and balance data created by the balance data creating means with reference to a portfolio review database storing past portfolio review data. A portfolio management / evaluation system, comprising: a portfolio review / data creation unit for creating current portfolio review data. As described above, by providing not only the transaction database but also the intermediate balance database and the portfolio review device, the process of creating portfolio review data becomes quick and easy.

In this system, for example, each of the balance data creating means and the portfolio review data creating means is means for creating data on a contract basis, a contract settlement basis, and a delivery basis, respectively. The database and the portfolio review database are both databases that store data in the same format. This eliminates the need to create a program for each of the contract base, the contract settlement base, and the delivery base, and can be dealt with by one common program.

[0015]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A portfolio management / evaluation system according to an embodiment of the present invention will be described below with reference to FIGS.

FIG. 1 is a block diagram showing the configuration of the portfolio management / evaluation system. This system was provided to a customer by an information system provider.

As shown in FIG. 1, the portfolio management / evaluation system includes a computer 11 used by a customer.
And a communication device 12 capable of communicating with an external communication network connected to the computer 11. The computer 11 has conventionally known components. That is, the computer 11 includes a CPU 21 that executes application software under a predetermined OS and performs a predetermined processing function, and is connected to the CPU 21 via a bus 22.
OM23, RAM24, hard disk 25, monitor 2
6, an input device 27, and interfaces 28 and 29.

The ROM 23 stores in advance program data of application software and other necessary fixed data.
Called by the PU 21 or the RAM 24. RAM 24
Are used as temporary data storage means during the processing of the CPU 21. The monitor 26 and the input device 27 are used by an operator of the customer, and an interactive operation with the system is realized.

The hard disk 25 is connected to the computer 11
Is stored as a storage device, and the memory elements constitute a rule book 25A, a transaction database 24B, a balance database 25C, and a portfolio review database 5D, which will be described later, in addition to the OS program data.

The rule book 25A contains conditions and parameters used for the business processing of portfolio management / evaluation (number of rounded digits (number of digits to be rounded) when calculating for each brand, and how to round (rounded, rounded up, rounded). Is included in the calculation of book value, etc.) is defined by industry and / or customer.

The conditions and parameters of this processing vary according to the industry to which the customer belongs (bank industry, securities industry, etc.) and the customer's own requirements, and also vary according to the brand.
Stocks, bonds, CB / WT,
A wide range of derivatives, investment trusts, foreign stocks, foreign bonds, etc. Therefore, as the number of customers increases, the types of such conditions and parameters increase, for example, to thousands. Therefore, in the present system, each rule is classified according to industry and / or customer for each page in accordance with each of those conditions and types of parameters, and one rule book 25 is provided.
We are building as A. This rule book 25A can be updated by a customer or a system provider even during operation of the system.

For this reason, when calculating the balance of a certain customer's stock, for example, on a contract basis, the industry to which the customer belongs specifies which page of the rule book 25A and which rule to use, and the balance according to the rule is specified. Calculation will be performed. In this embodiment, when a condition or parameter to be used is specified, the condition or parameter is used. When the condition or parameter is not specified, a standard rule (for example, a rule most widely used in the industry) is used. Is done.

The transaction database 25B stores transaction data of each customer and various data necessary for the transaction. The balance database 25C stores balance data of each customer up to that time. This balance data is a balance for each brand, and is stored in a format such as the number of shares of the company A. Further, the portfolio review database 25D is data for the customer to present to the client as a portfolio as a portfolio, and is calculated here for each asset. The balance calculation and the portfolio review data calculation are executed on a contract basis, a contract settlement basis, or a delivery basis, as described later.

Next, with reference to FIG. 2, the flow of management / evaluation work by this portfolio management / evaluation system will be described.

The customer operator operates the input device 27 to give a command to the CPU 21, and refers to the past data in the transaction database 25 B under the processing of the CPU 21.
A trade (transaction) command is issued (step S1). This trading command is executed in connection with, for example, an external supplier via the communication device 12. The trading data generated in connection with this trading (transaction) is sent to the transaction database 25B to be updated and stored.

This transaction data is also subjected to processing for balance calculation by the CPU 21 (step S).
2). At this time, the rule book 25A is referred to (step S2a), and the rule page to be used is specified. C
The PU 21 refers to the rule on the designated page (step S2b), and processes the trading data according to the rule. As a result, for example, a processing is performed in which the foreign exchange transaction value of a certain customer is calculated by the “rounding digits” set by the customer different from the industry setting method.

Next, the contract base, the contract settlement base, or the delivery base is selectively designated by the CPU 21, and based on any of them, the balance database 25C
Based on the balance data stored so far, the balance for each brand for the transaction performed this time is calculated (step S3).

The balance data obtained by this calculation is stored again in the balance database 25C, and is also processed (step S4). This processing is
This is for calculating the balance by asset from the balance by stock up to that time. Specifically, the rule book 25A is referred to again (step S4a), and a rule page to be used is specified. The CPU 21 refers to the rule on the specified page (step S4b), and processes the balance data for each brand into the balance data for each asset according to the rule. As a result, for example, the balance data such as “how many shares of a company and how much of a share” is obtained and the balance for each asset such as “how much of a stock” is obtained.

The balance for each asset is then subjected to portfolio review data creation processing by the CPU 21 (step S5). This processing is executed this time based on the previous portfolio review data stored in the portfolio review database 25D based on one of the contract base, the contract settlement base, and the delivery base, which are selectively designated. The portfolio review data reflecting the trades that have been made is calculated in the same format (format) as the balance database.

The portfolio review data is:
It consists of records for the entire portfolio, for each currency and for each asset, and includes a portfolio rental balance sheet (BS), a portfolio profit and loss statement (PL), performance data (such as time-weighted rate of return), cash flow data, and the like.

The portfolio review data thus calculated is then presented to the customer in a printed or online form (step S6).

As described above, according to the portfolio management / evaluation system according to the present embodiment, firstly, since the rule book is provided to correspond to the processing conditions and processing parameters for each industry and / or each customer, There is no need to build a portfolio management / evaluation system for each company or industry. It is only necessary to register processing conditions and processing parameters unique to the industry or the customer in the rule book. Further, even when it becomes necessary to change the processing conditions and processing parameters during the operation, it is possible to cope with it only by updating only the rule book by the system provider or the customer. Therefore, system startup and subsequent operation and maintenance become easier,
One program can meet the needs of customers of all types and business types. For this reason, the information system provider can suppress the cost for the system construction as compared with the case where the system is constructed according to the needs of each customer, and the system can be provided at a lower cost.

Second, according to the portfolio management / evaluation system, unlike the conventional system, an intermediate database such as a balance database and a portfolio review database is provided in addition to the transaction database. Are assembled on one database. Therefore, it is not necessary to calculate the balance data and the portfolio review data from the transaction database each time, and the data processing becomes extremely quick, and the amount of calculation is reduced, so that the calculation load on the CPU can be reduced. As a result, it is also possible to suppress the arithmetic capacity of the CPU, and it is possible to reduce the manufacturing cost of the arithmetic device.

Third, a contract base, a contract settlement base, and a delivery base, which were conventionally handled as separate systems, can be executed by the same system, and the balance database and the portfolio database of the three bases are held in the same format. ing. Therefore, various processes and forms on each base can be handled by one program only by switching the database. This can also reduce costs related to the construction and operation of the portfolio management / evaluation system.

It should be noted that the present invention is not limited to the configuration described in the above-described embodiment, but can take various other forms within the scope of the claims.

[0036]

As described above, according to the portfolio management / evaluation system according to the present invention, a portfolio management / evaluation system which is low in cost and has a high calculation function is provided for both system users and customers. Alternatively, an excellent effect of being usable can be obtained.

[Brief description of the drawings]

FIG. 1 is a functional block diagram showing an overall configuration of a portfolio management / evaluation system according to an embodiment of the present invention.

FIG. 2 is a flowchart showing a schematic flow for evaluating a portfolio.

[Explanation of symbols]

 11 Computer 21 CPU 22 Bus 23 ROM 24 RAM 25 Hard Disk 26 Monitor 27 Input Device 28, 29 Interface

Claims (3)

[Claims] 1. A portfolio management / evaluation system for creating a portfolio from data generated by buying and selling financial products and presenting the portfolio to a customer, wherein a rule necessary for processing the data is defined by at least one of an industry and a customer. A rule book separately stored, a rule selecting means for selecting a rule necessary for processing the data from the rule book, and a portfolio creating means for creating a portfolio of the customer according to the rule selected by the rule selecting means. Portfolio management and evaluation system. 2. A portfolio management / evaluation system for creating a portfolio from data generated by buying and selling financial products and presenting the portfolio to a customer, wherein the portfolio management / evaluation system refers to a transaction database storing data necessary for the buying and selling. Trading means for performing processing, balance data generating means for generating current balance data from trading data generated by the trading with reference to a balance database storing past balances, and a portfolio storing past portfolio review data A portfolio management / evaluation system comprising: portfolio review data creation means for creating current portfolio review data from balance data created by the balance data creation means with reference to a review database. 3. The portfolio management / evaluation system according to claim 2, wherein each of the balance data creating means and the portfolio review data creating means creates data on a contract basis, a contract settlement basis, and a delivery basis. A portfolio management / evaluation system, wherein the balance database and the portfolio review database both store data in the same format.