NiftyMagician : How to get all NSE data on Excel.

[ashishp]

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.

[asif]

Thank you ashish Da for such a wondefull trick..

[asif]

Thank you Mitra jee...@@

[deepak]

Very simple. I uploaded this video i guess more then a year ago.
please give your feedback on youtube page if you like .
How to fetch realtime quotes.

[nameeta26]

This is a very helpful tips for the management of the data in excel. Thank you!