Pegged to Market Order using VBA

Pegged to market orders are frequently used by traders and scalpers in volatile markets, because they provide the opportunity to get the best possible price when buying or selling a security. Peg orders are based on the Best Bid and Ask. The Best Bid is the highest price a trader […]

User Defined Function (UDF) to get Trade Symbol for Options

Below UDF can be used to get trade symbol for weekly and monthly options. Click here to know more about Trade Symbol format for various segments. Syntax: GetOptionTradeSymbol(Symbol,Strike,OptType,Expiry) Example usage: =GetOptionTradeSymbol(“BANKNIFTY”,26200,”CE”,”30-May-2019″) OR =GetOptionTradeSymbol(“BANKNIFTY”,26200,”CE”,DATE(2019,5,30)) Public Function GetOptionTradeSymbol(ByVal Symbol As String, ByVal Strike As Double, ByVal OptType As String, ByVal Expiry As […]

Excel formula to get Weekly Options Trade Symbol

To know more about the trade symbol format for various market segments, please refer this link. Below excel formula can be used to get weekly options trade symbol. =[SYMBOL]&TEXT([EXPIRY],”yy”)&IF(MONTH([EXPIRY])=10,”O”,IF(MONTH([EXPIRY])=11,”N”,IF(MONTH([EXPIRY])=12,”D”,MONTH([EXPIRY]))))&TEXT([EXPIRY],”dd”)&[STRIKE]&[OPT]   Example: A3 = BANKNIFTY B3 = 21-Apr-2019 C3 = 25000 ‘CE Options D3 = A3&TEXT(B3,”yy”) &IF(MONTH(B3)=10,”O”,IF(MONTH(B3)=11,”N”,IF(MONTH(B3)=12,”D”,MONTH(B3)))) &TEXT(B3,”dd”)&C3&”CE” ‘PE Options E3 […]

Hello Upstox v2.0 Setup

Steps involved 1. Upstox API Subscription 2. Hello Upstox Installation 3. Initial Settings and Login Upstox API Subscription: Login to Upstox developer console at https://developer.upstox.com Make sure you have sufficient balance in your trading account for API charges. Create New App Select: API Trading App Name : As required (Ex: […]

Hello Kite v2.0 Setup

Steps involved 1. Kite API Subscription 2. Hello Kite Installation 3. Initial Settings and Login Kite API Subscription: Login to Kite developer console at https://developers.kite.trade Add necessary credits using Payment Gateway or use balance from your trading account. Create New App Type: Connect App Name : As required (Ex: My […]

Functions supported by Upstox Bridge

Order Details: GetOrderCTag( Exch, TrdSym, CTag, IsLive ) GetOrderIds( Exch, TrdSym, ProdType ) GetOrderIdsBridge( Exch, TrdSym, StgyCode, Source, IsLive ) GetLastOrderId( Exch, TrdSym, ProdType, IsLive ) GetChildOrders( OrderId, IsLive ) GetOrderDiscQty( OrderId, IsLive ) GetOrderExch( OrderId, IsLive ) GetOrderExchId( OrderId, IsLive ) GetOrderExchTime( OrderId, IsLive ) GetOrderExchToken( OrderId, IsLive ) […]

Functions supported by Kite Bridge

Order Details: GetOrderCTag( Exch, TrdSym, CTag, IsLive ) GetOrderIds( Exch, TrdSym, ProdType ) GetOrderIdsBridge( Exch, TrdSym, StgyCode, Source, IsLive ) GetLastOrderId( Exch, TrdSym, ProdType, IsLive ) GetChildOrders( OrderId, IsLive ) GetOrderDiscQty( OrderId, IsLive ) GetOrderExch( OrderId, IsLive ) GetOrderExchId( OrderId, IsLive ) GetOrderExchTime( OrderId, IsLive ) GetOrderExchToken( OrderId, IsLive ) […]

What is the use of Bridge?

Bridge is an add-on feature available in our Hello Kite and Hello Upstox applications. Bridge is for those users who just want to connect their existing trading system (coded in AFL, VBA etc) with their trading account through API. Bridge can be used to connect 3rd party charting software’s (like […]

Purpose of Software Library

First, let’s see What is an API? An API (Application Programming Interface) is a set of procedures, protocols and methods that enable one application or server to communicate with the other and request or retrieve data. API is everywhere in your life, *the app you use in your android phone […]

How much time it will take to place an order through API?

It depends on the following factor; 1. Your computer resources If your computer has very less resources, say you have a little RAM, then your program may take more time to process the code/instructions, thus eventually resulting in more time to place a order. 2. Your network speed If your […]