System and method for online trading using an electronic spreadsheet
AssigneeJPMorgan Chase Bank, National Association
InventorsBrian Lynn, Lawrence Miller
Life of this patent
Estimating the term…
Abstract
A system and method for receiving streamed, real time quotes with respect to financial instruments. The system applies a spreadsheet based investment strategy to the real time quotes, generating electronic orders based on the results of the investment strategy analysis and transmitting the orders for real time execution. The system generates a unique order identifier that allows users to actively track the status of orders in real time. This unique order identifiers can be shared with other users so that other trading strategies can be developed to execute upon the successful execution of the order (e.g., hedging).
Claims31
A system for performing trading of non-exchange traded financial instruments comprising:
- an electronic spreadsheet application, the electronic spreadsheet application containing at least one sheet, the sheet containing an identification of at least one non-exchange traded financial instrument;
- a Dynamic Data Exchange (DDE) interface coupled to the electronic spread sheet application, the electronic spread sheet application transmitting a subscription request to the DDE interface with respect to the financial instrument;
- a financial instrument server coupled to the DDE interface;
- and
- a trading engine coupled to the financial instrument server, wherein real time data related to the financial instrument is provided to the electronic spreadsheet through the financial instrument server and the DDE interface.
A method for performing trading of non-exchange traded financial instruments, the method comprising:
- creating a sheet in an electronic spreadsheet application;
- identifying at least one non-exchange traded financial instrument in the sheet;
- transmitting a subscription request to a Dynamic Data Exchange (DDE) interface with respect to the financial instrument;
- transmitting the subscription request from the DDE interface to a financial instrument server;
- retrieving real time data related to the financial instrument from a trading engine;
- and
- providing the real time data to the electronic spreadsheet through the financial instrument server and the DDE interface.
A system for performing trading of financial instruments comprising:
- an electronic spreadsheet application, the electronic spreadsheet application containing at least one sheet, the sheet containing an identification of at least one financial instrument, wherein the electronic spreadsheet application is programmed to create an order with respect to the financial instrument, the order containing a unique order identifier and wherein the electronic spread sheet application is further programmed to transmit a subscription request to the DDE interface with respect to the financial instrument;
- a Dynamic Data Exchange (DDE) interface coupled to the electronic spread sheet application,;
- a financial instrument server coupled to the DDE interface, wherein the financial instrument server receives the subscription and the order through the DDE interface, the financial instrument server storing the unique order identifier and providing status of the order using the unique order identifier;
- and
- a trading engine coupled to the financial instrument server, wherein real time data related to the financial instrument is provided to the electronic spreadsheet through the financial instrument server and the DDE interface, and wherein the trading engine executes the order.
23 The system according to claim 22, wherein the communication network is the Internet.
A method for performing trading of non-exchange traded financial instruments, the method comprising:
- creating a sheet in an electronic spreadsheet application;
- identifying at least one non-exchange traded financial instrument in the spreadsheet;
- retrieving real time data related to the non-exchange financial instrument from a trading engine;
- generating an order for the non-exchange financial instrument;
- and
- assigning an order identifier to said order and recording the order identifier in the spreadsheet.
A method for performing trading of exchange traded financial instruments, the method comprising:
- creating a sheet in an electronic spreadsheet application;
- identifying at least one exchange traded financial instrument in the spreadsheet;
- retrieving real time data related to the exchange financial instrument from a trading engine;
- generating an order for the exchange financial instrument;
- and
- assigning an order identifier to said order and recording the order identifier in the spreadsheet.
Dependencies are inferred from the claim text.