Build a Stock Watchlist with Live Data in Google Sheets
Вставка
- Опубліковано 11 жов 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.
Every crash/collapse brings with it an equivalent market chance if you are early informed and equipped, I've seen folks amass up to $1m amid economy crisis, and even pull it off easily in favorable conditions. Unequivocally, the collapse is getting somebody somewhere rich.
I do not disagree, there are strategies that could be put in place for solid gains regardless of economy or market condition, but such execution are usually carried out by investment experts with experience since the 08' crash.
The issue is people have the "I want to do it myself mentality" but not equipped enough for a crash, hence get burnt. Ideally, advisors are reps for investing jobs, and at first-hand encounter, my portfolio has yielded over 300% since 2020 just after the pandemic to date.
i'm blown away! mind sharing more info please? i am a young adult living in Miami where i've encountered several millionaires, and my goal is to become one as well.
NICOLE ANASTASIA PLUMLEE' is her name. She is regarded as a genius in her area and works for Empower Financial Services. She’s quite known in her field, look-her up.
I just curiously searched her up, and I have sent her an email. I hope she gets back to me 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.
You are the best at describing things, thank you so much for this unique video❤🔥❤🔥
Very simple and good teaching, Thanks Sir
Isse pahle kisi ne bhi itna ache se nahi samjhaya....very food bro
Clear explanation.Thank you
VERY GOOD EXPLANATION.SO FAR I HAVE NOT HEARD SUCH AN EXPL;ANATION.
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?
My first comment on my entire life i really impressed very useful and awesome video with great explanation
Sir aap Ak formula bta Skte ho kya for example SBI price 800 and I bought 700 down by green signal
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.
Hi Google Sheets Tutor
Can you please look into market cap unit? I think it should be Billion in place of Crore....
Thanks
Very good knowledge
VERYWELL EXPLAINED. FULL MARKS FOR THIS FANTASTIC VIDEO
very nicely explained
Mind blowing work, a big thumps up 👍👍👍👍
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?
Thank you sir file mujhe mil gaya mere email adress mein aaya hua tha..forgive me for my comments
Thanks g for your efforts, subscribed 👍
Sir Excel Sheet description may dal dijye na pls download karna hy
@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 .
Very nice excelkent🎉
Can we also use Google sheets to automate my trades
Very good sir
Very nice information.... Thank you very much Sir...🙏
bhai data scraping par bhi ek vid daal do. fundamentals ki analysis ke liye. industry/sector ke saath.
🙏🙏🙏🙏
Aapka video bohot hi helpful hai
Bhai ji last day ke low ko kaise enter krunga sheet par ise btaye pls
Great video bro
Kon ho aap? This is epic shit!!!
Great Brother Knowledgeable.
Do you have an updates way to add "industry" on spreadsheets?
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
super bro
Very simple and good explanation
Can i add nifty optiins like stock?
Much needed information.
very nice
sir payment issue ho raha he excel sheet buy karne me
Can we add RSI VALUE
EXCELLENT
5 Day % change and 30 Day % change value's are not accurate. Please check and help me.
Great...How to use Sparkline chartype for BSE listed stocks??
We have an entry name like - BSE:Stock name
E.g
BSE:RELIANCE
Thanks!
Nifty 50 option chain ki google sheet banaie. Agar allready available haiy to plz. link share kijiye.
thanks
Can we get 5 min candle change value and its %age?
Superb... 👌👌
Thanks sir.👍👍
From two days iam waiting for your Video Bro... from Mysuru ❤
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.
ThankYOu Very very very much
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
Sir rs. Send kiye fir bhi sheet nahi mili
Please help
Name yash gupta
Thank you so much
Delay ko live kaise rain
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.
Thankyou Dear Friend.......🙂
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")
i need a help.. looking for a function to fetch weekly rsi value of the stock in similar watchlist
This Can do on option chain data for compression oi & oi change with vwap & volume if yes reply it & make video on it
BRILLIANT
Thank you very much Sir.
I have paid for excel sheet through Phonepe just now. Kindly share the sheet for me
Please check your mail.
Maine Aaj hi Google sheet download ki hai yah edit nahin ho rahi main ismein stock add karna chahta hun
Sir please make a copy of the sheet then use it
Superb.....
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.
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.
after putting 5 day % formula why it's causing it to fetch data for multiple days 4 and 5 days value.
How to sort from high to low percentage?
mere liye google finance excel m kaam nhi kar raha hai
Very nice . 👌👌👌👌👌
its not working where share is listed in BSE only
Please watch this video - ua-cam.com/video/3Sb854Wum_E/v-deo.html
@@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
Formula is not working in my sheet?
Super sir, useful information.
Keep watching
I have tried to build the sheet but googlefinace function is not working O365.. any one help me how to enable this function
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.
Thanks, very nice
Good, Thanks
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.
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.
sir could you tell me agar mujhe kisi particular date ka price chahiye let suppose 5 march 2023 toh wo mai kaise launga
ua-cam.com/video/9-Ln0rrHrLI/v-deo.html
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...
Please watch this video - ua-cam.com/video/3Sb854Wum_E/v-deo.html
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.
Last Day,week,month High
-low kaise pata chalega?
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 ji new stock ko kaisa add kare
Awesome guidance 😊😊😊😊
Thanks 😊
thanks sir jii
Anyone Downloaded the sheet ?
Good work bro. Great efforts keep it up from australia.❤
price was lower 5 days back them why percent change is positive.
Ath ka formula nhi mil rha
Mai ye formula se kam kiya pr error aata hai
Same here
Kaisa error aa raha hai?
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.
for infosys, googlefinance fetch infosys ADR data instead of INFY data from india. pls tell me way out to resolve...
Please check this video - ua-cam.com/video/3Sb854Wum_E/v-deo.html
is there any template Excell sheet with pre-typed google finance formulae.
Sir this same sheet is available. Not a complete Google finance formula
How to get the sheet auto refreshed
Its automatically refreshed within 20 mins
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.