Hi. I want someone to develop my algo trading system. I need python based application. My requirements are- 1. I need kite connect to ask me the list of instruments of which I require live data. It can be a csv file etc. 2. Based on this data, a websocket should be created to receive live data. Whether I require ltp,quote or full should be asked by the program before connecting to websocket. 3. This live data should be saved in a database with clearly defined schema. 4. This database should store the data of all ticks for a complete day. After the day is over if we want we can keep the table or delete it's contents. 5. I need a blank defined function named entry-strategy. The definition of this function will be blank and I will program it myself. However, all the fields of table should be available as variables etc. 6. If this function returns true, an order should be placed. 7. Similatky an exit-startegy blank function is required on the base of which order will be exited.
This is an outline. More can be discussed after your offer. If you are interested, kindly pm me with your quote. Thanks.
def get_login(api_k,api_s): # log in to zerodha API panel global kws,kite; kite = KiteConnect(api_key=api_k)
print("[*] Generate access Token : ",kite.login_url()) request_tkn = input("[*] Enter Your Request Token Here : ");
data = kite.generate_session(request_tkn, api_secret=api_s) kite.set_access_token(data["access_token"]) kws = KiteTicker(api_k, data["access_token"]) get_login(api_k,api_s); #function that used to get connected with API
def on_ticks(ws, ticks): #retrive continius ticks in JSON format global row print(row) try: for company_data in ticks: sht.range('A'+str(row)).value=company_data['last_price'] sht.range('B'+str(row)).value=company_data['volume'] sht.range('C'+str(row)).value=company_data['buy_quantity'] sht.range('D'+str(row)).value=company_data['sell_quantity'] row=row+1
go through this link
Thanks for the video.
How to append data to excel? In this video, the data is changing in the same row.
make a excel file "store.xlsx"
use this program
import openpyxl
import logging
from kiteconnect import KiteConnect
from kiteconnect import KiteTicker
import operator
import inspect
import datetime,time,os,random;
import collections
import operator
import xlwings as xw
now = datetime.datetime.now()
kws = "";kite = ""
api_k = "*******************"; #api_key
api_s = "**************************"; #api_secret
def get_login(api_k,api_s): # log in to zerodha API panel
global kws,kite;
kite = KiteConnect(api_key=api_k)
print("[*] Generate access Token : ",kite.login_url())
request_tkn = input("[*] Enter Your Request Token Here : ");
data = kite.generate_session(request_tkn, api_secret=api_s)
kite.set_access_token(data["access_token"])
kws = KiteTicker(api_k, data["access_token"])
get_login(api_k,api_s); #function that used to get connected with API
wb = xw.Book('store.xlsx')
sht = wb.sheets['Sheet1']
row=2
def on_ticks(ws, ticks): #retrive continius ticks in JSON format
global row
print(row)
try:
for company_data in ticks:
sht.range('A'+str(row)).value=company_data['last_price']
sht.range('B'+str(row)).value=company_data['volume']
sht.range('C'+str(row)).value=company_data['buy_quantity']
sht.range('D'+str(row)).value=company_data['sell_quantity']
row=row+1
except Exception as e:
raise e
subscribe=[325121]
def on_connect(ws, response):
ws.subscribe(subscribe)
ws.set_mode(ws.MODE_FULL,subscribe)
kws.on_ticks = on_ticks
kws.on_connect = on_connect
kws.connect()
{'tradable': False, 'mode': 'full', 'instrument_token': 256265, 'last_price': 10992.4, 'ohlc': {'high': 11049.35, 'low': 10882.85, 'open': 10969.95, 'close': 10967.4}, 'change': 0.22794828309353174, 'timestamp': datetime.datetime(2018, 9, 25, 11, 58, 25)}
for any queries mailto : [email protected]
or 9370789912
[email protected]
www.tradesmac.com
[email protected]