Completed

ZERODHA KITE automation with excel.

I want to automate a 3-minute breakout strategy for Zerodha kite via excel.

Requirements :

The system would be divided into 2 worksheets :

Sheet 1: This sheet will be a Scanner, I'll share a google spreadsheet with you which I've built however it gets data from google finance, so the same features need to be transferred to a normal excel or you can build a similar logic scanner without google finance.

Sheet 2: Strategy + positions automation.

=============================

- Below is an example of a 3 min chart time frame and what I want starting from 9:15 AM.

0) Copy all final breakout stocks from Sheet1 over to Sheet2.

1) First Candle >> Skip this candle.

2) Second Candle >> Mark/Store the high and low values.

3) As soon as the third candle starts at 9:22 >> If it crosses the high with a 0.05 to 0.10 paisa buffer then place a market buy BO. If it crosses the low with a 0.05 to 0.10 paisa buffer then place a market Sell BO.

4) It should allow me to input the buffer amount for step 3, so I can change it in future if need be.

5) Stop-loss - 0.5 (should be editable).

6) Target - 0.5 (should be editable).

7) Balance View.

8) Quantity Calculator - This should be based on the percentage I specify it to use & according to the leverage I plan to use (i.e money management). (should be editable).

9) Automatic close all trades at a specific IST time (should be editable).

10.) If anything else is needed I'll let you know, and lastly also let me know if I would be needing an API from zerodha, or is it something that you can work around with.

11) If you have understood my requirements type the word "PROFIT" when you send your proposel to me.

Thank you.

Link to sheet 1: https://docs.google.com/spreadsheets/d/11R-1wpB8RLrXXn_ywyPRUFFzckrgsfGcsRC7YmZWD7s/edit?usp=sharing

Skills: .NET, Excel, Python, Software Architecture, Visual Basic

See more: roster automation excel, excel macro change cell contents, automation excel sql 2000, excel logo change, automation excel, excel automatic change color depending value, excel extension change dat, excel formulas rate calculator, free excel converter web calculator, excel import cost calculator, excel vba change pivot data sources, excel pivot change data source sql, shopify change price quantity, macro automation excel 2003, excel sheet forex calculator, excel irish tax calculator, excel heating btu calculator, excel forex risk calculator

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #18179870

Awarded to:

Kamalbhatia528

Hi #PROFIT I am working as a python developer from one year in a reputed mnc. I can do your work with perfection and ensure you that my code will be delivered to you on time. I did many projects for excel autom More

₹1450 INR in 7 days
(0 Reviews)
0.0

7 freelancers are bidding on average ₹1186 for this job

dataexplorer

"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as More

₹1300 INR in 1 day
(16 Reviews)
3.9
₹850 INR in 2 days
(0 Reviews)
0.0
balajipadavala

I need more clarity on this project. If you can give the full details I will give you the aumatated in the powershell script which will give the details in the excel sheet Relevant Skills and Experience Power shell is More

₹1300 INR in 5 days
(0 Reviews)
0.0
Abhitannu

Employees is a perfect man because compny ki ashli capital company k liy ak employees Hota h Kuki company ko uchai pr le Jany Bala most people employ Hotah or

₹1300 INR in 1 day
(0 Reviews)
0.0
Fazalacca

A self-managed and result-oriented professional accountant over 04 Years of experience in the field of Finance, Accounts, Internal and External audit, Financial Reporting and Accounting different organizations of diff More

₹1300 INR in 1 day
(0 Reviews)
0.0
pandapk47

Dear Sir, We offer the services for your project of excel work. Please feel free to contact us for further discussion. Regards, RZP General.

₹1500 INR in 30 days
(0 Reviews)
0.0