Price-Volume and Delivery % Analysis Sheet in Excel
Вставка
- Опубліковано 6 вер 2024
- Delivery percentage and volume analysis is a very important indicator for deciding buying or selling of stock. Delivery based buying or selling decides the seriousness and long term view of the stock. Some of the basics of delivery percentage and volume analysis consist of 4 scenarios.
1. If the delivery percentage increase - price increase -volume increases it is a sign of FII buying sign
2. If the delivery percentage increase - price increase -volume decrease it is confusion. Don't trade when it is not clear if volume increased later then buy otherwise leave.
3. If the delivery percentage increase - price decrease - volume increases or decreased it is a sign of FII selling sign. Exit from the stock volume, in this case, is not mattered because FII doesn't try to sell all their quantity in one day if they do the stock will fall more.
4. If the delivery percentage decreased - price increase - volume increases it is a sign of trap and speculative position is created in stock and stock will be volatile and it increases the chances of loss. Don't trade in this case also.
#PriceVolumeDelivery#ExcelSheetforPriceVolumeDelivery#DeliveryPercentAnalysisSheet
It would be great if this can be done in Google sheet...thanks for this .... its working perfectly...
Haan sir ✔️✔️
Thank you sir for sharing your knowledge
U R GRT......APKI TARIF K LIYE WORDS NAHI HA.....APKI EXCEL....LYF EASY KAR DE......JOKING.....BUT U R AWSOME...ESE HI EXCEL SIKHATE RAHIYE.........
Thanks for your comments
This is to request you to share the work with us in your Video description, that will connect so many people easily
With lots of respect wish you limitless number of subscribers. You are the best.
Very helpful content thanks 👍
Bro, you are good Excel expert than a trader
Great sir.it may required some practice but it is great help.thanks a lot.
Excellent teaching...but Excel takes several minutes for refresh, how to reduce refresh time.
Sir ji coustom colum k bad process nhi le raha agai same problem
Some time it's picking the data 2 times of same symbole with in the same date, you can fix it by making unique identifier of Symbol and Date, Then remove the identifier before close and load.
jo aapki 4 conditions hain uska signal ek summary me last column me daal dijiye taki dekhte hi maloom chal jaye kya chal rha hai stock me.
Very good n helpful 👍
Great thinking. 👍
Thank you sir ji ❤
Sir can you make an video in how you trade how you choose stock how you trade what was your model i believe that that video really help us to do better in trading.
Thanks for sharing your knowledge!
bahut hi behtarin 👌👌 sir
thank you
Good one bhaiya
ధన్యవాదాలు సోదరా 🙏👌
learnt a lot from your videos on how to automate the excelsheet. Is there a way to get all three expiries of F&O stocks also in the same sheet??
Excellent Video!!!! Very Impressive!
sir, volume, delivery & NT data use karne ke liye minimum 60days ka data chahiye. yeh format mein nahi hopayega. agar stock ko drop down mein rakhen aur DATE column mein rakhen toh ache se analysis ho payega. can u guide how to make that.
I always love watching your videos.
I've already subscribed your channel. So I don't missed your videos.
Thanks
sir ,unable to fetch data from web..no basic or advanced dialogue box opening..only showing google chrome brower..
Sir error aa rha h any one help me sec bhavdata full wasn't recognised
Delivery % mein formula sab sahi but waha pe zero hi aa raha hai .. any other mistake ?
EXCELLENT WORK,egarly we are waitting your video
Thanks
@@MyeLearningZone pls call sir
I am not able to get Basic and Advanced in From Web and I am using Excel 2016. Can you please tell me your Excel version?
Hi sir, in the video i couldn't getting formula right ,can you help me ( for daily upgradation , it is not visible properly )
Sir, You have explained in good way.
However, when I prepared the sheet it's showing error in a week where 1 day is market holiday..can you please look into it?
after downloaded Bhav copy not show three Dot (…and copy download link)
please tell me how.
During get data from web in excel sheet , I get (400, bad request). Please help to fix this error.
Very good sir. Can I get average of last 30 days directly or I need to fetch 30 days data like we did 5 days in this and thn calculate avg
When I add url then the next data not updated
are we able to do it now.. its taking time to get data from web
hi I am using Excel 2007, how to make it ? guide me, Thanks
Sir aapke pass live option vol% check karne ki sheet hai??
Hats off to you!
Sir pls make a video on how to create this data in Google sheet.
Can this Data be brought Live on Excel sheet so that I don't need to download and do it daily???
Hlo sir your vedo very help full?
veri nise video
greet work ............I always waiting for your videos.
I've already subscribed your channel. So I don't missed your videos
Thanks
Getting stuck at power query
It was working fine but now nse download are getting failed. What to do?
sir can we get the same excel sheet data presentation using GOOGLE SHEETS , i am facing problem getting 5 days data in google sheet if you have any google sheet data pls share or tell me if any video is related to this topic
I tried more than 3 days finally reached this chart but I can not use it on future days,
Good
@@MyeLearningZone if you have any techniques, chart for future days
This error coming
Expression.Error: We cannot convert the value 290921 to type Text.
Details:
Value=290921
Type=Type
Please Whatsaap me at 0091-7319933013
Man gaye guru 🙏🙏🙏
Sir esme filter lagaya jayega kya jaise 5 days men high price, 5 days mein high volume, &5 days mein high delivery% hoga to plzz bataye kyoki yese dhekhne me bahut time lagta hai filter lagaya to scan hokar ayega please 🙏🙏🙏batana sir
Amazing ....🔥🔥🔥 Your teachings are very clear. Subscribed
7:12 date is coming 6/11/2021 instead of 11-Jun-21 how to fix this
After making the 5 day chart/table I save the the same and when I reopen I cannot see the bhav copy where am I going wrong
in last column delivery the sum function is returing 0, kinldy help to fix the issue
Change format to decimal number in data table
Thank you very much bro.
Amazing
Sr please all fno stocks ka ek vidio banayea jisme,avg price,ttl treded quanty,turnover, no of trade,diliviry quanty, del %, tq/nt ka 3/5/8/13 day ka analysis ho automated
Yes sure
Hi sir,pls share excel
We I'll get last 5 days data right automatically ,no need to download bhav copy everytime ,it I'll take today tomorrow and day after tomorrow day and so on right automatically
Yes you are right
ab to fno wali sheet ka besabri se intezaar ha.......
Sure
Sir volume in this sheet is not showing if total volume for the day has increased From previous day, suppose yesterday delivery was trading 6 out of 10 and today if it was 4 out of 4 then it'll show that delivery percentage has increased. Can we update it with if there is increase in total volume and delivery % or if there is any spike in volume and delivery %, pls confirm
im using ms office 2013 so data me jaate toh kuch alag hi ata hai, pls help sir
Hello sir Ji muje Data tab me ….From web option me….Basic and And advanced Nahi dikh raha hai…
Use Excel 2019
Sir, ye analysis 200 days ke liye karne par excel slow ho jata hai. Please provide solutions.
sir your download file could not able to find it and make excel so please tell me another source to get link
How to fix error - "imported content is empty", while importxml in Google sheets.
Im making all sheets as per his guidance...everything perfect...
Sir delivery % is not available in bhav copy, how do u get it
v good
Thanks
Please tell us how to do it in Google sheets
Thank You ! Works fine with me.
You're welcome!
after changing the dates, are you getting the data.
Sir but m thoda sa confused hu please help me 🙏
Which excel version ti be use
ggogle sheet p possible h?
Sir aur ek bar video ban a do
This will work in windows 2007?
Excel 2016 onward required for any power query if 2013 then add in to be installed
fno ki bhav copy ke liye bhi koi video hai kya ap ka sir?
sir, 3 dots for link is not coming pls help
Helo Nice work. I could do till Price, and Volume. However, Delievery percentage it's not picking up. It's giving zero value. I don't know where I am going wrong. Can you please help me on this. Thanks
Yes sure please Whatsaap me
@@MyeLearningZone Thank you so much. Will you please share your whatsapp number. Thank you so much.
Hi, Ye kon sa XLS hai ye option to nahi aa rhe hamare main
Is work on excel 2016?
How it do in google sheet?
Sir, can i buy this sheet ?
Sir my excel is 2016
But from web se advance and besic advance a nahi raha hein.uske ke liye kya karna padega
Please Whatsaap me
Same issue... using updated one but no luck...
@@MyeLearningZone sir your what'app number?
Sir Custom column karka jab bhi public kar reha hu, error coming
Please contact me
what will be result.........?
Sir jab main fil download krta hun to usme three dot nhi aa rha hai plz help (excel 2016 hai)
Please Whatsaap me personally i will try to help you
SIR GOOGLE SHEET ME KARIYE WO JIYADA COVENCING AUR EASY TO USE HE WITH LIVE DATA, AAP PLEASE EXCEL CHOD KAR GOOGLE SHEET ME WORK SHURU KIJIYE AAPKE VIEWERS BADH JAAYENGE....
Thnaks for your valuble advice I will try .
Sir, how can i filter FNO stocks in DataLive table query to get only fno stocks. Thank you for your generous help.....
sir can u make dividend all stocks in nse and dividend date ex dividend date on google sheets
Please Whatsaap me
Sir ye hum Google sheets par kaise kare
Sir aur ek bar video banado
सर क्या यह शीट Live रहेगी मार्केट डाटा चेंज होगी तो।
sir how to understand this use delivery % data
For analysis it totally depends on you!
Mera load Nahi ho Raha hai, hang hojata ha
Tq
1600 से भी ज़्यादा स्टॉक आ गया है। किसी एक स्टॉक को सर्च करने में काफी टाइम लगेगा। पावर सर्च कैसे बनाये
Sir can you please share this file?
hello sir, 5 min volume
Maan gaye boss.
Thanks
Sr kya ye sheet milegi
Pls share excel