You will have to build this feature of order placement via Google sheets at your end via Publisher or kite connect APIs. We don't provide this order placement via google sheets out of the box.
I tried again to place the order via Publisher api the same way as I m doing for CNC trades. The following is the error message i m getting: {"status":"error","message":"No valid orders found in payload.","data":null,"error_type":"InputException"}
{"status":"error","message":"No valid orders found in payload.","data":null,"error_type":"InputException"}
You are requesting the wrong order payload. You need to re-check all order fields. Refer to the documentation here for the order request param.
BHARTIARTL AUG 570 CE
You will have to send, Tradingsymbol of the instrument for tradingsymbol field. Trading symbol for above would be: BHARTIARTL21AUG570CE. You can find instrument-related detail using this API.
{"status":"error","message":"No valid orders found in payload.","data":null,"error_type":"InputException"}
BHARTIARTL AUG 570 CE
Tradingsymbol of the instrument
fortradingsymbol
field. Trading symbol for above would be:BHARTIARTL21AUG570CE
.You can find instrument-related detail using this API.