Easiest way to track your portfolio using Google sheets! Stock Portfolio Tracker Spreadsheet

  Рет қаралды 90,741

Yadnya Investment Academy

Yadnya Investment Academy

Күн бұрын

Пікірлер: 71
@MrSaurav1983
@MrSaurav1983 Жыл бұрын
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.
@umeshsj
@umeshsj Жыл бұрын
If it's sharable, please enable read access and share
@ravijag73
@ravijag73 Жыл бұрын
Can u pls share template
@gauravchoudhary4218
@gauravchoudhary4218 Жыл бұрын
That's a very commendable job to inform about other products if you have a similar product. Thanks Gaurav Jain
@ravijag73
@ravijag73 Жыл бұрын
Very very true. Shows selflessness to the core. They never push their products to people. They deserve more likes and respect brother
@adeshtamrakar
@adeshtamrakar Жыл бұрын
Thank you sir, From last 3 years I am using Google sheet for managing my portfolio. Its really helpful.
@pertneeru
@pertneeru Жыл бұрын
Cn u pl provide link for sheet
@snehaljoshi6995
@snehaljoshi6995 Күн бұрын
Can you demo option to track SIP on gsheet automated way
@MOHITRATNESH
@MOHITRATNESH Жыл бұрын
sheet ka link share krna chahiye tha sir
@padmajyotigogoi6778
@padmajyotigogoi6778 Жыл бұрын
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.
@ravijag73
@ravijag73 Жыл бұрын
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, 🙏
@ShivanandT-k4f
@ShivanandT-k4f Жыл бұрын
investment tracking made very simple.Thanks a lot
@meetanjaria3213
@meetanjaria3213 Жыл бұрын
Thank you Sir! Much Appreciated :)
@gyansagar1223
@gyansagar1223 Жыл бұрын
Dear Sir, Thank you 🙏 so much it really helps a lot to manage my portfolio.
@shubamdutta7599
@shubamdutta7599 Жыл бұрын
Consolidated account statement also available from nsdl or cdsl
@nachiket_daithankar
@nachiket_daithankar Жыл бұрын
I usually get it a month late.
@simrangupta9678
@simrangupta9678 13 күн бұрын
How to integrate duration of investment in this? Say I bought different stocks at different point of time in a year and I want to compare my portfolio with the benchmark now.
@HarishKumar-tj2sq
@HarishKumar-tj2sq Жыл бұрын
Very useful info
@swarnajyoti100
@swarnajyoti100 Жыл бұрын
Hello, the value of IGL and TCS not coming properly in google sheet after applying the code IGL and TCS respectively
@JPCorpIT
@JPCorpIT Жыл бұрын
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.
@ramyasri6093
@ramyasri6093 Жыл бұрын
Thanks for the idea sir. Please tell how to add CAGR
@ravirajphalle5478
@ravirajphalle5478 Жыл бұрын
Yadnya investment's i portfolio tracker is very good
@harishn5873
@harishn5873 8 ай бұрын
Nice video, Sir how can we compare our portfolio performance with index if we're doing SIP?
@debchak27
@debchak27 Жыл бұрын
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.
@subhasisroy2592
@subhasisroy2592 Жыл бұрын
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 👍
@PRanjitkumar001
@PRanjitkumar001 Жыл бұрын
What means IY?
@pratapnayadkar
@pratapnayadkar Жыл бұрын
@@PRanjitkumar001 Invest Yadnya
@amanhooda3876
@amanhooda3876 Жыл бұрын
Is it free or paid tool?
@TotalBasicgyan
@TotalBasicgyan Жыл бұрын
Great video
@piyushkriplani146
@piyushkriplani146 Жыл бұрын
Hi Sir, can you attache a sample excel with formulas, we need the same to put formula for the first time
@up1948
@up1948 3 ай бұрын
How to add brokerage ?😊
@krunalpatel4234
@krunalpatel4234 Жыл бұрын
THANKS....SIRJI
@shrikantbadge3978
@shrikantbadge3978 Жыл бұрын
ARE WARREN BUFFET JI, NSE CODE KAISE PRAPT KAREN YE TO BATAIYE.
@Amarjeetsingh-mj7zi
@Amarjeetsingh-mj7zi Жыл бұрын
Thank you very much sir
@amzadhossain4297
@amzadhossain4297 Жыл бұрын
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.
@SkyBlueCouch
@SkyBlueCouch Жыл бұрын
BSE stocks are not coming up, anything different to do for them?
@ajaykumarmaan1975
@ajaykumarmaan1975 5 ай бұрын
Faced same problem
@gprocky2010
@gprocky2010 Жыл бұрын
Bhau, jhakaas 👍🙏
@johnsonrajendran3334
@johnsonrajendran3334 Жыл бұрын
Very useful resource
@nagarajubandi3131
@nagarajubandi3131 Жыл бұрын
Thank you🙏🙏🙏 so much sir
@Chaitanyarana446
@Chaitanyarana446 Жыл бұрын
How to find average price for SIP?
@gurunguns06
@gurunguns06 Жыл бұрын
How to get average cost price of MF SIP?
@PavanKumar1997.
@PavanKumar1997. Жыл бұрын
What to do amd alter when we see Sell any amount of shares from the current holdings??
@anadiakshay
@anadiakshay Жыл бұрын
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 💡🙏
@rohitjain3497
@rohitjain3497 5 ай бұрын
@@anadiakshay Can u share the format with me. I want to create the same kind of data but not very proficient in google sheets.
@bhavneshparikh8283
@bhavneshparikh8283 Жыл бұрын
How To Downalod this File?
@mdileyasiti
@mdileyasiti Жыл бұрын
Great info thanks a lot
@shubhambansal1876
@shubhambansal1876 Жыл бұрын
HOW TO TRACK ONLY BSE LISTED SHARE IN GOOGLE SHEET?
@sachinpatil54321
@sachinpatil54321 Жыл бұрын
How to get 52 week high of mutual fund in sheet
@ManojKumar-ic1iy
@ManojKumar-ic1iy Жыл бұрын
MF tracking CAMS me bhi hota hai.
@simmifernandis3749
@simmifernandis3749 Жыл бұрын
52 w high low in mutual fund is not shown
@sanjoydatta3277
@sanjoydatta3277 Жыл бұрын
Sir, mein "google finance" use karta hoon to track my portfolio.
@mangeshgidde4626
@mangeshgidde4626 Жыл бұрын
its not happening. gives error in name.
@Sandeesh_Srikantam
@Sandeesh_Srikantam Жыл бұрын
Please try to post such portfolio tracker for mutual funds portfolio also.
@InvestYadnya
@InvestYadnya Жыл бұрын
It is for MF portfolio too
@Sandeesh_Srikantam
@Sandeesh_Srikantam Жыл бұрын
@@InvestYadnya I heard not all MFs have google tickers, so just asked if there is any other way.
@harshit_162
@harshit_162 10 ай бұрын
Dunia bhar ke link de rakhe hai bio mein. google sheet ka bhi de dete. easy rehta edit karna
@shagunb45
@shagunb45 Жыл бұрын
Sir can you share this excel sheet
@JPCorpIT
@JPCorpIT Жыл бұрын
No . Its a google sheet. You can also create even on mobile. Works seamlessly
@ChiragLawyer
@ChiragLawyer 8 ай бұрын
base sheet share kar dete.
@sinchannnn8690
@sinchannnn8690 Жыл бұрын
Try on value research
@prabhatshukla8611
@prabhatshukla8611 Жыл бұрын
Solution looking for a problem 😂
@prathamkadiyal3270
@prathamkadiyal3270 Жыл бұрын
♥️
@JatinArora9
@JatinArora9 Жыл бұрын
First view
@TheMohitMishraShow
@TheMohitMishraShow Жыл бұрын
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
@JPCorpIT
@JPCorpIT Жыл бұрын
Bhai pura video to dekho. Sab to bataya hai.
@siddhantjaiswal9115
@siddhantjaiswal9115 Жыл бұрын
Bhai khana bhi chaba k chahiye kya. Kuch toh mehnat karlo.
@ThaVexedCanadian
@ThaVexedCanadian Жыл бұрын
Excuse me sir, what language are you speaking speaking language what to you speaking to you while language?
How I track my investments in 2022 | Ankur Warikoo Hindi
18:00
Stock Market क्यों गिरा आज?
13:20
Yadnya Investment Academy
Рет қаралды 34 М.
SLIDE #shortssprintbrasil
0:31
Natan por Aí
Рет қаралды 49 МЛН
Their Boat Engine Fell Off
0:13
Newsflare
Рет қаралды 15 МЛН
Easy way to earn more returns than SIP | Buy the Dip Strategy | @PrateekSinghLearnApp
9:51
Build Your Own Stock Portfolio Tracker On Google Sheets
1:06:25
Think Stocks
Рет қаралды 657 М.
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
25:59
Brian Turgeon (bmturgeon)
Рет қаралды 1 МЛН
How to Smartly Save Taxes on Stock Market Gains? | CA Rachana Ranade
28:19
CA Rachana Phadke Ranade
Рет қаралды 1,7 МЛН
Excel Stock Portfolio Dashboard - FREE File Download
27:06
MyOnlineTrainingHub
Рет қаралды 532 М.
Build a Stock Tracker in Google Sheets: The Ultimate Guide
20:02
Ryan O'Connell, CFA, FRM
Рет қаралды 52 М.