I want to automate a 3-minute breakout strategy for Zerodha kite via excel.
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.
Link to sheet 1: https://docs.google.com/spreadsheets/d/11R-1wpB8RLrXXn_ywyPRUFFzckrgsfGcsRC7YmZWD7s/edit?usp=sharing
7 freelancers are bidding on average ₹1186 for this job
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