Systems and methods for automating securities trading

A computerized system comprising:

• a graphical user interface configured to provide a workspace comprising one or more spreadsheets, each of the one or more spreadsheets comprising:
• a first section comprising a plurality of spreadsheet cells for displaying securities data of one or more securities selected by a user;
• a second section comprising a plurality of segments composed of spreadsheet cells for receiving one or more trading orders of one or more securities, wherein each segment is associated with a trading order of a security, wherein each segment comprises an execution trigger cell, a volume cell, a price cell and a status cell, wherein the execution trigger cell defines a condition for executing the trading order, wherein the volume cell defines a volume of the security to be traded, wherein the price cell defines a price for the security in the trading order, wherein the status cell indicates an execution status of the trading order;
• a processor configured to repeatedly retrieve the securities data and update the first section based on a historic database;
• wherein said processor is further configured to evaluate the execution trigger cell of each segment, wherein responsive to the condition of the execution trigger cell being met, said processor is configured to simulate execution of the trading order and update the status cell accordingly.

A computer-implemented method comprising:

• repeatedly retrieving securities data of one or more securities and updating a first section of a spreadsheet, wherein the spreadsheet is displayed by a graphical user interface of a computer;
• receiving, using the spreadsheet, one or more trading orders of the one or more securities, each of which trading orders comprises an execution trigger parameter, a volume parameter, a price parameter and a status parameter, wherein the execution trigger parameter defines a condition for executing the trading order, wherein the volume parameter defines a volume of the security to be traded, wherein the price parameter defines a price for the security in the trading order, wherein the status parameter indicates an execution status of the trading order, wherein the one or more trading orders are received and displayed in a second section of the spreadsheet, wherein each trading order is defined in a segment of the second section, wherein each parameter is defined in a spreadsheet cell;
• evaluating the execution trigger parameter of each trading order;
• responsive to the condition of the execution trigger parameter being met, sending the trading order for execution;
• and,
• updating the status parameter in response to the trading order being completed successfully, whereby the spreadsheet is updated to reflect the successful completion of the trading order;
• wherein said repeatedly retrieving, said receiving, said evaluating, said sending and said updating are performed by a processor.