Manage your PORTFOLIO on Google Sheets in 10 mins | Track your Stocks & Mutual Funds | Anmol Sharma
HTML-код
- Опубликовано: 4 авг 2023
- Welcome to Anmol Sharma's RUclips 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.
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
Brother sheet asi banayo jisme mutual fund b track ker sake
The problem to me is, if I have a bought a stock today, and I accumulate it later, then how do I track?
I need one more to add mutual funds , SGB & Bonus , Split Dividend in this google sheet.
Not added any example of Mutual Fund
Googlesheet have limited number of lines, what if I have more than 15k lines?
Sir, how can we compare our portfolio performance with index if we're doing SIP in stocks?
How to track Mutual fund in Google sheets ?
Sir ji ek qoutex money management excel sheet ke upr v video bana do sir viral hojao ge ap plz rply
Requesting edit access pls..
Thanks for this video, in addition to this how can I get ROCE for a particular stock? any utility ?
Nice, I learned by your video. Thanks
Thanks bro awesome video save much time
What should we do for commodities, forex and cryptocurrency
Excellent work
Do you have stock wise XIRR ? that is more relevant than trade wise returns.
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
Thanks
hi, how do we find the CAGR of the portfolio that we have made. It should iclude all the cashflows that i put in my brokerage accounts and the reinvestments that i made ffrom booking profits in securities.
Great man❤❤