Dear Apurva, You are the best with honest intentions to help retail novice traders. I must say this is Level Up Course. Only real trader can part this insight. THANQ & God Bless You :)
Excellent and very useful video. I used to look only at broker software for open interest. But the you have given in this video it has opened my eyes. Thanks.
The way you have compiled the DATA in Excel makes me feel a DATA SCIENTIST in you, as well; where you can easily convert the raw data into meaningful points and do a "What if....?" analysis kind of thing. Since I'm also from the DATA ANALYSIS field, I got the concept. I salute you for your selfless efforts for the Retail Trader Community and also your hand holding for the amateur traders. May God bless you 🙏 and keep you doing the same day after day. Thanks 👍
Dear Apurva, Thanks for educating us on the importance of O.I in deciding a trade. I am a great fan of your way of explaining things, step by step. Excellent. Please keep it up.
Dear Apuravaji,, thanks for highly researched contend. your effort is highly appreciated. Somebody said Data is the next Oil. And you have showed the process,, how to refine Oil. wow thats great.
Thanks a lot Apurva, as I know how difficult it can be to teach this topic, I must say you are a genuine personality with the aim to teach the retail traders. Thanks 👍
Thanks Apurva, you are giving information free of cost which most people charge heavily. Thanks for your teaching. This will help beginners like me to grow.
Dear Apurva, no one goes in that detailed explanation, as you did, you made my Sunday. Many thanks. I will work on this file and circle back with you in few days. On this day of Makar Sankranti, i pray to God that he give you all what you need in abundance.
Gr8 video Apurva Sir. I am overwhelmed by the way you explained the steps to create sheet. I have made it and initially paper trading only. I will trade only when I get confidence for next 2/3 months. Thanks
@@SAMCOSecuritiesIndia Apurva Sir, as I have told that after paper trading I will start actual trading and I am happy to tell you that I have started and got 3 trades in Sept 2022. I got iNFY on 16th Sept and Gujgas on 21st Sept and Shreecem on 22nd Sept. Exited on same day. Trading only 1 lot for now.❤
Its really very helpful. Please make the same video series for options. Like how to fetch data from bhavcopy for 3 expires and combine them ....like how the same which you did for futures.. Thank you.
Thanks sir for your dedication to help noviest trader. The best video in my life.which cover all aspects of market movement. And i understand why market moves. Other videos are only indicator based which are hit sometimes.thanks sir. If any simple indicator can used to show oi it will easy because we r lezy people won't nedd to take studying time easy money.... So money goes easy.... Thanks 🙏
Hi Apurva Sheth, I have seen many videos of open interest but this video will remain on the top. Your way of explaining is too good and easy to understand even if someone is new to market. I have a request. Can you please do a video on Open = High and Open = Low concept for both Futures and options.
Your feedback is been noted. We'll try to incorporate this in our upcoming videos. Please subscribe to our TH-cam channel for more such insightful videos.
Hi sir , I am really impressed by watching this video. I am daily collecting bhavcopy data and crated the sheet as describe by you. Kindly suggest how to use this data for next days trading. Requesting you to make second part of this video which gives information about how exactly use previous day data to take trades on next day. Thanks
HEY, Apurva your knowledge are very good, I'll appreciate it. Please reply can we use this for option trading as well, or what we can filter it for option trading.
Thank you for the kind words, Mohit! We are glad that you are enjoying the content that we put out. We will continue to strive for you and others and bring such valuable knowledge and insights on our channel. Stay tuned!
Sir why we calculated ℅ of change in oi since last expiry and ℅ change in price since last expiry if we don't use it. In your given video the said data is not used anyway. Kindly guide me why we calculated it.
Hello Sir, Thank you sharing the knowledge. I have been following the concepts explained in this video along with price action and Most of the times convictions are proved to be inline with market movements. However there is a small challenge I couldn’t solve so far, that is how to define a SL and which strike prices to select for better results. Would greatly appreciate if you could share some knowledge on the topic, if possible. Thank in advance.
Apurva Ji, Really Superb Video, helping lot in a trading, if possible please take this video to next level. Also request you to make one more video for cash stock, specially Volume Analysis & of course with excel formula. Thanks Dear 🙏
@@SAMCOSecuritiesIndia Already subscribed and watched ur all videos. All videos are extremely good. Keep ur good work going. One request: Make video on" How to read Option Chain all columns and effect of those on trading".
Thanks for your feedback. Here's a video on option chain analysis. Please watch and share your feedback below the video - th-cam.com/video/Div61Tj9Mh4/w-d-xo.html
Hi Apoorva, Splendid efforts. Two suggestions pls. 1) first completely explain the concept, revise/repeat it and in the next video expain how to do it in excel. Concept video is needed for what we want to achieve and why(means what solution it will provide). Second video (means actually this video) will explan HOW - the step by step method to implement it? 2) would it be possible to upload this worksheet on webiste or sharing link on google drive? Icing on cake would be if we can make google sheet of this which can auto update. Never worry about time, those who want will learn in 2-3 sittings if needed. Concept and impletementation should be clear. Anyways, you are doing excellent work. keep sharing these wonderful concepts and ideas. Regards, Hemant !!
Hi Sir, thank you so much for your positive comment! We are happy to hear that you found the video informative and it gave you a full knowledge of Open Interest.- Mehendi.
Sir, Excellent video and gud sheet to follow! Request you to kindly make a similar video on Option Chain for any particular stock and help us( retail) identify whether Big hands are writer/ buyer on Call/Put side . Hope you would help.
Thanks for your feedback. Here's a video on option chain analysis. Please watch and share your feedback below the video - th-cam.com/video/Div61Tj9Mh4/w-d-xo.html
Superb awesome mind blowing sir… this is the best video of yours which i have seen. Your curved trend lines video is also superb. Selected stocks on roe bases excel sheet video was also awesome… cant thank you enough for these type of videos…. Love from the bottom of my heart
Superb. Thanks for great detailed and informative . Thanks for taking time to create such educative videos. If the volumes traded are very high say, like Bank nifty and Nifty, should we consider the cur off criteria at 10% increase in Open intrest. Thanks once again. very well explained.
Thanks for amazing video sir. If possible can you make one video like how to find where Mutual fund investor are investing which equity stock. Thank you.
आपने बहुत खूबसूरती से इस वीडियो में ओपन इंटरेस्ट का शेयर के रेट से संबंध विषय पर बेहद फायदेमंद जानकारी दी है। परंतु कृपया वीडियो छोटी बनाया करें, और भी बहुत कम होते हैं।👍
Dear Apurvaji,you are honestly teaching us this method of finding where OI, price booth are rising. Great video. i m trying to practice the spread sheet.at 19.47 minuts in video, i could not Lock the date cell. Pl help me do it. Hope u explain. Tq
Wonderful video Apurva. Thanks. Will have to check it out in back test. In these times when everyone sells a course/webinar its good to see you empower retail traders by openly sharing your knowledge. Kudos and God bless.
Dear Apurva, Thank you for putting up this video, but with NSE website format changed, i dont know which file to download from NSE, Please guide me which file to download.. the replacement file is not showing the OI values.. please help thanks
Dear Apurva, in the Video we have to select CONTRACTS VAL_INLAKH , OPEN_INT & CHG_IN_OI what is the purpose of VAL_INLAKH & CHG_IN_OI pls explain. thanks
Thanks! Kudos to the thought that went behind this idea of posting something like this...subscribed and liked!! Pls give some color if data from Options can also be used to interpret the same way.....or do come up with a video on it. Looking forward to it...
Thanks sir for a very special and insightful video. Pl clear one doubt if possible. If we use only one day data comparison, why we should maintain data expiry to expiry?
Dear Apurva, You are the best with honest intentions to help retail novice traders. I must say this is Level Up Course. Only real trader can part this insight. THANQ & God Bless You :)
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Lamba lekin bahut bahut bahut valuable video, no one should miss. Thank you Apurva. We expect more such valuable info/videos from you.
Thank you for your feedback.
Very less people like you in market who explain such details of data making nbusing ut right way. Very transparently explained
One of the best videos I have seen in my career, so much clarity and openness in sharing knowledge, God bless you
Hi, thank you for the kind words and we're glad to know that you found the video best.
Excellent and very useful video. I used to look only at broker software for open interest. But the you have given in this video it has opened my eyes. Thanks.
Hi Raghunath, thank you for sharing your thoughts. We're delighted you enjoyed the video.
One of the best video I have ever seen on FnO trade selection...Thanks
Hi, thank you for appreciating us with your kind words.
The way you have compiled the DATA in Excel makes me feel a DATA SCIENTIST in you, as well; where you can easily convert the raw data into meaningful points and do a "What if....?" analysis kind of thing.
Since I'm also from the DATA ANALYSIS field, I got the concept.
I salute you for your selfless efforts for the Retail Trader Community and also your hand holding for the amateur traders. May God bless you 🙏 and keep you doing the same day after day. Thanks 👍
Hi Vishal, thank you for your kind words and for taking the time to watch our video. We are glad you found it well explained and enjoyed it.
have u made this excel sheet ? im finding difficulty in making this sheet
Dear Apurva, Thanks for educating us on the importance of O.I in deciding a trade. I am a great fan of your way of explaining things, step by step. Excellent. Please keep it up.
TH-cam per video dekhna pehli baar saarthak hua...Thank you Sirji..
Sir Sikh to gaya but kam se kam do din lagey aapki video ko pura dekhney mai 1000 times back kiya or 0.25 speed se dekha really nice video sir
Thank you. Please subscribe to our TH-cam channel for more insightful videos.
Dear Apuravaji,, thanks for highly researched contend. your effort is highly appreciated. Somebody said Data is the next Oil. And you have showed the process,, how to refine Oil. wow thats great.
Thanks a lot Apurva, as I know how difficult it can be to teach this topic, I must say you are a genuine personality with the aim to teach the retail traders. Thanks 👍
Thank you for your feedback
बहुत बढ़िया विश्लेषण। बहुत मेहनत से बनाया गया।
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Aise koi knowledge share karta hai pata nahi tha Sir Ek selut App ko , Bahat achha laga sir aise hi video banate rahiye
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
superb it is, people charge thosands of rs for this training.
thank you so much
Thank you for your feedback.
Please subscribe to our TH-cam channel for more such insightful videos.
Really a very very good video, vry very insightful,
Thank you for appreciating, Abhishek. Keep watching!
Thanks Apurva, you are giving information free of cost which most people charge heavily. Thanks for your teaching. This will help beginners like me to grow.
Thank you for your feedback. Please subscribe to our TH-cam channel for more insightful videos.
have you made it ? can you help me making this sheet ?
Extremly advanced video which i needed THNAK YOU SO muuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuch
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
God Bless You Dear Apurva Ji. We pray to God for you to becom a Successful in every field of your life
Hi Sir, thank you for your kind words.
Very nice explanation with actionable inputs
Dear Apurva, no one goes in that detailed explanation, as you did, you made my Sunday. Many thanks. I will work on this file and circle back with you in few days. On this day of Makar Sankranti, i pray to God that he give you all what you need in abundance.
Hi Sruhid, thank you for your comment, we are glad that you liked the video. Keep Watching:)
did you make this excel sheet bro its hard for me to make
. Not many free chanels will provide these much of details. Really helpful. Shall try to apply the same.
Thank you so much Apurva Ji, for making this video.
🙏🙏🙏🙏🙏
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Your presentation, clarity is very simple and easy to understand, hats off to your way of presentation. God bless you 🙏
Gr8 video Apurva Sir. I am overwhelmed by the way you explained the steps to create sheet. I have made it and initially paper trading only. I will trade only when I get confidence for next 2/3 months. Thanks
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
@@SAMCOSecuritiesIndia Apurva Sir, as I have told that after paper trading I will start actual trading and I am happy to tell you that I have started and got 3 trades in Sept 2022. I got iNFY on 16th Sept and Gujgas on 21st Sept and Shreecem on 22nd Sept. Exited on same day. Trading only 1 lot for now.❤
*You are honestly & gently helping to novice traders*
Hi Syed, thank you for the kind words and we are glad to know that you found the video informative.
Its really very helpful.
Please make the same video series for options.
Like how to fetch data from bhavcopy for 3 expires and combine them ....like how the same which you did for futures..
Thank you.
Love you sir very knowledge full video
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Great Apurva Sir Thank you so much this type of grand knowledge.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Thanks sir for your dedication to help noviest trader. The best video in my life.which cover all aspects of market movement. And i understand why market moves. Other videos are only indicator based which are hit sometimes.thanks sir.
If any simple indicator can used to show oi it will easy because we r lezy people won't nedd to take studying time easy money....
So money goes easy....
Thanks 🙏
Thank you for appreciating. Keep watching!
You are honest man sir
Jai shree sitaram ji
Best video on open interst ..................kindly make a video on option open intrest analysis
Thank you so much.
Your feedback has been noted, we'll try to incorporate this in the upcoming videos.
Sir Excellent explain,
I have seen many videos on this but this one is best , made full sheet
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Excellent sir, thank you very much for this knowledgeable video, it help lots
Thank you for your comment. Please subscribe to our TH-cam channel for more such insightful videos.
you are a gem apoorva sir
Thank you for your feedback.
VERY GOOD👍.. I AM FOLLOWING YOUR SESSIONS, TRUE KNOWLEDGE OF HIDDEN SECRETS🤫.. VERY LESS PEOPLE SHARE..
THANKS🌹..
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
APURVA SIR THANKYOU SO MUCH FOR USEFUL N HELPFUL CONTENT
IT CAN HELP LIKE ME NEW TRADER TO LEARN
Thank you for your feedback. Please subscribe to our TH-cam channel for more insightful videos.
Sir this is a Excellent video thanks a lot of u for sharing informative video.
Thanks and god bless you
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
very nice apurva ji
Thanks for watching! Please subscribe to our TH-cam channel for more such insightful videos.
Fantastic Presentation keep up the good work
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
My god
So much deep study
Thank you very much Apurva
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Very good.
Thank you for taking the time to leave a comment.
Boss.. Super
Hats off to explanation..
To Good!!
MindBlowing...
Superb👌
Well explained...
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Hi Apurva Sheth, I have seen many videos of open interest but this video will remain on the top. Your way of explaining is too good and easy to understand even if someone is new to market. I have a request. Can you please do a video on Open = High and Open = Low concept for both Futures and options.
Your feedback is been noted. We'll try to incorporate this in our upcoming videos.
Please subscribe to our TH-cam channel for more such insightful videos.
Excellent vdo and explanation. Thx a lot. God bless.
Thank you for your feedback.
Sir excellent video, this video not delate from TH-cam.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Hi sir ,
I am really impressed by watching this video. I am daily collecting bhavcopy data and crated the sheet as describe by you. Kindly suggest how to use this data for next days trading. Requesting you to make second part of this video which gives information about how exactly use previous day data to take trades on next day. Thanks
hello bro have you made this excel sheet ? can you help me im having difficulty making this sheet .
Great Analysis sir. Thanks for sharing it.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
HEY, Apurva your knowledge are very good, I'll appreciate it.
Please reply can we use this for option trading as well, or what we can filter it for option trading.
sir aap face se bahut Emandar or ache ensaan lagte hai keep knowledgeing us❣
Thank you for the kind words, Mohit! We are glad that you are enjoying the content that we put out. We will continue to strive for you and others and bring such valuable knowledge and insights on our channel. Stay tuned!
@@SAMCOSecuritiesIndia 🙏❤️
Hi Rohit, thank you so much for taking interest in our video. Keep Watching. 😊
Excellent Insightful session
Sir why we calculated ℅ of change in oi since last expiry and ℅ change in price since last expiry if we don't use it. In your given video the said data is not used anyway. Kindly guide me why we calculated it.
We are calculating change on daily to know the new trend which might be emerging and from expiry so we know the ongoing trend in stocks.
Excellent video brother. God bless
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Thank you for sharing your knowledge and wisdom. This will really help.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Great great explaining sir👌👌
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Hello Sir,
Thank you sharing the knowledge.
I have been following the concepts explained in this video along with price action and Most of the times convictions are proved to be inline with market movements.
However there is a small challenge I couldn’t solve so far, that is how to define a SL and which strike prices to select for better results.
Would greatly appreciate if you could share some knowledge on the topic, if possible.
Thank in advance.
Apurva Ji, Really Superb Video, helping lot in a trading, if possible please take this video to next level. Also request you to make one more video for cash stock, specially Volume Analysis & of course with excel formula. Thanks Dear 🙏
beautiful and useful. shall try.
Thanks a lot 😊. Please share it with others too.
Thanks for the vedio,it is very knowledgeable. 🙏🏻
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
What a video? Fully knowledgeable. Filling in mind that video should not end.👍👍
Glad it was helpful! Kindly subscribe to our channel so you keep on seeing such videos regularly.
@@SAMCOSecuritiesIndia Already subscribed and watched ur all videos. All videos are extremely good. Keep ur good work going. One request: Make video on" How to read Option Chain all columns and effect of those on trading".
Thanks for your feedback. Here's a video on option chain analysis. Please watch and share your feedback below the video - th-cam.com/video/Div61Tj9Mh4/w-d-xo.html
Great and thanks team Samco. It was really helpful. Can we get the excel sheet please?
Hi Apoorva, Splendid efforts. Two suggestions pls. 1) first completely explain the concept, revise/repeat it and in the next video expain how to do it in excel. Concept video is needed for what we want to achieve and why(means what solution it will provide). Second video (means actually this video) will explan HOW - the step by step method to implement it? 2) would it be possible to upload this worksheet on webiste or sharing link on google drive? Icing on cake would be if we can make google sheet of this which can auto update. Never worry about time, those who want will learn in 2-3 sittings if needed. Concept and impletementation should be clear. Anyways, you are doing excellent work. keep sharing these wonderful concepts and ideas. Regards, Hemant !!
Thank you so much. Your feedback has been noted, we'll try to incorporate this in the upcoming videos
Excellent Video Apurva. Very clear strategy using oi price trend. Request to throw light on stop loss and target as well ( basically exit strategy).
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Useful info. But process is very hard for me.
easier said than done..... thanks anyways...👍
Glad it helped
Excellent
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
very g00d bro u r best
Thanks!
Many thanks for the love you showed to this video.
SIMPLY EXCELLENT SIR
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Excellent explain sir
Thank you for your feedback.
Exilent video, sir
Pls sir make another video for those who have not familiarise with excel sheet.
Please....
very mcuh helpful
Good one full knowledge of open interest
Thanks for liking. Keep watching!
Hi Sir, thank you so much for your positive comment! We are happy to hear that you found the video informative and it gave you a full knowledge of Open Interest.- Mehendi.
Sir, Excellent video and gud sheet to follow! Request you to kindly make a similar video on Option Chain for any particular stock and help us( retail) identify whether Big hands are writer/ buyer on Call/Put side . Hope you would help.
Noted. Thank you for your feedback. Do share this video.
Thanks for your feedback. Here's a video on option chain analysis. Please watch and share your feedback below the video - th-cam.com/video/Div61Tj9Mh4/w-d-xo.html
True
Dear Apurva Thank you for excelent video. Practice english daily for viewers like me who are not conversant in hindi
Thank You Sri.Apurva
Thanks sir..you gave me good knowledge
Thank you so much..Do share this video ahead..
Superb awesome mind blowing sir… this is the best video of yours which i have seen. Your curved trend lines video is also superb. Selected stocks on roe bases excel sheet video was also awesome… cant thank you enough for these type of videos…. Love from the bottom of my heart
Thank you so much for the kind words. 😀 Its feedback like these that keeps us going. Please spread the word and share this video with others.
Thank you very much sir
Thank you for your feedback.
Content is very beneficial and beautifully explained in simple easy to understand manner BUT background music causes irritation.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Superb. Thanks for great detailed and informative . Thanks for taking time to create such educative videos. If the volumes traded are very high say, like Bank nifty and Nifty, should we consider the cur off criteria at 10% increase in Open intrest. Thanks once again. very well explained.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Best one બહુ સરસ કામ ભાઈ
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
Thanks for amazing video sir. If possible can you make one video like how to find where Mutual fund investor are investing which equity stock. Thank you.
आपने बहुत खूबसूरती से इस वीडियो में ओपन इंटरेस्ट का शेयर के रेट से संबंध विषय पर बेहद फायदेमंद जानकारी दी है। परंतु कृपया वीडियो छोटी बनाया करें, और भी बहुत कम होते हैं।👍
Thank you for your feedback. Your feedback has been noted, we'll try to incorporate this in the upcoming videos.
Dear Apurvaji,you are honestly teaching us this method of finding where OI, price booth are rising. Great video. i m trying to practice the spread sheet.at 19.47 minuts in video, i could not Lock the date cell. Pl help me do it. Hope u explain. Tq
You need to do is press and hold Fn and then press the F4 key and release.
Great.thanks for this info.
Thank you for your feedback. Please subscribe to our TH-cam channel for more such insightful videos.
From where to download the Excel sheet that you have created, that will mr create my own
Wonderful video Apurva. Thanks. Will have to check it out in back test. In these times when everyone sells a course/webinar its good to see you empower retail traders by openly sharing your knowledge. Kudos and God bless.
Glad it was helpful! Kindly subscribe to our channel so you keep on seeing such videos regularly.
Dear Apurva, Thank you for putting up this video, but with NSE website format changed, i dont know which file to download from NSE, Please guide me which file to download.. the replacement file is not showing the OI values.. please help thanks
Dear Apurva, in the Video we have to select CONTRACTS VAL_INLAKH , OPEN_INT & CHG_IN_OI
what is the purpose of VAL_INLAKH & CHG_IN_OI
pls explain. thanks
Thanks! Kudos to the thought that went behind this idea of posting something like this...subscribed and liked!! Pls give some color if data from Options can also be used to interpret the same way.....or do come up with a video on it. Looking forward to it...
Thank you for your comment. Your feedback is been noted.. Please subscribe to our TH-cam channel for more such insightful videos.
Thank you so much
Thank you for your feedback.
Excellent stuff…kudos!
Yes..
Thanks sir for a very special and insightful video. Pl clear one doubt if possible. If we use only one day data comparison, why we should maintain data expiry to expiry?
Hi Hemant, we are glad to know that you founded our video knowledgeable. You can see the trend of price and OI from expiry too.
Thanks for the knowledge sharing🙏🏻.
Can someone please help me automate this sheet?
Very nice