LEARN TO USE EXCEL TO GET REAL TIME DATA FROM NSE SITE

PROCEDURE TO DOWNLOAD REAL TIME DATA OF NIFTY OPTION from www.nseindia.com

1. OPEN EXCEL FILE IN MSOFFICE EXCEL 2007

2. CLICK ON DATA – ( APPEARING ON TOP LINE OF EXCEL FILE)

3. CLICK ON “FROM WEB” – ( APPEARING IN 2^ND LINE.. SECOND OPTION FROM LEFT)

4. WRITE – www.nseindia.com & PRESS ENTER.. NOW NSE SITE WILL OPEN

5. CLICK ON “F&O” UNDER DERIVATIVES BOX ( APPEARING AT MIDDLE PART OF RIGHT SIDE) NOW DETAILED TABLE OF CALL & PUT VALUE OF NIFTY WILL OPEN.

6. CLICK ON RED CROSS IN YELLOW BOX ( APPEARING ON TOP RIGHT SIDE)

NOW WHOLE SHEET WILL BE MARKED WITH YELLOW BOX WITH BLACK ARROW.

7. CLICK ON LAST BLACK ARROW(IN YELLOW BOX) … AFTER CLICKING “YELLOW BOX & BLACK

8. ARROW” WILL TURN IN “GREEN BOX & TICK SIGN”

9. NOW CLICK ON “OPTIONS…” ( APPEARING RIGHT SIDE OF TOP CORNER”

10. MARK TICK ON ROUND BEFORE “Full HTML Formating” & press OK

11. CLICK ON “IMPORT” --- (APPEARING ON RIGHT SIDE BOTTOM CORNER)… NOW WE WILL BACK AGAIN IN EXCEL FILE.

12. CLICK ON “PROPERTIES” AND CLICK ON BOX APPEARING BEFORE Refresh every …. Minutes

13. Change minutes to 1 minute and press OK

14. Again press OK…

NOW REAL TIME DATA OF CALL & PUT PRICE OF NIFTY WILL APPEAR IN EXCEL FILE.

SAVE FILE

TRADE IN NIFTY FUTURE DISCIPLINE, FAITH, PATIENCE

TRADE IN NIFTY FUTURE - DISCIPLINE – FAITH – PATIENCE

RULES TO FOLLOW -

1. Trade in 4 lots (maximum) of Mini-Nifty future. You can start with 1 lot also. (DISCIPLINE)

2. Follow EMA 13/ EMA 34/ EMA 55 / EMA 89 or any other EMA as per your study.(DISCIPLINE)

3. Don’t expect profit from first trade itself. Be ready for initial losses in few trades. As per back testing of method, we have to trade in discipline for at least 6 months. Longer the duration, chance of getting profit is more. (FAITH & PATIENCE)

4. No need to follow any other technical indicator, news or tips etc. (FAITH)

5. Check the signal between 3.00 p.m. to 3.30 p.m. on daily basis (DISCIPLINE)

6. Enter in trade as per Signal by Price & Exponential Moving Average (EMA) crossover (DISCIPLINE & PATIENCE)

7. Wait for opportunity to exit from previous trade and enter in New Trade. Here you will book your losses or profits. (DISCIPLINE & PATIENCE)

8. When Price is above all 4 EMA Value, you should have 4 long (BUY) position in Nifty (DISCIPLINE)

9. When Price is below all 4 EMA Value, you should have 4 short (SELL) position in Nifty (DISCIPLINE)

10. Rollover your position to the next month before 4/5 days of expiry if we are getting same signals. Here you will book your losses or profits. (DISCIPLINE & PATIENCE)

Trade in Nifty (Mini_nifty) as a Machine with out any emotions like fear, greed & over confidence.

All the Best.

REASON TO TRADE IN NIFTY FUTURE

Trade in Nifty (MINI-NIFTY) future only as there is less chance of manipulations of price

Nifty consists of 50 stocks so it is as good as diversified portfolio.

We require minimum margin for trading in Mini nifty future compare to other available futures.

This is not a copy n paste article. I wrote it as per my past experience and study of data.

Thanks to fruitfull discussion with M K Sinha Sir, Ahmed Jariwala Sir, Suni Tkarji. If you have any query, please write in my inbox so I will try to reply you at the earliest.

Please take your own decision. Unless you are sure about trading in share market, please don’t trade.

NIFTY - BUY ABOVE PREV HIGH & SELL BELOW PREV. LOW

I HAVE ANALYSISED DATA OF 2000 TRADING DAYS SINCE APRIL 2003 ( LAST 8 YEARS ) OF NIFTY SPOT

AND FOUND THAT :-

IF WE TRADE AS PER SIMPLE METHOD WHICH DISCUSSED SEVERAL TIME ON MUDRAA IE.

BUY ABOVE PREVIOUS DAY'S HIGH & SELL BELOW PREVIOUS DAY'S

BUT HERE I ADDED ONE MORE CRITERIA IE.

STOP LOSS FOR BUY POSITION - PREVIOUS DAY'S LOW &

STOP LOSS FOR SELL POSITION - PREVIOUS DAY'S HIGH.

ASSUMPTION IS CONSIDERED THAT PREVIOUS LOW IS TOUCHED AFTER CROSSING PREVIOUS HIGH OR VICE VERSA.

THE RESULT OF ANALYSIS IS

PROFIT IN BUY 33897.50

PROFIT IN SELL 34309.30

LOSS IN BUY 10833.95

LOSS IN SELL 10833.95

----------------

46538.90

==========

SO 1 NIFTY COULD HAVE GIVEN PROFIT OF 46538.90 POINTS IN LAST 8 YEARS.

I am Nitin Potade from Mumbai

I am full time online trader. Trade in nifty future & options.

My trading is based on my OI data analysis file.

please download excel file from http://www.4shared.com/document/iCbjAxOT/OI_JUNE2011_MUDRAA.html

Please post your feedback.