Excel help required.

praveen98

Well-Known Member
#2
Hi Mohan,
I think the ATP updation in the Nse website is delayed....but if you want ATP updation in real time...it is possible through NOW to excel linking...then that will be updated real time...
Hope this helps
Regards,
praveen
 

mohan.sic

Well-Known Member
#3
Hi Mohan,
I think the ATP updation in the Nse website is delayed....but if you want ATP updation in real time...it is possible through NOW to excel linking...then that will be updated real time...
Hope this helps
Regards,
praveen
hi praveen,

what i posted earlier was incomplete.
i linked nse option chain page to excel. but nse is not providing atp in optio chain page. i want open interest data along with atp in same excel sheet.

as you suggested we can get both from Now.
But problem is with data differences between trading softwares and nse website. i dint cross check with Now terminal but i did with odin and nest and they differ from nse website in both live and eod data ( only open interest values ). i think nse webite - option chain page has correct data.

if you have access to Nse Now pls check closing open interests for different strikes between Now and nse website and tell if are same or different. I dont have access to Now.

thank you ....
 

praveen98

Well-Known Member
#5
hi praveen,

what i posted earlier was incomplete.
i linked nse option chain page to excel. but nse is not providing atp in optio chain page. i want open interest data along with atp in same excel sheet.

as you suggested we can get both from Now.
But problem is with data differences between trading softwares and nse website. i dint cross check with Now terminal but i did with odin and nest and they differ from nse website in both live and eod data ( only open interest values ). i think nse webite - option chain page has correct data.

if you have access to Nse Now pls check closing open interests for different strikes between Now and nse website and tell if are same or different. I dont have access to Now.

thank you ....
Hi Mohan,
I will check on Monday and let you know....:clap:
 

praveen98

Well-Known Member
#6
Hi Mohan,
I have checked OI of 8000 CE, 5 times during the day....In NOW and in NSE web site OI volumes are one and the same....there is no deviation...so you can think about NOW excel linking to serve your purpose.....

All the best,
praveen:clap:
 

mohan.sic

Well-Known Member
#7
Hi Mohan,
I have checked OI of 8000 CE, 5 times during the day....In NOW and in NSE web site OI volumes are one and the same....there is no deviation...so you can think about NOW excel linking to serve your purpose.....

All the best,
praveen:clap:
... will request my broker for NOW.

Thank you praveen.....
 

mohan.sic

Well-Known Member
#8
Hi Mohan,
I have checked OI of 8000 CE, 5 times during the day....In NOW and in NSE web site OI volumes are one and the same....there is no deviation...so you can think about NOW excel linking to serve your purpose.....

All the best,
praveen:clap:
praveen sir,

I got Now installed .... and i see same differences between NOW and Nse option chain page....

see the differece below. pls check in ur NOW terminal.


Strike Option chain NOW
8000 ce 2089525 2122975
8100 ce 2775450 2827325
8200 ce 4223900 4546425
 
Last edited:

praveen98

Well-Known Member
#9
praveen sir,

I got Now installed .... and i see same differences between NOW and Nse option chain page....

see the differece below. pls check in ur NOW terminal.


Strike Option chain NOW
8000 ce 2089525 2122975
8100 ce 2775450 2827325
8200 ce 4223900 4546425
Hi Mohan,
Sorry for the late reply..i have not seen your post....i don't know what strikes you are observing now...let me know and i will check those strikes for you...if the differences are minor..ignore them if possible as NOW is real time and nse option chain is a bit delayed...
All the Best
Regards,
praveen
 

mohan.sic

Well-Known Member
#10
Hi Mohan,
Sorry for the late reply..i have not seen your post....i don't know what strikes you are observing now...let me know and i will check those strikes for you...if the differences are minor..ignore them if possible as NOW is real time and nse option chain is a bit delayed...
All the Best
Regards,
praveen
Check EOD if not live. Even they are not matching. look at ATM strikes.
 

Similar threads