Pick High Conviction Trades with Open Interest | F&O Bhavcopy से Trades कैसे ढूंढे

We are back with yet another insightful video on picking trades with open interest. You will find out how to identify high conviction trading opportunities in this video.
Despite such crucial insights lot of people still ignore or don’t know the right way to use open interest. In this video, Apurva shows the right way to calculate and analyse open interest.
You must always analyse open interest of all the three futures contracts open at any given point of time. Open interest must always be analysed along with price.
Apurva takes you through the whole process of downloading and analyzing open interest data from Bhavcopy.
We are certain that if you watch this video then it will help you identify excellent trading opportunities.
Apurva shows how you can pick high-conviction trades with the help of our Samco App.
Link to watch the video: • High Conviction Trades...
Download the Samco app now to explore this feature. App link: app.samco.in/
Timeline:
0:00 Introduction
4:16 What does open interest tell us?
6:57 Most People Interpret Open Interest in a Wrong Way
9:42 Download Bhavcopy file from NSE
11:25 Doing Groundwork for Analysis
23:15 Adding Price, Open Interest and Lots Traded Data Daily
30:00 Calculating percent changes in Price and Open Interest
34:00 How to Analyse Open Interest Data
49:00 Conclusion
49:56 Highlights
--------------------------------------------------------------------------------------------------------------------------
Open a Free Demat Account
www.samco.in/h...
--------------------------------------------------------------------------------------------------------------------------
About the Speaker :
Apurva Sheth is the Chief Markets Editor at Samco Group. He has a rich research experience of more than a decade in the Indian stock market.
He has helped institutions like banks, mutual funds, insurance companies, and FII’s to profit from his recommendations early on in his career. He has also guided retail investors on the path to profits with his articles and videos in his previous firm.
Apurva is a Chartered Market Technician (CMT). He has also done MBA in Finance and M.Com from Mumbai University. He was also a regular guest/contributor on Zee Business and The Economic Times.
For more updates on the stock market and mutual funds do consider subscribing to our KZbin channel by clicking here - / @samcosecuritiesindia
You can also follow us on:
Facebook - / samcoindia
Instagram - / samco_india
Linkedin - / samco-securities-limited
Twitter - / samco_india
Private Telegram Group - t.me/tradeflix...
#TradingstrategiesbySamco #SamcoSecurities #ApurvaSheth #stocknote
#openinterest #interest #trading #investing #strategy #markets #growth #investment #trade #trader #shares #stocks #futures #options #exel #sheet #calcuations #analyze

[@srinivasdatta]

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 :)

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@lab3755]

Very less people like you in market who explain such details of data making nbusing ut right way. Very transparently explained

[@paulkrupavaram8296]

Lamba lekin bahut bahut bahut valuable video, no one should miss. Thank you Apurva. We expect more such valuable info/videos from you.

[@SAMCOSecuritiesIndia]

Thank you for your feedback.

[@kamaltiwari7244]

One of the best videos I have seen in my career, so much clarity and openness in sharing knowledge, God bless you

[@SAMCOSecuritiesIndia]

Hi, thank you for the kind words and we're glad to know that you found the video best.

[@VishalKumar-kv3dp]

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 👍

[@SAMCOSecuritiesIndia]

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.

[@koopeigwer8072]

have u made this excel sheet ? im finding difficulty in making this sheet

[@raghunathpolur4440]

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.

[@SAMCOSecuritiesIndia]

Hi Raghunath, thank you for sharing your thoughts. We're delighted you enjoyed the video.

[@gsamy21]

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.

[@himanshujadaun2169]

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 👍

[@SAMCOSecuritiesIndia]

Thank you for your feedback

[@narann2267]

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.

[@goatoftrading13]

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

[@SAMCOSecuritiesIndia]

Thank you. Please subscribe to our KZbin channel for more insightful videos.

[@commercedarbar1119]

KZbin per video dekhna pehli baar saarthak hua...Thank you Sirji..

[@bharadwajshinde2420]

superb it is, people charge thosands of rs for this training. thank you so much

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@Factswithkartik735]

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.

[@SAMCOSecuritiesIndia]

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.

[@praveenkurle5556]

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.

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more insightful videos.

[@koopeigwer8072]

have you made it ? can you help me making this sheet ?

[@tirthasarkar4486]

Aise koi knowledge share karta hai pata nahi tha Sir Ek selut App ko , Bahat achha laga sir aise hi video banate rahiye

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@pushkarc28]

बहुत बढ़िया विश्लेषण। बहुत मेहनत से बनाया गया।

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@sruhidvernekar8589]

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.

[@SAMCOSecuritiesIndia]

Hi Sruhid, thank you for your comment, we are glad that you liked the video. Keep Watching:)

[@tradingjohn9884]

did you make this excel sheet bro its hard for me to make

[@amitkinkar4945]

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]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@amitkinkar4945]

@@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.❤

[@abhishekgoelsun]

Really a very very good video, vry very insightful,

[@SAMCOSecuritiesIndia]

Thank you for appreciating, Abhishek. Keep watching!

[@priceactionbyashokpatel464]

Extremly advanced video which i needed THNAK YOU SO muuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuch

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@dilipthakur1292]

Thank you so much Apurva Ji, for making this video. 🙏🙏🙏🙏🙏

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@bikash0176]

God Bless You Dear Apurva Ji. We pray to God for you to becom a Successful in every field of your life

[@SAMCOSecuritiesIndia]

Hi Sir, thank you for your kind words.

[@ogennavar]

Very nice explanation with actionable inputs

[@pratiksheladiya]

Excellent explain sir

[@SAMCOSecuritiesIndia]

Thank you for your feedback.

[@SyedAkhter]

*You are honestly & gently helping to novice traders*

[@SAMCOSecuritiesIndia]

Hi Syed, thank you for the kind words and we are glad to know that you found the video informative.

[@sandeepbhat8275]

I have seen many videos on this but this one is best , made full sheet

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@Hruturaj2812]

very nice apurva ji

[@SAMCOSecuritiesIndia]

Thanks for watching! Please subscribe to our KZbin channel for more such insightful videos.

[@nawazuddinm5914]

Your presentation, clarity is very simple and easy to understand, hats off to your way of presentation. God bless you 🙏

[@RameshKumar-bg2rb]

Great Apurva Sir Thank you so much this type of grand knowledge.

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@anoshlokhande8102]

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 🙏

[@SAMCOSecuritiesIndia]

Thank you for appreciating. Keep watching!

[@mrityunjoyghosh8025]

. Not many free chanels will provide these much of details. Really helpful. Shall try to apply the same.

[@nedumburathasandeep9915]

Very good.

[@SAMCOSecuritiesIndia]

Thank you for taking the time to leave a comment.

[@KutKut0323]

Love you sir very knowledge full video

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@viraldomadia2479]

Excellent sir, thank you very much for this knowledgeable video, it help lots

[@SAMCOSecuritiesIndia]

Thank you for your comment. Please subscribe to our KZbin channel for more such insightful videos.

[@mahantk4415]

VERY GOOD👍.. I AM FOLLOWING YOUR SESSIONS, TRUE KNOWLEDGE OF HIDDEN SECRETS🤫.. VERY LESS PEOPLE SHARE.. THANKS🌹..

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@niteshvig817]

You are honest man sir Jai shree sitaram ji

[@rajmehra8133]

Sir this is a Excellent video thanks a lot of u for sharing informative video. Thanks and god bless you

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@stuartbroad30]

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.

[@ut2387]

APURVA SIR THANKYOU SO MUCH FOR USEFUL N HELPFUL CONTENT IT CAN HELP LIKE ME NEW TRADER TO LEARN

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more insightful videos.

[@gopalmr882]

beautiful and useful. shall try.

[@SAMCOSecuritiesIndia]

Thanks a lot 😊. Please share it with others too.

[@nitinjadhav6228]

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

[@koopeigwer8072]

hello bro have you made this excel sheet ? can you help me im having difficulty making this sheet .

[@WarningRed]

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.

[@phanideep.poluru]

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.

[@SAMCOSecuritiesIndia]

Your feedback is been noted. We'll try to incorporate this in our upcoming videos. Please subscribe to our KZbin channel for more such insightful videos.

[@mysuperemecy]

From where to download the Excel sheet that you have created, that will mr create my own

[@sanjeevs1224]

Excellent

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@hustleuntilendoftimee]

Great and thanks team Samco. It was really helpful. Can we get the excel sheet please?

[@drshatrughnathorat7109]

Sir Excellent explain,

[@PalwankarRavi]

Excellent vdo and explanation. Thx a lot. God bless.

[@SAMCOSecuritiesIndia]

Thank you for your feedback.

[@pawankumarsingh6029]

Best video on open interst ..................kindly make a video on option open intrest analysis

[@SAMCOSecuritiesIndia]

Thank you so much. Your feedback has been noted, we'll try to incorporate this in the upcoming videos.

[@simplestreview4796]

My god So much deep study

[@maheshangaladas7223]

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.

[@vivekgovila4148]

Thank you for sharing your knowledge and wisdom. This will really help.

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@lokesh0garg]

Great Analysis sir. Thanks for sharing it.

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@cryvell2109]

Fantastic Presentation keep up the good work

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@vijaytomar8094]

Great great explaining sir👌👌

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@abishekmajee8064]

Sir fno stocks shortlisted to kar liya lekin ap jis tara ek organised way pe list banaya tha percentile system pe wo bana nhi paya,can you please help me with that?

[@nikhilchowdhary8919]

Excellent video brother. God bless

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@MarketSeeker16]

Thank you very much Apurva

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@fazarali7756]

Sir excellent video, this video not delate from KZbin.

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@ghanshyammishra6740]

you are a gem apoorva sir

[@SAMCOSecuritiesIndia]

Thank you for your feedback.

[@bhavyajoshi2371]

Thanks for the vedio,it is very knowledgeable. 🙏🏻

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@sudeepghosh1848]

Thanks!

[@SAMCOSecuritiesIndia]

Many thanks for the love you showed to this video.

[@sruhidvernekar8589]

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

[@rahulsha91]

Apurva sir! NSE website main changes huye h, how can we download the bhai copy file now.

[@wildgentleman5600]

Good one full knowledge of open interest

[@SAMCOSecuritiesIndia]

Thanks for liking. Keep watching!

[@SAMCOSecuritiesIndia]

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.

[@jaydeepdwivedi7760]

Useful info. But process is very hard for me.

[@ketandeshpande2604]

Excellent Video Apurva. Very clear strategy using oi price trend. Request to throw light on stop loss and target as well ( basically exit strategy).

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@mohitnakoti5282]

sir aap face se bahut Emandar or ache ensaan lagte hai keep knowledgeing us❣

[@SAMCOSecuritiesIndia]

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!

[@mohitnakoti5282]

@@SAMCOSecuritiesIndia 🙏❤️

[@SAMCOSecuritiesIndia]

Hi Rohit, thank you so much for taking interest in our video. Keep Watching. 😊

[@shyam1290]

To Good!! MindBlowing... Superb👌 Well explained...

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@krishnanlr6494]

Excellent Insightful session

[@shivajadhao3077]

SIMPLY EXCELLENT SIR

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@MSG9960]

As per your creation, I have also made same excel sheet, but when I click on "blank" option from instrument, all data comes zero value, I dont what kind of error happened.

[@nime1231]

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.

[@SAMCOSecuritiesIndia]

Noted. Thank you for your feedback. Do share this video.

[@SAMCOSecuritiesIndia]

Thanks for your feedback. Here's a video on option chain analysis. Please watch and share your feedback below the video - kzbin.info/www/bejne/eprZZ2SKn56AnpY

[@iamhemantji1]

True

[@dpgamer8176]

Best one બહુ સરસ કામ ભાઈ

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@mahantk4415]

Boss.. Super Hats off to explanation..

[@mahekchandarana1142]

Hello sir vlook up table after 4 th column index number 10 ypu typed again which is not explained in video , range look up due this formula is not working for me can you help

[@paulkrupavaram8296]

At around 13.53, why coming back to single/current series, when we r summing up OI of all three series? Please clarify

[@skgfin]

sir , we need to create new sheet for every new month expiry?

[@hemantkothari372]

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 !!

[@SAMCOSecuritiesIndia]

Thank you so much. Your feedback has been noted, we'll try to incorporate this in the upcoming videos

[@pro_chartist]

very mcuh helpful

[@rajulabtech7529]

Thanks sir..you gave me good knowledge

[@SAMCOSecuritiesIndia]

Thank you so much..Do share this video ahead..

[@kplsn999]

Hello Sir, You have taken data of 29 Oct 2021 (Friday) which just next day of expiry and while taking next date of data you have selected or taken 2nd of November data (Tuesday). Why did you skip Monday data (1st Nov) ?

[@SAMCOSecuritiesIndia]

Apologies. We skipped it by mistake.

[@pratikparikh5686]

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 🙏

[@user6559.]

Thanks for the knowledge sharing🙏🏻. Can someone please help me automate this sheet?

[@munishalijalali8813]

very g00d bro u r best

[@kiranbangera3023]

Average lots traded to be considered is 3 days or it should be total number of days from expiry to current day.

[@noorullahbNoorulla]

hello sir dated 08/07/2024 se bhavcopy nse site par download ny hora pls bathao any reson reply do sir THANK YOU

[@crexm7171]

Great.thanks for this info.

[@SAMCOSecuritiesIndia]

Thank you for your feedback. Please subscribe to our KZbin channel for more such insightful videos.

[@tototica]

easier said than done..... thanks anyways...👍

[@SAMCOSecuritiesIndia]

Glad it helped

[@dtchowdhary]

What a video? Fully knowledgeable. Filling in mind that video should not end.👍👍

[@SAMCOSecuritiesIndia]

Glad it was helpful! Kindly subscribe to our channel so you keep on seeing such videos regularly.

[@dtchowdhary]

@@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".

[@SAMCOSecuritiesIndia]

Thanks for your feedback. Here's a video on option chain analysis. Please watch and share your feedback below the video - kzbin.info/www/bejne/eprZZ2SKn56AnpY

[@indiancitizen8601]

Thank You Sri.Apurva

[@ashokkumar-qh7iq]

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.

[@DevSingh-mu7se]

Thank you very much sir

[@SAMCOSecuritiesIndia]

Thank you for your feedback.

[@bharatdave2248]

In case of price why do we use closing price and not settlement price? If you share your thoughts please.

[@binodpower]

Exilent video, sir Pls sir make another video for those who have not familiarise with excel sheet. Please....

[@paulkrupavaram8296]

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

[@SAMCOSecuritiesIndia]

You need to do is press and hold Fn and then press the F4 key and release.

[@malkannabegari7276]

Sir, Pls provide the chartink scanner for open Intrest for F& O

[@SAMCOSecuritiesIndia]

Your feedback is been noted.

[@muralikummar.s.k2636]

Dear Apurva Thank you for excelent video. Practice english daily for viewers like me who are not conversant in hindi

[@MrUpendra7]

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

[@SAMCOSecuritiesIndia]

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.

[@hemant1967]

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?

[@SAMCOSecuritiesIndia]

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.