| View previous topic :: View next topic |
| Author |
GET REAL TIME DATA FROM NSE SITE - NITIN POTADE |
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
Post: #1  Posted: Sun Oct 23, 2011 9:26 am Post subject: GET REAL TIME DATA FROM NSE SITE - NITIN POTADE |
 |
|
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
|
|
| Back to top |
|
 |
|
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #2 Posted: Sun Oct 23, 2011 12:23 pm Post subject: |
|
|
I have the excel file, micro and web enabled. But I couldn't see any of these things such as data, from web, f&o, last black arrow, etc. Also, it says nifty is at premium of 18.05 while, as per bhav copy, premium is about 5 only.
Do you also take into account effect of sgx nifty before opening?
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #3 Posted: Sun Oct 23, 2011 1:30 pm Post subject: |
|
|
| vinay28 wrote: | I have the excel file, micro and web enabled. But I couldn't see any of these things such as data, from web, f&o, last black arrow, etc. Also, it says nifty is at premium of 18.05 while, as per bhav copy, premium is about 5 only.
Do you also take into account effect of sgx nifty before opening? |
===============================================
VINAY,
I DONT THINK THAT YOU ARE TALKING ABOUT FILE CREATED BY PROCEDURE GIVEN BY ME. AS IF YOU CREATE FILE AS PER PROCEDURE GIVEN BY ME, THERE IS NO QUESTION ABOUT NIFTY WITH PREMIUM AS I HAVE WROTE ABOUT UPLOADING DATA OF NIFTY OPTION WHERE PREMIUM DOES NOT ARISE.
IF POSSIBLE, SEND FILE OR PROVIDE LINK SO I CAN UNDERSTAND YOUR QUERY.
SECONDLY, WHAT IS A CONNECTION BETWEEN NIFTY OPTION DATA OF NSE SITE & SGX NIFTY SO HOW TO CONNECT IT?
|
|
| Back to top |
|
|
bismillah
White Belt
Joined: 25 Sep 2009
Posts: 35
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #5 Posted: Sun Oct 23, 2011 8:00 pm Post subject: |
|
|
Potade, I had downloaded the excel file "nifty_banknifty_trading system" from the link provided by you earlier. Sorry if I have missed something here.
As regards sgx nifty, I was wondering whether feeding that data would give advance info on action to be taken before market opens?
|
|
| Back to top |
|
|
ndpotade
Yellow Belt
Joined: 05 Feb 2010
Posts: 580
|
| Post: #6 Posted: Mon Oct 24, 2011 1:24 pm Post subject: |
|
|
| vinay28 wrote: | Potade, I had downloaded the excel file "nifty_banknifty_trading system" from the link provided by you earlier. Sorry if I have missed something here.
As regards sgx nifty, I was wondering whether feeding that data would give advance info on action to be taken before market opens? |
================================================
VINAY,
I HAVENT PREPARED ANY FILE WITH THE NAME GIVEN BY YOU SO NO QUESTION ABOUT PROVIDING LINK FOR IT.
I THINK THE FILE WHICH YOU ARE REFERRING IS PREPARED BY MR. NISHANT
THANKS & REGARDS.
|
|
| Back to top |
|
|
vinay28
Black Belt
Joined: 24 Dec 2010
Posts: 11748
|
| Post: #7 Posted: Mon Oct 24, 2011 7:30 pm Post subject: |
|
|
| oooo, my apologies potade for wasting your time
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
