Moving Average Crossover Signal in Google Sheets with One Advance Formula using Google Finance data2

[@Vasili_Wears_Shorts]

Not that I could understand really 99.99% of this video, you seriously helped me build one phenomenal stock screener. Thank you so much!

[@SilentTrader24]

Glad you enjoyed learning

[@subhasisj]

MISTAKES ARE PART AND PARCEL OF LIFE. GREAT LEARNING VIDEO SIR. THANKS FOR SUCH AN INFORMATIVE VIDEO.

[@adilhumayun125]

Thanks very much sir for sharing this file... God bless you ❤

[@YeJoHeVo]

Good Luck I am very pleased to know this. Some are trying for a watchlist One from the south has done similar things in the chart by altering that added signal size, and color combining two average indicators... Surely it gives two signals on any length of chart.... We should not be 100% sure as it is MARKET Combining Bollinger Bands, Moving Avg. 9:30 am exercise is? ast by two consecutive days one day it ends high and the next day it deeps ... rather than dives. RSI can be given entry by adding some research ratios with percentages allowing 8 decimals either way .....We are not, but comp. is t"hat capable....

[@kumarhitesh9026]

Creat kr li sheet thx mne dekh dekh k...thanks from HITESH . CS ENGG.

[@SilentTrader24]

That's great 👍

[@sachinbhalerao871]

Hi

[@pravinnautiyal5235]

As per my experience, Since prices of stocks fluctuate a lot, the price line crosses the moving average lines frequently and we get a number of "false" buy n sell signals. Hence in order to get only a few but more dependable signals, I request you to please modify this table to include a column each for I) 10 days sma for the previous day, II) 10 days sma for the current day, and compare it with 20 days sma for current day, to get much fewer Buy n Sell signals. It would increase utility of your screener manyfold. Thanks.

[@kumarm6617]

Did you try?

[@subhashchalla4573]

SUPER AND EXCELLENT WORK, FOLLOWING YOU NOW

[@nikhilghonge7506]

Thank you , One of most useful & important video i seen, i have 2 Query's 1) Why there is no Buy signal in axis 2) can we plot EMA Also

[@SilentTrader24]

Google sheet not allow , EMA

[@SilentTrader24]

Axis price less than 20 DMA so not fulfill condition

[@nikhilghonge7506]

Thank you very much sir, must appreciate your efforts and contribution

[@kannanrajan5469]

YOU HAVE DONE A GOOD JOB. I WOULD LIKE TO KNOW, WHY YOU HAVE MADE 20 AND 50 CROSSOVER DETAILS. THE PURPOSE OF CROSSOVER SIGNAL (COLUMN "J") NOT EXPLAINED AND IT WAS NOT EFFECTED IN THE BUY OR SELL CONDITIONS, WHICH IS ALSO AN IMPORTANT. OTHERWISE ALL OTHER THINGS ARE ALL AMAZING. THANKS FOR SHARING THE KNOWLEDGE

[@EasyRecharge-mc8gk]

Excel se broker me order lagta hai kya automatic

[@rajuwagh31]

Very nice experience part 1 & part 2 video Thankyou sir

[@abdulmanaf4980]

Silent Trader - I made this excel sheet , it’s amazing we can consider for swing trading 😍

[@PlayfulTube-Entertainment]

I downloaded this file, this is not working it is showing different price

[@fazlufakih4211]

very well explained, can you show how to get weekly high stock list

[@azarsayyad8976]

Sir great work.thank you. Will this sheet work in love market?

[@SilentTrader24]

Yes and data update depends on website update

[@azarsayyad8976]

@@SilentTrader24 thank you so much for your reply. Have a nice day

[@seanvieira6231]

Hello Dear thanks for the great content can you please update the google sheets link

[@loganathansiva7063]

NAMASTE SIR. LEARNT NEW THING. DANYAVADH

[@zarifjohn839]

Lots of information contained in this video

[@vishalsinghal7234]

Can u make a video on supertrand calculation in xl or Google St.

[@mustafakamal5945]

I was looking for this for months, thanks so much for sharing this. Is it also possible to get the RSI value, Please advise ?

[@SilentTrader24]

Google finance not providing RSI value ... if I find alternate ...Will share with all

[@purnimabharambe3265]

Very nice video Can this strategy be included on 5min chart

[@elahi1055]

Can you please tell me how to link charts of stocks to tradingview directly

[@krkitskills]

very good , can we do the same for intra day time frames ?

[@Prithvi2506]

Hi, very nice educative session. Is it possible to include relative strength compared to nifty also in this (not rsi) . If possible can u pls make a video on this also

[@bhavneshparikh8283]

Can be available mutual funds scanner in excel?

[@mohammedrizwanshaikh4342]

Jitna bhi thanks kahu kum hai Sir.........Sir SWING TRADING ke liye NIFTY 500 or 100 or 50 with 44 high rising and above 200 EMA, High Volume, Breakouts Stocks ke saath banaoge to bahot acha hoga, its a request

[@pankajk6373]

Sir. I have made this sheet. It is very useful for swing trade. Also I want to make it more effective. Please give formula for ... If Sell sìgnal changed to Buy what will be the conditional formatting or Formula

[@SilentTrader24]

You can use if logic for any formula ... once you key in =if(

[@psrrams1]

RSI Crossing ka bhi ek video banadijiye sir.... Thank you.

[@shivkumarmp4800]

HOW CAN DO FOR 5MIN AND 15 MIN, WHAT WOULD BE THE CHANGES CAN BE MADE IN 50DAYS MA FOR INTRADAY PURPOSE. PLEASE

[@manojmendhe3093]

🙏🙏🙏Great sir g thanks so much sir g very nice g 💜💛💚💐🌷🌹

[@dr.kulwindersinghmann784]

Thanks for this video. I would like to know why the 20 Day's and 50 Day's Moving Average of some stocks shown are wrong. For example in the above video at 15:26 mins the ACC Stock 20 Days MA is 51 and 50 Days MA is 53. Similarly the error in the following STOCKS: ABB, ACC,BEL, HAL, INFY, TCS, etc.🔊

[@SilentTrader24]

Google finance count number of days include sat and sun that's why variance in data

[@jagdishgyanchandani1988]

Thanks for the nice learning video. Sir, how to retrieve Nifty 50 spot LTP in Google Finance

[@mgmoniofficial]

+2% and -2% ki change all stock kaysay safarate karu live

[@rajeshbhatia8246]

ITS REALLY SUPERB , SIR CAN WE ADD VWMA with this ,if yes can we add VWMA10 and 50

[@SilentTrader24]

Regret to inform that there is limitations in Google finance data so we can not add vwma

[@themazingworld]

Can you please share code for price to ATR trailing stop loss cross over

[@manojkvi9830]

Very nice sir hats off

[@rajusabhadinde3283]

Pls provide logic for weekly closings of last 5 continue weeks and there over-all positive performance increasing prices

[@ankitagarwal4901]

file is not available in your channle , please you please share it, i have triy to write but getting error

[@sttreetboy]

Fantastic!

[@MrPralhad1977]

Useful video. Thank you so much. I was looking for up and down arrow in google sheet. I didn't find anything even in the previous video. Can you please share how we can put up and down arrow.

[@SilentTrader24]

Part 2 video 13:40 it's html code which I use #9650 & #9660

[@atultanna]

Put the link to the video plz

[@SilentTrader24]

kzbin.info/www/bejne/mqHadHevird-e7c

[@Dahaad08]

How can we make a excel sheet with EMA as you said google sheet is not allowing us for EMA condition. If google is not allowing us so can we try on excel sheets. Can we make automated EMA excel sheet

[@Muralikrishnac]

very informative to automate

[@Devrat1]

Perfect Thanks a ton 👍

[@sureshbmadalgi61]

Sir, I need an Excel sheet that can extract data from NSE - Market data - Equity & SME Market - Others (Securities in F&O) CSV file. I need stocks that closed at exactly .00 in the Open, High, and Low columns.

[@SilentTrader24]

for your conditions , I suggest chartink website. you can get free data as you want

[@therocky2010]

Can we add what type of candle was formed last day on chart..like want to know whether indecision candle was formed or not

[@SilentTrader24]

You can use if formula to use logic with ... open, close , hig and low

[@azarsayyad8976]

Sir this sheet is working perfectly. But this sheet is calculating moving average of 1 day. Sir how to calculate moving average on different time fream,like 30 min 1 hous ,2 hour?

[@dhananjayarbat4470]

Sir, All Equity stocks me ( All Time High Stock price , Market cap & Stock Listing date ) ko kaise find kare

[@SilentTrader24]

tradingview me aap screener bana sakte ho ...52 week high + market cap

[@guillermobarragan7426]

Very good video!!! Do you have a download link?

[@SilentTrader24]

Unfortunately No , no link

[@sdmagickids8906]

Sir very useful information but vwap aad kar sakte hai kya isme

[@SilentTrader24]

Nai excel me vwap add nai ho raha

[@venkatswarna3800]

Very nice video. would you please share the google sheet

[@Shubhrishi33]

Sir moving average bala Google sheets Sahi se work nahi kar raha hai

[@abhinandanyadav144]

Thank You Nice Video

[@jackr6727]

It would have been good if u would have attached your excel sheet to this so that people can download and use it directly

[@girdharilal2199]

Sir ji data live automatic Chang hoga

[@RohithShashishekar]

unable to download the excel file. Any other way to download this file?

[@SilentTrader24]

t.me/DonloadExcelfile You can get excel file from here

[@A2Call]

Very useful 👍 thanks 🙏

[@RDG18S05]

Sir weekly time frame me 30 Ema ke up side Jane Wale stock show dikhaye Aisa formula bataiye sir pls

[@pullaraog]

Is EMA POSSIBLE

[@nitinlader]

Open=low ka sir Google sheet pe kaise banate hai .

[@SilentTrader24]

Do column me ... low and open price lena hai phir usko if formula se alag karna hai

[@rayrimultiservices3182]

DEAR SIR KINDLY PROVIDE READY GOOGLE EXCEL SHEET

[@manojverma-fv2gq]

Sir, EMA KAISE NIKALENGE, PLS BATAYE

[@nileshsingh7367]

i m not able find out moving average formula can u help me

[@SilentTrader24]

It's cover in part 1 & 2 ... did you watch both part ?

[@chickshupatel3936]

Thank you Sir👌

[@subhasishbhattacharya3754]

Sir bolinger band calculation possible in this sheet

[@SilentTrader24]

Difficult hai ...Will see in future

[@A2Call]

Ok dost very nice 👌 and how to make fundamental analysis for Google sheet

[@Sunil.Gidwani]

Bhai must ulitlity tracker banaya hai, best dashboard

[@Shaktikumarnayak]

Hey genius...can you please tell me how to get (1D,1W,1M,1Y,3Y,5Y, ALL) change with change percentage of any share in Google sheet.

[@SilentTrader24]

support.google.com/docs/answer/3093281?hl=en above link is for the formula and below link for dashboard for stock kzbin.info/www/bejne/e2WveYp4lKaFr9U

[@venkp4600]

Sir very useful information kindly share the google sheet

[@jitenderkumaryadav642]

good knowledge share

[@SilentTrader24]

Thanks for liking

[@Winterbear009]

sir am I making error? I am unable to fetch price details from google finance. Is there any change? I am using NSE for fetching details just like you.

[@SilentTrader24]

There is no chane bro

[@raimohanpradhan9315]

Great job

[@Chart_Informer]

AAPKA MA CURRTENT TRADING VIEW SE MATCH NAHI HUA MENE PURA FORMULA DAAL KE BANYA HAI BUT PRICE MAI BAHOT DIFFRENCE H

[@SilentTrader24]

because google count number of days include holidays and tradingview count working days

[@sanjibc2652]

i want previous days high or previous days low

[@Legendarypost143-si6yv]

Sir its humble request kindly make google sheet for index weightage sensex, midcap selecte and nifty and nigty bank and fin nifty

[@SilentTrader24]

Index weightage?

[@navneetbahety973]

can you pls share the google sheet

[@BharatPress-qu6wp]

sir buying and seling number show hona is sheet please add kardo

[@SubscriptionYouTube-zl5lm]

Time frame kaunsa aata isme

[@SURESHPATEL-pn6og]

Daily Rsi value ko add Karo sir

[@mmsmg8815]

SIR, WHICH IS GOLDEN CROSS 50>200 OR 200>50

[@SilentTrader24]

Both

[@303100gautam]

Sirji File download nahi ho pahi he. Download keise kare ?

[@SilentTrader24]

t.me/DonloadExcelfile

[@sonjoy1964]

thanks

[@vaya99]

plz share google sheet link

[@dwaramaswani2608]

Thankyou sir

[@12345678pradeep]

Thank you

[@thameemyousuf8194]

Thanks👍

[@pateloffset5570]

Sir 20 day and 50 day MA kam nahi kar raha hai plz help

[@SilentTrader24]

kya error aa raha hai

[@kumarshantveerayya5114]

Thank YOU SIR, HOW TO GET PDH, PDL, PLO and PDO

[@SilentTrader24]

support.google.com/docs/answer/3093281?hl=en

[@isni2002]

Sir, is video ki link share kijiye

[@manoranjanmallick1216]

How calculate EMA20 and EMA50 values. Kindly give formula sir.

[@SilentTrader24]

Googlefinance count on days so you need to count with the number of days as 1 ema

[@manoranjanmallick1216]

@@SilentTrader24 sir kindly make a video

[@anujmauryan]

RSI indicator lagana ho to kaise hoga sir pls guide us

[@SilentTrader24]

Anujbhai, Google sheet me RSI nai aata ... Will update if there is anything change in future

[@vasugiramu4087]

IN THE FORMULA USED WHAT col2

[@SilentTrader24]

Col 2 data

[@Sobhanadri]

bro good work 20dma means 20 trading day average bro

[@SilentTrader24]

Yes ,Google finance count number of days instead of number of trading days

[@Sobhanadri]

@@SilentTrader24 it will serve as Moving Avarage purpose

[@Sobhanadri]

It will serve requirements

[@sena1asian]

Macd is possible in Google sheet

[@SilentTrader24]

No 🙏

[@jayparonawalla]

stock ka all time high ka koi formula he

[@SilentTrader24]

Stock ka high low pata karna hai ki ... stock kitna dur hai high se ?

[@MrDivyesh007]

After 1000 views you said you will share the Sheet free Could you upload the Sheet please

[@SilentTrader24]

link updated

[@girdharilal2199]

​@@SilentTrader24sir ye live kase chlega exil me

[@sallumiya933]

Dear sir apne isme moving average ka fORMULA---- dala h but merr excel me #value aaraha h likh kar 😩

[@sallumiya933]

Plz help me sir mai try karraha hun ye bannane ki!

[@SilentTrader24]

It's Google sheet not excel

[@SURESHPATEL-pn6og]

Date ka column dalo Sir kab

[@deepaa409]

Please add weekly 20moving average

[@sachinbhalerao871]

Sir down arrow ke liye kon sa code he

[@SilentTrader24]

Check description.... code bataya hai

[@sachinbhalerao871]

@@SilentTrader24 hi sir I checked there is no code for down arrow symbol in description please rpy with symbol code it would be great help from you

[@SilentTrader24]

Please check part 1 , I have given code for in video

[@pateljayesh3152]

SIR PLZ.KINDLY PROVIDE READY GOOGLE EXCEL SHEET

[@vasugiramu4087]

How to fetch data