How to Track Portfolio in Google Sheets for FREE [Hindi]
HTML-код
- Опубликовано: 18 июн 2019
- 📚Don't forget to check out our other channel, focused on real-life trading:
/ @vrdrao
How to Track Portfolio in Google Sheets for FREE [Hindi]
Link to download Free Google Sheet Portfolio Tracker Template: goo.gl/4tPVS6
👍Stay updated. Join telegram Channel for free:
t.me/vrdnation
➡️Yes Bank Down 30% - Should You Buy?
• Yes Bank Down 50% - Sh...
➡️Why DHFL Stock is falling? (Detailed Analysis):
• DHFL का STOCK क्यों गि...
📌Every Week Stock and Market Analysis (Add to your Playlist Now):
• Stocks & Market Analysis
➡️3 Most Important Stocks Every Trader must watch:
• 3 Most Important Stock...
➡️Top 3 Sectors which gives investment Opportunity in New Government:
• नयी Modi सरकार आई - अ...
➡️Stop Loss Orders in Zerodha Kite (Live Trading):
• Stop Loss Zerodha Kit...
👍Stay updated. Join telegram Channel for free:
t.me/vrdnation
Don't forget to Like👍, Share↗️ & Subscribe🔔 to the channel
👉1. SUBSCRIBE NOW : goo.gl/ZKgjdd
💹2. LIVE TRADING Channel: goo.gl/YWGNCX
Useful Links: goo.gl/4tPVS6
📚Checkout our Stock Market Training courses:
www.vrdnation.com/courses-ove...
🆓Free Stock Market webinars:
www.vrdnation.com/webinars/
🚀We are on a mission of building biggest stock market library in India.🚀
🎓Experience and gain the knowledge with all videos we make for you.🎓
🔥Explore and learn from these videos🔥
Sir, thanks for the video it is really helpful. Can we make similar tracker sheet for Mutual fund SIP monthly installments
Very useful for beginners, thank you for sharing
aapki yeh google sheet bahut acchi hai, agar isme stocks sell karne k baad profit loss track karne ka koi option hota toh aur accha hota, maine modify kiya toh isne kaam karna band kar diya
Sir, very useful video and very well explained. One question. How we also record the "Sell" transactions on this sheet? How? .
A very useful tool... Thank u sir for sharing this
Sir thanks for sharing Valuable information about Stock Market.
Sir Please Share Any information About Why Rain Industry Stock Go Down Sides.
Sir, Thanks for the video. It is very nice and very comfortable to work with.
BUt sir, In day to day life, We do buy and sell both. This sheet can tell us about our holdings. but When I am buying something and selling half of the quantity or again buying on different price then how to manage?
May be I am not clear what I am asking but hope you will understand my concern. i want to make a full solution on G-sheet.
Hello.. I have downloaded the file and it is very useful. I have a question, if i sell share how to reconcile it from the sheet
Same Question
Very useful informations with simplicity
Nice Information and esay way thank you very much
Super sir keep continue
Kya this sheet mai automatically LTP and profit. Change ho sakta hai ,?means according to dates. LTP and profit automatically update hota rahe ga kya?
hello sir mujhe ap se puchna tha ki example mere paas already tatamotors ka share pada hai rs190 ka,aaj maine tata motors ke share liye hai uska price hai rs75 ka toh main jab sale karta hu to zerodha vala FIFO ke aadhar pe woh jo pehle liya tha usme se sale karte hai to mujhe usme loss hota hai to kya koi tarika jise mujhe pata chal sake ke meri real average cost kya hai aur sale bhi usi main se ho jo main chahu ??????????????????????????????? please hellppp???????????????????
SIR CAN WE ADD DIVIDEND TRACKER DURING THE FA 2019-2020 OR 2020-2021
Excellent sirji thanks a lot
Very informative sir
You explain very well, thanks for video..
Make some more videos on asset allocation on Google sheets.
HI, I noticed that only NSE stocks are captured, BSE is not working in this file. kindly suggest.
Sir,
The prices updated in google sheet is not exactly matching with the actual closed price that is shown in my zerodha demat account. What may be the cause.
Bhai bahut badiya
Eaisa hi chahiye tha
Hello Sir, How to calculate Portfolio PE vs Market PE? Is there any video , please share.
Sir lekin humne kush shares ka date yaad ni hai to jaise koi share aaj liya 5 Qty aur kush 2 months pehle ke liye hai to usko kaise manage kre
Thanks Bhai🙏🙏🙏
I am not abel to use it on mac...can someone help out plz?
Thanks for Sharing.
I have a question, how track the same when we sell the stock,
Like swing trading
Very nice tool
Sir BSE stocks ke symbols kaise add kare ?
Very good information
Sir, I posted all my stocks, but current market price not showing
Good... Sir
How to add futures and option in this google sheet and combine with stock.
Sir different date ko buy kiya hoy to kese manage kare
Namaste
Thanks a lot for sharing your expert knowledge ~
May i kindly know,
1. How to record bonus shares entry ?
2. How to record Split / Sub-division of Share ?
3. If i add Purchase Invoice No. in the spreadsheet, will the spreadsheet function ?
Kindly share your suggestion ~
Sir, stock split, bonus, & same stock another date purchase how added? negative colour how to change automatic, and email pe msg Kaise karthe hai, Please Rply me sir.
Please assist for stock split/bonus. How to make entry for that. Thank you
very good video
VERY GOOD TRACKING TOLD VERY NICELY.
I NEED TO KNOW HOW TO TRACK IF WE SELL ANY THING IN THAT
V good information
Thank you
I need a exel format for my Trading accounts can you create for me . I can buy
It means we are publishing our whole data in Google sheets. What is the security.
Email Alert kaise daal sakte hain ???
Sir isme apne ek chiz or add karni hogi
Ki agar kisi stock me dubara buying ya kisi me se kuch sell kiye to vo kaise manage hoga
I request you to kindly educate me how to adjust for splits and bonus in portfolio tracker google sheets?
Very Good
thank you sir
Sir coinswich ka bitcoin ka aisa chart banake de sakte ho ky sir....
Sir isme monthly and yearly tracking kaise kare
Mai time bound profit loss dekhna chahta hu
aap ye bataye portfoliyo ki pehli row kaise bani vo bataye , vo to copy nahi hogi??????
aur dividend aata hai to vo kya add ho jata hai ??????
Sheet me ₹ ki jagah = kyo aa rha he sir,aur bse ke share me kuch mistak ho rha he
If humne kisto me share liye hai tb kya ????
Ex- Humne 1 jan 2019 ko L&T ke 20 share liye phir Price niche yaa uper hua to
Feb me phir se 30 shares aur add kr liye uske baad
May me 10 share aur add kr liye
Aisa case me Ye sheet kaise kaam kregi ?????
Then just update the quantity and replace the buying price with the average buying price
sir great job
can i use this for NSE futures
Thank you for sharing the tracker.. can we add more columns to track brokerage
Bro hum Pakistan stock ka symbol Google finance mein show ni hota kiya kry
Nice
How to import BSE price on google sheet?
How to update Mutual Fund NAV on Google sheet ,
Please make video on this topic
i want to create own portfolio by my stock sir please tell how
Thank you so much for this.
It is simple and very easy to use.
is this work for SIP
Hello sit..i have a one question regarding this vedio..How to calculate holding periods (days)????
How to calculate holding periods (days) ??
Sir no of days date ke sath keise karte hai please bataiye
Sir can we add mutual funds
How to add BSE and NSE stocks in same google sheet
Can we add mutual funds
Hello sir this sheet operates only for NSE Data & not for BSE Stocks??
How to update it with BSE Data???
Instead of "NSE:SDFREFS" it will be "BOM:123456". Search for company name and BSE symbol
good
Sir. TATA MOTORS REVIEW KR DO
Isme Mai apna bna rha hu to apka wala delete nhi hi rha h portfolio
Please explain - how to enter 'sell' entry in Google Finanace
Money control also best.
Mutual funds ka kaise kare
But sir update to ho ni reha sir hai Google sheet mein
Google symbol is not working . It is not detecting the price
Share ki kharidi ki Date nahi pata hai to kaise pata karein please koi formula Batave sir
Unable to use in mobile, can u help??
Mutual fund?
This Google sheet download link pl
मैंने आपकी शीट डाउनलोड कर ली इसके बाद क्या करना है कुछ एड नहीं हो रहा है
HOW TO ADD AVEREGE BUY PRICE
👌
Mobile pr bana sakte h
E mail alert kaise kare
Please include trade charges too
Can we edit this in excel?
You can't edit anywhere. It is view only file
Stock SIP kaise track kare
Sheet download link pls
Editing mode not available
Sir where to paste this file after making its copy???
🐼
HOW TO SAVE FILE...?
Instructions on how to save excel sheet are clearly mentioned here: www.vrdnation.com/useful-links
Sirjee...its tough to remember date of buy..why that is needed. Suggest some solution how to use it for some onewho has say list of 40 shares and dont have date of purchase. At the most can take download from HDFC sec portfolio...thats it....how to put date...if dont have record....and one might have done sip for one share 10 time buy...so provide if any other solution you have
Its for kids
the web 420
Kuch bhi nahi hota
vidio bana nahi aata to mat banawo
Bakwas
Sir, very useful video and very well explained. One question. How we also record the "Sell" transactions on this sheet? How? .
Sir esme sell ki data kaise insert kare