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.
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
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.
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
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?
How do I fetch option chain data from NSE for other indices and stocks like reliance as referred in the video? Do we have to repeat the same procedure for each of these items?
Can you please help getting the same for stocks instead of the indices. The code to do it for stocks is not available anywhere and the version I tried wasn't working (I tried modifying the json code from indices to stocks)... would be great if you could help please
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...
Bro you are AWESOME! This is very helpful! Can you please explain us how can we automate this process so we can story the nes data for every 10 min Or so we can refer to the change on data?
Informative...I could retrieve data from NSE. Thanks a lot. I have a small suggestion for improving your videos, On the part where you are explaining the code part in Advanced query, you could go a bit slow. It would help even those who are not very comfortable with programming. Thanks once again.
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
Can you please teach how to create macro to record data? I have made the live sheet and want to record every 15 minute data. But when refresh new data over rights the old data.
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🙏🙏🙏🙏🙏🙏
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
Hey Keval, Did everything as you explained but the data is not importing. The request was aborted. Could not create SSL/TLS Secure channel. This error is coming. Please help.
Hi , once we are creating the blank query we are getting error like could not create ssl/tls secure channels please let me know how to solve thanks in advance
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
Hello, I want to extract data of Fixed Income and Debt Market (Bond) from the NSE website. I am unable to do it. All the available videos on youtube are either pulling data of Nifty50 or Option chain. Please provide me with the codes or any link where I can learn how to do it.
Dear Sir,Please let me know, instead of nse option chain, if I want to import the data from any other provider like sensibul, dhan ,or info 4 investment, can I be able to do it? Please suggest. Thanks.
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.
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
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.
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.
🙏🙏🙏🙏🙏🙏
😇🙏🙏🙏
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.
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
Very good bro Aapne itne complex cheez ko itna simple kr Diya very good keep it up
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?
Absolutely amazing.. i made sheet by watching this video.. short simple ! 🔥
Kya apko cookies reenter krni padti hai?
This video is ver much informative. Thanks for revealing.
Thank you brother with the help of yours I created my option chain analysis of my own.
I just see this now. Would like to thank you for this work and sharing to all.
Thanks, bro. I was looking for this data like anything. finally got it.
Excellent Work Bro, I want to learn more from your end for stock data scrapping from the websites
one of the best video for option chain trader
How do I fetch option chain data from NSE for other indices and stocks like reliance as referred in the video? Do we have to repeat the same procedure for each of these items?
Very great information, it works well, thank you brother.
Thanks for this precious info...
Genius Guy and thank you for providing free knowledge
Thank you for putting this informative video
Thank you Keval. Loved your video.
Amazing, great work, 🙏
lovely explanation bro. keep it up n thanks!
Pls make a detail video on how to plot Live data in graphical form.. for example- time vs change in OI. THANK YOU
Excellent! Thanks for sharing this info. It works well
Very well done and explained also very good thanks
Superb !! thanks a lot :)
Bahut Hi Pyaara Sa Dhanyawad Brother 🙏
Hi Keval,
How did you change the indices or equities dynamically from drop down cell ?
Can you please help getting the same for stocks instead of the indices. The code to do it for stocks is not available anywhere and the version I tried wasn't working (I tried modifying the json code from indices to stocks)... would be great if you could help please
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...
THANK YOU VERY MUCH SIR,EXTREMELY USEFUL
Thanks a ton bhai for the amazing feat.
Sir aapne bahut badiya video banaya very useful hai
Totally fruitful video series to learn stocks👍👍👍👍
Bro will you elaborate Sell Buy signal in Excel, and how it works? Along with its mechanism?
Very good video ou gave me a great tool.Thank ou very much sir
Bro you are AWESOME! This is very helpful! Can you please explain us how can we automate this process so we can story the nes data for every 10 min Or so we can refer to the change on data?
शानदार my dear thnkxz alot..
Informative...I could retrieve data from NSE. Thanks a lot. I have a small suggestion for improving your videos, On the part where you are explaining the code part in Advanced query, you could go a bit slow. It would help even those who are not very comfortable with programming. Thanks once again.
Maine try kiya par
Mera visual basic pe code dalne k baad , run par click karne k baad
Error 9 aa raha , plz help
Need it
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
Do we need to pull every script separately in the separate workbook?
बहुत शानदार धन्यवाद।।
Too good bro. It's helpful
extremely useful. thanks
Thank you So Much Keval Bhai !! Its Working.😊🙏
Thanks a lot.really wonderful. please guide how can prepare separate data sheet for BankNifty and other stocks?
Awesome work :)
Awesome Bro!
YOu are to good👌
Can you create a similar one for Google Spreadsheet, is it possible?
Thank you So much Keval..
Can you please teach how to create macro to record data? I have made the live sheet and want to record every 15 minute data. But when refresh new data over rights the old data.
Thank you soo much for valuable information.🙏🙏
Indeed, it is paid content and you are sharing free of cost. Thanks and god bless you!!
🙏🙏
Just Woww... Thanks a lot bro
Thanks for the great video. Can you explain the concept for adding the dropdown list for expiry days and underlining assets (Nifty, banknifty).
thanks bro ..it helped me alot
Glad it helped
Subscribed Bro being a fellow tool Creator I can understand the amount of efforts needed to present this kind of magic
🙏😇
@@CAKevalKhimsariyaचु😮तिये बनाया कैसे वो तो बता बो😢सड़ी के
Absolutely supper.. I made sheet seeing your video
Thank you so much.. Its working 100%..
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.
Wow. Thanks. Connected on LinkedIn with you.
Great. Please DM on LinkedIn
Insightful information 👍👍
Thank you Kedar
Really great man
Thanks Bhaia. Danyavath
How to do this on mac? As there is no option in excel for mac to fetch "data from web". And there is no power query editor too...
awesome video bro..thanks a lot
Hey can we do this data pull in office 364 online the free version?
Nice...very informative 👍
Thanks a lot
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 brother!!!!
hi
i am not able to get stock option data from nse website, i can do it for nifty, bank nifty.. can you please suggest
Thank you Sir 🙏
hi, thanks for the great video. I am getting error ' we could not authenticate credential provided' on pressing refresh. How to resolve this ?
Hello do you make customized option chain program in excel on paid version??? If you are comfortable with it please let me know.
Thanks a ton brother 🙏
Thank you for the information
Sir.. If I want to pull nifty futures derivative data viz equity-derivatives-watch, how to write the code. Please guide..
Got it . Thank you
Superb vdo bro. Nice thank you
Thnx for Superb Video
*Super explanation bro*
very usefull work tq so much
Welcome 😊
Thanks for such useful, successfully done
Hey Keval,
Did everything as you explained but the data is not importing. The request was aborted. Could not create SSL/TLS Secure channel.
This error is coming. Please help.
Thanks a lot man :)
Very helpful kebal..thnx
Hi ,
once we are creating the blank query we are getting error like could not create ssl/tls secure channels
please let me know how to solve
thanks in advance
Hi, nice video and very useful.i want to make excel like yours but I do not have knowledge of excel to make thia
Nice info bhai 👍👍
Thank you Bhai.
Very good explanation
Thanks for sharing brother
Most Welcome!!
Thank you so much sir ❤
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
Sir, Can I get this excel sheet for working with any version of excel beyond excel 2007? If possible please update me🙏
Well done 👍
very very very useful thank you sir
Hello, I want to extract data of Fixed Income and Debt Market (Bond) from the NSE website. I am unable to do it. All the available videos on youtube are either pulling data of Nifty50 or Option chain. Please provide me with the codes or any link where I can learn how to do it.
Dear Sir,Please let me know, instead of nse option chain, if I want to import the data from any other provider like sensibul, dhan ,or info 4 investment, can I be able to do it? Please suggest. Thanks.
Bhai bahot achya banaya he....can you please share this excel file itself it would be very helpful for me