How to do Stock Analysis | A step-by-step process using screener.in

Here is an ultimate TechnoFunda Excel Screener (worth ₹4,999) GIFT for 2023 to understand how to do stock analysis with a step-by-step process using screener.in excel template: technofunda.co/excel
This is a powerful session on understanding fundamental analysis of Indian Stocks using Screener.in Excel template with a detailed demo tutorial.
FREE Investing Workshop GIFT 🎁 (worth INR 999): technofunda.co/webinar
GIFT: technofunda.co/posters
VIP FB Group: technofunda.co/facebook
In this video, Vivek Mashrani explains various strategies to perform fundamental analysis of Indian stocks using excel screener template. This is ultimate session to understand various aspects on analysis of Income statement, Balance Sheet, Cashflow statement as well as performing Ratio Analysis.
00:00 - Overview and excel screener template overview
00:57 - Navigation and Uploading Screener.in Excel Template
06:51 - Details of different tabs inside stock screener excel
10:46 - Understanding and stock analysis for income statement
17:01 - Understanding income statement financial ratios
27:16 - Understanding balance sheet and it's ratios
42:20 - Cashflow statement analysis of company
48:08 - Dupont analysis - three stage and five stage model
54:36 - Q&A and closing comments about excel screener.in template
If you love reading TechnoFunda Investing books, you can explore below video:
Top 10 Investing Books: • 10 Best books for stoc...
TechnoFunda Investing Books on Amazon: technofunda.co/books
This video will be very useful if you are searching for below:
- best stock screener setup
- how to screen for growth stocks
- high growth stock screener
- screener.in multibagger
- best stock screener formulas
- value investing screener criteria
- best stock screens
- Basics of Fundamental Analysis of Stocks for beginners
- How to find fundamentally strong stocks
- How to find great companies using screener.in
- How to fetch financial data of stock in excel from the screener.in
- Free screener for fundamental analysis
- How to choose the right stocks for investments
- how to use screener.in
- Screener.in tutorial
- Detailed tutorial for using screener.in
- How to screen stocks using screener.in
Read full disclaimer and privacy policy below:
vivekmashrani.com/disclaimer-...
Investments in securities are subject to market risks. Read all the related documents carefully before investing. The securities quoted are for illustration only and are not recommendatory. Please consult your financial advisor before making any investing or trading decisions.
#TechnoFunda #VivekMashrani #Screener

[@mashranivivek]

Here is an ultimate TechnoFunda Excel Screener (worth ₹4,999) GIFT for 2023 🎁: technofunda.co/excel FREE Investing Workshop GIFT 🎁 (worth INR 999): technofunda.co/webinar

[@ubaidiqbal8674]

Hello sir. I want to be part of ur silver membership lifetime programme. How to contact.

[@mashranivivek]

@@ubaidiqbal8674 Here you go: technofundainvesting.com/sales-page

[@coderonthewheels]

Sir, what is the difference between silver membership and lifetime membership? I would like to opt in but not sure which one to choose.

[@ubaidiqbal8674]

Sir I have downloaded ur Excel template but it is showing version 2 and not 3. And also in income statement sheet there is no sales growth yoy, ebitda growth and pay growth.

[@coderonthewheels]

Sir, what is the difference between silver membership and lifetime membership? I would like to opt in but not sure which one to choose.

[@MrVeer58]

Many thanks for explaining many of the things in a lucid way.

[@harpalsinghgill1029]

Excellent learning. I am a silver member

[@RBG9000]

this lecture and excel template provided is worth gold! i edited the existing template to add a lot more charts since i like looking at charts than read numbers, makes my past performance analysis a matter of 10-15 minutes so I can now focus on future growth drivers and risks of the business from the setup of past performance, instead of mindlessly reading about past performance. God bless you and your family Sir!

[@praveenchandrashekar9508]

CAN YOU SHARE THE EXCEL WITH US ALSO SO WE CAN ALSO GET BENIFITED

[@unnikrishnanv6259]

Ready

[@jawedakhtar36]

Thank you sir

[@maheshkarambelkar6230]

Thank you so much sir

[@rakeshvyas3864]

Thank Sir

[@pandurangnayak2140]

Thanku very much sir

[@adagoudamakannawar4933]

Great session thank you so much sir.

[@user-gg8dz6mg8t]

super clear

[@boneson13]

Powerful indeed!

[@vikasg2184]

Excellent Session

[@adagoudamakannawar4933]

Powerful

[@bmuniverse4012]

Thanks sir

[@latestnews25]

Good Effort keep it up please

[@ammupachayil7723]

That was excellent Session. Thank you so much for your Love, Simplicity and Sincerity. I would love to share my holdings and take appropriate advice.

[@shakuntalamangal3]

powerful

[@shakuntalamangal3]

ready

[@user-gg8dz6mg8t]

cleary

[@arvindmanglik9896]

the companies performace over the time in terms of sales ,profitability,margins, power to decide product price

[@dineshkr175]

Great stuff

[@mashranivivek]

Thanks Dinesh

[@explorerbasuofficial]

loved the session. thanks a lot for helping us with our valuable advice. looking forward for more of this. god bless you.

[@mashranivivek]

Our pleasure!

[@pritesh3752]

You should have added dcf method it this sheet if it was possible

[@user-gg8dz6mg8t]

healthiness of company

[@kds796]

Sir Happy Vijaydashmi To you,,, Just seen your vedio on "Stock fanancial manupulation",, So looking CFO/PAt for Avantel Stock.. what it interprits,, STock price is high and higher but this ratio is in negative since last 4 quarter

[@user-qh8xo8wl6w]

pl support i chek nestlay data show up to dec21

[@user-gg8dz6mg8t]

cc

[@bmuniverse4012]

Sir I am not getting the excel, how can I get it pls tell me

[@shakuntalamangal3]

How strong is company

[@mithileshkumarshah2231]

Hi

[@kedarnathhota471]

sale is going up or down

[@sanjooghosh8442]

not finding share holding pattern page ? is it there?

[@mashranivivek]

Not there

[@rakeshvyas3864]

Not Done

[@rakeshvyas3864]

I appreciate your objective for investors & traders to protect & multiply their wealth Kudos to you ✌

[@bmuniverse4012]

Sir hame excel nehi mila

[@mashranivivek]

Technofunda.co/excel

[@rameshbapat7510]

balbond

[@jitendrabhadur8186]

Ready.

[@jitendrabhadur8186]

Ready

[@anandipoojary5203]

Ready

[@arvindmanglik9896]

cc

[@varghesethomas1845]

Ready

[@varghesethomas1845]

Ready

[@arwindmodi9985]

Ready

[@mashranivivek]

Great

[@rakeshvyas3864]

Ready

[@mashranivivek]

Awesome

[@adagoudamakannawar4933]

Ready

[@mashranivivek]

👍

[@shyambagrodia6257]

cc

[@rameshbapat7510]

cc