Manage your PORTFOLIO on Google Sheets in 10 mins | Track your Stocks & Mutual Funds | Anmol Sharma
ฝัง
- เผยแพร่เมื่อ 4 ส.ค. 2023
- Welcome to Anmol Sharma's TH-cam Channel.
Here's the link to the Google Sheet used in the video. Feel FREE to play around with the inputs and customize it as per your needs. Needless to say, you can manage your portfolio LIVE on this sheet.
docs.google.com/spreadsheets/...
And in return, you can consider subscribing this channel!
Also, Join our WHATSAPP COMMUNITY where we share stock and personal finance related content on a daily basis along with weekly sessions on various financial topics!
www.community.anmolsharma.in/
--------------------------------------------------------------------------------------------
In this video, I'll show you how to create a stock portfolio tracker in Google Sheets. This is a great way to track your investments and keep an eye on your performance.
We'll cover the following topics:
- How to track live stock prices data
- How to add column headers and format the spreadsheet
- How to input your stock portfolio information
- How to calculate your current stock prices
- How to calculate your gains and losses
- How to create charts and graphs to visualize your portfolio performance
By the end of this video, you'll have a fully functional stock portfolio tracker that you can use to track your investments and make informed decisions about your financial future.
Keywords:
stock portfolio tracker by Anmol Sharma
google sheets
stock market
investing
finance videos Anmol Sharma
personal finance
financial planning
Thanks for watching!
------------------------------------------------------------------------------------------------------
🛑Copyright Disclaimer:
All materials in these videos are used for educational purposes and fall within the guidelines of fair use.🙏🏻 No copyright infringement is intended. If you are or represent the copyright owner of materials used in this video and have a problem with the use of said material, please contact us via email on the "About" page on our channel.
🛑Affiliate Disclosure:
There are a few links in this description that, at no cost to you, will earn us a commission if you choose to click them and make a purchase.
Don't worry, we only ever promote things that we find genuine, trustworthy, and useful ourselves, and that can also genuinely help you.
Thanks for this video, in addition to this how can I get ROCE for a particular stock? any utility ?
Do you have stock wise XIRR ? that is more relevant than trade wise returns.
What should we do for commodities, forex and cryptocurrency
Sir, how can we compare our portfolio performance with index if we're doing SIP in stocks?
Sir,closed stocks ki cagr to nikal jaati hai but sabhi closed stocks ki ek cagr ka bhi koi formula hai kya
Stocks which are only listed on BSE , what can be formula?
For SUM function, use this SUM(A3:A). It will add all cells from A3 to the last cell in the table in col A. As we will be going on the adding new rows. You need not change the formula every time you add a row. But there should be no gap
How to do it can you please tell me
Nice, I learned by your video. Thanks
sir how to add book value in it?
Thanks bro awesome video save much time
Can be available mutual fund scanner?
Sir how can we do the same if we work on intraday only
very nice sheet, would you pls add XIRR in this sheet to calculate
Googlesheet have limited number of lines, what if I have more than 15k lines?
Excellent work
Thank you for the sheet and how to use it but also for covering how to create valuable sheets like these ✌✌
Thank you so much 😊
concatenate is not added in current holdings. Please amend
Thankyou for this sheet. If possible pls add XIRR also
Sir Excel sheet download nai ho pa raha hy.😢
mutual fund ke liye google sheet banaa sakte hain kya
How to get stock symbols for stock list
God bless you my friend 🙏....i subscribed ur channel
Thanks for sheet,
Enlarge kar ke bataiye toh turat samaz me aa jayega
Great man❤❤
Thanks
Thanks you my Techie Bro for the Sparkline stuff. I also would like to return favour by telling you about google Trend function.
Nice sheets
very nice, sir mujhe mutual fund ke liye spreadsheet chahiye, jisme sip aur lumpsump amount ka column ho.thanks
thank you for video
Ye sheet edit q nhi ho rhi hai
Brother sheet asi banayo jisme mutual fund b track ker sake
Edit nahi ho raha
View only ho raha hai
Thank you sir ji ❤ please mutual fund ka liya bhi share kijiye
The problem to me is, if I have a bought a stock today, and I accumulate it later, then how do I track?
Bro mutual fund ms sip ke upr ye sheet bana kr bataiye please
very good
Requesting edit access pls..
How to track Mutual fund in Google sheets ?
Can you Extract Beta Value each of stock from googlefinance formula if u able to do it please make a vidoe on it, It is very useful for me understanding of Portfolio Beta
Sir average bhi to kareange
give access sir! thank you
Excellent !!!!, Can you also make such sheet for Mutual fund portfolio , Please . Also provide your address and whatsapp for future conversation -
What is the code to pull the NAV of an *etf*
=GOOGLEFINANCE(CELL NUMBER,"price")
Please make a safe for Mutual Fund also
Not added any example of Mutual Fund
❤❤❤❤❤❤❤
Sir ji ek qoutex money management excel sheet ke upr v video bana do sir viral hojao ge ap plz rply
Plz make video on crypto curreñcy investment in wazir x and can it be done in SIP mode.i m your new subsriber from sikkim
"Hey Anmol ! Hope you're doing well. I'm launching a podcast and would be honored to have you as my first guest. Your insights and experiences would be incredibly valuable. Would you be interested? Let me know! 🎙️"
Ye sirf view only hai to ise apne hisab se kaise banaye ?
Copy it, rename and use it 🎉
sir its view only , plz update the link
Make a copy to your Google Drive then use it
I am not able to copy
Open the link, under menu item FILE, press MAKE A COPY. Save it by giving file name. Start using it
इस जा लिंक बेकार बेहूदा है। बेईमान ठग है।