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 – http://www.nseindia.com & PRESS ENTER.. NOW NSE SITE WILL OPEN & GO TO PREVIOUS VERSION.
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
now every time u oepen the saved file if internet is connected automatically the data will get updated
DONEEEEEEE
Regards,
MITRA.