Finding a stock's Maximum or Minimum value in last X trading days using Googlefinance formula
HTML-код
- Опубликовано: 29 авг 2024
- Watch the Full tutorial of Google sheets here: • Google Sheet Tutorial
For chatting with like minded people join my Telegram group (copy and paste it into browser if it does not take you to Telegram group): t.me/joinchat/...
Superb sir ji
I was searching this formula all over youtube channel. I got here Thanks a lot sir
Sir please make video on other formulas like moving averages-daily, weekly, monthly formulas, RSI formulas, and select sheet formulas to fatch the data from all in 1 sheet.
Thank you, for all videos you posted in these series they are good tutorials to novice like me.
Learnt a lot.
People are selfish, here views are 3607 and likes are 121, feel pity for these people.
Thank you very much for making educational videos.
Thank you. You are doing great job. Also I appreciate your enhancmet of videos of our Guru Maheshchandra Kaushkji .
I just saw this vedio.Awsome content.Thanks for knowledge sharing. I need one formula-- Previous day close of stock .Can you share please ??
Dear sir, I have 2queries with regard to Google finance, I hope you may know the formulas
1. How to make a formula to get ALL TIME HIGH from the inception (i.e. start of the company) of the company till today. Another one
2. Formula to get the start date 📅 of the company in Google finance. If possible could you please reply, so that it may helped many people.
Same doubt
You had explained very very nicely I request you to make similar vedeo on how to find moving average of different days using Google sheets.
Thanks boss for your educational videos 🙏🏾 which you are selflessly sharing for free, God bless you
You are welcome 🙂
Please make a video for portfolio tracker for buy, sell and hold status. And also for watch list stocks for buy, wait etc.
Your videos are educative. Thanks.
Please make a video for portfolio price performance for daily, weekly, monthly, quarterly, half yearly, yearly, 2Y, 5Y and Max. This will be very helpful for port folio churning.Thanks.
This is one of the good topic. Thank you
Thank you for this video, very good information, could you please share a formula to calculate weekly and monthly 200 day moving average.
Another gem for your students sir
Thank you sir.
I have one query kindly answer.
How can we get weekly moving average or
11 week average = 11*5 day average
Am I correct sir?
For weekly moving average, you will put "limit 5" in the formula.
You are right about the 11 week average.
Sir I am regular viewer of mahesh sir and now u also and just started trading as I am 22 yrs old
I see most of your strategies but i am confused to select right strategies for me can u help me in finding the right one.
And thanks for your efforts you put in making these videos.
Sharegenius Swing Trading in NIFTY 100 stocks is a good one to start with.
But make sure you are well prepared for ups and downs of the market
GREAT JOB DEAR
Hello, Can you guide how find maximum High of Stocks from starting date to till now trading date by Google finance sheet?
Namskar - how can we get the high and low price of last Thursday of any particular year and month
GREAT HELP BRO
Sir chart ka lane ka formulas kiya hoga 190 din ya200 din ka plg sir🙏🏾🙏🏾🙏🏾🙏🏾🙏🏾🙏🏾🙏🏾🙏🏾
Sir All time high price kaise nikalte hai.. formula batayiye sir please
I need previous days high and low. please tell me the formula
Bro max high price ka sirf date chiyea uska formula kya hai
Bro. Previous high52 date formula?
Sir me yehi video doodh raha tha thankyou very much sir
Welcome Devendra ji
thanks sir but i hav querry 20 days moving avrage weekely chart per kise calculate kar sakte hai
Sir
I have copied this formula, but it is not working showing #VALUE----------"Error
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: COL2"
=MAX(QUERY(SORT(GOOGLEFINANCE(A1,"HIGH",TODAY()-40,TODAY()),1,0),"SELECT COL2 LIMIT 20"))
What mistake am I making, Will you please correct me.
Thanks
sir, how about getting weekly high of NSE and bse stocks
Sir,
Can you give formula for finding yesterday;s high or yesterday's low?
Thanks Krishan ji…can we also get date when high/low was touched?
Hello sir how do i get the previous month’s high price of any stock in google sheets and automatically updated every running month? Can you create sheets for me I just need sheets and kitne money dena hoga sheets banane ke liye???
Hello DC ji.
Such a sheet will need to be created from scratch as it does not exist right now.
Before I can let you know the cost of developing the sheet, I would like to fully understand your requirements. You can contact me on Telegram id @fire_in_india to discuss it further
Col2 kya hai formula me
Hi, How to remove headers from historical data.please help
Sir please relative streanth ka formula samz na he yani ki koi bhi stoks nifty ko kitna outperform kar raha vo dekhna hi ki stok 0 line se plus hebki minis he please help
Sir ji mujhe sirf last 7 Trading days ka high nikalna hai. Only high value no date to wo formula kya hoga. Mai apke formula ko try kia but samj nhi aya pls tell
sir mujhe particular date ka high nahi nikalna aata please help me. example :- muje "reliance" company k dt.01/01/2022 to today 07/10/2022 tak ka high nikalana he to konsa formula use karu sir? please guide me sir
Please watch the video again, I have explained exactly what you have asked
Thank you so much for thsi video, this is exactly what i was looking for .. But am stuck inbetween. How can I link all this together to find the prices for all stocks in one sheet. Like I want the 1 month high of all stocks .. not able to get there. Pls help
You are welcome.
Do you want one month high on moving basis (i.e. last 30 days or so) or calendar basis (1st to 31st)?
@@FIREinIndia Calender basis
I was trying to get it for all stocks in one sheet
@@LearnEarnwithAsha I have created a similar screener for 15 days period in the below sheet, you can do small modifications to get it for full month:
docs.google.com/spreadsheets/d/1LBnS2s8Wm3xrkI9Vnl_WFeCEvyqovPtozBEv60yNiZM/edit?usp=drivesdk
Make a copy of this sheet and then you can make modifications
SIR, IS THERE ANY FUNCTION IN GOOGLE FINANCE TO FETCH 10 DAYS HIGH LOW PRICE"DATE' ???
Thanks sir
Weekly high??
High low date, and price before 1 year, 2 year etc
Sir can we made sheet of 4 stroke method? please reply sir 🙏
Is it possible to get historical volatility of stocks in Google sheet ?
Plz make vedio on how to calculate alpha,beta and median PE of stock.
Right now this series is only focused on formulas used in my Google sheets for various strategies
how can i get direct 50 days high without using columns
Query Kyu Laga Rahe hai ?
Fayda kya hai ?
Bhai sheet par portfolio tracker kaise banate
SIR, can you give me your this google sheet for practice
Sir kya ham hdfc bank ka previous high and low Google sheets me la sakte hai
Haanji la sakte hain. Kaunse period ka data dhund rahe hain aap?
@@FIREinIndia previous day high and low sir,
=Index(Googlefinance("NSE:HDFCBANK", "Low", today()-5,today()), 2,2)
@@FIREinIndia SIR KUS ERROR AA RAHA HE
@@pateljayesh3152 Thik se check kijiye apne formula sahi se lagaya hai k nahin. Mujhe koi error nahi aa raha hai same formula use karke
SIR MUJE 50 DMA KA FORMULLA DIJIYE NA PLE.
Sir can you please tell how to get both date and stock price in last 30 days. I want lowest date.
Just adjust the index number to focus on the date instead of the price
@@FIREinIndia thanks for your quick reply
Namaste bhai
Mai share market me new inter kiya hu mai kaun sa strategy use karu please help me
Sharegenius Swing Trading in NIFTY 100 stocks is a good one to start with.
But make sure you are well prepared for ups and downs of the market
Please creat for 200DMA
The moto of the video is to teach how to DIY
Can you please share formula for 20 days high
It's available in the sheet I have provided in the description
@@FIREinIndia okay
yeh formula kaam nehin karte
Meri sheet me to hamesha kaam karte hain, aap thik se check kijiye, shayad koi error hoga apke formula me
This is one of the good topic. Thank you
This is one of the good topic. Thank you