# US 2013/0159832 A1 · Systems and methods for trading using an embedded spreadsheet engine and user interface

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

- Number: US 2013/0159832 A1
- Document ID: US20130159832A1
- Status: Published application
- Kind: A1
- Application number: 13/712,439
- Filed: 2012-12-12
- Published: 2013-06-20
- Earliest claimed: 2011-12-12
- Assignees: Black Point Technologies LLC
- Inventors: Rosario M. Ingargiola; Jay Marvin
- Web page: https://patentgrep.com/patent/US20130159832A1

## CPC

- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06Q 40/00: Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- 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

Systems and methods for facilitating trading and trading analyses are presented herein. Aspects of the present invention include systems and methods for receiving real-time and historic data, caching and updating the data for access by an embedded spreadsheet engine with a spreadsheet user interface, processing the data using spreadsheet logic and functions, and generating electronic trading message orders. Embodiments of the present invention also support the publishing of and subscribing to data and trading messages. Embodiments of the present invention also support backtesting analyses.

## Claims

### Claim 1

A computer-implemented trading system comprising:
a trading application for receiving and analyzing data, the trading application comprising:
a user interface that provides one or more features that facilitate displaying data in memory to a user and receiving input from the user;
a spreadsheet user interface that provides one or more features that facilitate displaying data in memory to a user and receiving input from the user;
an embedded spreadsheet engine, which is in-process with the trading application, that is communicatively coupled to the spreadsheet user interface and to the user interface and that receives from the user a request comprising one or more parameters; and
a dynamic cache communicatively coupled to the embedded spreadsheet engine that is accessed by the embedded spreadsheet engine using a key that is based upon the one or more parameters in the request to access data in the dynamic cache to process, at least in part, the request, wherein data in the dynamic cache is stored in key-value pairs, with each key being based upon one or more parameters and each value being a value related to the one or more parameters.

### Claim 2 (depends on 1)

The computer-implemented trading system of claim 1 further comprising:
an event subscription manager that:
for each data stream specified by a user, registers with one or more data servers to receive event notices from the one or more data servers; and
responsive to receiving data from one or more data servers, populates the dynamic cache with data by creating entries in a table of keys in the dynamic cache, a key in the table of keys being based upon one or more parameters associated with data.

### Claim 3 (depends on 2)

The computer-implemented trading system of claim 2 further comprising:
a data aggregation processor that, responsive to a request for data not in the dynamic cache, receives data from one or more data services and responsive to the received data not being in a form to satisfy the request, performs one or more transformations on at least some of the data and stores the transformed data in the dynamic cache.

### Claim 4 (depends on 3)

The computer-implemented trading system of claim 3 wherein:
at least one of the caches in the dynamic cache comprises streaming data and the data aggregation processor performs a transformation in real time on at least some of the streaming data, historical data, or a combination thereof.

### Claim 5 (depends on 1)

The computer-implemented trading system of claim 1 wherein:
at least one of the caches in the dynamic cache is an indexed cache that stores a rolling time-ordered series of data that is updated in real time.

### Claim 6 (depends on 1)

The computer-implemented trading system of claim 1 wherein the application is further configured to perform at least one of:
publishing data for consumption by one or more third-parties; and
subscribing to receive data from one or more third-party for use by a user of the application.

### Claim 7

A computer-implemented method for generating a trading message using a trading application comprising an in-process embedded spreadsheet engine, the method comprising:
receiving values for a trading-related parameter into an array in a dynamic cache communicatively coupled to an embedded spreadsheet engine that accesses data in the array in the dynamic cache using keys based upon one or more parameters in a function that defines the array, data in the dynamic cache being stored in key-value pairs;
generating a display of the array using a spreadsheet user interface communicatively coupled to the embedded spreadsheet engine, the values being updated according to a specified condition defined by the function;
generating a trading trigger using at least some of the values in the array; and
responsive to the trading trigger yielding an affirmative trading trigger, generating the trading message.

### Claim 8 (depends on 7)

The computer-implemented method of claim 7 wherein the array comprises a real-time array and the step of receiving values for a trading-related parameter in the array:
receiving real-time values for a trading-related parameter and updating at least one cell in the array with one or more real-time values based upon one or more parameters in the function that defines the array.

### Claim 9 (depends on 8)

The computer-implemented method of claim 8 wherein:
the array is a rolling window array such that as a new value is added into the array according to one or more parameters in the function that defines the array, the prior values in the array are shifted and a last value in the array is dropped.

### Claim 10 (depends on 8)

The computer-implemented trading method of claim 8 further comprising:
responsive to the function requesting data that is not in the dynamic cache, receiving data from one or more data services and responsive to the received data not being in a form to satisfy the function, performing one or more transformations on at least some of the data and storing the transformed data into at least part of the array in the dynamic cache.

### Claim 11 (depends on 7)

The computer-implemented trading method of claim 7 further comprising:
receiving input from a user via a user interface that defines a named-range trading parameter template, the named-range trading parameter template comprising sufficient information for a trade message, the named-range trading parameter template being assigned a name by the user as an identifier for that particular trading message template to facilitate referencing the trading message template within one or more trading functions in the trading application.

### Claim 12 (depends on 11)

The computer-implemented trading method of claim 11 further comprising:
displaying the named-range trading parameter template as a collection of cells in the spreadsheet user interface.

### Claim 13 (depends on 11)

The computer-implemented trading method of claim 11 further comprising:
receiving the trigger as a trigger function in a cell in the spreadsheet user interface, the trigger function comprising one or more parameters in which at least one of the parameters is the name of the named-range trading parameter template.

### Claim 14 (depends on 11)

The computer-implemented method of claim 11 wherein the named-range trading parameter template comprises at least one or more of the following fields:
a “Status” field configured to receive a state value of a most recent trade request originated from the named-range trading parameter template;
a “CancelFirst” field configured to receive one or more assigned names of named-range trading parameter templates that comprise trade messages;
a “CloseFirst” field configured to receive one or more assigned names of named-range trading parameter templates that comprise trade messages; and
an “IfDone” field configured to receive one or more assigned names of named-range trading parameter templates that comprise trade messages,
wherein the one or more of the fields allowing transaction controls affecting execution of the trading message.

### Claim 15 (depends on 14)

The computer-implemented method of claim 14 wherein the trade message is further processed with state management and automation comprising one or more of the following conditional tests:
a Status test that checks whether a state of a last order submitted using the named-range trading parameter template to determine whether the trading message is allowed to be sent for execution;
a Cancel First test that, responsive to the trade message being permitted, checks whether any of the named-range trading parameter templates in the CancelFirst field having pending trading messages, and responsive any such pending trading message or messages, automatically cancelling any such pending trading message or messages before sending the present trading message for execution;
a Close First test that, responsive to the trade message being permitted, checks whether any of the named-range trading parameter templates in the CloseFirst field having open positions from the named-range trading parameter templates, and responsive any such positions, automatically closing any such positions before sending the present trading message for execution; and
an If Done test that, responsive to the trade message being permitted, automatically processes trading message from the named-range trading parameter templates in the IfDone field when the when the present trading message has been executed.

### Claim 16 (depends on 7)

A non-transitory computer-readable medium or media comprising one or more sequences of instructions which, when executed by one or more processors, causes steps to perform the method claim 7.

### Claim 17

A computer-implemented method for facilitating publication of and subscription to trading-related information among a plurality of third parties, the method comprising:
receiving a content service registration from a publisher user using a first instance of a trading application;
responsive to receiving a request from a subscriber user to subscribe to the content service, the request being generated by a second instance of the trading application in which a subscriber user entered a subscription request into a user interface of the second instance of the trading application, the request comprising a unique identifier of the content service, associating the subscriber user with the content service; and
responsive to receiving a content message for the content service from the publisher user, the content message being generated by the first instance of the trading application in which the published user entered a publication request into a user interface of the first instance of the trading application that causes the content message to be published, the publication request comprising the unique identifier of the content services, broadcasting the content message.

### Claim 18 (depends on 17)

The computer-implemented method of claim 17 wherein the content message is a trading message and the method further comprises:
generating a subscriber trading message for the subscriber user by performing at least one of the steps comprising:
responsive to the subscriber user having identified one or more modifying parameters, modifying the trading message according to the one or more parameters to generate the subscriber trading message; and
responsive to the subscriber user not having identified one or more modifying parameters, mirroring the trading message to generate the subscriber trading message; and
sending the trading message and the subscriber trading message to one or more brokers for execution.

### Claim 19 (depends on 18)

The computer-implemented method of claim 18 further comprising:
aggregating the trading message and the subscriber trading message into one or more aggregate block trades for execution.

### Claim 20 (depends on 17)

The computer-implemented method of claim 17 wherein the content message is a data message and the step of broadcasting the content message further comprises:
broadcasting the data message to the subscriber user via the second instance of the trading application.
