# US 2013/0254091 A1 · System and Method for Online Trading Using an Electronic Spreadsheet

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2013/0254091 A1
- Document ID: US20130254091A1
- Status: Published application
- Kind: A1
- Application number: 13/868,280
- Filed: 2013-04-23
- Published: 2013-09-26
- Earliest claimed: 2002-09-27
- Assignees: JPMorgan Chase Bank, N.A.
- Inventors: Brian Lynn; Lawrence Miller
- Web page: https://patentgrep.com/patent/US20130254091A1

## CPC

- G06Q 40/04: Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
- G06Q 40/06: Asset management; Financial planning or analysis
- 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

## 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).

## Claims

### Claim at position 1

1-41. (canceled)

### Claim 42

A computer-implemented method for facilitating execution of a hedging strategy by a second trader system in response to an order executed by a first trader system, each trader system including a spreadsheet application connected with a DDE server, the method comprising:
receiving at a financial instrument server a first order from the first trader system, the first order created by the spreadsheet application executed by a processor and received at the financial instrument server through the DDE server of the first trader system;
storing a copy of the first order from the first trader system at a shared file server, the first order identified by a first unique order identifier;
retrieving, using the second trader system, the first order identified by the unique identifier from the shared file server and creating a hedging strategy using the spreadsheet application of the second trader system based on the retrieved first order;
sending a status monitoring request to the financial instrument server from the second trader system for the order identified by the unique identifier;
automatically executing the hedging strategy upon receiving a status update regarding the first order from the financial instrument server, the hedging strategy executed by generating a second order through the spreadsheet application at the second trader system, the second order identified by a second unique order identifier.

### Claim 43 (depends on 42)

The method of claim 42, further comprising communicating through a web browser coupled between the DDE interface and the financial instrument server, wherein the web browser receives the receives real time data from the financial instrument server and publishes the real-time data to the DDE server.

### Claim 44 (depends on 43)

The method of claim 43, further comprising communicating over a communication network coupled between the web browser and the financial instrument server.

### Claim 45 (depends on 44)

The method of claim 44, wherein the communication network is the Internet.

### Claim 46 (depends on 42)

The method of claim 42, further comprising creating an executable order at the financial instrument server for execution by a trading engine, the executable order containing a unique server order identifier, wherein the unique server order identifier is correlated with the first order identifier and the first order identifier differs from the unique server order identifier.

### Claim 47 (depends on 46)

The method of claim 46, further comprising transmitting the executable order from the financial instrument server to the trading engine for execution.

### Claim 48 (depends on 42)

The method of claim 42, further comprising generating the first order by creating a sheet in an electronic spreadsheet application executed by a processor of the first trader system and identifying at least one financial instrument in the spreadsheet.

### Claim 49 (depends on 42)

The method of claim 42, further comprising generating the first order for a non-exchange financial instrument.

### Claim 50 (depends on 42)

The method of claim 42, further comprising generating the first order for an exchange traded financial instrument.

### Claim 51 (depends on 46)

The system of claim 46, wherein, based on a subscription request, the trading engine automatically provides real time update data related to the financial instrument, including the unique server order identifier, to the financial instrument server, the financial instrument server correlating the unique server order identifier with the corresponding unique order identifier and transmitting the real time update data including the corresponding unique order identifier to the electronic spreadsheet application through the DDE interface.

### Claim 52 (depends on 51)

The system according to claim 51, further comprising a web browser coupled between the DDE interface and the financial instrument server, wherein the web browser receives the subscription from the DDE interface, receives the real time data from the financial instrument server, and publishes the real-time data to DDE.

### Claim 53 (depends on 42)

The system of claim 42, wherein the spreadsheet of each trader system is automatically and continuously updated to reflect any changes in data related to financial instruments referenced in the spreadsheet.

### Claim 54 (depends on 42)

The system of claim 42, wherein each spreadsheet is programmed to automatically generate and submit orders if certain conditions occur.
