Easiest way to track your portfolio using Google sheets! Stock Portfolio Tracker Spreadsheet
HTML-код
- Опубликовано: 26 янв 2023
- In this video, we are going to learn easiest way to track your MF & stocks portfolio using Google sheets. We have showed the whole process with demo to make you understand it in most easy way possible.
Complete Fundamental Stock Analysis Tool - Stock-o-meter:
investyadnya.in/stock-o-meter
Research Based Ready-made Model Portfolios:
investyadnya.in/model-portfolios
Comprehensive Mutual Fund Reviews:
investyadnya.in/fund-o-meter
Yadnya Books and eBooks now available:
On Amazon - amzn.to/2XKtlks
On our website - investyadnya.in/books
Find us on Social Media and stay connected:
Blog - blog.investyadnya.in
Telegram - t.me/InvestYadnya
Facebook Page - / investyadnya
Facebook Group - goo.gl/y57Qcr
Twitter - / investyadnya
LinkedIn - / investyadnya
#InvestYadnya #YIA
LEGAL DISCLAIMER:
Use of this information is at the user's own risk. The Company and its directors, associates and employees will not be liable for any loss or liability incurred to the user due to investments made or decisions taken based on the information provided herein. The investment discussed or views expressed herein may not be suitable for all investors. The users should rely on their own research and analysis and should consult their investment advisors to determine the merit, risks and suitability of recommendation. Past performance is not a guarantee for future performance or future results. Information herein is believed to be reliable, although its accuracy and completeness cannot be guaranteed. The images used may be copyright of the company or third party. As a condition to using the services, the user agrees to the terms of use of the website and the services.
DISCLOSURES UNDER SEBI (RESEARCH ANALYST) REGULATIONS, 2014:
Yadnya Academy Pvt. Ltd. (InvestYadnya) is registered with SEBI under SEBI (Research Analyst) Regulations, 2014 with registration no. INH000008349.
Disclosure with regard to ownership and material conflicts of interest
1. Neither Research Analyst nor the entity nor his associates or relatives have any financial interest in the subject Company;
2. Neither Research Analyst nor the entity nor its associates or relatives have actual / beneficial ownership of one per cent or more securities of the subject Company, at the end of the month immediately preceding the date of publication of the research report or date of public appearance;
3. Neither Research Analyst nor the entity nor its associates or his relatives have any other material conflict of interest at the time of publication of the research report or at the time of public appearance.
Disclosure with regard to receipt of Compensation
1. The Research Entity and its associates have not received compensation from the subject company in the past twelve months.
2. The subject company is not or was not a client during the twelve months preceding the date of recommendation.
Sir salute to you for showing the power and simplicity of using the readily available tools for one's investment tracking. Much respects from Bengaluru, 🙏
investment tracking made very simple.Thanks a lot
Dear Sir, Thank you 🙏 so much it really helps a lot to manage my portfolio.
Well thank you for this so productive content which is really helpful to have everything you want at one place specially when you have multiple demats to track.
Thank you Sir! Much Appreciated :)
sheet ka link share krna chahiye tha sir
I prepared few days back, itz of grt help as customized portfolio is difficult to get from anywhere. After preparation one can share with himself to view in smartphone anytime anywhere.
Thank you I will create this excel and track it using google data studio creating different reports. it would be like creating my own mutual fund or basket of stocks and comparing it with benchmark index. thanks for the Idea 💡🙏
Great info thanks a lot
THANKS....SIRJI
Thank you sir, From last 3 years I am using Google sheet for managing my portfolio. Its really helpful.
Cn u pl provide link for sheet
Great video
Very useful info
What a coincidence!! I just created this about a week ago in google sheets. Rather, i went ahead and created RSI based buying indicator for long term buying.
If it's sharable, please enable read access and share
Can u pls share template
Thank you very much sir
Thank you🙏🙏🙏 so much sir
Hello, the value of IGL and TCS not coming properly in google sheet after applying the code IGL and TCS respectively
Thanks for the idea sir. Please tell how to add CAGR
BSE stocks are not coming up, anything different to do for them?
Very useful resource
Hi Sir, can you attache a sample excel with formulas, we need the same to put formula for the first time
Nice video, Sir how can we compare our portfolio performance with index if we're doing SIP?
Instead of Absolute returns, it is important to know XIRR of the stocks and the overall portfolio (as stocks have been transacted (buy and sell) over a period of time at different cost prices). Can we do that in Google sheet? If yes how.
I use IY portfolio tracker since very first day and it's very convenient for me!!
It takes very little time to update and check 👍
What means IY?
@@PRanjitkumar001 Invest Yadnya
Is it free or paid tool?
Sir, I want to make a portfolio using Google sheets like this. But it is not working in Dhaka stock exchange (Country- Bangladesh). Please guide me or send me demo with using formula for Dhaka stock exchange.
ARE WARREN BUFFET JI, NSE CODE KAISE PRAPT KAREN YE TO BATAIYE.
Consolidated account statement also available from nsdl or cdsl
I usually get it a month late.
How To Downalod this File?
Bhau, jhakaas 👍🙏
How to find average price for SIP?
Sir, mein "google finance" use karta hoon to track my portfolio.
How to get average cost price of MF SIP?
Yadnya investment's i portfolio tracker is very good
How to get 52 week high of mutual fund in sheet
HOW TO TRACK ONLY BSE LISTED SHARE IN GOOGLE SHEET?
base sheet share kar dete.
That's a very commendable job to inform about other products if you have a similar product. Thanks Gaurav Jain
Very very true. Shows selflessness to the core. They never push their products to people. They deserve more likes and respect brother
its not happening. gives error in name.
MF tracking CAMS me bhi hota hai.
52 w high low in mutual fund is not shown
♥️
Dunia bhar ke link de rakhe hai bio mein. google sheet ka bhi de dete. easy rehta edit karna
Please try to post such portfolio tracker for mutual funds portfolio also.
It is for MF portfolio too
@@InvestYadnya I heard not all MFs have google tickers, so just asked if there is any other way.
Sir can you share this excel sheet
No . Its a google sheet. You can also create even on mobile. Works seamlessly
Try on value research
First view
Solution looking for a problem 😂
Intial step se batana tha na, how to start making a spreadsheet....waste video if you started with a general filled in data..mis leading title
Bhai pura video to dekho. Sab to bataya hai.
Bhai khana bhi chaba k chahiye kya. Kuch toh mehnat karlo.
What to do amd alter when we see Sell any amount of shares from the current holdings??
Excuse me sir, what language are you speaking speaking language what to you speaking to you while language?