Volume and Delivery % Analysis - How to Do it Yourself | HINDI
HTML-код
- Опубликовано: 16 сен 2024
- Volume and Delivery % Analysis is very critical during stock selection. It helps to find whether some serious buying is happening the stock or stock is in the grip of operators. It is important to do Volume and Delivery % Analysis if you are a long-term investor.
In my theoretical video on the same subject, i shared how to read the conclusion based on this analysis. You can check the theoretical video on the same subject through the following link
• Delivery Percentage an...
The investor can utilize the excel for this analysis and can use macros to automate this analysis on daily basis. In this video, i have explained in detail how i do Volume and Delivery % Analysis.
If you liked this video, You can "Subscribe" to my RUclips Channel. The link is as follows
goo.gl/nsh0Oh
By subscribing, You can daily watch a new Educational and Informative video in your own Hindi language.
For more such interesting and informative content, join me at:
Website: www.nitinbhatia...
T: / nitinbhatia121
G+: plus.google.co... #NitinBhatia
🔴🔴 To OPEN FREE Demat Account, Click 👇👇
tinyurl.com/2agptj76
Thanks Nitin ji,
it will be great if you could share the macro excel file and explain how to make the macro..so that we can make use of the technique wonderfully explained in your video, thanks again.
Sure..I will share.
thanks, Nitin ji, my mail id is himsouq@gmail.com,
I guess there is one mistake in above analysis, I could be wrong, but just want to put it here what I am thinking.We want to derive at conclusion where we want to have a look at If the price and volume % both are increasing. However the way you have put the formula E>D, D>C should have been vice versa as D>C and C>D. This is because we want to see the price increase from previous day. For that we have to keep If Current day price > then previous day price then put "Y".
However, in above analysis as Base price (C) is current price and day 1(D) price is previous day price, so keeping D>C gives us a reverse conclusion.
Kindly advise If am wrong.
YES, Sumensh ji it should be reverse i agree with u dear nitin ji kindly check the same there its lots of confusion on thw=e same point
दिल से शुक्रिया सर ..... आपके वीडियोस ने स्टॉक मार्किट जैसे जटिल विषय पर अच्छी समझ विकसित करने में सहायक रही है .......फिर भी आग्रह है की मैक्रो फंक्शन लगाने के तरीके पर भी एक विडियो अवश्य बनाइये ... एक बार फिर से धन्यवाद्
Dear Sir, excellent video, thanks for sharing but, i also have same doubt as many others have already commented as -
1. The order of Price, Traded Qty & Del % should be in increasing but the way use used formulae, the order is becoming decreasing. The formulae for "Y" or "N" should be reversed
OR
2. The base data should be oldest data and data in Day 3 column should be latest/today's data.
Kindly extend your help to understand this.
Sir you are doing analysis at 4:30 am felt proud on you & somehow ashamed on my progress of learning. You are true inspiration.🙏
Sir mai such bolu toh maujee vlookup nhi ati thi but ap..k vje sae muje sikne ko mila
Apka video 26 sep sae Follow kr rha hu
Mostly apka sub video dekta hu
Sir mai abhi abhi new demat account open kiya
Really awesome video this is only 1 channel where we learn better about stock market and grab some depth knowledge and sir you really surprise us here we also learned some excel tricks. Channel 1 leaning infinity. good job sir hats off....
Thank you Nitin Sir..
Thankyou sir for spreading best knowledge in public
Nitin Ji, your videos are really very helpful. While navigating through the NSE website, I found that the historical data is also available for an equity. Here is how I got it. Serach the equity on the NSE page, then equity detail will appear. on the right side of the page there is section - Historical Data. In this section, when you click on the link View Historical Data (Equities) then you can see the historical data for one year.
I must tell you all your videos are very information and I am great admirer of yours.
Are u using this?
Sir, the grace you elected is not lees than boon for beginners. For hoi polloi your language is Confederate. Keep it continue...
Explained in very simple manner, many thanks Sir !!
I made it for 11 market days to capture data of 15 calendar days. I have added a FII sector column and % share of FII of the quarter to capture FII buying in last 15 days after getting fortnight data of FII in NSDL site. This is also helping price, volume and delivery analysis. Expecting your suggestion further to improve. I do not have macro right now.
Sir, Great Video & Analysis. iam little confused about formulae for Y/N in column G,H,I and others. I think it should be base >= Day1 and so on. Please clarify. Rest everything is clear
Hello Nitin, thanks for sharing this. It was very helpful. Just wanted to understand should we calculate moving average for deliverable volume (by adding deliverable qty and dividing it by total trading qty) for a given period of time and then compare or just compare day1, day2 and day3.
I saw your previous video and you mentioned about comparing 15, 8, 5, 3 days moving average and then compare. Should we also calculate moving average for price and traded volume and then compare?
I am a Data analyst and have calculate all of the above, that’s why asking.
Thanks a lot.
@Nitin Bhatia Sir, with due respect, I was going through the Volume analysis video and have one confusion... When we are putting IF condition in this sheet it then if we are checking price is increasing from yesterday or not then we should put condition like [=IF(Day1=Base,"Y","N")] kindly clarify ... leaning a lot from you thank you so much for helping us like a angel ..:)
Thanks sir. Market knowledge k saath excel b sikhne mila thanks
hi, this is Vikas, as per my understanding, at the end of the vedio "Volume and delivery % analysis - how to do it yourself", we will select in filter "N" option, because this will give us correct answer, if we select "Y" the result is showing in decreasing from day 1 to day 2
बहुत शानदार 👌
Complicated but is super..
Thank you sir..
Thkuuu.. I mean you made a very nice effort to teach us. I appreciate it
Amazing video. Very good practical learning it depicts.
Thank you sir just crated master sheet now learning macros
Please share the sheet with me its urgent.
Aap se maine bohot kuchh sikha hai
Wouderfull.... This is called complect info on a topic hats off sir
Awesome!!! Glad you found it helpful! Keep Watching 🙂
Today we have learnt cool excel tips. Thank you!!!
Awesome!!! Glad you found it helpful! Keep Watching 🙂
Sudip ji are you ready sheet pls help me I confused some
@@DDevbhoomiyatra sir have u made this sheet?
No I have not made this sheet
Excellent Learning, Thank You for teaching ...
Great sir , ji 👍
Your knowledge is not compare with any one
REALLY GOOD ONE ... TEACHING LEVEL IS SMOOTHER ... THANKS TO PUT EFFORTS FOR NEW AND MODERATE PEOPLE LIKE US...
Nitin Sir, aapki har video bahut understanding hoti but ye wala jo video hai "Volume & Delivery % Analysis ka isme mujhe confusing ho raha hai.
1. Base price day 3 price increasing order mein lekin aapne kaha tha base price current price hota to base price to zyada hona chahiye day 3, day 2, aur day 1, se ye confusing state hai hamare liye please isko clarify karde.
2. Macro mujhe create nahi karne aata hai to aap please in dono condition ko solve karne ke liye iske upar ek video bana de.
Thank you so much for your effort for us...
Hi Sajid , i agree with you. Pls sir, Ek bar phirse video banaiye iske upar.
Same pont me ujhe bhi confusion hai base price current price ka lena hai fit price increse laha ho raha hai pls clarify it
Same question...
Valuable knowledge
Hi sir New learner I have learned lot of stock market things from you still learning. God bless you.
Excellent piece of work!!!
Excellent learning video,found after long time.
Thank you very much sir ji for this valuable video.. revision done...... copied.
Informative video as always thanks sir keep supporting retailers... 🙏🙏🙏❤❤
Dear Sir,
Thanks for the wonderful assesment and to share your knowledge with the people.The way you make things understand to the public is awsome. Very cool and clam. Great and God bless you.
Pls bataiye ye strategy kounse trade ke liye fit hai, Intraday, short term, long term, Swing etc..., time frame kya honi chahiye, aur is strategy ke filters kya hone chahiye to arrive at the best stock for next day trading.
Dear Sir, Pls bataiye ye strategy kounse trade ke liye fit hai, Intraday, short term, long term, Swing etc..., time frame kya honi chahiye, aur is strategy ke filters kya hone chahiye to arrive at the best stock for next day trading. Sir pls make one more video ion this, Pls . There is a lot of confusion in base price, day 1 , day2, and so on...... I usually do intraday. So pls confirm is this strategy work out the stock for next day intraday trading. Ir i will be eagerely waiting for your reply.
Are u using this?
SIR ONE DOUBT
IN ANALYSIS SHEET, WHILE USING IF FORMULA U HAVE USED >= SIGN THAT MEANS YOUR DAY 3 VALUE>=D2 VALUE MEANS PREVIOUS DAYS VALUE SHOULD GREATER OR EQUAL TO NEWER DAY THAT DENOTES Y SIGHN......BUT SIR, NEWER DAY VALUE SHOULD BE HIGH AS YOU SAY STOCK PRICE SHOULD INCREASE MEANS PRICE LAST VALUE OF BASE SHOULD HIGH THAN DAY 1. I THINK WE R USING WRONG FORMULA HERE
Nitin Sir, This is awesome work & great effort. but if you don't mind the formula could be vice versa. because the base price is the latest price & Day 1 price should be deduct from the base price.
nice video sir ap such me bahut genious hai sir
sir agar apne ye comment read kiya to plz reply zarur kare
bahut achhi important zakari n is video or apke vlookup n macros wale video se automated system banane me bahut help hogi
apne humko sab kuch available karke diya hai bus hum hi thode sust hai
heartly thanks nitin sir .... u r very GREAT Personality
three year agol 13k sub and 5 lakh view ...now 5 cr view and 8 kah sub.... itna growth to multibagger stock mein bhi nhi hua
audio volume thoda zyada aur clear rakhe thank you.... respect.... good work
Thanks a lot for your feedback 🙏🙏. I will definitely work on the same. Keep watching 🙂
Great...clossing Prise volume delivery percentage analysis study
Thank you very much sir ji for this wonderful video... appreciate your hard work..in early days..keep guiding us
Fine work, will hear and see all one by one...
Dear sir agar ek bhi din data enter karana bhool gaye to kya karana hoga sir ...
Sir, Bahut Hi maje daar
Thank you Nitinji..Much Appreciated..very useful info..
This was a super information guru ji
Very good sirjee
Nice video sir. Thanks sir.
Thank so much sir your efforts are precious.
Siri.... as you are you making vedio in morning at 4.00 ? 🙄🙄🙄 Tusi Great ho Gutuji....Nice vedio for Positional Buy and Sell Decision .. 🙏🙏🙏
sir why J K L col is used for???? and what is cal behind it
nice data information sir for retail investor
good video, one confusion, kindly clearify, you said in the end in two sorted stocked price and volume is increasing but actully that is decreasing as compare to last day price and thats why that is coming Y.
Very helpful.
Nice
Sir, could you please add this video to swing trading or technical analysis playlist for benefit of all.
Thanks you sir
Thank you sir for this valuable insight. I am looking forward to become a trader.
Per volume & Delivery % wali video aapne bata hai ki D2>=C2 iska meaning tuo y hua ki stock price niche aa rahi hai .
Correct you are right... He made a mirror mistake
Great work sir, quality information provided by you ,but still 1 question is in my mind what parameter you had taken in column A 🤔
Yesa hi krunga sir g
Today I saw this video more than 6 times
@@dhavalkumarpatel2193 let me check
@@dhavalkumarpatel2193 yes, Patel ji, you r right. formula edit karna padega
Formula reverse karna hai
Sir thank u very much for sharing hidden knowledge of investing. plz my personal request u to make video for crypto currency, in this field investment good or bad
Very nice video sir.
Stock wise historical delivery percentage data is also available on NSE.
Thank you
Wah sir me bhi abhi vedio dekh raha hu or 16 june ka hi deta 2021 ka updated hai ...😃
Sir mai kehna chahta hoon ki isme if condition reverse me laga hua hai.
Nitin Bhai, congrats. This video is wonderful & very useful. Thank you very much.
Thanks a lot for your kind words of encouragement 🙏🙏. Keep watching 🙂
Are u using this?
Thanks a lot sir very very nice information
Please share other analysis. Specially analysis related to fii. You are awesome. Thank you very much.
sir god always bless you and your family..☺️☺️☺️
Excellent video sir
Thanks sir ! Sir base price is latest price . day1 is yesterday. then" yes" formula giving decreasing value.not incresing.please explain . To this point most enquary in comment section I saw. Please explain it.
Sir please reply ! I am working on this & I have this problem.
sir *correction) base price se 1 day ki traf badh rha hai fir 2day me bhi badh rah hai fir 3 day me bi badh rha hai jo ki ulta ha jabki hona chiye 3day se 2 day ki traf badhna
thanks
I already replied.
unable to find your reply sir...i am also having same querry. plz help.
Sir i m watch completed this worksheet but close price volume and delivery price not increasing , i m confuse this share only watch list day1 day2 day3 which copy date mistake
सर आप नही होते तो शायद कितने रिटेलर mkt में बर्वाद और कितने के घर लूट गए और कितने कभी के mkt को bye bye कर गए होते
Great sir I would like to really appreciate ....
Agar 1 ek v din update ni ho paya to Kya hoga ya gap ho gaya to
Prepared the sheet and Macro for automation also. One important thing guys, change the "> " with "
अजय जी कृपया अपनी एक्सेल सीट मेरे साथ शेयर करिये
Thank you
Thanks a lot for Ur efforts
informative video
So useful sir....
Sir, maine delivery % wala video dekha aur accordingly excel sheet bhi bana liya bus ek confusion ho raha hai….like base, day1,day2, day2 main day3>=Base hoga ye sahi ya nhi…..
great sir thanks
Thanks Nitin Sir, Its a great video with well explanation. I used the record macro to record the steps but looks like its not working. Could you please help me to share your macro function code?
🙏🙏🙏Very nice thanks great sir g, asch krin sir g 🌸🌼🌺
धन्यवाद
THANKS FOR SHEARING U R TECHNIC WITH US. Regarding that i have a query
sir if i see the DAY1 Value >= Base Value = Y, and vise versa for day2, day3, then isn't the latest (which is base) is decreasing then we use Y and if all Y thats means day by day the CLOSING PRICE is every new day is decreasing (vise versa for all)??? then how much is good this???
Sir,how to run macro? Any video there after how to run macro?
Nice information. Seems to this file now change from NSE now delivery percentage is getting from diff file.
Thank you sir for this knowledgeable video. Base price se 1 day ki traf badh rha hai fir 2day me bhi badh rah hai fir 3 day me bi badh rha hai , jo ki ulta hai, jabki hona chihiye 3day se 2 day ki taraf badhna. Pls confirm
Sir jab 1st day Ko last column me rakh rahen hain or last k NSE ki list ko first column me...to grater than ka symbol last column se first pr ayega na...confusion hai thoda sa...
Han mjhe b Esa lgta h
Sir nice video.
I understood the excel part but please tell/teach how to prepare the micros.
Regards
The sheet checks delivery percentage for 4 consecutive days, whereas theoretically you explained to use 15, 8, 5, 3,1 day moving average of delivery percentage . Kindly clarify this.
see latest stock talk vedio this senario is explaned
sir ji, macro starting me hi record karna he? k 4 days ka data fill up hone ke badme?
THANKS SIR
GOOD
Hi Nitin Sir, Video is really helpful & you have explained it very well. I have only one doubt and that is how you have created macros function. It would be really helpful to me if you could guide me on that or conduct video for same.
Thank you very much:)
Dedicated work
Sir, please help us how to calculate the data which you have shown in column J,K,L / T,U,V & AD,AE,AF
Sir explain what is the J,K,L , colam calculations
Very nice video!!
Price ko vlookup lagane se pahele stock ke symbol aapne master sheet me kaise laya jay?
Ya symbol ka colume copy karna padta hai?
Sir mai aapka video last two months se dekh Raha hoon