Excellent Video. Makes so much sense. I spend 1 hr daily on downloading the data and still I cannot use it most of the times, because my downloaded data becomes old in the next minute. This gives live information. Extremely fantastic
Very nice thanks. The fact that you have given us an awesome way to get ALL data on Excel and then managing to manipulate your own data and insight, and have done so very successfully, is really admirable. Only an individual can make his own system, very correct. Thanks you again. You are a legend.
thx Keval, Tried everything from Powershell to vba query for new nse website, did not work!!! your simple method works like a charm!!! thx a ton bro!!! you rock!!
@@CAKevalKhimsariya Keval, I tried it for BankNifty, as I copied Cookies from Banknifty page but still it's showing / retrieving Nifty Option chain data. Is it because Code you given is for Nifty? Or is there other issue?
I followed so many videos to extract data from NSE, you are the only guy explained about refresh automatic option. You gave replied to most of the comments, Sailute to your patiency. 🙏🙏🙏🙏🙏🙏
Jabardast simple and short with full information video, thank you so much sir aapne apna precious time nikal ke hamare liye itna acha video banaya.... thank u thank u
Extremely useful information, very well explained with 100 % accuracy, Thank you so much, SIr. After watching and practicing your instructions, I am able to extract live data of the Nifty Option Chain, My request is, please teach how to use this live information in trend identification and taking trading decisions also, in your next presentations. Thank you so much.
You're a gift to those around you. You are awesome!🙏🙏🙏 Please explain how to pull out the data of futures. Futures OI data into excel. plz plz plz🙏🙏🙏🙏🙏🙏
Btw there are total 5 videos. This was the first video only. go through the playlist. it might help you ruclips.net/p/PLqJd-cgHAQeKnuerBjfpMhRWKiNYOkwcr
Sir maine iss video ko ko dekh ke file banaya aur 4 to 5 days work bhi kiya par last Friday se data upload nahi ho raha hai. 1 min ke bad refresh hote hi sab data 0 ho jate hai. Pls help me
Simply copy the entire sheet from NSE page and paste it on excel any version. Save it as .csv and close. Open the same file again . That's how I CALCULATE Max pain, OIPCR VOLPCR .on a regular basis.
i am really grateful to u for ur videos sharing how to import option chain data to excel. but in that video u have told that u have shared the codes in description or something which couldnt be found by me. plz help me with that, as i am half way making the import. thnk u.
can you spoon-feed me this xl sheet. i saw this in SMC webinar posted on some other channel. but you have taken to next level. i would like to backtest the logic that you have put with my learning so far in live market and aftermarket...i don't do option trading yet... still learning.... i can modify the formulas as it changes...
Awesome video. Thanks for guiding.. If is it possible can you please create one more video for how to change column name and manage like which excel you created for yourself...Thanks again for this also.
great job.........how can i adjust the column width, i cannot drag and simply adjust like in an excel sheet, if done it automatically realigned to its default width immediately after refreshing, plz help
Hi bro in video u have selected stocks ,what are the steps to create the columns you have explained everything but pls explain this feature which will be helpful for us ....thank you
Excellent Video. Makes so much sense. I spend 1 hr daily on downloading the data and still I cannot use it most of the times, because my downloaded data becomes old in the next minute.
This gives live information.
Extremely fantastic
Very nice thanks. The fact that you have given us an awesome way to get ALL data on Excel and then managing to manipulate your own data and insight, and have done so very successfully, is really admirable.
Only an individual can make his own system, very correct.
Thanks you again. You are a legend.
thx Keval, Tried everything from Powershell to vba query for new nse website, did not work!!! your simple method works like a charm!!! thx a ton bro!!! you rock!!
You're welcome!
@@CAKevalKhimsariya Keval, I tried it for BankNifty, as I copied Cookies from Banknifty page but still it's showing / retrieving Nifty Option chain data. Is it because Code you given is for Nifty? Or is there other issue?
was struggling for many days, finally able to get the NSE data in excel.... thanks
I followed so many videos to extract data from NSE, you are the only guy explained about refresh automatic option.
You gave replied to most of the comments, Sailute to your patiency.
🙏🙏🙏🙏🙏🙏
😇🙏🙏🙏
@@CAKevalKhimsariya TG CHL PAR OPTION NAHI DIYA HAI,, JI , NORMAL EXCEL HAI, ONLY OPEN NO COOKIE, NO QUERY,
Jabardast simple and short with full information video, thank you so much sir aapne apna precious time nikal ke hamare liye itna acha video banaya.... thank u thank u
Absolutely amazing.. i made sheet by watching this video.. short simple ! 🔥
Kya apko cookies reenter krni padti hai?
Very good bro Aapne itne complex cheez ko itna simple kr Diya very good keep it up
Indeed, it is paid content and you are sharing free of cost. Thanks and god bless you!!
🙏🙏
I just see this now. Would like to thank you for this work and sharing to all.
Bahut Hi Pyaara Sa Dhanyawad Brother 🙏
one of the best video for option chain trader
Extremely useful information, very well explained with 100 % accuracy, Thank you so much, SIr. After watching and practicing your instructions, I am able to extract live data of the Nifty Option Chain, My request is, please teach how to use this live information in trend identification and taking trading decisions also, in your next presentations. Thank you so much.
Thank you brother with the help of yours I created my option chain analysis of my own.
Genius Guy and thank you for providing free knowledge
Subscribed Bro being a fellow tool Creator I can understand the amount of efforts needed to present this kind of magic
🙏😇
@@CAKevalKhimsariyaचु😮तिये बनाया कैसे वो तो बता बो😢सड़ी के
Sir aapne bahut badiya video banaya very useful hai
Thanks a lot for sharing the detailed code and process to import the data. I could successfully import the data using the steps. Thanks a lot.
Thanks, bro. I was looking for this data like anything. finally got it.
बहुत शानदार धन्यवाद।।
Absolutely supper.. I made sheet seeing your video
So very thank ful yaar. Still working in 2024 🙌🏻
शानदार my dear thnkxz alot..
Thank you So Much Keval Bhai !! Its Working.😊🙏
Thank you so much.. Its working 100%..
Bahut shandar
Thank you Keval. Loved your video.
Very good explanation
Excellent! Thanks for sharing this info. It works well
Very great information, it works well, thank you brother.
Really great man
Thank you So much Keval..
extremely useful. thanks
Thanks Bhaia. Danyavath
Very good video ou gave me a great tool.Thank ou very much sir
Thanks a ton bhai for the amazing feat.
Ultimate Video lecture :)
THANK YOU VERY MUCH SIR,EXTREMELY USEFUL
very very very useful thank you sir
Just Woww... Thanks a lot bro
Very good knowledge sharing
Too good bro. It's helpful
You're a gift to those around you.
You are awesome!🙏🙏🙏
Please explain how to pull out the data of futures. Futures OI data into excel.
plz plz plz🙏🙏🙏🙏🙏🙏
Okay Brother, as you demanded.
ruclips.net/video/qyqn7AyWr-Q/видео.html
@@CAKevalKhimsariya I will never forget your favor. But sir Open Interest data didn't fetch.
Awesome Bro!
YOu are to good👌
Superb vdo bro. Nice thank you
Well done 👍
Thanks for such useful, successfully done
Thank you brother!!!!
Sir very helpful video sir thanks
*Super explanation bro*
Very helpful kebal..thnx
Insightful information 👍👍
Thank you Kedar
Lovely video dear
Brother you rock . Thanks 🙏🏻 alot you made my day . M so releaved.
By writing this, you made my day as well..
Btw there are total 5 videos. This was the first video only.
go through the playlist.
it might help you
ruclips.net/p/PLqJd-cgHAQeKnuerBjfpMhRWKiNYOkwcr
@@CAKevalKhimsariya Dear can connect with you..Please
Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU
Thnx for Superb Video
very usefull work tq so much
Welcome 😊
Thank you for putting this informative video
Very well done and explained also very good thanks
This video is ver much informative. Thanks for revealing.
Awesome. No words to thank you ❤
Thank you for the information
Hi, nice video and very useful.i want to make excel like yours but I do not have knowledge of excel to make thia
Wow. Thanks. Connected on LinkedIn with you.
Great. Please DM on LinkedIn
awesome video bro..thanks a lot
Great work brother
Thank you so much 😀
Sir maine iss video ko ko dekh ke file banaya aur 4 to 5 days work bhi kiya par last Friday se data upload nahi ho raha hai. 1 min ke bad refresh hote hi sab data 0 ho jate hai. Pls help me
Nice template Keval
Thank you
thanks bro ..it helped me alot
Glad it helped
Thank you so much sir ❤
Thanks a ton brother 🙏
Thanks for such a HIGH quality video 😍
Most welcome😇
brothee plz help mee
good work bro..
Simply copy the entire sheet from NSE page and paste it on excel any version. Save it as .csv and close. Open the same file again . That's how I CALCULATE Max pain, OIPCR VOLPCR .on a regular basis.
Very Nice content Great work bro
Only request pls show how to extract ATM/SPOT of instrument
Hi thank you so much
Excellent Work Bro, I want to learn more from your end for stock data scrapping from the websites
Salute sir,,
lovely explanation bro. keep it up n thanks!
Nice...very informative 👍
Thanks a lot
Thanks. How to do it for Stock Options like ITC. TCS etc.
Got it . Thank you
Thanks for sharing brother
Most Welcome!!
Nice info bhai 👍👍
Thank you Bhai.
i am really grateful to u for ur videos sharing how to import option chain data to excel. but in that video u have told that u have shared the codes in description or something which couldnt be found by me. plz help me with that, as i am half way making the import. thnk u.
I have emailed you
bhai thanks so much. Keval bhai if we need to select only selected strike price how do we achieve this
can you spoon-feed me this xl sheet. i saw this in SMC webinar posted on some other channel. but you have taken to next level. i would like to backtest the logic that you have put with my learning so far in live market and aftermarket...i don't do option trading yet... still learning.... i can modify the formulas as it changes...
Superb !! thanks a lot :)
Awesome video. Thanks for guiding.. If is it possible can you please create one more video for how to change column name and manage like which excel you created for yourself...Thanks again for this also.
how can we add ticker Dropdown for the Stock Option chain data in the same ??
Amazing, great work, 🙏
Awesome work :)
Thank you sharing your knowledge.
Kindly request you to share your excel sheet formula ...
great job.........how can i adjust the column width, i cannot drag and simply adjust like in an excel sheet, if done it automatically realigned to its default width immediately after refreshing, plz help
Very nice! Please let me know one thing. How can I do the same for Bank Nifty?
Thanks for this precious info...
Thanks a lot man :)
Kya video banaya hai..... Kin chutiyo ne dislike kia hai.
Bro salute. You make my work easy.
very nice
Hi bro in video u have selected stocks ,what are the steps to create the columns you have explained everything but pls explain this feature which will be helpful for us ....thank you
Thank you so much
can you please do a video on stock futures? How to download historical data of stock future.