My son recomended me this particular video and it is just awesome❤ It definately took me 2 hour to prepare the sheet first time as I have almost 70 equity and mf for me and my family but once done, its just amazing. Smart way to track complete portfolio for multiple people.
Ended up following some of your videos after your FIRE interview in Wint Wealth. Can't thank you enough for this simple great idea. As the saying goes, being simple is very difficult but you demonstrate this consistently. Brilliant! Kindly consider posting English only podcasts. That would help me and many south Indians better.
Hi Ravi, I had 2 Q's: a) Google Finance doesnt list Aditya Birla Sun Life Liquid Fund - Direct Plan - Growth, how to fetch current rates in such cases? b) If one has a SIP, how to add every month the incremental units? Thanks!
I was looking for something like this, thanks for posting just curious if you know how to track SGB, I am not able to get the codes from Google Finance
+1, how can we track SIP investments? I have SIP amount, SIP date and SIP start date based on which number of transaction is calculated. But how can we update units automatically??
Wow Ravi thanks bro this is Brilliant! 👍👍 pls ask admin to add *'Buy $ Pay'* feature for your channel.. Earlier i could only check Portfolio on my mobile app only but not on laptop / PC. Ab sahi hai.. Can see my whole portfolio using Google Sheets anywhere - my laptop or my mobile devices. Plus the Auto NAV updation is a extremely must have feature provided by Google. 😎
Sir. We can also add the buying price in google finance and create a portfolio there. Then it would be easier to grab it to sheets. Hopefully Google Bard would make it easy.
Nice video sir, I need to know some more. If I want to know how much my portfolio has grown from the date that I invested and how can I compare with the benchmark for example Nifty50 or BSE500
What is the difference both are spread sheet software basically. Not everyone even has excel or it's latest version, also not everyone is proficient in excel. I think Google sheets being freely available on most platforms is a plus.. The live auto update of nav is a game changer as illustrated by Ravi in this video.
My son recomended me this particular video and it is just awesome❤
It definately took me 2 hour to prepare the sheet first time as I have almost 70 equity and mf for me and my family but once done, its just amazing.
Smart way to track complete portfolio for multiple people.
Glad it helped!
TH-cam ki sabse achhi video kam samy me thank you so macha salary bad gayi hamari
This is such a great example of “Invent & Simplify”
Ended up following some of your videos after your FIRE interview in Wint Wealth. Can't thank you enough for this simple great idea. As the saying goes, being simple is very difficult but you demonstrate this consistently. Brilliant!
Kindly consider posting English only podcasts. That would help me and many south Indians better.
Great way, only thing is with SIP the number of units will keep changing, and will have to update that part manually
Great Mr Ravi It was very informative video... Request you to make a video on Clapia how to make app.....
I do not know enough about that. Sorry.
Video is very helpful. I was searching for symbols of Mutual Fund Scheme wherefrom to get it. And my problem is solved. Thanks for clarity.
Topic starts 2:02 thanks me later
Cool feature.. Didn't know .. Thanks!
Glad you liked it
Nice useful tool. Loved it
Glad you like it
Thanks bro for valuable info.
Very helpful ❤
Very Useful Ravi Sir. Thanks for the vlog
Thank you. Please like / subscribe. Will put out more contents like this.
how you plotted pie chart,? seperate for each?
Dear, How do I track my portfolio over period (except entering values every day)?
Thanks Bro, very useful :)
Glad it helped
Sir monthly SIP karne par unit change kaise change hoga?
Thank You Ravi 🙂
My pleasure 😊
Hi Ravi, I had 2 Q's: a) Google Finance doesnt list Aditya Birla Sun Life Liquid Fund - Direct Plan - Growth, how to fetch current rates in such cases? b) If one has a SIP, how to add every month the incremental units? Thanks!
Hi Sir,
a) It does. I just checked. Google it instead of going to google finance and searching it there.
B) Needs to be done manually.
VERY INFORMATIVE VIDEO SIR
So nice of you
Google finance app bhe ha sirrr
BSE stock kaise add karu ?
I was looking for something like this, thanks for posting
just curious if you know how to track SGB, I am not able to get the codes from Google Finance
I don’t think that option is there.
SIR, MUTUAL FUND SIP ME UNITS BADALTI RAHATI HAI. USKE LIYE KOI FORMULA BATAAIYE
+1, how can we track SIP investments? I have SIP amount, SIP date and SIP start date based on which number of transaction is calculated. But how can we update units automatically??
Wow Ravi thanks bro this is Brilliant! 👍👍 pls ask admin to add *'Buy $ Pay'* feature for your channel.. Earlier i could only check Portfolio on my mobile app only but not on laptop / PC.
Ab sahi hai.. Can see my whole portfolio using Google Sheets anywhere - my laptop or my mobile devices. Plus the Auto NAV updation is a extremely must have feature provided by Google. 😎
Glad this could help
But will it automatically cater for SIP investment? I don't think so
No. That needs to be updated manually.
Sir. We can also add the buying price in google finance and create a portfolio there. Then it would be easier to grab it to sheets. Hopefully Google Bard would make it easy.
Hello Sir, Is "closeyest" attribute working properly for Mutual Funds?
No clue. Never used it.
I am looking Mutual Fund NAV date for 52 week high or low date.
How I can get please reply me, thank you.
Thanks Sir
Awesome
So nice of you
how to downalod this file?
Sir NAV in google finance doesn’t update regularly
What do you mean by regular? It is delayed by half an hour or so for stocks and max a day for MFs.
@@desifirepodcast sir do check NAV Rate of PPFAS it is still showing the NAV of Dec7th
Sir does the nav update automatically or we have to update it
It updates automatically. That is the whole point.
@@desifirepodcast😎👍👍
How are you updating your units, day to day basis?
Also, what about the xirr returns (not tracking that?)
Not adding units. Since I do not have an income, I do not have any fresh investments. I do redeem from time to time and update that when required.
Not sure there's a way to update EPFO balance in google sheet , must be done manually I guess.
Yes. I think that part would be manual.
HOW TO SAVE THIS CHART?
pl prepare a video to add "52W high" and "52W low" for mutual funds using google sheets
Super easy method to keep track of investments in 1 sheet itself, along with tracking achievement towards personal goals
How about tracking SIP ?
Nice video sir, I need to know some more. If I want to know how much my portfolio has grown from the date that I invested and how can I compare with the benchmark for example Nifty50 or BSE500
I am sorry I don't know
All of this can be done in Excel too, not sure why to use google sheets
What is the difference both are spread sheet software basically. Not everyone even has excel or it's latest version, also not everyone is proficient in excel.
I think Google sheets being freely available on most platforms is a plus.. The live auto update of nav is a game changer as illustrated by Ravi in this video.
Use excel. Would be the same I guess
Best❤
I tried. This doesn't update NAV of MF. What needs to be done to update it
What mutual fund do you need
Check in Google finance
This is for axis growth opportunities fund
=googlefinance("MUTF_IN:AXIS_GROW_OPPO_1LDB7MS","price")
anyone has sample google sheet?
Thank u sir
Welcome
Sir , it will be of helpful if you can provide the subtitles in English.
Good
Thanks