How Do I Track Stocks? (w/ English CC) Use Google Sheets like a PRO | FREE & EASY தமிழ்
ฝัง
- เผยแพร่เมื่อ 26 ก.ย. 2024
- Welcome to our comprehensive guide on leveraging the power of Google Sheets to track stock prices and manage your investments like a pro! In this video, we dive deep into the world of finance and demonstrate how to harness the potential of the GOOGLEFINANCE formula to stay on top of your portfolio.
Join us as we explore the key features and benefits of using Google Sheets for investment tracking. We'll show you how to effortlessly retrieve real-time stock data, historical prices, and various financial metrics using the powerful GOOGLEFINANCE function.
The GOOGLEFINANCE formula is a game-changer when it comes to stock tracking. With a simple syntax, you can access a wealth of financial information. We'll guide you through the process of setting up the formula correctly, so you can retrieve real-time stock prices, market capitalization, dividend yield, price-to-earnings ratio, and much more. Say goodbye to manual data entry and welcome automated updates to your investment spreadsheet.
But it doesn't stop there! We believe in the importance of understanding the rationale behind our investment decisions. That's why we emphasize the significance of keeping detailed notes on why we buy specific stocks and when it's time to sell them. With Google Sheets, you can easily document your investment thesis, track your buying and selling decisions, and evaluate the performance of your portfolio over time.
Additionally, we demonstrate how Google Sheets can be a valuable tool for currency conversion. Whether you're dealing with international investments or simply want to keep an eye on exchange rates, we'll walk you through the process of seamlessly integrating currency conversion into your investment tracking sheet.
Don't miss out on this opportunity to enhance your investment management skills and gain valuable insights into your portfolio. Watch our video now and empower yourself with the knowledge to make informed financial decisions.
🔔 Subscribe to our channel for more finance and investment-related content!
📄 Download the templates and resources mentioned in the video from our website.
✍️ Share your thoughts and questions in the comments section below.
Time to take control of your investments and excel in the world of finance with Google Sheets! Let's get started. 💪
#GoogleSheets #InvestmentTracking #StockPrices #FinancialManagement #CurrencyConversion
#usefulinformationboosan #stockmarket #boosan #financeboosan
Join this channel to get access to perks:
/ @finance.boosan
_______________________________________________
Click here for more : bit.ly/3m4tygT
_______________________________________________
* Zerodha *
Commision free investment in Zerodha for Stocks/Mutual funds
Click this link to sign up now
zerodha.com/?c...
* Paytm Money *
My investing experience on Paytm Money has been great. You can try it too by opening a FREE Demat account.
Download now: paytmmoney.pag...
#usefulInformationBoosan
Useful Information Boosan, Personal Finance Tamil, Productivity, Self improvment
Boosan
I generally don't comment on youtube videos, but i wanted to take a minute to thank you for helping us understand how one can efficiently use their free resources and indirectly influencing people to understand why they are investing.
Great Job Cheers !! :)
Thank you Naveen for your positive words and support ❤️
Definitely we need a long video in this topic
Great job . Looking forward for that🎉
Awsome content brother we need another video about google finance sheet✨
Tq so much sir. Each and every minute in every videos are packed with extremely useful information that we cannot gather even if we spend hours in books and other sources....I cannot thank you enough for uploading these videos.. please upload more useful information sir
Kandipa full video podunga ji and daily expenses and bank account import yepdi panurthu yepdi oru oru categories pirikanum nu elame solu ga ji
Bro create a another video on indepth usage of Google sheets for investments in detail ... It's will be very helpful to everyone ... And your doing great job . All the best for your future ❤.
Great video brother about Google Sheets and Google Finance use case, thankyou for the English subtitles, helped a lot.
personally had searched about how people are tracking their investments, and nowhere found a convincing answer. After months I was somehow landed on this video.
Already using it, but adding comment is excellent point Boosan. Pls tell us more about Google sheets and individual stock picking in US
Wow. Nice session on Google finance. Our finance booster
Thank u boosan sir. This is stepup one of great knowledge for track analysis. But need the full elaborate video of excel sheet.❤
This was helpful. Yes, I would like to know more. Please post more videos on the same.
Brother we need a seperate video for Google sheets ... waiting for it 🤩❤
We need another video regarding Google finance ❤
We need more usage of googlefinance please do series of video about googlefinance
STOCKHISTORY for excel
Need detailed video in this topic ji🎉🎉🎉
Please upload a video of guiding us to create an excel sheet. definitely need a detailed explanations . thank you
It is very useful information. Surprisingly, I wanted to make the same comments of Mr. Naveen. (ie) Generally I don't comment on videos. But, this video made me to make comment. It is very useful information. It was searching for something like this. I recommended my friends your channel to gain personal finance knowledge. Thank you very much.
I was looking for this and got it easily from your channel.
Please make a detailed video. If already done provide the link. I have made a mutual fund tracker using google finance. By using this tracker I will come to know the day end value at 3.30 PM itself. Whereas most of the mutual funds update the day end value at the midnight only. Thank you so much.😀
Great job
❤ good info bro, waiting for next google sheet video
This piece is pretty interesting.. Worthwhile. Looking for 2nd view. Thanks.
Glad you liked it!
Brother please create a detailed video for Google sheets to use it for stocks
We want lengthy detailed video sir
Yes boosan, pl share networth monitoring related sheet videos
Yes. We know it
Thanks for the video, Kindly share separate video about the Google shhet usage.
Interested bro. Please do detailed video about Google finance about your investments...
Will make a video on it 💯
@@finance.boosan thanks for the reply bro. Keep growing. We will keep learning something new from you...
Semma tool can you post a separate video on Google sheets
Ok Vishal sir
Excepting a detailed video on google finance.
Complete and full video potunga bigener ku puriuramari
Obviously yes
kindly upload time based historical data collecting using google sheets
Yes sir really helpful ❤❤❤ I want tracking sheets link.. please share
I Request you to make a video for selecting a stock with good price to buy and estimated return using historical data in google sheet
Yes pls, Google sheet for personal finance & net worth calculation
Surely we want ur personal finance google sheet video bro
Will make a video on it 💯
Thank you boosan good video need investment tracking video by using google finance
6:19 Yes, pls share it.
5:49 - pls share this as well - importing bank statements
I am doing it religiously too for past 2 years. But manually.
May you can share your approach of tracking expenses in google sheets. Would be very useful
Will make a video on it
Super. Please more videos for using hand-on. Thanks
Super bro 🔥
Thank you Boosan
Definitely need more detail bro❤
Please brother if possible add subtitles it helps me a lot i m from north india it is bit difficult for me to understand the language but still i could manage but love if you add subtitles 😂❤
Added English cc for you bro ❤
@@finance.boosan love you bro ❤️
நன்றி
நிறுவனங்கள் விலை Google sheets பயன் படுத்தி ஒரு குறிப்பிட்ட நாளில் அதன் விலை காணும் formula கூறுங்கள் ஐயா..
Day to day expenses and , wealth , bank statement tracker template send pannuga bro
Yes I want explain and need this explanation
Yes share
Amazing video bro... 🎉
Thanks bro for knowing Google finance... Very useful video bro. Please do a video on doing personal finance with Google sheets
I'm always waiting for your content
Hi, Yes please make a video on analyzing bank statements on google sheet
Need more information 😊
Bro binary trading pathi explain pannuka bro. TH-cam ku vanthale binary trading suggestion naraya varudhu bro plss explain it.
Avoid it straight away, Binary Trading is also known as all-or-nothing contracts. If you win you make money, else you lose your entire investment. Stay away from any kind of speculative trading.
Your expense calculation in Google sheets podunga bro.
Please do a video on sheets tracker bro
Offcourse need ur personal sheets video 😊
Semma Boosan vera level 🔥
thank u bro very useful information its new information for me
Please try to share your Personal finance tracking
Very useful video bro. Please do a video on doing personal finance with Google sheets
bro ,how to get specific time trade price see ,please konjam solunga bro
Make a video series about this topic.
Great sir
Thank you sir nice explanation
Pls create a video on how u track your expenses in google spreadsheet
Expense Tracker : th-cam.com/video/MvaR-DoRgtA/w-d-xo.html
Hi bro
Na IND money use panni us stock la invest pannittu irukka
But us stock la qqq searies 1 etf la investment pandra
Indha etf la sip format la invest pannamudiyala and indha etf la investment panna best results varuma
Please reply pannunga bro 😊
super. learnt a new topic today. best wishes
Part 2 please
We need long video
Need video for complete guide bro 🔥
Tharam🔥 bro 🥳 Hat's off
how to buy US stocks and can we buy mothilal oswal s&p 500 index fund ?
pls make video of these
Need another video
Pl make a video on NASDAQ & S&P500 index fund (US market) , explain why all Indian amc are investing thro invesco ETF ?
Pfc can't find in Google sheet
We Need a detailed video on google sheets bro...
Thanks for this video and kindly make full video about this and attach your sheet template if possible
Thanks for your genuine efforts to transfer your knowledge to the public.. kudos!
I'm having a doubt in tracking. The same tracking which you are showing in the video can be done in google finance website itself right ? Instead of having it in google sheets? Both give us same projection? Please do a comparison video on this topic.
Thanks
Yes we need it
Anna ithu pudhusu Anna ithu pudhusu
Doing well your video 👏
Yes boosan pls share net worth video
bro very useful information. please tell about more
anna vedio podunga more about google sheets we are waiting
Yes bro show me your protfilio bro...
Bro kindly ask some video's for bond investment
Investing in Bonds | Risks, Rewards & Everything you need to know | A Beginner's Guide
th-cam.com/video/rISzQMoE9nw/w-d-xo.html
How to get BSE stocks in google sheets
Person finance share podunga Google sheet la eppati maintenance panna
Bro etha Google sheets vagi live banknifty price pannalama CE and PE
Wonderful video❤Very useful 👌🏼
Make a video on your Google finance sheet bro
google sheet use pandrathu bathil google finance app download panalame !
what is the diference here?
xirr calculation for exiting a group of stocks. How to calculate
We only need the transaction amount and the date of each transaction. With this data, we can calculate the XIRR. This information should be available in our stock broker's application.
how to get price of STOCK FUTURE PRICE?
Yes make a new detail video
Voi mattum tha bro
Bro next video plz