How to Calculate Live Simple Moving Average in Google Sheet

The moving average is calculated by adding a stock's prices over a certain period and dividing the sum by the total number of periods.
Join this channel to get access to perks:
/ @myelearningzone

[@nothingblasted8464]

REALLY I FOUND YOU AFTER LONG SEARCH, THANKS FOR YOUR VALUABLE TEACHING

[@vv9730]

for those want to copy formula
=AVERAGE(QUERY(SORT(GOOGLEFINANCE("NSE:"&B1,"price",today()-365,today()),1,0),"select Col2 limit 5"))

[@saurabhjain1809]

Tnx brother video was so blur couldn't see formula 😊 your comment is appreciated

[@HarendraSharmaGwl]

Bhai closing price lete h

[@ranjanprusty1167]

In Google sheet while giving average formulae the error message " function Average parameter 2 expects number values, but "select col2 limit 10" is a text & cannot be coerced to a number.

[@bhasker789]

Average not matching with chart sma price

[@ataurrahman-pi3nc]

GOOD WORK I AM WAITING FOR PART 2

[@umeshkumavat8764]

SIR VERY KNOWLEDGEABLE SHEET I APPRECIATE YOUR EFFORT. THANKS BROTHER

[@karankokane8630]

When can we expect the next video on automation? I want to understand how you pull the constituents of the index into the sheet. Can you help me with that?

[@letsdosomething2022]

Dhaka stock exchange nehi hota hain keu sir?

[@shashikantparannavar]

Thanks for teaching🎉

[@raghusubbuanuram22]

Very good information

[@ninja78]

is there any formula to get Exponential moving averages ?

[@vv9730]

very nice....is there any way to calculate EMA in similar way...???? as same is used more widely than SMA...

[@kamlesh6279]

Kindly provide the link to get the Google sheet showing the moving average as shown in your video

[@IMAMKHASIMS]

Thankyou for trained me i am waiting for next video

[@dasprem3992]

Thanks for the video tutorial. I am always getting an error while using the select function when I tried to do the same example as you have shown. Not accepting col2. Any suggestion to correct the error.

[@atultanna]

Have you got a sheet for weekly crossover

[@mannoj78]

IT WOULD BE VERY HELPFUL IF YOU GIVE THE FORMULAS IN NOTE PAD ATTACHMENT. YOU ARE VERY KIND FOR TEACHING US.

[@khempalmishra2]

Sir I have issue
How can we calculate 50 sma on weekly chart on Google sheet

[@sanjaymishra3104]

How to pull Option chain in Google sheet through broker terminal if possible please make video on this topic.

[@relaxingbeats3025]

Thank you for this video, very good information, could you please share a formula to calculate weekly and monthly 200 day moving average.

[@narayananhari]

Upto query works. Average not working. Error " UNSBLE TO PARSE QUERY STRING FOR FUNCTION QUERY PARAMETER 2; NO_COLUMN: col2. Kindly explain how to clear

[@dinkds26]

Thank you for the wonderful video

[@tejaskumarbhajiwala8762]

Hello sir, I am getting error while using select query. No clumn found. Pls help

[@rnayak1979]

Thanks your for the hard work sir. Can we get Hourly basis change of price in excel to plot the super trend for BTST type of trade . Plese help.

[@PrakritiEquities]

Excellent; keep it up

[@chanduapte3895]

This is DMA calculation. But when time frame is changed to monthly. Moving average figure changes. How to calculate monthly ma???

[@12345677748]

Sir open chain ki jo file apne blog pe post Kiya hai o site open nahi ho rahi hai

[@azar382]

Sir is excel1 day time fream he.
S1 hour time fream me moving average kaise add kare.

[@cmvy]

I am not getting the sort function. This is the formula I typed. =QUERY(SORT(GOOGLEFINANCE("NSE:RELIANCE","PRICE",TODAY()-365,TODAY())),1,0) What is wrong with this? Can you please copy the formulas and increase the text size so we can view them easily? I am getting without sorting but moment sort is added, it shows error.

[@milanjyani6120]

Sir, can we add Bollinger band value in google sheet like moving avg?

[@jagdishgyanchandani1988]

Thanks for the useful learning. Sir, please also share how to fetch Nifty 50 Spot data through Google Finance command.

[@sipra555]

Sir, can you kindly make a sheet of 20 DMA FOR ALPHA ETF & MOM30IETF FOR ME.

[@pravinsakpal6798]

Sir, can you please share excel sheet plotting said formula in it

[@sttreetboy]

Very well done

[@naveendn2888]

Hello sir,Is it possible to get intraday (10 min/15 Time frame) live indice data in google finance?Thanks a lot in advance.

[@JACK9396]

thank you very much sir.

[@stormynight9663]

how to get the file?

[@gajakuppagodu4328]

sir please make 1 video of nifty daily data store by date wise in excel it will be helpful to us

[@Dahyabhai.Chaudhary]

Moving average ki jagah yahi formet me return pe ek video banao

[@karanicomp7122]

BEST ONE THX JAY HIND

[@vasugiramu4087]

can i get the excel sheet

[@hariomsingh873]

Sir dividend traker manthly and yearly banaye

[@prustysaurabh]

But googlesheet SMAs not accurate....when i download scrip price from NSE site and tabulate SMA 20, 50, 100...the results of google sheet is different. Also the SMA on charts are different. Google needs to align trading dates with NSE.

[@suryawanshianand9426]

Amazing knoledge

[@sumankant8519]

Unable to get average it shows error

[@TRADINGTACT45]

auto update kese hota hy

[@JaiPrakash-ec6kf]

EXCELLENT!! BUT I WANT TO DO THIS IN EXCEL IN SPITE OF GOOGLE SHEET, PLEASE TELL ONLY FUNCTIONS FOR LIMIT NO NEED TO DESCRIBE INTACT PROSSES.

[@nileshbhalodiya5017]

Nice sir
Weekly moving average kese kare ?

[@soumyajitbiswas3708]

Formula doesn't work, what to do

[@BornkillerSharma]

not working,i m getting error

[@milanjyani6120]

Thank u... Sir

[@tarachandkhatri9]

Select add karne par error show kar rha he

[@saroj4900]

Sir Ema me error aa raha hai

[@komaljiwanapurkar6000]

KUCH DIKH HI NAHI RAHA HAI

[@cbyadav73]

Not clear

[@PS-rr4qt]

humare google sheet mein select ke baad error dikha raha hai

[@bestpicks6249]

Not working your formula

[@RakeshKumar-lt9vk]

Screen dhudhli hai,,kuch samaj nhi aya

[@karanicomp7122]

[@hsswhatsapp6511]

=AVERAGE(SORT(GOOGLEFINANCE("NSE:"&A2,"OPEN",TODAY()-365,TODAY()),1,0),"select Col2 limit 3")) IT didn't work.

[@vinodk4805]

Sir this is not work please clear make a video