Build a Stock Watchlist with Live Data in Google Sheets
HTML-код
- Опубликовано: 22 ноя 2023
- 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/finance/?hl=en
👋 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
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
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.
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.
I’ve been looking to switch to an advisor for a while now. Any help pointing me to who your advisor is?
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.
I searched for her full name online, found her page, and sent an email to schedule a meeting. Hopefully, she responds soon. Thank you
Very nice video no music no nonsense talks only straight forward information. Thank You 👍🏼
jabarjast👌👌👌kya aapka samjane ka style he, I salute you sir.
Thanks, very nice
Very simple and good teaching, Thanks Sir
Great Brother Knowledgeable.
From two days iam waiting for your Video Bro... from Mysuru ❤
Good, Thanks
Very simple and good explanation
Thank you very much Sir.
My first comment on my entire life i really impressed very useful and awesome video with great explanation
Very nice information.... Thank you very much Sir...🙏
Do you have an updates way to add "industry" on spreadsheets?
Super sir, useful information.
Keep watching
Very nice excelkent🎉
Thankyou Dear Friend.......🙂
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.
Superb... 👌👌
Thanks sir.👍👍
thanks sir jii
Awesome guidance 😊😊😊😊
Thanks 😊
Isse pahle kisi ne bhi itna ache se nahi samjhaya....very food bro
Can we get 5 min candle change value and its %age?
Wow.....❤❤❤❤
i need a help.. looking for a function to fetch weekly rsi value of the stock in similar watchlist
Superb.....
From where u download Google sheet ???
5 Day % change and 30 Day % change value's are not accurate. Please check and help me.
sir payment issue ho raha he excel sheet buy karne me
Sir ji new stock ko kaisa add kare
good
How to sort from high to low percentage?
Sir Excel Sheet description may dal dijye na pls download karna hy
Great...How to use Sparkline chartype for BSE listed stocks??
We have an entry name like - BSE:Stock name
E.g
BSE:RELIANCE
Highly appreciate sir. I really like your video sir. Sir in this google sheet how we can put sector PE please. Thank you
Yes sir, we can add PE and EPS.
Formula -
PE - =GOOGLEFINANCE(STOCK NAME,"PE")
EPS - =GOOGLEFINANCE(STOCK NAME,"EPS")
is there any template Excell sheet with pre-typed google finance formulae.
Sir this same sheet is available. Not a complete Google finance formula
Very good .
How to make it live or auto refresh ?
This sheet is working on live data and it's automatically refresh all the data.
Isme mein ek column industry aur dursa sector k liye add kar sakte hai kya?? Please guide.
No sir we cannot auto populate industry and sector. If we add this we have to write it manually for all stocks.
sab thik h infosys ka nhi le rha h uska kya
titan tcs bhi ek bar list me add krke check kro ap
Good work bro. Great efforts keep it up from australia.❤
Mai ye formula se kam kiya pr error aata hai
Ath ka formula nhi mil rha
Can i do it in normal excel or mandatory to do in google sheet
No sir, normal excel didn't fetch the stock price.
sir could you tell me agar mujhe kisi particular date ka price chahiye let suppose 5 march 2023 toh wo mai kaise launga
ruclips.net/video/9-Ln0rrHrLI/видео.html
Boss, if people have say 40 stocks already, then what is best and quick way to make such sheet using portfolio data?
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.
@@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.
❤
Great. Can i create this similar chart for MFs? I need this for Lump Sum investment in the MFs.
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.
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
Please check your mail sir.
The sheet is not fetching BSE listed stocks. For example, Polyplex Polymer and Tilak Venture
BOM: stock BSE code
Hi cn u provide google sheet for live data of bybit
Live data cannot be fetched on Google sheets, it will get some time to fetch and update the price.
Sir Index bhi update kar sake he kya
If you want to add Nifty50 then add Nifty_50, for SENSEX type SENSEX
hi i have paid to buy this google sheet but again it is asking to buy.. what are the steps.
No please don't buy it again you will check and you will get it within 24hrs.
I am unable to download the excel sheet after payment.
Please check your mail.
PLEASE SEND FORMULA
Is this update everyday all by itself?
Yes
Delevery % le skte hi kya
What is the formula for delivery volume sir?
i have paid for sheet, how do download the sheet
Please check your mail.
How to get yesterday stock open,high,low in google sheets
Hello sir you would check this video - ruclips.net/video/9-Ln0rrHrLI/видео.html
I can't able to download the excel sheet after did my payment
Please check your mail sir
@@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.
@@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.
Does it indicates 20DMA ?
Will make a complete video on the same soon!!
I have paid but not received google sheet?
Please share your details so I will check and update you.
i jus paid to download template, but i cant download, can some one help
Please check your mail.
Market cap and Pe pull नहीं हो रहा
मैं etf के लिए try कर रहा हूँ
प्लीज आप इस वीडियो को देखिये इसमें बताया गया है कि स्टॉक को कैसे ऐड करना है
वीडियो - ruclips.net/video/3Sb854Wum_E/видео.html
HOW TO GET BANK NIFTY FUTURE OR NIFTY FUTURE PRICE ON GOOGLE SHEET
For option this feature is not working in Google Sheets.
sheet ka pyment kiya hi sheet kaha milegi
Apko mail par ek file receive hogi usko aap open karoge toh usme sheet ka link hai. Please check your mail.
Sheet ka payment done but link not received
Paid not get sheet sir
Please check your mail sir
Payment done but link not received
Mail per aya hoga
Market cap conversion to Crores Code #,##0,,, "Cr" , seems wrong. Values are coming in wrong. check and provide the correct conversion code to CR
Chartink me karo ye sab bekaar hai.
Sirji Video me Time 19:58 se leke 20:08 me aapne N2 and 02 ko Persontage me kese Convert kiya, Vo samaj me nahi aaya. please help.
sir jo H column hai waha phale %age mein formatting ki thi. Isliye waha paint formatting option ka use kiya hai. H column ki formatting ko copy kiya hai
Payment cut ho gya but sheet download nhi hui
Would you please share your details so I will check and update you.
गूगल शीट का ऐसा फार्मूला बताइए जो महीने की लास्ट डेट का क्लोज प्राइस बताएं।
ruclips.net/video/9-Ln0rrHrLI/видео.html
@@Excel4Freshers thank you so much
PAYMENT DONE LINK
Please check your mail
Payment Kia but link nahi mili 😢
You will get it by Email. Check your inbox
If you make a sheet for monthly close
Weakly close daily close hourly close 15 min close 5 min close sheet then
I will pay 1000 for this type of sheet
paid in the name of vinay solanki
Yes please check your mail you have received it on your mail.
"HAL "NAHI HO RAHA HAI
Please watch this video - ruclips.net/video/3Sb854Wum_E/видео.html
DELAYED DATA
Khayali Pulao
Aise hee sapne dekhne raho... BJP 275+ NDA-340-360
Unclear views 🤔🤔🤔
🕥🕞 weldone...
Thanks buddy... I tried made it too but yrs I like ...
Per sir ye change kaise red or green ho raha to column bhi hona chahiye tha aaisa hoga kay
Nahi sir iss sheet mein only values ka hi colour change hoga
nice video, mujhe isme thoda sa changes chahiye watchlist ke liye, your contact no