WO1999039289A2 - Method for elaborating and representing data analysis in a decision support system - Google Patents
Method for elaborating and representing data analysis in a decision support system Download PDFInfo
- Publication number
- WO1999039289A2 WO1999039289A2 PCT/EP1999/000504 EP9900504W WO9939289A2 WO 1999039289 A2 WO1999039289 A2 WO 1999039289A2 EP 9900504 W EP9900504 W EP 9900504W WO 9939289 A2 WO9939289 A2 WO 9939289A2
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- user
- selection
- securities
- criteria
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/904—Browsing; Visualisation therefor
Definitions
- the present invention relates to a method for representing data analysis in a decision support system.
- the invention relates to a method for elaborating and representing data analysis in a decision support system, the system comprising:
- - computer means comprising linking interfaces to allow on line connections to said data base;
- display means associated to the computer means for displaying information and data and for allowing the user to define data selection criteria by a mouse or a keyboard interface.
- the daily challenge of a professional set of securities manager is just that of spotting the right investment opportunities, reacting quickly to market changes while increasing the quality of the results.
- the data are displayed by software tools which allow the professional user to watch the current numerical value of many securities and to compare such a current numerical value with past values series.
- the whole information set is difficult to manage and to evaluate so that a decision based on the available information is not always taken according to the investment objectives .
- a first object of the present invention is that of providing a new method of representing data analysis which may help the user to take faster decisions.
- a further object of the present invention is to provide an innovative system which allows full personalization of investment strategies using a large range of indicators.
- Another object of the present invention is that of providing a software tool which may be used by non-expert users.
- a further object of the present invention is that of representing information data in a friendly user manner in order to facilitate the taking of a decision according to the investment objectives.
- a further object of the present invention is that of providing a easy-to-use interface which might help the user to work faster in taking all relevant investment decisions improving the results while reducing the risk of wrong decisions .
- the solution idea on which the invention is based is that of providing a fast reactive computer program interface which allows the user to quickly scan the data base through graphical images or views corresponding to historical paths of selected data.
- the technical problem is solved by a method for elaborating and representing data analysis in a decision support system, the system comprising:
- - a computer means managing said data base and comprising linking interfaces to allow on line and/or batch connections to external data suppliers or providers; - display means for displaying information and data and for allowing the user to define data selection criteria;
- a plurality of different information data may be selected one after the other through said selection panel and a corresponding plurality of history charts are automatically shown in an overlapping format on said display means and with the same time base.
- FIG. 1 shows a schematic diagram of an apparatus implementing the method according to the present invention
- FIG. 2 is an exemplary visual representation of a selection menu presented on a display according to the method of the present invention
- FIG. 3 is an exemplary visual representation of a selection panel according to the present invention.
- FIG. 4 shows a schematic view of a historical data path of a selected data contained in a data base of the apparatus according to the present invention
- FIG. 5 is a further exemplary visual representation of a selection panel according to the present invention.
- Figure 6 shows a schematic view of a historical data path of a selected data shown in Figure 5;
- FIG. 7 and 8 show respective overlapping historical data paths of a set of data contained in a data base of the present invention
- FIG. 9 is an exemplary visual representation of a graphic interface of the present invention.
- FIG. 10 is a high level flow-chart representing the steps of a method in accordance with the present invention.
- the method and the apparatus allows to combine:
- the inventive method are implemented in a decision support system 1 including computer means 2 which may operate in a stand-alone manner or may be interconnected on a local area network LAN 7.
- the computer means 2 comprises memory means 3 and linking interfaces 4, such a gateway ⁇ , to allow on line connections to external data providers managing a data base containing financial information.
- the external data providers may be structured with computers local area networks .
- Video display means 5 are provided for displaying to the user information and data.
- a conventional keyboard 11 is associated to each computer means 2 and printer 12 is available too.
- the memory means 3 are provided to store locally financial information such as set of securities which are received from the data provider.
- Each computer means 2 which contains a computer program according to the present invention and which is structured by a set of functions which have been developed in a C++ programming language, within a Visual C++ MS® programming environment.
- Each function assists the user in performing a specific task, such as:
- the user may combine the functions use according to his favorite work flow as will be explained in the following description.
- the functions operates on the set of securities data base. However, they are not designed to update the basic information which are treated by the data provider.
- a set of securities is always presented as a browser with the list 15 of securities presented in a table, as shown in Figure 2.
- the user can quickly configure the table columns to display the values of any indicator in the data base, such as: date, market, weight, volatility, etc...
- the table can be searched and sorted with respect to the values in any column.
- a list of securities may be selected from a domain, according to a predetermined set of user's specified criteria.
- the set of securities data base is used as domain and a selection menu 16 is available to the user for defining the preferred selection.
- the user may create a list of target securities using standard filters for security selection.
- the security selection panel or menu 16 is presented to the user so that basic, fundamental, quantitative and technical data may be selected.
- Second selection such as: price/earning, price/book value, dividend.
- Numerical constrains can be defined in a graphical way and may be quantitative, for instance a volatility of no more than 2,5%, or qualitative, for instance a price/earning low or very low; where "very low” means the lowest quartile of the values in the used domain and "low” means the quartile before the lowest.
- all the available information about a specific security may be displayed in a specific window. As many security display windows can be opened at the same time as needed.
- Each of the displays is fully configurable to include only the information or indicators relevant for a current task.
- This function allows to define securities scores. This function may be used to define filters for personal and global asset scoring.
- Figure 9 shows a dialog window 22 which may be used by the user to set the score ranges of the securities .
- a visual flag or indicator on securities having a high score such as a score inside the range 90.00 and 100.00.
- a flag may be shown as a "buy" label associated to a predetermined remaking color.
- the score or weighting is displayed and defined by means of a very intuitive graphical interface 19, as shown in Figure 9.
- the selected scoring is quickly computed and an optimized scored set of securities is presented on the selected panel 15 with respect to the combination of user's defined preferences .
- Beta parameter of no more than 40% on a certain security
- a Year to Date Total Return of 60% on another security and so on.
- Constraints are easily added, modified or removed according to the present invention by means of the graphical interface 19 shown in Figure 2.
- the data base set of securities may be deeply analyzed through a specific function.
- the analysis function computes the average of the set of securities combining the historical quotes of the securities while taking into account the set of securities scoring.
- Pie charts 21, scatter diagrams 28 or heat maps may be presented on the video display by defining the indicators to focus on. 1.5 Comparison
- a comparison function allows to compare and match any set of set of securities data.
- the user indicates a reference set of securities and a number of actual set of securities to be compared.
- the comparison function computes the buy/sell actions needed to transform each of the set of securities into the reference and the implied turnover.
- the actions may be filtered and presented in a fully customized way.
- the comparison allows to analyze the differences among the set of securities under consideration with a powerful set of display tools, such as multiple synchronized pie charts, multiple scanner diagrams, etc...
- the comparison computes the average of all the set of securities under analysis combining the historical quotes of the securities .
- the program presents to the user a selection panel 16 for displaying information and data and for allowing the user to define data selection criteria.
- the data supplied by the external data provider are received on line by the linking interfaces 4 of the computer means 2.
- Such a window is a graphical representation of the history of the security's market quotations, that is: a history chart 24 as shown in Figure 4. It is possible to open any number of such representations.
- a view or history chart 24 showing to the user the variations versus time of the preferred data, while maintaining the selected panel 18 as a side or background view;
- the automatic refreshment of the history chart is such that for the user get the updated view in the same instant in which a new highlighted security 23 is detected.
- the implementation is based on the Document-View model of an architecture based on Microsoft Foundation Classes (MFC).
- MFC Microsoft Foundation Classes
- a pointer to the current security is defined.
- the set of securities display (browser) as well as the history chart and the security display are implemented as Views.
- both the history chart 24 and the security selected panel 18 ask to the computer means 2 the information to be displayed.
- the needed data are acquired from the data provider in numerical format to the requiring views, which in turn compute the proper graphical representation and update their displays on the screen.
- a history chart it is possible to compare any number of securities histories, as shown in Figure 7. This is achieved by dragging form a set of securities display or browser the name of the security into the screen area 25 of a displayed history chart. All the displayed histories are rescaled to a reference value, for instance 100, at the beginning (first day) of the displayed period.
- the rescale day is moved to the day in the history corresponding to the clicked point.
- the arrow keys allow to move the rescale day backward and forward on the time line. It is thus possible to evaluate the relative performances of all the securities displayed in a history chart over any specific period in the past, simply by clicking on the proper day.
- the history graph legenda the market data of all the displayed securities at the rescale day are displayed together with the performance of each of them since the rescale day.
- the original security in the history chart is substituted with the new one and the chart is rescaled to the last selected rescale day.
- the history chart view obtains from the data provider the history of each added security as soon as it is dragged into the chart screen area.
- the histories are stored in numerical format.
- the actual values to be displayed in graphical format are computed locally and by-need.
- the value of all the histories is set to the reference value at the rescale day and each of them is transformed to keep unchanged the percentage variation of the value of each day with the value of the rescale day.
- a new graphical representation is computed and the display is updated.
- This feature allows a plurality of different information data to be selected one after the other through said selected panel 18 and a corresponding plurality of history charts to be shown on said display means with the same time base and in an overlapping format, as clearly shown in Figure 7.
- a score function allows to associate a score to each security in a list.
- a score is a real value between 0.00 and 100.0.
- the score of each security is relative to the scores of the other securities in the current list.
- the "best” security gets score 100.0 and the "worst” gets 0.0; all the securities in the range between 0.00 and 100.00 get a value proportional to their "goodness”.
- the scoring is computed by the system according to a set of criteria interactively defined by the user as shown in Figure 9.
- Any numerical dimension on which the securities in the securities list can have a value can be used as an scoring criteria.
- the values of all the numerical field offered by the data provider on each security can be adopted as a scoring criteria. The user can select the scoring criteria among the numerical parameters available for the securities.
- the user can also weight the selected criteria by graphically manipulating a set of cursors 19 on the screen, one for each criteria. Weight of criteria is expressed in percentage.
- the user interface includes a set of tools for balancing the weights according to the user's preferences. When the weight of a criteria is manipulated with the interface, the weights of the other criteria are adjusted in real-time to keep their sum to 100 while respecting the ratios among them, as clearly shown in the display portion 17 of Figure 2.
- each criteria can be used on a direct (higher values are preferred) or an inverse (lower values are preferred) scale.
- the system assigns a score value to each security in the current list.
- the score of each security is computed as a combination of the values of the data fields used as scoring criteria.
- the security with a better compromise of values for the weighted criteria gets a proportionally higher score than a security with a worse combined value.
- Scores can be displayed in a column of the Browser View and can be used, as the value of any data field, to sort and search the securities list.
- the score function transforms the score into a symbolic evaluation.
- An evaluation is a colored short text associated to a range of scores.
- the user with a graphical interface, defines the text, the color and the range of scores to be associated to each evaluation. Evaluations can be displayed in a column of the Browser view and can be used, as the value of any data field, to sort and search the securities list.
- the user interface of this function is dynamically built on the set of criteria defined and weighted by the user.
- the interface is restructured to host a new graphical object enabling the user to weight the criteria.
- the application asks the data provider for the values of the M parameters used as criteria for the N securities in the securities list.
- a NxM matrix is built and locally stored.
- the securities values are thus cached by the application inside the local memory means 3 and it is not necessary to communicate with the data provider if the set of the criteria is not changed.
- the computation of a new scoring is performed as follows:
- the weights of the parameters are stored in a column vector of dimension M;
- a score is assigned equal to the internal product of the row vector with the column vector of the parameters weights.
- the method according to the present invention has the great advantage of allowing the managing of huge amounts of daily changing data and information which are transformed into image results helping the user in his decision process .
- the method according to the invention may be considered as a very fast solving puzzle in which a huge amount of different pieces are correctly put together in order to provide a complete picture.
- the method allows to work faster having all relevant investment information to take better investment decisions which may be based on the user preferred criteria.
- This method allows to improve the investment results by taking optimized decisions according to security parameters .
- the user may manage the risk by controlling set of securities and investment strategies.
Abstract
Description
Claims
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CA002284086A CA2284086A1 (en) | 1998-01-30 | 1999-01-29 | Method for elaborating and representing data analysis in a decision support system |
EP99908825A EP0972262A2 (en) | 1998-01-30 | 1999-01-29 | Method for elaborating and representing data analysis in a decision support system |
JP53890699A JP2001518221A (en) | 1998-01-30 | 1999-01-29 | A Method for Elaborating and Representing Data Analysis in Decision Support Systems |
AU28302/99A AU2830299A (en) | 1998-01-30 | 1999-01-29 | Method for elaborating and representing data analysis in a decision support system |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US1631498A | 1998-01-30 | 1998-01-30 | |
US09/016,314 | 1998-01-30 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO1999039289A2 true WO1999039289A2 (en) | 1999-08-05 |
WO1999039289A3 WO1999039289A3 (en) | 1999-10-14 |
Family
ID=21776509
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/EP1999/000504 WO1999039289A2 (en) | 1998-01-30 | 1999-01-29 | Method for elaborating and representing data analysis in a decision support system |
Country Status (5)
Country | Link |
---|---|
EP (1) | EP0972262A2 (en) |
JP (1) | JP2001518221A (en) |
AU (1) | AU2830299A (en) |
CA (1) | CA2284086A1 (en) |
WO (1) | WO1999039289A2 (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2000042833A2 (en) * | 2000-06-08 | 2000-07-27 | Andrei Duka | Method of graphical display and analysis of information |
US7849117B2 (en) | 2000-01-12 | 2010-12-07 | Knowledge Sphere, Inc. | Multi-term frequency analysis |
WO2014113898A1 (en) * | 2013-01-25 | 2014-07-31 | Ytrail Ag | Method for accessing and automatically correlating data from a plurality of external data sources |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO1992012488A1 (en) * | 1990-12-28 | 1992-07-23 | Teknekron Software Systems, Inc. | Apparatus and method for creation of a user definable video displayed document showing changes in real time data |
WO1995026005A1 (en) * | 1994-03-23 | 1995-09-28 | Belzberg Sydney H | Computerized stock exchange trading system |
WO1996006402A1 (en) * | 1994-08-23 | 1996-02-29 | Financial Models Company Inc. | Portfolio performance analysis system |
-
1999
- 1999-01-29 JP JP53890699A patent/JP2001518221A/en active Pending
- 1999-01-29 AU AU28302/99A patent/AU2830299A/en not_active Abandoned
- 1999-01-29 WO PCT/EP1999/000504 patent/WO1999039289A2/en not_active Application Discontinuation
- 1999-01-29 EP EP99908825A patent/EP0972262A2/en not_active Withdrawn
- 1999-01-29 CA CA002284086A patent/CA2284086A1/en not_active Abandoned
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO1992012488A1 (en) * | 1990-12-28 | 1992-07-23 | Teknekron Software Systems, Inc. | Apparatus and method for creation of a user definable video displayed document showing changes in real time data |
WO1995026005A1 (en) * | 1994-03-23 | 1995-09-28 | Belzberg Sydney H | Computerized stock exchange trading system |
WO1996006402A1 (en) * | 1994-08-23 | 1996-02-29 | Financial Models Company Inc. | Portfolio performance analysis system |
Non-Patent Citations (2)
Title |
---|
KAZUHIDE SHIGEMI ET AL: "DECISION SUPPORT EXPERT SYSTEMS FOR BOND TRADING" HITACHI REVIEW, vol. 41, no. 1, 1 February 1992 (1992-02-01), pages 9-14, XP000312045 * |
MOON Y S ET AL: "AN INTELLIGENT DECISION SUPPORT SYSTEM FOR STOCK INVESTMENT" INFORMATION TECHNOLOGIES FOR THE NINETIES - E2C2;ENERGY, ELECTRONI COMPUTERS, COMMUNICATIONS, BOMBAY, NOV. 22 - 24 NOV., 1989, no. CONF. 4, 22 November 1989 (1989-11-22), pages 956-959, XP000204000 INSTITUTE OF ELECTRICAL AND ELECTRONICS ENGINEERS * |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7849117B2 (en) | 2000-01-12 | 2010-12-07 | Knowledge Sphere, Inc. | Multi-term frequency analysis |
WO2000042833A2 (en) * | 2000-06-08 | 2000-07-27 | Andrei Duka | Method of graphical display and analysis of information |
WO2000042833A3 (en) * | 2000-06-08 | 2001-03-15 | Andrei Duka | Method of graphical display and analysis of information |
WO2014113898A1 (en) * | 2013-01-25 | 2014-07-31 | Ytrail Ag | Method for accessing and automatically correlating data from a plurality of external data sources |
US10204123B2 (en) | 2013-01-25 | 2019-02-12 | Datawerks Holding Gmbh | Method for accessing and automatically correlating data from a plurality of external data sources |
Also Published As
Publication number | Publication date |
---|---|
CA2284086A1 (en) | 1999-08-05 |
AU2830299A (en) | 1999-08-16 |
EP0972262A2 (en) | 2000-01-19 |
WO1999039289A3 (en) | 1999-10-14 |
JP2001518221A (en) | 2001-10-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20020059294A1 (en) | Method and apparatus for elaborating and representing data analysis in a decision support system | |
Jung et al. | Robo-advisory: opportunities and risks for the future of financial advisory | |
US7603308B2 (en) | Security analyst estimates performance viewing system and method | |
US8615456B2 (en) | Enhanced system and method for managing financial market information | |
US7167838B1 (en) | Security analyst estimates performance viewing system and method | |
Archer et al. | An integrated framework for project portfolio selection | |
US8005733B2 (en) | Methods and interface for set-partitioning decision support tool | |
US7991672B2 (en) | System and method of visual illustration of stock market performance | |
US20080163085A1 (en) | Multi-criteria decision support tool interface, methods and apparatus | |
US7539637B2 (en) | Security analyst estimates performance viewing system and method | |
US7149716B2 (en) | Security analyst estimates performance viewing system and method | |
US20040068429A1 (en) | Strategic organization plan development and information present system and method | |
US20020055899A1 (en) | Display system and method for displaying and organizing financial information | |
US20120188250A1 (en) | Graphical forecasting interface | |
US20090006226A1 (en) | Stock analyzing engine | |
US20120011080A1 (en) | Core/satellite financial portfolio design methodology, system and computer readable medium | |
US8150752B2 (en) | Computerized financial information retrieval by dynamic URL construction | |
AU2006262221B2 (en) | Enhanced system and method for managing financial market information | |
US20050267835A1 (en) | System and method for evaluating exposure across a group of investment portfolios by category | |
US20040220868A1 (en) | Financial information display system | |
US20050108268A1 (en) | Company board data processing system and method | |
Guo et al. | Rankfirst: Visual analysis for factor investment by ranking stock timeseries | |
CA2640068A1 (en) | System and method configured for facilitating financial analysis | |
EP0972262A2 (en) | Method for elaborating and representing data analysis in a decision support system | |
US20230360129A1 (en) | Enhanced system and method for managing financial market information |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
ENP | Entry into the national phase in: |
Ref document number: 2284086 Country of ref document: CA Ref document number: 2284086 Country of ref document: CA Kind code of ref document: A |
|
WWE | Wipo information: entry into national phase |
Ref document number: PA/A/1999/008861 Country of ref document: MX |
|
ENP | Entry into the national phase in: |
Ref document number: 1999 538906 Country of ref document: JP Kind code of ref document: A |
|
WWE | Wipo information: entry into national phase |
Ref document number: 1999908825 Country of ref document: EP |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
AK | Designated states |
Kind code of ref document: A3 Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A3 Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
WWP | Wipo information: published in national office |
Ref document number: 1999908825 Country of ref document: EP |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: 1999908825 Country of ref document: EP |