Build a Stock Watchlist with Live Data in Google Sheets

About Video - Transform your stock tracking experience with this quick tutorial on creating a dynamic stock watchlist in Google Sheets. Learn how to efficiently organize key data, including Name, Open, High, Low, Prev. Close, LTP, and more, all in one accessible sheet.
What you can do in this sheet -
➟ How to structure your Google Sheet for optimal stock data tracking.
➟ Techniques for fetching real-time stock information using formulas.
➟ Tips for integrating additional metrics like 52 High, 52 Low, Market Cap, PE, and more.
➟ Ideas for visualizing trends with a 250-day chart.
👋 Google Finance - www.google.com...
👋 Additional resources -
Download the file from here - imojo.in/1L0Mqyo
Join us on Instagram - / excelforfreshers
Take control of your stock analysis with this comprehensive Google Sheets tutorial! Watch now and elevate your stock market tracking. Don't forget to subscribe for more investing insights!
#vinaysolanki #excelforfreshers Stock watchlist in Google Sheets Google Sheets tutorial stock market tracking investing tips financial data analysis #googlesheets

[@thuylamson-z7t]

I think investors should always put their cash to work, especially In 2024, we'll start to see more market diversification. I'm hoping to invest about $350k of my savings in stocks against next year. Hope to make millions in 2024

[@Daneilchirs]

Since risk is at an all-time high right now, perhaps you should be a little more patient and return when it has decreased. Alternatively, you can consult a trained financial expert for strategy.

[@mertie-l2f]

Yes true, I have been in touch with a brokerage Advisor. With an initial starting reserve of $80k, my advisor chooses the entry and exit commands for my portfolio, which has grown to approximately $550k.

[@mertie-l2f]

Angela Lynn Shilling is the licensed advisor I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.

[@monkeywr840]

Very nice video no music no nonsense talks only straight forward information. Thank You 👍🏼

[@dilipkumarbhatt8392]

jabarjast👌👌👌kya aapka samjane ka style he, I salute you sir.

[@Shirish2012]

Very simple and good teaching, Thanks Sir

[@DesiAnalyzer-fx6nx]

Isse pahle kisi ne bhi itna ache se nahi samjhaya....very food bro

[@RAJUJOSEPH-v2h]

VERY GOOD EXPLANATION.SO FAR I HAVE NOT HEARD SUCH AN EXPL;ANATION.

[@mohanmadayi1498]

VERYWELL EXPLAINED. FULL MARKS FOR THIS FANTASTIC VIDEO

[@suleman-jb3pw]

My first comment on my entire life i really impressed very useful and awesome video with great explanation

[@samratchaudhari496]

Mind blowing work, a big thumps up 👍👍👍👍

[@Hariram-ew2us]

From two days iam waiting for your Video Bro... from Mysuru ❤

[@irfanulhaque1047]

23:18 I am using Mac, F4 does not work in the same way as windows does. could you plz tel me what key should press as am alternative.

[@sachidanandsadhguru3703]

Sir, Thank you very much for making and uploading this video. Your above video is nice. But Can you teach us a way to get Dividend Yield as a Column in the Table you shown in the video?

[@ganeshshenoy1344]

Thanks!

[@sagir144]

Thank you sir file mujhe mil gaya mere email adress mein aaya hua tha..forgive me for my comments

[@ashishsahu1310]

Much needed information.

[@bimaleanekka733]

Sir Excel Sheet description may dal dijye na pls download karna hy

[@masroorkhan737]

Very simple and good explanation

[@rupaliponnalwar9454]

Aapka video bohot hi helpful hai

[@ramm3118]

5 Day % change and 30 Day % change value's are not accurate. Please check and help me.

[@Prof_Ganesh_R_Ringankar_Winner]

Very nice information.... Thank you very much Sir...🙏

[@rameshbabu3659]

I have tried to build the sheet but googlefinace function is not working O365.. any one help me how to enable this function

[@metwaretrading2424]

bhai data scraping par bhi ek vid daal do. fundamentals ki analysis ke liye. industry/sector ke saath. 🙏🙏🙏🙏

[@shinderaju123]

Very good sir

[@ArunKumar-vg5hp]

Superb... 👌👌 Thanks sir.👍👍

[@jaydeeppal1588]

mere liye google finance excel m kaam nhi kar raha hai

[@BillyBoyHero]

BRILLIANT

[@chrome-j]

after putting 5 day % formula why it's causing it to fetch data for multiple days 4 and 5 days value.

[@sathukurian9481]

Thank you very much Sir.

[@rupaliponnalwar9454]

Hello sir kya mai isme 1 day ka chart nahi banasakti hu -100 days ke sath 1 day ka chart alag se banane ki koshish kar rahi hu but ho nahi raha hai Pls reply

[@vickyshrivastava7177]

Very nice . 👌👌👌👌👌

[@ashwinthacker42]

Nifty 50 option chain ki google sheet banaie. Agar allready available haiy to plz. link share kijiye.

[@samratws]

i need a help.. looking for a function to fetch weekly rsi value of the stock in similar watchlist

[@DS-247]

Market cap calculation mein kuch gadbad hai. 94,237 Cr should be the right value, not 942 Cr. Rest everything is fine. Nice video.

[@pankajkundu1998]

Thank you so much

[@navaneetharajp156]

Thankyou Dear Friend.......🙂

[@umaranimallam6343]

Good work bro. Great efforts keep it up from australia.❤

[@sureshbmadalgi61]

Sir, I need an Google / 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.

[@bemodernsadhu]

sir payment issue ho raha he excel sheet buy karne me

[@anupamsadhukhan5620]

for infosys, googlefinance fetch infosys ADR data instead of INFY data from india. pls tell me way out to resolve...

[@Excel4Freshers]

Please check this video - kzbin.info/www/bejne/aYTFaWhqjNqglac

[@umabaidya9377]

Formula is not working in my sheet?

[@USKUMAVAT]

Great Brother Knowledgeable.

[@Nusratofficial226]

Maine Aaj hi Google sheet download ki hai yah edit nahin ho rahi main ismein stock add karna chahta hun

[@Excel4Freshers]

Sir please make a copy of the sheet then use it

[@BROitsYG]

Sir rs. Send kiye fir bhi sheet nahi mili Please help Name yash gupta

[@Mr.BuyTheDip]

Do you have an updates way to add "industry" on spreadsheets?

[@ghanshyamkhatri3257]

Superb.....

[@Sumit5volg]

This Can do on option chain data for compression oi & oi change with vwap & volume if yes reply it & make video on it

[@pranayjithaldar1465]

Last Day,week,month High -low kaise pata chalega?

[@veereshd301]

Super sir, useful information.

[@Excel4Freshers]

Keep watching

[@RunandReviewsofproduct]

Very nice excelkent🎉

[@kapilahirwal1919]

sir i went to the link to download the sheet and the payment option was available i have also made the payment but the sheet has not been downloaded please tell me how the sheet will be downloaded

[@Excel4Freshers]

Please check your mail.

[@sidrathulmuntaha]

its not working where share is listed in BSE only

[@Excel4Freshers]

Please watch this video - kzbin.info/www/bejne/aYTFaWhqjNqglac

[@sidrathulmuntaha]

@@Excel4Freshers Still not working for some stocks, please make a video for these stocks. Taparia Tools Ltd. RAJVI LOGITRADE LIMITED EMKAYTOOLS GLOBAL SHRITECH PROLIFE MICROPRO TIMESCAN AMIABLE LOGISTIC

[@nileshbhalodiya5017]

How to sort from high to low percentage?

[@nitinsingh.2107]

Great...How to use Sparkline chartype for BSE listed stocks??

[@Excel4Freshers]

We have an entry name like - BSE:Stock name E.g BSE:RELIANCE

[@ravimehta8669]

Awesome guidance 😊😊😊😊

[@Excel4Freshers]

Thanks 😊

[@pravinsharma765]

Isme mein ek column industry aur dursa sector k liye add kar sakte hai kya?? Please guide.

[@Excel4Freshers]

No sir we cannot auto populate industry and sector. If we add this we have to write it manually for all stocks.

[@hamee152]

Hy I paid for the excel, But I have not received

[@Excel4Freshers]

Hello sir, Have you received the file? Please confirm.

[@anilraivlogs3894]

Highly appreciate sir. I really like your video sir. Sir in this google sheet how we can put sector PE please. Thank you

[@Excel4Freshers]

Yes sir, we can add PE and EPS. Formula - PE - =GOOGLEFINANCE(STOCK NAME,"PE") EPS - =GOOGLEFINANCE(STOCK NAME,"EPS")

[@philosopher703]

sir could you tell me agar mujhe kisi particular date ka price chahiye let suppose 5 march 2023 toh wo mai kaise launga

[@Excel4Freshers]

kzbin.info/www/bejne/b16vn2Oop62lgqs

[@DrKallalPramanik]

The sheet is not fetching BSE listed stocks. For example, Polyplex Polymer and Tilak Venture

[@vishwajitmore3318]

BOM: stock BSE code

[@satishbharti2978]

thanks

[@spv1444]

Can we get 5 min candle change value and its %age?

[@shyam281988]

Thanks, very nice

[@sasodekar]

Boss, if people have say 40 stocks already, then what is best and quick way to make such sheet using portfolio data?

[@Excel4Freshers]

Sir, we have to create just the first row after that we can copy from the first row and paste formulas in other rows. Data will fetch according to the stock name. But we have to enter all stock names separately.

[@sasodekar]

@@Excel4Freshers Sir I think you did not get my point here. First row is OK which is configuration. Important is data pulling. Basic issue is about columns here. Hence again as said, if one have 50 stks, then can he simply copy paste names from his downloaded portfolio from HDFC, ICICI etc to first column? Later the first row has to work for all below rows- that is understood.. and another thing is lots of you tubers have provided such excel sheets here I found its not free. So again,, its on people how to make use it. My comment is for your deep understanding of retail person problems as they always have many stks.

[@user-ks7df2hv9r]

Market cap conversion to Crores Code #,##0,,, "Cr" , seems wrong. Values are coming in wrong. check and provide the correct conversion code to CR

[@Sanctimonious007]

Chartink me karo ye sab bekaar hai.

[@ankurjajodia3018]

Can i do it in normal excel or mandatory to do in google sheet

[@Excel4Freshers]

No sir, normal excel didn't fetch the stock price.

[@HaidarAliiii]

How to edit this file because this file have view only, i have to send request for read but still not accepted if some how accept then i remove my comment

[@Excel4Freshers]

please make a copy of the sheet.

[@manojheartthrob]

Great. Can i create this similar chart for MFs? I need this for Lump Sum investment in the MFs.

[@Excel4Freshers]

Hello sir, In a mutual fund, we can only track - Prev. close price LTP Change and last % of change we can also create charts like those mentioned in this video. According to me, this is enough to track to mutual fund.

[@SachG1980]

Very good . How to make it live or auto refresh ?

[@Excel4Freshers]

This sheet is working on live data and it's automatically refresh all the data.

[@GamingGhostRider2020]

Stock Name enter karne par ADR le raha hai ..... Jaise Infosys Ltd ke liye.... INFY type kar rahe hai to... INFY ADR ki value(Price) dikha raha hai.... Indian exchanges ki show karane k liye kya karna hai...

[@Excel4Freshers]

Please watch this video - kzbin.info/www/bejne/aYTFaWhqjNqglac

[@anil2903]

i payment for the excel at Jun 30, 2024 at 11:49pm amount dedected from my account of 25.9 but didnt received any excel

[@Excel4Freshers]

Please check your mail sir.

[@tayyabshaikh1401]

hi i have paid to buy this google sheet but again it is asking to buy.. what are the steps.

[@Excel4Freshers]

No please don't buy it again you will check and you will get it within 24hrs.

[@ankitsoni8498]

Sir aapne ye jo excel banai hai please mail kar dijiye

[@Palaniraj1963]

is there any template Excell sheet with pre-typed google finance formulae.

[@Excel4Freshers]

Sir this same sheet is available. Not a complete Google finance formula

[@rpmeenapdz]

Good, Thanks

[@growwstock3290]

Sir ji new stock ko kaisa add kare

[@malkeetsingh3438]

Ath ka formula nhi mil rha

[@chrome-j]

Why my LTP is not changing with Realtime

[@Excel4Freshers]

Sir it sometimes may not change in real time. It fetches data then updates it.

[@chrome-j]

@@Excel4Freshers thank you

[@gouravaramrupesh3029]

I am unable to download the excel sheet after payment.

[@Excel4Freshers]

Please check your mail.

[@MANOJPALIYA]

thanks sir jii

[@shikhartaneja4638]

Hi cn u provide google sheet for live data of bybit

[@Excel4Freshers]

Live data cannot be fetched on Google sheets, it will get some time to fetch and update the price.

[@Sharemarket_gyaan]

Google sheet download nhi hui payment ker di

[@Excel4Freshers]

Please check your mail.

[@bhagwandhobale2415]

Delevery % le skte hi kya

[@christophercutinha3640]

What is the formula for delivery volume sir?

[@navaneetharajp156]

I can't able to download the excel sheet after did my payment

[@Excel4Freshers]

Please check your mail sir

[@navaneetharajp156]

@@Excel4Freshers No sir i did not receive MAIL.... with your guidance i create my own but the stock name / prices is not perfect in google finance (Eg); ACE, ABBOTINDIA, ABB PLS DO CHECK AND REPLY ME SIR, THANKYOU.

[@navaneetharajp156]

@@Excel4Freshers I Did not receive mail...... as per your guidance i have created my own but the Stock name / price is very difference in google finance eg.; ABB, ABBOTINDIA, ACE etc..... Pls check & reply me sir, Thankyou.

[@manuvoyager]

Can you make one sheet for me different than this ? I'll pay the fees

[@ravimehta8669]

Wow.....❤❤❤❤

[@soumyadeep100]

I am Soumyadeep Ray. I pay you. But till now didnt get the file.

[@Excel4Freshers]

Sir please check your mail. If not could you please share your details at Instagram - excelforfreshers

[@annigeridarshan4856]

Does it indicates 20DMA ?

[@Excel4Freshers]

Will make a complete video on the same soon!!

[@loyalfinancialadviser]

I have paid but not received google sheet?

[@Excel4Freshers]

Please share your details so I will check and update you.

[@santoshkumar-hn4ki]

Mai ye formula se kam kiya pr error aata hai

[@rudrapratapmohanty9766]

Same here

[@Excel4Freshers]

Kaisa error aa raha hai?

[@sasinageswaran]

How to get yesterday stock open,high,low in google sheets

[@Excel4Freshers]

Hello sir you would check this video - kzbin.info/www/bejne/b16vn2Oop62lgqs

[@saraladda1983]

Market cap and Pe pull नहीं हो रहा मैं etf के लिए try कर रहा हूँ

[@Excel4Freshers]

प्लीज आप इस वीडियो को देखिये इसमें बताया गया है कि स्टॉक को कैसे ऐड करना है वीडियो - kzbin.info/www/bejne/aYTFaWhqjNqglac

[@murugan1473]

i jus paid to download template, but i cant download, can some one help

[@Excel4Freshers]

Please check your mail.

[@TusharGadhia-ye5gu]

i have paid for sheet, how do download the sheet

[@Excel4Freshers]

Please check your mail.

[@manishmahato2001]

Is this update everyday all by itself?

[@Excel4Freshers]

Yes

[@saurabhvishwakarma5591]

Sir Index bhi update kar sake he kya

[@Excel4Freshers]

If you want to add Nifty50 then add Nifty_50, for SENSEX type SENSEX

[@raghuk3141]

HOW TO GET BANK NIFTY FUTURE OR NIFTY FUTURE PRICE ON GOOGLE SHEET

[@Excel4Freshers]

For option this feature is not working in Google Sheets.

[@abdulrasheedameer531]

Paid not get sheet sir

[@Excel4Freshers]

Please check your mail sir

[@rohitaggarwal4411]

From where u download Google sheet ???

[@myna4616]

Playstore

[@sagir144]

Bhai mere paise vi kat gai sheet bay nhi hua

[@Excel4Freshers]

Hello sir, apke mail par receive hua hoga file please ek baar aap apni mail par check kare.

[@CHANDRAPHOTOSTUDIO]

good