System for extracting historical market information with condition and attributed windows
First Claim
1. A system for extracting historical market information identifying recurring trends relating to securities traded in a market, the system comprising:
- a computer having a digital storage medium;
a computer data base operable with said computer for organizing historical market information according to attributes;
means for providing a first menu of attributes for presentation in a report;
means for providing a second menu for selecting a condition defining temporal fluctuations of the attributes;
means for selecting one or more attributes from said first menu providing a SHOW ATTRIBUTE query construction;
means for selecting one or more conditions from said second menu providing a WHEN CONDITION query construction;
means for limiting said WHEN CONDITION selecting means to a time interval during which said conditions are satisfied for a predetermined number of occurrences;
means for retrieving, according to said selected SHOW ATTRIBUTE-WHEN CONDITION query construction and said limiting means, the selected attributes of the computer data base for each point in history corresponding to the satisfaction of the selected conditions; and
means for generating, for each point in history according to the satisfaction of the selected conditions, a report presentation for each of the retrieved attributes, whereby a plurality of report presentations is generated, one for each point in history satisfying the selected conditions, allowing comparison among said plurality of report presentations for identifying recurring trends relating to the commodities traded in the market.
2 Assignments
0 Petitions
Accused Products
Abstract
A computerized data retrieval system, especially for commodity price information databases, having a windowing system which aids a user in creating and revising formal search language queries, a database searching engine responsive to such queries, means to generate and format results in both textual and graphic reports, and a capacity for echoing a formal search language query to a display in a near-natural language format for easy comprehension by the user as the query is constructed using the windowing system. The system has facilities for including domain knowledge in a query, such as market knowledge of calendar events, national holidays, triple-witching hours, and option contract expiration dates. The system has additional facilities that permit a user to include more fundamental domain knowledge, such as dates of political elections, date of issuance and value of company earning reports, the consumer price index, and so on. The near-natural language format of the query may be created and revised either through the windowing system or with a text editor.
-
Citations
7 Claims
-
1. A system for extracting historical market information identifying recurring trends relating to securities traded in a market, the system comprising:
-
a computer having a digital storage medium; a computer data base operable with said computer for organizing historical market information according to attributes; means for providing a first menu of attributes for presentation in a report; means for providing a second menu for selecting a condition defining temporal fluctuations of the attributes; means for selecting one or more attributes from said first menu providing a SHOW ATTRIBUTE query construction; means for selecting one or more conditions from said second menu providing a WHEN CONDITION query construction; means for limiting said WHEN CONDITION selecting means to a time interval during which said conditions are satisfied for a predetermined number of occurrences; means for retrieving, according to said selected SHOW ATTRIBUTE-WHEN CONDITION query construction and said limiting means, the selected attributes of the computer data base for each point in history corresponding to the satisfaction of the selected conditions; and means for generating, for each point in history according to the satisfaction of the selected conditions, a report presentation for each of the retrieved attributes, whereby a plurality of report presentations is generated, one for each point in history satisfying the selected conditions, allowing comparison among said plurality of report presentations for identifying recurring trends relating to the commodities traded in the market. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method for extracting historical market information identifying recurring trends relating to securities traded in a market, the method comprising the steps of:
-
organizing, in a computer data base, historical market information according to attributes, the attributes comprising;
market indicators, commodities, equities, transaction price, transaction volume, date, time and the like;providing a first windowing system embodying click on menus of the attribute for presentation in a report; providing a second windowing system providing click on menus of a plurality of interrelated templates providing auto-sequencing for selecting a condition defining temporal fluctuations of the attributes; selecting one or more attributes from said first windowing system providing a SHOW ATTRIBUTE query construction; selecting one or more conditions from said second windowing system providing a WHEN CONDITION query construction; limiting said WHEN CONDITION selecting step to a time interval during which the conditions are satisfied for a predetermined number of occurrences; retrieving, according to said selected SHOW ATTRIBUTE-WHEN CONDITION query constructions and said limiting step, the selected attributes from the computer data base for each point in history corresponding to the satisfaction of the condition; and generating, for each point in history corresponding to the satisfaction of the selected conditions, a report presentation for each of the retrieved attributes, whereby a plurality of report presentations is generated, one each for each point in history satisfying the selected conditions, allowing comparison among said plurality of report presentations for identifying recurring trends relating to the commodities traded in the market. - View Dependent Claims (7)
-
Specification