How to Create a Stock Watchlist in Google Spreadsheet 

I learned about Google finance last year and made my watchlist. Very useful in my investing journey

I was looking for this simple and powerful tool. The search ends here. Thank you.

Real nice stuff...have been looking for something that could update itself automatically but still be in an excel format. Excellent!!

Brilliant! Thank you so much Vishal for this amazing knowledge.

Good video👌👍

Very Informative!!!

Thanks for good stuff and sie keep it continue.

Thank you Safai! Very good stuff! And the company you've entered into your list is good too ;) now I have them too! And lastly - I am working for Infosys BPM! ;) ha ha!

Excellent information. Thanks

Thank you for this wonderful video !

God Bless You,Vishal

Thanks Vishal, it was helpful

How do I get those formulas and headings into my spread sheet? You video is pretty good but you skipped over essential stuff to set this up. Thanks

thanks, i was in need of this simple and powerful tweak.

Enjoyed listening to your talk !

That's very useful and simple. I have been struggling since weeks with Excel to have it updated automatically.

THank you for this video. It was very helpful . I Cant wait to start my spreadsheet. Of course I wont move as fast as you!

Very useful. Thanks

This is a cool tool for keeping track of stocks. Highly informative and valuable. I fully agree with your last point that this is just a tool and one needs to do a small recheck on the fundamentals of the business before buying a stock. Thanks Vishal.

Can we use such spreadsheet to prepare a watch list for stock and nifty options? e.g. Nifty Marrch series 11700 CE?

Thanks a lot sir.

How do I find the stock codes for to, example all the S&P 500 companies?

How do I watch Crude Oil using Google Sheets? Does Google Sheets even handle commodities? Thanks,

This is what I was looking for.

If stock is splited or bonus share is given how the intrinsic value will be impacted ?How this sheet will take care of split or bonus share?

Hi, Can you also share how you have the columns inserted?

Sir can u tell me how toh add the special tags in spreadsheet

Safal, can you share all the formulas you used in this incredible worksheet please.

this is like a watchlists for a long term trader

can we link NSE codes also here ?

sir could you explain logical funtinos of 'google spreedsheet'' once in detial like how to cal buy price after 30%

👍 👍

Please help me how to add the special tags in the spreadsheet ?

Pls share the xle sheet link...or pls explain the how to use formula of earning yields

Sir how get Previous Day High Low price in Google sheets ?

Sir , how can we create a watchlist getting updated in real time during market hours ?

You can do same from MS EXCEL too under STOCK option

Market cap formula not clear so please reply me.

Can you please guide on how to calculate Intrinsic Value?

How to get code of different company ?

good stuff

Hi Vishal, Thanks a lot for sharing But could you please show us how to add Price tag in the spreadsheet

You can create a dynamic screenr at screener.in

There are plenty of apps which can do this , they're easy to use and on your phone 24/7 with more information .

margin of safety is 40% in the formula. but in the sheet you have written 30%.

You say in the title “how to create” yet you only show the end result

Bogus