HOW TO SCREEN ATTRACTIVE BLUE CHIP STOCKS USING GOOGLE SHEETS? | TAMIL |

STOXKART FREE DEMAT ACCOUNT OPENING (PROMOCODE "SPLFREE")
🌼ekyc.stoxkart....
**********************************************************
JOIN OUR CHANNEL MEMBERSHIPS
🎁 / @kplcenter
************************************************************
DEMAT ACCOUNT OPENING - USE OUR CHANNEL REFERRAL LINK FOR AVAILING EXCLUSIVE BENEFITS
✔️ZERODHA (FREE REWARD POINTS OF RS300):zerodha.com/op...
✔️UPSTOX (FREE ZERO BALANCE INDUSIND BANK A/C OPENING & UPTO RS.5LACS MARGIN TRADING FACILITY FOR POSITIONAL TRADING):upstox.com/open...
✔️ALICEBLUE(HIGH LEVERAGE FOR INTRADAY TRADING):app.aliceblueo...
************************************************************
MUTUAL FUNDS INVESTMENTS - JUST CLICK THE LINK & INVEST INSTANTLY BY SELECTING TOP MUTUAL FUNDS.
💰www.assetplus....
***********************************************************
MEMBERS ONLY VIDEOS
💖 • MEMBERS ONLY VIDEOS
***********************************************************
SHARE, SUPPORT AND SUBSCRIBE!!!
Telegram - t.me/kplcenter
Facebook - / kplcenter
Twitter - / kplcenterpage
Gmail- [e-mail]
************************************************************
KPL CENTER Official Playlist
🔥Full List of Videos : / kplcenter
************************************************************
About : KPL Center is a youtube education channel where you will find videos related to learning of investments (Equity Shares, Mutual funds, ETFs, Cryptocurrencies and Personal finance) in Tamil.
Happy Learning and Happy Investing:)
Regards
GK
#KplCenter
#StocksScreener
#GoogleSheets
#GoogleFinance
#StockMarketBeginnersTamil
#ShareMarketBeginnersTamil
#GettingRich
#PersonalFinance
#KplMoney
#MutualFundInvestment
#Zerodha
#TradingTamil
#InvestmentBeginnersTami

[@KPLCenter]

STOXKART FREE DEMAT ACCOUNT OPENING (PROMOCODE "AOCFREE") 🌼ekyc.stoxkart.com:10124/Home/Index?refcode=BDSTX0348 ********************************************************** JOIN OUR CHANNEL MEMBERSHIPS 🎁kzbin.info/door/BusxiOQblobA139wqNY4Ngjoin ************************************************************ DEMAT ACCOUNT OPENING - USE OUR CHANNEL REFERRAL LINK FOR AVAILING EXCLUSIVE BENEFITS ✔️ZERODHA:zerodha.com/open-account?c=ZMPLIX ✔️UPSTOX:upstox.com/open-account/?f=48B4 ✔️ALICEBLUE:app.aliceblueonline.com/openAccount.aspx?C=SSP02 ************************************************************ MUTUAL FUNDS INVESTMENTS - JUST CLICK THE LINK & INVEST INSTANTLY BY SELECTING TOP MUTUAL FUNDS. 💰www.assetplus.in/ifa/KPLMONEY ***********************************************************

[@sudhakarkannan5277]

Hi bro why IRCTC share price is increasing when lock down is happening... How come it will give profit when no train is running ?

[@KPLCenter]

Irrespective of current situation and revenues, people would like to own it for long-term due to its monopoly biz. Something like doing higher education by spending hefty amount with the forecast that definitely I will get the job and recover the invested amount...

[@rameshganesan2409]

Hi Mr.Gk Anna.... I am beginner for share market.i continuous watched your videos....very useful....and also I make google sheet with ref.thank u very much. Thanks for your unlimited and continues support....

[@KPLCenter]

Happy learning brother😊🤝👏👍

[@samsundar874]

Thank you sir,I don't know about stock market but now i know 20% learnings with your videos, now i confident will improve stock market knowledge with your valuable videos and also get excel knowledge. Thank you for ur valuable time to post this videos.

[@KPLCenter]

Excellent

[@krishnakumar-gd5tu]

Realy amazing teaching. Hats off 💐. Today i learned a good thing from you sir 👍

[@greatwinsanthiya9107]

Good explanation bro.. Very useful information.Thanks for your selfless knowledge sharing.

[@KPLCenter]

It's my pleasure

[@gobinathsubramaniam6541]

Brother, well explained, you voice seems from teaching profession back ground and slides are good. Superb presentation👌👍

[@KPLCenter]

Thank you so much 🙂

[@sri6863]

I have seen many channels who is explaining about trading and investing but everyone have some hidden benefit. But you are the one I have seen doing this as a educational purpose to the people. Really all the videos are awesome and informative. Especially if you learn something from Tamil we can learn easily. Thanks a lot for the help. Please keep doing the great work.

[@KPLCenter]

Thanks Sri for your kind words and happy to be part of your learning journey😍🤝👍

[@vellingiris766]

I really indebted to appreciate your incredible effort...Your each vedios deserve a worth of 50000 course/ class in outside market

[@KPLCenter]

Thanks Buddy, enjoy👍👍😍 once again reiterates that " A candle losses nothing by lighting up an another candle"

[@victors4524]

Very nice way of screening, bro ... thx a lot ... good learning for me / all viewers ... much appreciated... keep rocking 👏🏻👍

[@KPLCenter]

Welcome:-)

[@riyazjbabu]

Thank you anna, daily im learning new things from you nd developing myself... on Thursday i have applied for demat account for investment... god bless u anna. Anna

[@KPLCenter]

All the best

[@rajan.n5435]

Same we can use investing.com stock screener very easy to filter

[@velmurugan443]

Very informative. Learnt a new thing today. Thanks for educating and sharing information....Channel in tamil is very useful for our people to learn and invest/earn in share market

[@KPLCenter]

Thanks and welcome

[@arjunansericulture1532]

சார் உங்கள் காணொளி மிகவும் பயனுள்ளதாக உள்ளது மேலும் எனது personal finance அறிவினை மேம்படுத்த உங்கள் சேவை உதவிகரம் ஆகவும் உங்கள் கருத்துக்கள் மிகவும் அருமையாக உள்ளது மேலும் மேலும் இது போன்ற கருத்துக்கள் பதிவேற்றம் செய்யுமாறு விரும்பி கேட்டுக்கொள்கிறேன்..மேலும் எனது நண்பர்களும் உங்கள் காணொளி கலை கண்டு தங்கள் personal finance அறிவினை மேம்படுத்தும் பயன்படுத்துமாறு கேட்டுக் கொண்டுள்ளேன்....🙏🙏🙏🙏👌👌👌

[@mohanhasini]

Bro excellent video I saw, u explained me very well and clearly, definitely I will try this for valuations. Please do your excellence forever.... We will always support you....👍

[@KPLCenter]

Happy learning:-)

[@lingakumar1635]

Excellent . useful info. I feel educated after watch this video.

[@KPLCenter]

Glad to hear that

[@senthilkumar-nc8uv]

Very usefull channel for this 21 days & for beginners.

[@KPLCenter]

Glad to hear that

[@aravinthkumar9707]

BEST INFORMATIVE CHANEL

[@KPLCenter]

Thanks Aravinth:-)

[@sureshchander481]

Dear GK, Excellent Presentation. Thanks and keep up your good service. How can I get the Google finance sheets already given by you or by subscribers. I joined in Telegram only on 12th April 2020. Can you guide me. Suresh

[@KPLCenter]

Click the channel icon and access it from files

[@muhamedhashick1293]

Assalamu alaikum!! Nice sir. Good knowledge based work. Thanks a lot.

[@KPLCenter]

Thank you so much Mohammed for continuous support and encouragement. You are one of my true subscriber😍🙏

[@tonya7322]

Good job Bro. The way you explain seems to be like a matured professor in college. Hope you have some teaching background 😎😍

[@KPLCenter]

Thanks a ton

[@2524csv]

EXCELLENT PRESENTATION. BEST WISHES, SIR.

[@KPLCenter]

Many many thanks

[@sundarkumarsundarsun]

Nicely explained ..👍👍

[@KPLCenter]

Glad you liked it

[@senthilkumar-nc8uv]

மிக்க நன்றி உறவே.........

[@KPLCenter]

Yes you are right, all KPL center subscribers are our relatives only😍👍

[@intradaywinningdeals8332]

valuable info

[@vairaprakasha4466]

குருவே 🙏🙏

[@jawaharp6718]

Thanks for your ideas

[@KPLCenter]

Glad you like them!

[@arulabi8639]

Thank you professor ji ❤🌹❤

[@KPLCenter]

Always welcome

[@sanjeevmail]

Great video hard work Never fails

[@KPLCenter]

You got that right!

[@mohanhasini]

👍 super Bro thanks 4 this video, Bro pls put videos for mid cap mutual fund

[@KPLCenter]

Ok coming soon

[@karthikpintu5479]

Sir the investment strategies are good but when can we know the right time to exit

[@KPLCenter]

Soon we will see that video...

[@paranthamansomasundaram9566]

Fantastic Bro...you are a gem...

[@KPLCenter]

Thank you so much 😀

[@johngopi222]

Good sir

[@KPLCenter]

Keep watching

[@maveric7742]

Very informative Sir, which formula I can use to get Book value from Google finance. Thank you

[@KPLCenter]

Not available

[@KRISHNAKUMAR-sh1hy]

Hi sir, Investing 50k in Equtity in current down market or starting SIP approach or Doing both, which is a good approach sir? Kindly suggest me... Also Thanks for your Detailed and clear explanation. I am spending my quarantine with your valuable videos.😊

[@KPLCenter]

SIP one is always best

[@sandeeprajan7921]

Nice video sir. I made a sheet based on earlier video. I have a question. Is there any min days for getting dividends before Ex div date. I had bought coal 1 qty on 18th March and 5 qty on 23rd March. But I got dividend of RS 12 for 1 stock only. Can you please clarify

[@KPLCenter]

For more details on dividend kzbin.info/www/bejne/r2axloydq5qcldU

[@ukiruba]

Sir, Should we follow the same ratios for BSE also.. Please revert

[@sundarraj4419]

wonderful video

[@KPLCenter]

Thanks for the visit

[@nrrajan6802]

Super bro

[@sureshganesan5292]

Sir, Sir, Screener la nifty yoda value varavaika mudiyuma sir. Stock ellame neenga solikodutha mari potuten data vanthuruchu google spread sheetla. But indexoda value varamatenguthu. Athu epdi sir vara vaikurathu

[@saravanansaravanan-vi2ei]

Nice information bro

[@KPLCenter]

Thanks

[@Ramesh_Kumar1987]

Good information broo....

[@KPLCenter]

Thank you so much 🙂

[@vairaprakasha4466]

👏👏👏

[@ArtofHacksCentral]

Informative!!

[@KPLCenter]

Glad you liked it

[@thyagu30585]

Sir, Even if we add NSE: for few stocks, Data are not reflecting, kindly advise. Eg. Birla tyres, Larsen Toubro Ltd etc

[@KPLCenter]

Yes, I heard this from others too. Will let you know once I found solution for the same. Until then you can compare it with other sites. Thanks for your patience!

[@thyagu30585]

@@KPLCenter Thank you !!

[@manochoco23]

Sir if i have to choose between high price stock with good dividend and undervalued stock with little to no dividend. which one should i prefer or rendume portfolio la irukama sir?

[@KPLCenter]

Have answered your query in the upcoming Q&A session video, kindly watch!

[@manochoco23]

KPL Center Thanks a lot 💐🙏🏽🙏🏽

[@kaushalram5241]

Bro Thanks a ton for sharing such a valuable information for free. Also can you please tell how much reliable is Zerodha for long term investment, coz in the past we have had some bitter experience with Karvy. Please share the best Demat account firms? Kotak or HDFC? Thank you.

[@KPLCenter]

Enjoy😍

[@kaushalram5241]

@@KPLCenter Bro Can you please clear the doubts on Demat account for long term investment? Thank you

[@KPLCenter]

Please let know your queries

[@kaushalram5241]

@@KPLCenter Can you please tell how much reliable is Zerodha for long term investment, coz in the past we have had some bitter experience with Karvy. Please share the best Demat account for eg like Kotak or HDFC?

[@KPLCenter]

Who is your stock broker : kzbin.info/www/bejne/gpWWgaywebmWnck

[@mech877]

SIR THANKS FOR THE VERY GOOD CONTENT I HAVE ONE DOUBT I HAVE MADE THIS WATCHLIST BUT AFTER FEW MONTHS IF SOME STOCKS PE VALUE COMES WITHIN THE RANGE OF 0-16 WILL IT BE AUTOMATICALLY UPDATED IN THIS SHEET?

[@KPLCenter]

Yes Google sheet is real time one

[@mech877]

Sir if a stock is already undervalued there is a possibility of it dropping down further down than the calculated margin how to deal with it

[@techemaster6459]

pls share the google sheet link for which you prepared 500 stocks

[@KPLCenter]

Pl download it from our t.me/kplcenter

[@Jayaprakash-zz4pm]

🙏🙏🙏👌

[@pandieswaran8464]

Bro when you will update best muticap fund waiting for video bro

[@KPLCenter]

Soon🤩

[@pandieswaran8464]

@@KPLCenter thanks for reply. This one week full I watched your stock market related videos all most I covered all videos. Such amazing videos bro. Crystal clear explanation plz continou as brother my request bro. Have gud nyte

[@KPLCenter]

Say thanks for the lockdown🤩👍

[@gurumoorthy.g7318]

Please make the videos for 10minute duration.

[@KPLCenter]

Thanks for your care and suggestion. If I short the videos, obviously I will get more view and subscribers but that is not my intention. I follow the phrase of Slow and steady, wins the race. In my opinion, educational videos should be given like full meals. At the end, people have to get satisfaction that I learnt something in full about that topic i.e end to end. That's what I required from all of you more than being successful commercially

[@sethnasethna]

As per Google finance in Google sheet, why icici bank market cap is showing low?

[@KPLCenter]

How much crore showing?

[@sethnasethna]

4679 crores. But money control is showing 1,85,444 crores. Also few others stocks showing low mcap.

[@KPLCenter]

That needs to be verified: To avoid this error, add NSE Infront of this stock. ICICI is ADR stock traded in US too

[@sethnasethna]

Thanks for reply. Kindly check with that and update. Infy, wipro, icici bank are showing low mcap.

[@KPLCenter]

That is due to Google considering the above scripts from US which might be in dollar. Better cross verify with other websites. This work is just for reducing one of our step in stocks filteration

[@cyberorcas]

Bro ithey mathri CAR, ROE, NPA, DE and other parameters google finance use panni find panna mudiyuma ?...

[@KPLCenter]

Good question my dear friend😊. But I tried, not available. If you find, please let me know. By the way, your good name please...

[@cyberorcas]

@@KPLCenter Rahul bro

[@cyberorcas]

@@KPLCenter Nanum search pannen bro , fundamental analysis oda Attributes kidaikala.. athu kidacha konjam try panni palakam..

[@KPLCenter]

You are one of my true subscriber. Let's keep connected🤩💐🤝

[@cyberorcas]

@@KPLCenter bro fundamental analysis ku thevaiyana ella parameter namale filter pandrathu epadi nu pathen bro. Screener website la poyetu namku thevaiyana fundamental parameters ra query ya run pannalam bro , its working.

[@tamilraj3285]

Investing.com screenar video pannunga

[@KPLCenter]

Sure, will upload soon

[@vigneshwaransubramanian9480]

Hello sir what is NPA sale

[@KPLCenter]

Non performing asset

[@vigneshwaransubramanian9480]

@@KPLCenter sir I meant by some times banks disclose the Non - performing asset sale. How could bank can acution their NPA

[@KPLCenter]

That is something like you pledged your jewel in the bank, if you are not releasing it on time and interest not paid which will go for auction. Bank is having all the rights to do it as per our initial agreement

[@vigneshwaransubramanian9480]

@@KPLCenter great thank you sir

[@ebanj9876]

how to do in MF ?

[@sankaa77]

Super bro