Build a Stock Watchlist with Live Data in Google Sheets
ฝัง
- เผยแพร่เมื่อ 23 พ.ย. 2024
- 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
(You will receive the file on your mail, if not, then dm me on Instagram, you will receive the file within 12 hours)
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.
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.
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.
Chart features ❤ superb sir. Many thanks 👍👍👍
Please give formula for 200 days EMA 🙏🙏🙏
Isse pahle kisi ne bhi itna ache se nahi samjhaya....very food bro
Very simple and good teaching, Thanks Sir
You are the best at describing things, thank you so much for this unique video❤🔥❤🔥
Marketcap not showing actual. May be error in formula
👌Excellent narration. Easy to follow.Thank you.
very nice explanation, good presentation.many thanks.
Sir Excel Sheet description may dal dijye na pls download karna hy
Can you please send the template for the stock analysis worksheet. 🎉
Your efforts much appreciated sir❤
sir bahut hi badhiya, par i also want the 1yr, 2yr,3yr,5yr,10yr, retuns in the sheet .how to do that. This will be also useful to search MFs.plz reply sir
Plz reply sir
Hi Google Sheets Tutor
Can you please look into market cap unit? I think it should be Billion in place of Crore....
Thanks
Never seen an amazing video like this before, one request bro, can you please help with 50 SMA, 150 SMA and 200 SMA formula, I tried a lot but not working.
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?
VERYWELL EXPLAINED. FULL MARKS FOR THIS FANTASTIC VIDEO
Sir aap Ak formula bta Skte ho kya for example SBI price 800 and I bought 700 down by green signal
Overall video is explained in simplest way . 👍
One Error I encountered: Market Cap showing in Thousand, Cr. Where as those stocks are in Lakh Cr.
Though I divide the number by Crore and I got the desired 17,37,557 cr. for reliance, but I'm still not satisfied.
Yes I already checked this but I can't find the solution yet. So I don't make changes in sheet. I will remove that column from the sheet.
VERY GOOD EXPLANATION.SO FAR I HAVE NOT HEARD SUCH AN EXPL;ANATION.
Do you have an updates way to add "industry" on spreadsheets?
Clear explanation.Thank you
@Excel4Freshers , the video is very informative and insightful , Thanks for making this video.
One thing i noticed - the market cap formatting used is seems wrong or misleading - its is 942 Cr , but actually IRFC's market cap was more when the video was uploaded. ( 9 months ago ). Please can you guide how to correctly format the market cap .
Do you know how to bring in Dividend yield data into googlesheets for US markets. thanks.
Is it the revenue of 5 days or 30 days in the end? If so can I add the time I decide to calculate the revenue in that period? like 3 years 5 years or ten years?
Thanks g for your efforts, subscribed 👍
Great...How to use Sparkline chartype for BSE listed stocks??
We have an entry name like - BSE:Stock name
E.g
BSE:RELIANCE
Can we also use Google sheets to automate my trades
Bhai ji last day ke low ko kaise enter krunga sheet par ise btaye pls
bhai data scraping par bhi ek vid daal do. fundamentals ki analysis ke liye. industry/sector ke saath.
🙏🙏🙏🙏
very nicely explained
ssuper sir i will also try this method
Very nice information.... Thank you very much Sir...🙏
Sir, To show in cell N1 display as 5 Day % I tried Format-Number-custom number format # 'Day %' and in similar way 30 day and is showing error only. Otherwise the formula in cell N2 and O2 are working. Any alternative way to display 5 Day % in the cell
Very simple and good explanation
Marketcap number formate is wrong. IRFC market cap is not 942 Crs. It's close to 2L Cr
Very good knowledge
Great Brother Knowledgeable.
Same file all ETF ke liye milega banake
Thank you sir file mujhe mil gaya mere email adress mein aaya hua tha..forgive me for my comments
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")
HOW RO GET THESE DETAILS IN OPEN OFFICE SPREADSHEETS
sir payment issue ho raha he excel sheet buy karne me
Nifty 50 option chain ki google sheet banaie. Agar allready available haiy to plz. link share kijiye.
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.
Aapka video bohot hi helpful hai
This Can do on option chain data for compression oi & oi change with vwap & volume if yes reply it & make video on it
i need a help.. looking for a function to fetch weekly rsi value of the stock in similar watchlist
Mind blowing work, a big thumps up 👍👍👍👍
Much needed information.
Can we get 5 min candle change value and its %age?
Great video bro
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.
Can i add nifty optiins like stock?
5 Day % change and 30 Day % change value's are not accurate. Please check and help me.
Very nice excelkent🎉
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.
after putting 5 day % formula why it's causing it to fetch data for multiple days 4 and 5 days value.
My first comment on my entire life i really impressed very useful and awesome video with great explanation
Very good sir
Superb... 👌👌
Thanks sir.👍👍
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.
Formula is not working in my sheet?
I have tried to build the sheet but googlefinace function is not working O365.. any one help me how to enable this function
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.
Awesome guidance 😊😊😊😊
Thanks 😊
How to sort from high to low percentage?
Super sir, useful information.
Keep watching
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.
Thank you very much Sir.
Thank you so much
From two days iam waiting for your Video Bro... from Mysuru ❤
Can i do it in normal excel or mandatory to do in google sheet
No sir, normal excel didn't fetch the stock price.
Thanks!
Good work bro. Great efforts keep it up from australia.❤
ThankYOu Very very very much
Can we add RSI VALUE
BRILLIANT
is there any template Excell sheet with pre-typed google finance formulae.
Sir this same sheet is available. Not a complete Google finance formula
Sir rs. Send kiye fir bhi sheet nahi mili
Please help
Name yash gupta
for infosys, googlefinance fetch infosys ADR data instead of INFY data from india. pls tell me way out to resolve...
Please check this video - th-cam.com/video/3Sb854Wum_E/w-d-xo.html
I have paid for excel sheet through Phonepe just now. Kindly share the sheet for me
Please check your mail.
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.
Thanks, very nice
sir could you tell me agar mujhe kisi particular date ka price chahiye let suppose 5 march 2023 toh wo mai kaise launga
th-cam.com/video/9-Ln0rrHrLI/w-d-xo.html
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.
Last Day,week,month High
-low kaise pata chalega?
very nice
Sir ji new stock ko kaisa add kare
EXCELLENT
Thank you
The sheet is not fetching BSE listed stocks. For example, Polyplex Polymer and Tilak Venture
BOM: stock BSE code
For BSE listed Stock formula not work, how to work
Sir go to the screener website there you have to search for a stock name there you will find nse or bse code copy them and paste the code in sheet.
super bro
price was lower 5 days back them why percent change is positive.
I bought it made payment bt how to open n download now... Plz help
A file has been sent to you in the mail. Please check.
Thankyou Dear Friend.......🙂
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.
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
Please check your mail.