'Same way you have to call this functions in cell to get Quotes 'If You don't add symbol in Pi Market Watch, You will not get quotes in Excel 'This is Equivalent to Adding Symbols in Market Watch in Pi. To get Realtime Quote, You need to Subscribe Quotes for the Symbol 'Returns One of the Order Status OPEN|TRIGGER PENDING|CANCELLED|REJECTED 'Returns Complete Order Details Like Qty Filled, Time, Avg Price etc =ConvertPosition(Exch, TrdSym, Trans, Qty,PositionType, OldProduct, NewProduct) 'Position Type - day or overnight (case Sensitive) =PlaceAmo(Exch, TrdSym, Trans, OrdType, Qty,ProdType, LmtPrice, TrgPrice, val) =ModifyBOMain(Exch, TrdSym, OrderId, Qty, LmtPrice) =ModifyBOSl(Exch, TrdSym, OrderId, ParentOrderId,TrgPrice) =ModifyBOTgt(Exch, TrdSym, OrderId, ParentOrderId,LmtPrice) =PlaceBO(Exch, TrdSym, Trans, Qty,LmtPrice, SqOffValue,StoplossValue, TrailValue) =Modif圜OSl(Exch, TrdSym, OrderId, ParentOrderId,TrgPrice) =PlaceCO(Exch, TrdSym, Trans, Qty,stoploss_Price) =ModifyRegularOrder(Exch, TrdSym, OrderId, OrdType,Qty, LmtPrice, TrgPrice) =PlaceRegularOrder(Exch, TrdSym, Trans, OrdType, Qty,ProdType, LmtPrice, TrgPrice, val) 'Trade Symbol - As it is in Instrument List 'For Example, To Buy 1 Lot of Nifty Just pass 1 not 75 'No of Lots to Buy/Sell incase of FUT NOT Lot Size 'Qty should be No of Shares to Buy/Sell incase of EQ 'Below Order Functions will Return OrderId in the Cell Itself These Functions are User Defined Functions which You can call from within the Excel Cell. Place Regular, BO & CO orders within the cell by Just inputing the respective Functionīelow are the Excel Functions Syntax for Order Requests. You can perform all kind of order request such as Place, Modify & cancel etc from within the Excel Cell. User Defined Functions List.For Reference.