4 Google Sheet SECRETs For INVESTING || Investment Growth 2023 || Track Investments In Google Sheets

[@torahulj]

If you like this video, please press like to support my channel, thank you very much :-)

[@biswadipkarmakar6924]

THANKS FOR THE VIDEO . PLEASE SHARE THE SHEET

[@balaji4154]

Wow. Superb Video. Thanks

[@srinaga1975]

Very useful video Rahul , Thank you for posting

[@jakehansenfitness]

This video has finally helped the proper CAGR formula click in my brain!! Thank you

[@PramodKasarekar]

thank you for your detail explanation, i need this sheet,

[@Debasis765]

I am a newcomer in stock market . I am thrilled to see this formula. I have already joined your channel

[@harishbsbillionaire1799]

Thanks for google sheet tutorial. I have created swing trading sheet with help of the video.

[@kvnrao1228]

very useful to track investments. please share the google sheets and these will help us to track

[@ShashankKulkarni]

Excellent information about Google finance formulae 👍

[@vijaygour6453]

Hi Liked the way you explained it in simple words. Please share the link for getting the template for this sheet.

[@TheNirmal1111]

GREAT INFORMATION..PLZ SHARE THE SHEET

[@mpsivakumar1589]

Thanks Very useful information

[@bhavneshparikh8283]

how to work more than 5 monthly SIP? & How to maintain in excel sheet like Google Sheet

[@SathishChandrasekaran-y8m]

What is the Formula to get the NAV of a particular MF for Particular old date automatically?

[@sudipkumarkhnan1929]

Rahul JI, thank you.

[@vasukirao3751]

Excellent analysis, please share this exel sheet sir

[@akilanaki9107]

Gud video posting sir..thanks

[@sajithanand]

informative

[@himanbg]

Excellent information about Google finance formulae Could you please share the Google Sheet? It will be a great help!

[@kalpanapatel9354]

Hello Rahulji, again simple though great information. pls share the sheet.

[@jayaramanonda]

Thanks for the google sheet. i am looking for this type of google sheet. Kindly share it please and I am in your google community

[@ranjana3183]

Very Nice, Rahul ! Could you please share the Google Sheet? It will be a great help!

[@joyitag]

Thanks for sharing👍👍

[@torahulj]

Thank you too

[@naushir_miraz]

Good one😊

[@torahulj]

Thanks 😊

[@hinasyed7817]

very informative video...can I get the link to the spreadsheet please

[@samrajah8846]

Thannks for the info, get i get the copy of the excel please

[@sagarbhowal9016]

Hi Rahul, Great video. Please share the same technique in MS Excel as well.

[@torahulj]

Hi Sagar - All the formula will work in excel (not sure about Google Finance though).

[@sagarbhowal9016]

@@torahulj ok, I will research out!

[@anilutkarsh]

Excellent Bhai. Plz share the sheet .

[@harishn5873]

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.

[@hyper-Insight]

Excellent information Rahul! I am going to make a graph out of it 😊 Thank you! Wish you a very happy new year..

[@torahulj]

Thank you Harshad and wish you a great 2023 :-)

[@pratikhh]

Hi Rahul great video, Please share the sheet

[@bikashiter]

Good informative video. However mostly MF deployments happen via SIP route, so CAGR calc won't work there.

[@chandanmondal21]

Please help me by sharing the google sheet. Thanks for the video

[@akotireddy]

Xirr formula makes more sense than cagr. Because we will invest in the same stock at different point of time.

[@sudipkumarkhnan1929]

Rahul Ji, If our investments are on a "staggered" basis; then "How are we to calculate the years of investment"?

[@shashanksrivastava2285]

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?

[@torahulj]

Hello Shashank - every time you purchase a stock, the purchase date becomes your investment date for calculating CAGR.

[@szsouvikzs]

Wonderful video Rahul. But in case MF, we mostly do SIPs, then which investment date shall we use? Thank you.

[@torahulj]

Thank you Souvik. For SIPs, please use SIP date = invested date.

[@VK_2002]

I think xirr should make more sense since we invest at different times...

[@shruthimp4945]

How can I use this calculatI ns for my current SIP?

[@OmkarShivde]

I'd like to have this Google Sheet. Please share the same

[@VENKATRAMANIYER-g7b]

Sir please check the price of the ticker on the date you have shot this video .... I am confused whether you want to teach or to confuse

[@abhijeets6593]

What if i do a sip and want to calculate the cagr

[@amitagar4u]

Hi Rahul. Please share the sheet

[@AMITDALVI-qg1bq]

PLZ SHARE THIS GOOGLE SHEET SIR,

[@shagunb45]

Sir please share this excel sheet

[@torahulj]

Hi Shirish - Please find below. Pls download a copy and make your changes docs.google.com/spreadsheets/d/1c40kosZ-GaRMlVZ5Nm7XyJcktHP0hNMbU8JEdohMPGM/edit?usp=sharing

[@shagunb45]

@@torahulj sir, formula are not there please check

[@torahulj]

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

[@wakandaforever6467]

@@torahulj Yes, formulas are present🙂

[@rajpattu73]

Need the sheet sir

[@sreejaashankar8885]

Hi I need this sheet

[@rajujoseph2948]

Please give me formulas

[@sajishkumar.j.d5179]

Please share the sheet

[@indranilgoswami1928]

Pl share the sheet

[@bhavneshparikh8283]

Can you provide file?

[@jitendrakadam6103]

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

[@samajhnahiara]

Share excel sheet

[@lightpost519]

hi rahul.pls share

[@alphabeta01]

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.

[@srinaga1975]

Very useful video Rahul , Thanks for posting

[@torahulj]

Thank you Nagasubramanian :-)

[@SathishChandrasekaran-y8m]

What is the Formula to get the NAV of a particular MF for Particular old date automatically?

[@bhavneshparikh8283]

What is the Formula to get the NAV of a particular MF for Particular old date automatically?