nitin potade
View Profile

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

Nitin Potade at 11:41 PM - Mar 01, 2011 ( ) Views: 72,363

30 77

PLEASE VISIT --

http://www.mudraa.com/singlepost.php?messid=80277
and download excel file from http://www.4shared.com/file/dJfPCjup/80277.html

http://www.mudraa.com/singlepost.php?messid=81489
and download excel file from http://www.4shared.com/file/jMg4fWO5/81489.html

I AM GETTING MAILS WHERE MUDRAA FRIENDS HAVE SHOWN INTEREST TO LEARN TO PREPARE EXCEL SHEET WHICH CAN BE USED TO KNOW MTM PROFIT/LOSS FOR FNO TRADE.

MTM PROFIT/LOSS WILL BE CALCULATED WITH THE HELP OF REAL TIME DATA FROM WWW.NSEINDIA.COM

I AM PLANNING TO SHOW HOW TO PREPARE EXCEL FILE WITH THE HELP OF TEAM VIEWER.(FREE OF COST) 

IF ANYBODY IS INTERESTED, PLEASE WRITE TO ME IN MY MUDRAA INBOX.. DONT GIVE YOUR MAIL ID OR CONTACT DETAILS.. I WILL INFORM THEM THE DATE & TIME ABOUT OUR TRAINING...

IT IS REALLY WORTH TO LEARN.. IT IS SIMPLE & USEFUL.

TRY TO USE YOUR OWN IDEAS THAN TO FOLLOW ANYONE BLINDLY. YOU CAN USE EXCEL FILE TO PREAPARE VARIOUS HEDGING STRATEGIES.

ALL THE BEST.

 



From: nitin potade at 11:00 AM - Nov 28, 2011


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 & 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 FILE

 


(1 to 20 out of 102) - Latest Replies on Top | First | << Previous | Next >> | Last |
Avii T at 02:02 AM - Feb 06, 2014 ( )

Thanks .... I tried ... It's nice

Trend_with_Volatility_fibonacci_Avii_addon.xlsx

http://www.mudraa.com/singlepost.php?messid=193041

Chakravarthy Snvs at 08:07 PM - Nov 16, 2013 ( )

Pchch Not able to get even ltp in a cell.

Shashi Dace at 06:58 PM - Nov 16, 2013 ( )

NITIN JI, 

I OPENED NEW XL SHEET 2007,CLICKED ON DATA,THEN ON THE BUTTON  "FROM THE WEB" , BUT THE NSE SITE DOES NOT OPEN. THERFORE FURTHER STEPS CANNOT BE FOLLOWED. WHERE AM I GOING WRONG? ALSO, THE PROCEDURE GIVEN BY YOU IS FOR OPTIONS.SIMILARLY HOW CAN I GET DATA FOR NIFTY AND BANKNIFTY FUTURES,OR FOR THAT MATTER FOR ANY STOCK?

 

 

Chakravarthy Snvs at 12:14 PM - Nov 16, 2013 ( )

Nitin ji, please tell me how  to get real  time data to excel now. nse old site is not working  for me.

Venkatesh Mp at 08:56 AM - Sep 18, 2013 ( )

Thank u nitinji

Vilas Havanur at 08:34 AM - Sep 18, 2013 ( )

Dear Nitinbhai,

Thanks a lot for the info.

I request you please to explain the Procedure to (get) import NSE Real-Time Data - 2 min. Chart to Excel Sheet.

Thanking you in advance.

Nitin Potade at 07:38 AM - Sep 18, 2013 ( )


GOOD MORNING






Ganesh Solanki at 05:30 PM - Aug 22, 2013 ( )

im sir...........

Nitin Potade at 05:26 PM - Aug 22, 2013 ( )

For those who missed it...

Pankaj Parimal at 06:57 PM - Aug 27, 2012 ( )

One can still fetch the data from the older version of NSE from the below mentioned link :

http://www.nseindia.com/content/fo/fo_contractsdata.htm

Patel Bhavesh at 05:02 PM - Aug 27, 2012 ( )

Helloo,

Nitin Sir

main stock mkt main naya hu or muje apki exel sheet ki strtagies pasand hai but muje exel sheet work kaise karta hai woh muje pata nahi so pls ap muje sikhayenge pls .or batayenge ?

 

Sunil Ramidi at 11:09 AM - Aug 03, 2012 ( )

I have got this answer from some other forum wher i posted for real time data into excel for stocks..

 

"you can scrap data from NSE website by parsing HTML"

 

Can anyone explain what is it and if anyone knows how to do it... pls post...

Mahadeo Gaikwad at 10:54 AM - Aug 03, 2012 ( )

nitin ji I am sending u a excel file please help me how to pridict trand and target as ur put call sheet

Nitin Potade at 10:19 AM - Aug 03, 2012 ( )

Sanjeevji,

I too need it but helpless...

Sanjeev Nevatia at 10:50 PM - Aug 02, 2012 ( )

Nitin ji ,

NSE has restricted access to older version and now updation of data in excel sheet is not working.

Please provide us some other method to get real time and historical data from nse site or some other site.

Thanx.

Sanjeev Nevatia at 06:50 PM - Jul 06, 2012 ( )

Dear KK ji,

In the above written procedure by Mr. Nitin ji replace step 4, 5 with the steps told by Nirmala ji . but dont click download csv. and follow the remaining steps.

Kripakar Kumble at 10:51 PM - Jul 05, 2012 ( )

Nitin ji..

i want the realtime  data from the web. 

CSV  format data is not the real time one.

Nitin Potade at 10:35 PM - Jul 05, 2012 ( )

KK,

You can follow the method given by Nirmalaji which more convinient and easy to operate.

Thanks Nirmalaji..

1 to 20 out of 102

Login to participate in discussion.