Friday, June 10, 2011

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 2ND 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

Posted by at

7 comments:

  1. aniJune 11, 2011 at 5:47 AM

    Sir i am new to trading in nifty future/ nify option. Was going through notes and views how to do better. I noted one thing whatever i gone through till date wont take me to success. so today i started from zero to find a path for earning. i didnot have enough fund for trading 4lots in nifty future. whether i could earn from nifty option in discipline way with the help of ur excel sheet? i downloaded ur excel sheet and wish to do fresh trading by deleting all other indicators that confused me till date.

    ReplyDelete
  2. aniJune 11, 2011 at 9:31 AM

    Sir i couldnot find this
    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.

    ReplyDelete
  3. AnonymousAugust 11, 2011 at 7:38 PM

    ani said...
    Sir i couldnot find this
    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.
    --------------------------------------
    Ani,
    I think that with different version of excel process is slightly diffrent.In my case
    STEP 6 7 AND 8 is not needed.
    Instead of that , a yello box appears on the left upper side-- in the opened window. Click that window and then follow rest fo the steps suggested by Nitin Jee.
    I think i am right.
    ----------------------------------
    Thanks Nitin Jee -- U R Very Helpfull.
    Saurabh

    ReplyDelete
  4. lallantopkhabreinDecember 6, 2013 at 9:02 PM

    thanks a lot for sharing this

    ReplyDelete
  5. AnonymousOctober 5, 2015 at 5:03 AM

    Thanks for sharing nice Information for Commodity trading . There is a lot of important information on your site

    buy sell indicators

    ReplyDelete
  6. AnonymousOctober 6, 2015 at 12:49 AM


    Thanks for sharing nice Information for Commodity trading . There is a lot of important information on your site
    buy sell indicators

    ReplyDelete
  7. UnknownOctober 13, 2015 at 5:28 AM


    Thanks for sharing information about trading....There is a lot of important information on your site.....!!

    EagleRTS@Gmail.com
    info@EagleRT.com

    09250 816 716

    EagleRT

    ReplyDelete

Subscribe to: Post Comments (Atom)