I have an excel sheet in which the current price of few stocks are listed. Now, In that excel sheet I want to create two buttons(One for Buy and the other for Sell) next to all the stocks and when I click them it should trigger buy/sell order for CO/BO in Kite website.
Can anyone please let me know the technical aspects that I need to take care of and any help in this regard will be highly appreciated. Thank you.
1. First create an userform for buy sell
2. Create two functions one for buy and one for sell, call that userform in these functions, with buy /sell enabled
3. call that udf in two cell, e.g. =buy(), =sell()