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

[healthraj]

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

1)Hope you are using 2007 SP3
i m having excel 2007 wat is sp3 i dont know....

2)you have setup for Macros and Data Connection
s macros ill enable all the time wen i open the software...

3) Hope you have also not renamed any sheet in the Excel tool
in excel nd all m very poor, so i didnt do any thing with dis....

to enable macros and Data connection in In Excel 2007...
1. Goto "Exccel options" - You can access it from the main menu
2. Goto Trust Center
3. Click on Trust Center Settings..
4. In "Macro Settings" Select "Enable All macros...." and "Trust access to VBA code..."
5. In "External content", Select "Enable All Data connections...."


You can download the latest Office Service pack (SP3) for 2007 from the below link
http://support.microsoft.com/kb/2526086

To find out what Service is pack is installed
From Main Menu->Excel Options->Resources-About

 

[DILIP_BAFNA]

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

is it possible to make 652 lakhs in 497 trading days with a starting capital of 1 lakh using nifty futures.

Well theoretically it is possible.

so what is the principle behind this strategy?

1. Nifty is trending only 20-25% of the time and so why always take 20 points stoploss when 80% of the time you are going to loose. Why not take 7-10 points loss and close the trade if stoploss hit.
2. 20-25% of the time when the market is trending, nifty never crosses the opening price by more than 10 points. So in those cases nifty always gives on an average 55 points on the long side and 77 points on the short side.
3. 80-20 principle. 80% of the losses comes from 20% of the trades and so 80% profit can come from 20% of the trades.
4. Why do we need to spend hours before the monitor, while we can spend maximum 30 minutes a day. (15 minutes during opening and 15 minutes during closing)

so let us say we do hundred trades.
75 trades with a loss of 10 points = 750 points loss
25 trades with a gain of 65 points = 1625 points gain
net gain = 875 points in 100 trading days.
If you started trading with a capital of 1 lakh and 2% risk, the profit would be rs 1,75,000.
With pyramiding (reinvesting the profit ) it would turn to crores.

Attaching the excel sheet with the backtested results with the data of last two years for nifty.

Also attaching back tested result for the sbin stock. Sbin unlike nifty falls in the 50:50 category. Ie 50% of time is trending and 50% it is rangebound. So it is one of the highly trending stock. The parameters are different for sbin. For eg... Your stoploss should be around 1% in sbin where as for nifty your stoploss should not be more than 0.2%.

All the prices for spot

http://www.4shared.com/file/582kqrc8/positional_trading_-_nifty-bac.html

http://www.4shared.com/file/ccpehgkq/positional_trading_-_sbin-back.html

will explain the strategy in detail in the next post.

sir ji
both file are not available( nifty and of sbin)

 

[prabhsingh]

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

Raj,

What i would suggest is to move Download link of Excel,Service Pack details and all the configuration settings on the first page of this thread as it seems same information is being repeated on continous basis.New people who are joining this thread can have all the required data on first post of this thread.

 

[healthraj]

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

Raj,

What i would suggest is to move Download link of Excel,Service Pack details and all the configuration settings on the first page of this thread as it seems same information is being repeated on continous basis.New people who are joining this thread can have all the required data on first post of this thread.

It would not be possible for me edit my old posts. It is not possible in Traderji. If people knows a way I would love to do that. so that I can remove obsolete links etc... The Edit option is not there in the post after some hours

 

[prabhsingh]

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

It would not be possible for me edit my old posts. It is not possible in Traderji. If people knows a way I would love to do that. so that I can remove obsolete links etc... The Edit option is not there in the post after some hours

I think Moderator would be able to help here.

 

[healthraj]

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

Please VOTE:

The poll would be closed by EOD today. Those who have not voted please click the voting button to say Either

YES. The tool helps to take safe positions using FLOW and Renko Charts OR
NO. The tool is not useful

Right now

YES. The tool helps to take safe positions using FLOW and Renko Charts - 95% 19 votes OR
NO. The tool is not useful - 5% - 1 vote

So as per the poll results now, since people feel that the tool is helping them to take safe positions, I think I will keep improving the tool until the majority say otherwise...

 

[guptak03]

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

to enable macros and Data connection in In Excel 2007...
1. Goto "Exccel options" - You can access it from the main menu
2. Goto Trust Center
3. Click on Trust Center Settings..
4. In "Macro Settings" Select "Enable All macros...." and "Trust access to VBA code..."
5. In "External content", Select "Enable All Data connections...."


You can download the latest Office Service pack (SP3) for 2007 from the below link
http://support.microsoft.com/kb/2526086

To find out what Service is pack is installed
From Main Menu->Excel Options->Resources-About

Raj,

What i would suggest is to move Download link of Excel,Service Pack details and all the configuration settings on the first page of this thread as it seems same information is being repeated on continous basis.New people who are joining this thread can have all the required data on first post of this thread.

It would not be possible for me edit my old posts. It is not possible in Traderji. If people knows a way I would love to do that. so that I can remove obsolete links etc... The Edit option is not there in the post after some hours

raj ji can v hve extra sheet in excel as user manual .so that new cummers like me can c the settings nd make changes according to der excel versions..
and also if possible sum suggestions like how to use Renko charts,Flow charts,how to add new stocks in stockTrackers..

 

[prabhsingh]

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

Raj,

Those Web queries which connect to nse website and populate Webdata sheet,are those being used anywhere else as well i.e for constructing charts or deriving any other value in various excel sheets.

 

[healthraj]

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

raj ji can v hve extra sheet in excel as user manual .so that new cummers like me can c the settings nd make changes according to der excel versions..
and also if possible sum suggestions like how to use Renko charts,Flow charts,how to add new stocks in stockTrackers..

I am not sure what you guys expect as a user manual. Because i thought it was straight forward tool.

I will think about this and implement when time permits.
The following things I can think of
- Excel requirements
- Settings for Macros and Data Connection
- Any Configuration to be done like EMA etc...
- What to Input andWhere to Input to get the Charts etc..

Please let me know if you guys expect anything else

 

[healthraj]

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

Raj,

Those Web queries which connect to nse website and populate Webdata sheet,are those being used anywhere else as well i.e for constructing charts or deriving any other value in various excel sheets.

There are 5 webqueries

2 Queries for Options chain - Not used
2 Querries for Futures - USED
1 query - SPOT data - used