4 Google Sheet SECRETs For INVESTING || Investment Growth 2023 || Track Investments In Google Sheets
HTML-код
- Опубликовано: 10 июл 2024
- If you want to grow your investments you can track your investment in google sheets so that you can make smarter investment decisions. I am sharing 4 google sheet formulas that will automatically track your investment growth.
--Investment Growth 2023
--Track Investments In Google Sheets
Timeline:
00:00 Intro
00:10 Find LIVE PRICE in Google Sheet
03:31 How Your Portfolio is Growing
07:25 What will be FUTURE VALUE of your investments
08:42 How Much SIPs You need to do
#investingforbeginners #indianstockmarket #mutualfunds
DISCLAIMER:
PLEASE NOTE that I AM NOT A SEBI REGISTERED ADVISOR SO please do your own research. This video is only for education and entertainment purposes.
On my channel, there are few more interesting videos that you watch:
🚀💥 Invest your first 1 Lakh Rupee in Stocks for beginners:
• First 1 Lakh Investmen...
🚀💥 How to select mutual funds for beginners:
• How To Select Mutual F...
🚀💥 Difference between Indian ETFs and US ETFs:
• The Difference Between...
🚀💥What is an Index Fund and how to invest in Nifty 50 Index Fund
• MUST WATCH - What are ...
🚀💥My financial Plan 75 Lacs by 2030:
• Financial Planning in ...
**********************
You can also follow me at:
🚀💥 Follow me on Insta
/ torahulj
🚀💥 Follow me on LinkedIn
/ connectwithrahuljain
🚀💥 Follow me on Twitter
/ torahulj
If you like this video, please press like to support my channel, thank you very much :-)
Wow. Superb Video. Thanks
very useful to track investments. please share the google sheets and these will help us to track
Very useful video Rahul , Thank you for posting
THANKS FOR THE VIDEO . PLEASE SHARE THE SHEET
informative
Gud video posting sir..thanks
I am a newcomer in stock market . I am thrilled to see this formula. I have already joined your channel
Excellent information Rahul!
I am going to make a graph out of it 😊
Thank you!
Wish you a very happy new year..
Thank you Harshad and wish you a great 2023 :-)
Hi Liked the way you explained it in simple words. Please share the link for getting the template for this sheet.
Hello Rahulji, again simple though great information. pls share the sheet.
Thanks for sharing👍👍
Thank you too
Good one😊
Thanks 😊
Excellent Bhai. Plz share the sheet .
Very Nice, Rahul ! Could you please share the Google Sheet? It will be a great help!
how to work more than 5 monthly SIP? & How to maintain in excel sheet like Google Sheet
Good informative video. However mostly MF deployments happen via SIP route, so CAGR calc won't work there.
What is the Formula to get the NAV of a particular MF for Particular old date automatically?
Nice video sir, if I want to set benchmark for my portfolio (example BSE500 or Nifty50), how can I do & how to check whether my portfolio has beaten the benchmark or not in excel.
Thanks for creating financial awareness. I have a question. I keep on adding units in the same stock regularly
. So will the invested date always be the date when that stock was purchased first time to calculate the CAGR?
Hello Shashank - every time you purchase a stock, the purchase date becomes your investment date for calculating CAGR.
Please help me by sharing the google sheet. Thanks for the video
Wonderful video Rahul.
But in case MF, we mostly do SIPs, then which investment date shall we use?
Thank you.
Thank you Souvik. For SIPs, please use SIP date = invested date.
Hi Rahul,
Great video. Please share the same technique in MS Excel as well.
Hi Sagar - All the formula will work in excel (not sure about Google Finance though).
@@torahulj ok, I will research out!
How can I use this calculatI ns for my current SIP?
What if i do a sip and want to calculate the cagr
I'd like to have this Google Sheet. Please share the same
Hi Rahul. Please share the sheet
Need the sheet sir
Hi I need this sheet
PLZ SHARE THIS GOOGLE SHEET SIR,
Share excel sheet
Can you provide file?
Sir please share this excel sheet
Hi Shirish - Please find below. Pls download a copy and make your changes
docs.google.com/spreadsheets/d/1c40kosZ-GaRMlVZ5Nm7XyJcktHP0hNMbU8JEdohMPGM/edit?usp=sharing
@@torahulj sir, formula are not there please check
Hi Shirish - I double checked and I can see all the forumals in the google sheet. Not sure why you are not able to see it. Sharing the link again: Pls retry and let me know if you can see now?
docs.google.com/spreadsheets/d/1c40kosZ-GaRMlVZ5Nm7XyJcktHP0hNMbU8JEdohMPGM/edit#gid=0
@@torahulj Yes, formulas are present🙂
hi rahul.pls share
Great sheet Rahul. I see you have used RRI. I have been using XIRR to get to CAGR instead. Any comments. Also, I am not computing RRI at the line item level, rather at the portfolio level. Not sure which is better? Also, can you share the copy of this google sheet please. Thanks.
sir lot of people do sip in stocks (weekly or monthly) this sheet will not be helpful , make a seperate VEDIO as how we can incorporate multiple dates and amount invested in one stock and find the CAGR
Very useful video Rahul , Thanks for posting
Thank you Nagasubramanian :-)
What is the Formula to get the NAV of a particular MF for Particular old date automatically?
What is the Formula to get the NAV of a particular MF for Particular old date automatically?