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 -

Raj, there is something not right with the calculation of EMAs. I am attaching an example below. I tried using three combinations : EMA3 + EMA15, 3+13 & 3+39.

In all of the above, you will find different values for EMA3. It shouldn't happen. EMA3 should remain constant in the above combinations.

Also, please note the column for the second EMA (whether 15 or 13 or 39), the values remain the same.

There was some formula error in the columns H (EMA3) and I (EMA15).
It is pointing to wrong EMAs.

Please change the formula's to "=IF(C7="","",Y7)" without quotes in column H7
Please change the formula's to "=IF(C7="","",Z7)" without quotes in column I7

Copy and paste the formulas in the Rest of the H Cells H8:H200
Do the same for I Column also

 

[timepass]

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

There was some formula error in the columns H (EMA3) and I (EMA15).
It is pointing to wrong EMAs.

Please change the formula's to "=IF(C7="","",Y7)" without quotes in column H7
Please change the formula's to "=IF(C7="","",Z7)" without quotes in column I7

Copy and paste the formulas in the Rest of the H Cells H8:H200
Do the same for I Column also

Perfect !!

Needed to unprotect it first.

 

[ashish2010]

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

Perfect !!

Needed to unprotect it first.

I am unable to copy the formula in the cells.
TP, could you please upload the new excel file after implementing the changes?

Thanks!!!

 

[timepass]

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

I am unable to copy the formula in the cells.
TP, could you please upload the new excel file after implementing the changes?

Thanks!!!

Here.

http://www.4shared.com/file/DvlR0mJQ/RAJ_Stock_Screener_v10_BETA.html


Raj. the Raj MTP 3.0 gave a message today "This file will expire on 20-Oct-2012. Please contact Raj for extending" (something like this). Is that right ?

 

[healthraj]

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

Here.

http://www.4shared.com/file/DvlR0mJQ/RAJ_Stock_Screener_v10_BETA.html


Raj. the Raj MTP 3.0 gave a message today "This file will expire on 20-Oct-2012. Please contact Raj for extending" (something like this). Is that right ?

Yes I had put a time bomb in the tool. Don't worry I will upload the next version by this week end.

 

[Option.Trader]

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

Yes I had put a time bomb in the tool. Don't worry I will upload the next version by this week end.

Raj

I have a new idea for a tool that would make it a triad of indicators for traders. Its based on OI F&O data that could incorporate in your Stock screener that would give the complete picture... i have some ideas which i will share in the evening with layout of the tool...

 

[ashish2010]

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

Raj

I have a new idea for a tool that would make it a triad of indicators for traders. Its based on OI F&O data that could incorporate in your Stock screener that would give the complete picture... i have some ideas which i will share in the evening with layout of the tool...

Indeed, a very nice move from your side!!!! :thumb::thumb:

 

[cooljai]

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

Hello Raj,
Thank you so much for the work that you have done.
Tried updating the sheet and all goes well except for the Renko.
Here is what i get when i look at the chart

It shows the prices as Sep, Oct and Nov.
Think this is because of some format change from Google data.
Can you please check and let me know how to correct this?

Thanks,

 

[bulltrader]

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

Hi Jai,

I also had same issue, but when I deleted all the csv files and log data and backfilled again, Renko showed correct results. Try it out, should work.

Regards,
Chidan

 

[Option.Trader]

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

Raj

I have a new idea for a tool that would make it a triad of indicators for traders. Its based on OI F&O data that could incorporate in your Stock screener that would give the complete picture... i have some ideas which i will share in the evening with layout of the tool...

Raj

The basic idea is to have a tool that analyses OI
For eg...Generate a signal when there is 10% long build up in calls and corresponding unwinding in puts go Long , vice versa
The formula is
OI Price Interpretation
Up Up Long Build Up a.k.a accumulation
Up down Short build up writing of calls
Down Up Short unwinding writing of puts
Down down Long unwinding a..k.a put accumulation

Using these rules plot a dashboard for Nifty and Stocks ITM, ATM and OTM as shown below

We could then have this as one of the inputs for your stock screener
Also for those who trade in options, this could act as a live dashboard of what is happening
Another interesting way is to analyze the price action of stock with corresponding OI build up in options. If people are manipulating the cash value and taking opp positions in Options, we could figure out the red herring
The link for Live option call is
Option Link

FII activity is at

FII Derivative statistics
But the above is a static link and would be available at only end of day

Let me know if this makes sense