Day Trading Backtest Interface Development
Budget: ₹12,500 – ₹37,500 INR
Aim : To develop a user interface / google sheet which I can use to back test a day trading system.
Background: I have system wherein I go long or short (only equities) at the opening price. This I execute by using AMO (After Market Orders) which I feed in the previous day. I specify the Position size, Stop Loss / Targets (in terms of % of the Buy price) when executing the orders. Whilst I have individual Stop Loss for each position , I also have a Portfolio SL at 30 % of the overall risk for the Day. If my PNL touches this figure all positions get squared off automatically at Market price and I done for the day. This is done by my present system which I am using. So by the end of the day the following would have happened:-
(a) The stock would have either hit the SL or Target Price)
(b) If not (a) then the system squares off all positions at 15:15.
(c) The PNL reaches 30% of the total risk and all positions are squared off.
Observations : My system presently enables me to monitor the overall PNL at time intervals as per my requirements ( 1 min time interval and above). I have observed that there is a great gap between the High PNL of the Day and the actual PNL which I get at the end of the day. This is because of a number of factors like a stock hitting the SL and subsequently retracing, increase in mid day volatility etc.
My Requirement: I need a system for back testing my strategy with the aim of giving me tabulated data of my overall PNL every min for the day).
So If I have got 10 stocks which I have gone long / short at the beginning of the day, I need to do the back test for the following permutations / combinations separately:-
1. Without setting SL / TGT - Result - Tabulated data of the overall PNL every min.
2. With setting the SL / TGT - Result - Tabulated data of the overall PNL every min.
3. With any stock hitting the SL, I square off half the position at SL, and let the balance run - Result - Tabulated data of the overall PNL every min.
I need to be able to do the backtest for at least the previous one year time frame.
I would prefer to deal with a developer based in India, preferably in Pune.
Background: I have system wherein I go long or short (only equities) at the opening price. This I execute by using AMO (After Market Orders) which I feed in the previous day. I specify the Position size, Stop Loss / Targets (in terms of % of the Buy price) when executing the orders. Whilst I have individual Stop Loss for each position , I also have a Portfolio SL at 30 % of the overall risk for the Day. If my PNL touches this figure all positions get squared off automatically at Market price and I done for the day. This is done by my present system which I am using. So by the end of the day the following would have happened:-
(a) The stock would have either hit the SL or Target Price)
(b) If not (a) then the system squares off all positions at 15:15.
(c) The PNL reaches 30% of the total risk and all positions are squared off.
Observations : My system presently enables me to monitor the overall PNL at time intervals as per my requirements ( 1 min time interval and above). I have observed that there is a great gap between the High PNL of the Day and the actual PNL which I get at the end of the day. This is because of a number of factors like a stock hitting the SL and subsequently retracing, increase in mid day volatility etc.
My Requirement: I need a system for back testing my strategy with the aim of giving me tabulated data of my overall PNL every min for the day).
So If I have got 10 stocks which I have gone long / short at the beginning of the day, I need to do the back test for the following permutations / combinations separately:-
1. Without setting SL / TGT - Result - Tabulated data of the overall PNL every min.
2. With setting the SL / TGT - Result - Tabulated data of the overall PNL every min.
3. With any stock hitting the SL, I square off half the position at SL, and let the balance run - Result - Tabulated data of the overall PNL every min.
I need to be able to do the backtest for at least the previous one year time frame.
I would prefer to deal with a developer based in India, preferably in Pune.
Related categories:
PHP
JavaScript
Excel
Software Architecture
Metatrader
Data Visualization
Data Analysis