Execution of MIS trades with Google sheet

Developer Brief (Execution)

Objective
Build a sheet-connected system that reads the daily stock list from my server, takes my inputs from the sheet (ON/OFF, Version, Capital per stock, Order type) places the trades with my broker( Currently Zerodha) and writes confirmations .

Daily flow
1) Read the latest stock list from the server (URL will be provided). The list is prepared around 09:16 IST( may be few seconds later)
2) In the Google Sheet, I will select:
Engine ON/OFF
Version (1, 1.1, 2, 2.1, 3, 3.1, 4, 4.1)
Capital per stock (e.g., 50,000)
Order type (MIS - Default)
Type of Trade - Paper Trade / Real Trade
3) After getting list from , Place the orders through my broker API ( Zerodha) based on the plan.
4) Record fills, exits into the sheet during the day.
5) Maintain P&L after end of all trades.
6) Close any remaining positions by 15:20 IST


Execution rules to follow
Place orders exactly as per the plan defined
Update the sheet with order status, average price, and quantity.
Track exits and P&L through the day and write updates to the sheet.
Exit all open positions at 15:20 IST and write a final P&L row.
This strategy is based on 1min candle so very and accurate execution required.

Handover items
1) A Google Sheet template with the following sections:
Controls (ON/OFF, Version, Capital per stock, Order type)
Symbols list (read-only, filled from the server)
All trade rules defined very accurately.
Live Orders & Positions
P&L log (with timestamps)
2) A short Readme describing how to connect the sheet to the server and to the broker API.
3) A small log file or tab that shows requests sent to the server and responses received (timestamps included).



I will share all trade rules after discussion with the right candidate only .