1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures - Bac

Whether the latest MTP v2.2 tool is useful?

  • YES. The tool helps to take safe positions using FLOW and Renko Charts

    Votes: 26 92.9%
  • NO. The tool is not useful

    Votes: 2 7.1%

  • Total voters
    28
  • Poll closed .

Option.Trader

Well-Known Member
#51
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Thanks. But my question is let us say on 23-Jul-2012, For the backtesting and analyisis, which month contract data will be used... We have atleast three months active every time. So today 4 days from expiry I can trade with July, August or Sep ?
Raj

I have taken care to see that only the current month's future contract data are taken for the futures data that i uploaded.
The way to do this is only take data for a month, for each month fo ryour time frame with the current months expiry and dates between the first day of the new contract and expiry day.
For example to get to May month's futures data (May 2012)
April month expiry is 26th April,
So choose the expiry as 31-may-2012, From date as 27th april-2012, to-date as 31-may-2012. Do this for all the months that are required. Its a labourious process...but i did that for the period in your backtest in about an hour.
The link is http://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm#

I think the way to go about this is, we need to define some rules for dealing with Futures
Due to discount or premium attached we need to change the stop loss
Playing around with the stop loss is one way to get an ideal SL defined. But i believe this would at most enable you to be in some trades and increase ur stop loss in others.
I have the entire data if you want to look at volumes and other stuff..
The other thing which i noticed was that, you choose the open value to determine your entry position. Its not possible to always get a trade at the opening rate. This would also decrease the profits or change the stop loss in a real case scenario.
Let me know
 

healthraj

Well-Known Member
#52
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Raj

I have taken care to see that only the current month's future contract data are taken for the futures data that i uploaded.
The way to do this is only take data for a month, for each month fo ryour time frame with the current months expiry and dates between the first day of the new contract and expiry day.
For example to get to May month's futures data (May 2012)
April month expiry is 26th April,
So choose the expiry as 31-may-2012, From date as 27th april-2012, to-date as 31-may-2012. Do this for all the months that are required. Its a labourious process...but i did that for the period in your backtest in about an hour.
The link is http://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm#

I think the way to go about this is, we need to define some rules for dealing with Futures
Due to discount or premium attached we need to change the stop loss
Playing around with the stop loss is one way to get an ideal SL defined. But i believe this would at most enable you to be in some trades and increase ur stop loss in others.
I have the entire data if you want to look at volumes and other stuff..
The other thing which i noticed was that, you choose the open value to determine your entry position. Its not possible to always get a trade at the opening rate. This would also decrease the profits or change the stop loss in a real case scenario.
Let me know
I understand how you have done but that will not work because the Premium for current month and next month is different. So when the data switches from the current month to next month, the EMA would not be calculated properly. So you have to switch over the data to next month on the rollover date and not after the expiry date...
 

healthraj

Well-Known Member
#53
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

I have automated the following in the Excel Tool so that It can be used those who are doing Intraday Trading. For those of you who are holding any positions from the morning can also track their positions.

Requirements.
1. You need to have the Historic Daily OHLC data upto date till the previous trading day (This is not automated).
2. When you open the tool the next day, if an entry is not there for current day it would be created automatically....
3. Apart from the signals got from the EMA, also taking two more signals, one from the Options Chain and the other from the 3 Futures contracts.
4. The Options, Futures and SPOT data is got directly from the NSEIndia.com site so there won't be any delay in getting the latest values (Compared to Yahoo)
5. Of course you need a reasonable Internet connection, which I am sure everybody is having.

I will post the tool by around 8 pm today.
 

Option.Trader

Well-Known Member
#54
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

I understand how you have done but that will not work because the Premium for current month and next month is different. So when the data switches from the current month to next month, the EMA would not be calculated properly. So you have to switch over the data to next month on the rollover date and not after the expiry date...
The switching of data before expiry should not be a problem. Just one entry for each month has to be changed. But i dont believe it should have that material impact as the current month and next month future anyway coincide on expiry day of current month
Let me know
 

healthraj

Well-Known Member
#55
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

I have automated the following in the Excel Tool so that It can be used those who are doing Intraday Trading. For those of you who are holding any positions from the morning can also track their positions.

Requirements.
1. You need to have the Historic Daily OHLC data upto date till the previous trading day (This is not automated).
2. When you open the tool the next day, if an entry is not there for current day it would be created automatically....
3. Apart from the signals got from the EMA, also taking two more signals, one from the Options Chain and the other from the 3 Futures contracts.
4. The Options, Futures and SPOT data is got directly from the NSEIndia.com site so there won't be any delay in getting the latest values (Compared to Yahoo)
5. Of course you need a reasonable Internet connection, which I am sure everybody is having.

I will post the tool by around 8 pm today.
Please find below the link for the Tool... It is not a full fledged tool and so please don't bother me with any bugs... You can modify and use the tool as per your wish. I have borrowed some idea from Nishant ([email protected]) and so the BUY/SELL signal using Options Chain should go to Nishant.

http://www.4shared.com/zip/mgZBNw8r/RAJ_NIFTY_Intraday_Tool.html
 
Last edited:

healthraj

Well-Known Member
#59
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

So today was typical day for our Trending Strategy. The NIFTY Spot opened at 5163 touched high 5164. NO STOPLOSS. Profit of 45 points at close in NIFTY Spot.

Follow the below steps. End of the Day fill the latest OHLC for today. Yesterday EOD we had only "CLOSE LONG".

But the levels were "SELL BELOW 5177" and "BUY ABOVE 5230"

Today morning with the market opening outside the Range, the "SELL SHORT" signal was triggered and also because of the market opened GAP DOWN.... So if there was no signal the previous day, Check for the signal on the opening hours...
 

healthraj

Well-Known Member
#60
Re: 1 lakh to 652 lakhs in 497 trading days - Winning 20% of Trade in NIFTY Futures -

Do not use the tool between 9:00 AM to 9:20 AM because the Options Chain data and the NIFTY Futures data are being refreshed by NSEIndia.com and so you will not get any values....

I need to do those automation in the sheet... Will try and do those changes in the coming days...
 

Similar threads