@@drawingangel21 Exactly my question is same. I was making a journal myself but I got stuck at this point. Like do we need to create new rows in this case or update the quantity and price in the existing row of that stock?
DONT WORRY ABOUT THE PEOPLE COMPLAINING ABOUT THE NOISE, YOU ARE DOING THEM ALL A GREAT FAVOR!!!! PLEASE ADD SOME MUTUAL FUND TRACKING TO THIS OR ANOTHER VIDEO HELPING US ADD OUR MUTUAL FUNDS TO THIS SPREADSHEET TO ALSO TRACK, GREAT WORK AND THANKS
Thanks for the portfolio!! You have created a portfolio only for purchasing of stock, how can we track the stock that we have sold at a certain period with a updated total investment or profit/loss. Please update with this option too, so that it'll be much more helpful.
Stock Portfolio Tracker is an effort at creating an online spreadsheet with Live market data that will let a stock investor 1) Monitor your stocks with live market data in your portfolio. 2) Track stock purchase/sale by transactions. 3) Transactions compatible includes purchase, sale, dividend, bonus and stock splits . 4) Aggregate transactions to individual stocks. 5) Aggregate individual stocks to portfolio. 6) Factors in Bonus, Split, Rights Issue, Dividend, Brokerage. 7) Charts for easy data interpretation. 8) Sector/Industry analysis. 9) Analyse stock price drawdowns for a max 10 years. 10) Maintain watchlist. 11) For Best results to view tracker use PC or mobile using Google Sheet app). 12) User input is only required in Ref sheet & Transaction sheet. 13) Customize tracker as per country specific Stocks/Investor requirements. eg India, US, Canada, Europe, Singapore, Japan etc bit.ly/2FdUDtj
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Amazing information. I was looking for a Portfolio Management program and thanks to you my problem is solved. Keep up the good work. God bless you Kritesh.
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Stock Portfolio Tracker is an effort at creating an online spreadsheet with Live market data that will let a stock investor 1) Monitor your stocks with live market data in your portfolio. 2) Track stock purchase/sale by transactions. 3) Transactions compatible includes purchase, sale, dividend, bonus and stock splits . 4) Aggregate transactions to individual stocks. 5) Aggregate individual stocks to portfolio. 6) Factors in Bonus, Split, Rights Issue, Dividend, Brokerage. 7) Charts for easy data interpretation. 8) Sector/Industry analysis. 9) Analyse stock price drawdowns for a max 10 years. 10) Maintain watchlist. 11) For Best results to view tracker use PC or mobile using Google Sheet app). 12) User input is only required in Ref sheet & Transaction sheet. 13) Customize tracker as per country specific Stocks/Investor requirements. eg India, US, Canada, Europe, Singapore, Japan etc bit.ly/2FdUDtj
Sir you have made life simple - appreciate your hard work to explain in simple words - just one question if I add purchase date and exit date - can you guide me how can I calculate number of days
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
I'm sure this is helpful, but why do you have that beat heavy music throughout the whole thing? I couldn't listen to it after a few minutes because the music was giving me a headache.
@@Wall.Street.AV. Yep. Of course. Was just a suggestion to get more folks to stay on the video longer and learn from your knowledge without the distraction.
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Hi, is there a command to pull data for dividend that each company gives out? Or I have to take just percent per year and add it to market value of stock?
Wow, thank you so much for this help. What if you decide periodically to invest more money into the same stocks in your portfolio? Would you have to create a new sheet because the buy price is no longer the same? I might be silly for asking this.
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Thank you for the video. If you do not mind suggest one thing for your future videos is that please consider eliminating background music. It is very annoying and torturing after a few minutes. Whoever watching your videos or any other videos, they can play their own music if they need to. Thanks again.
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month. (elvishercules48@gmail.com
Thanks for this video. Please explain how to track dividend income on spreadsheet..?? If possible please make video on dividend income tracker. Thanks..!!
HI Mr.PRITESH , I WANT TO MAKE SHEET SHOWING 24 MONTH CLOSING PRIZE, AVERAGE OF 24 MONTH , ALERT ON THAT PRIZE ,FOR EX ;(TODAY IS 20-08-2020, I WANT TO MAKE A SHEET STARTING DATE 01--01-2018 AND 24TH MONTH DATE IS 31-12-2019 , MONTHLY CLOSING RATE AND AVERAGE OF THE CLOSING RATE , WHEN MARKET IS ON THE SHARE THAT SHOW AVERAGE PRICE SHOULD BE FLASH.) CAN YOU HELP ????
Yes, I use a simple spreadsheet to track the dividends. Just have to enter ex-dividend date and dividend amount, and everything else adds up in the same tracking sheet. Mail me here - kritesh [at] tradebrains [dot] in and I'll share it with you. Cheers!!
Thanks for sharing and demonstrating this sheet. I would like to know if there is any way by which we can make it that way that we record multiple transactions in a day like, buy 10 in morning, sold 5 in afternoon, at the same time buy 10 more and the overall position.
Thanks for posting, very helpful very informative video. Just to give kindly feedback here, hope you don't mind, that techno dance music in the background - oh it is so so terrible, awful. In future would be much better without that added. Thanks again.
Great video, I learnt so much! Thank you. I have a question... I have a few stocks in CAD $, how do I connect to Toronto's stock market so that I can see it in the value I bought it in instead of US $? Thank you so much!
Hi. You have to use the exchange code before symbol to get data from any stock exchange. For example, use TSE:AC to get data for Air Canada. Here 'TSE:' is exchange code and 'AC' is company symbol. I hope it helps.
google finance is unable to provide data for JHS and BEL of NSE as both id's are present NYSE aswell its giving priority to it and giving those data,any work around?
Helpful video, but the music was really quite annoying. I couldn't hear what you were saying sometimes, especially with your accent. I had to rewind a few times. Thanks for the video
Thank you. Very helpful. I just tried to add (TCS )Tata Consultancy Services Limited. but its adding a different company from NYSE: The New York Stock Exchange. both company use TCS. any method to select TCS from NSE
Bro i have a problem with this, it is not taking correct data in some cells like some of the 52 week high are wrong or some times it shows wrong price of stock. How to solve that problem??
Hi Sahil. The data on google sheets are provided by Google itself. We never faced the problem of getting the wrong data regarding 52-week-high data. Can you share which stock you were searching?
Download free template here: docs.google.com/spreadsheets/d/1u8LDPF-xliJ-HJoYBLhFG8ddPMn-AhGZWT65FATYM1Q/edit#gid=1115838130
If I bought these same stocks at different times and different prices, do I make input them in a new row?
@@drawingangel21 Exactly my question is same. I was making a journal myself but I got stuck at this point. Like do we need to create new rows in this case or update the quantity and price in the existing row of that stock?
Thanks!
THIS IS MY 3RD VIDEO, BUT MY CONCEPTS ARE CLEAR. NOW I CAN MAKE ON MY OWN. THANKS BUDDY.
THANK YOU FOR THE WONDERFUL INFORMATION😍😍😍😍😍😍
DONT WORRY ABOUT THE PEOPLE COMPLAINING ABOUT THE NOISE, YOU ARE DOING THEM ALL A GREAT FAVOR!!!! PLEASE ADD SOME MUTUAL FUND TRACKING TO THIS OR ANOTHER VIDEO HELPING US ADD OUR MUTUAL FUNDS TO THIS SPREADSHEET TO ALSO TRACK, GREAT WORK AND THANKS
Fantastic video. resolved my problems in one shot. thank you so much. Regards
Great Video !! Thank for this great tutorial my man !
Thank you Indian Tutorial Guy on UA-cam
This is amazing! Thank you so so much you are saving lives.
This is exactly what I was looking for...thanks a lot
Thanks bro. It is really helpful.
Excellent video.
Good work bud.
Though very simple video its very useful for investment tracking...thank u dear.
Thank you 'Brains !
Thanks for the portfolio!!
You have created a portfolio only for purchasing of stock, how can we track the stock that we have sold at a certain period with a updated total investment or profit/loss. Please update with this option too, so that it'll be much more helpful.
Awesome thanks dude
THANK YOU SOO MUCH!!!
Very awesome! I had no idea about this
Stock Portfolio Tracker is an effort at creating an online spreadsheet with Live market data that will let a stock investor
1) Monitor your stocks with live market data in your portfolio.
2) Track stock purchase/sale by transactions.
3) Transactions compatible includes purchase, sale, dividend, bonus and stock splits .
4) Aggregate transactions to individual stocks.
5) Aggregate individual stocks to portfolio.
6) Factors in Bonus, Split, Rights Issue, Dividend, Brokerage.
7) Charts for easy data interpretation.
8) Sector/Industry analysis.
9) Analyse stock price drawdowns for a max 10 years.
10) Maintain watchlist.
11) For Best results to view tracker use PC or mobile using Google Sheet app).
12) User input is only required in Ref sheet & Transaction sheet.
13) Customize tracker as per country specific Stocks/Investor requirements. eg India, US, Canada, Europe, Singapore, Japan etc
bit.ly/2FdUDtj
hi can it be use for tracking mutual funds also??
hi, great presentation !!! , do we have any option or process to find Short Term Profit performance shares.
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
Thank you a million. Great job. Was looking for such a sheet for a long time. God bless.
Wonderful. How to handle share splits (1-to-1 allocation) here in this sheet?
Big thumbs up thank you very much
Knowledge gain
Regards
Amazing information. I was looking for a Portfolio Management program and thanks to you my problem is solved. Keep up the good work. God bless you Kritesh.
thank you for demonstrating. explained it very clearly. More power to you
Is it possible for dividend yield formula in google sheets to work for India stocks?
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
I was searching for this for so long....Thanks a lot buddy...
You are welcome.
Stock Portfolio Tracker is an effort at creating an online spreadsheet with Live market data that will let a stock investor
1) Monitor your stocks with live market data in your portfolio.
2) Track stock purchase/sale by transactions.
3) Transactions compatible includes purchase, sale, dividend, bonus and stock splits .
4) Aggregate transactions to individual stocks.
5) Aggregate individual stocks to portfolio.
6) Factors in Bonus, Split, Rights Issue, Dividend, Brokerage.
7) Charts for easy data interpretation.
8) Sector/Industry analysis.
9) Analyse stock price drawdowns for a max 10 years.
10) Maintain watchlist.
11) For Best results to view tracker use PC or mobile using Google Sheet app).
12) User input is only required in Ref sheet & Transaction sheet.
13) Customize tracker as per country specific Stocks/Investor requirements. eg India, US, Canada, Europe, Singapore, Japan etc
bit.ly/2FdUDtj
very good instantly helpful
Amazing job... Please keep on posting more helpful videos 👏👏
Sir you have made life simple - appreciate your hard work to explain in simple words - just one question if I add purchase date and exit date - can you guide me how can I calculate number of days
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
Quick question, how can you add the "day gain in %" and also in $$$ to the list?
Very Nice Video.
is ther any way we can get the Qty Bought and buy price as well automatically
Amazing explanation! Great work! Learning a lot from you! Keep posting new videos.
Thanks so much you are awesome
I'm sure this is helpful, but why do you have that beat heavy music throughout the whole thing? I couldn't listen to it after a few minutes because the music was giving me a headache.
IF YOU DONT LIKE THE MUSIC YOU ARE MORE THAN WELCOME TO GO SOMEWHERE ELSE.
@@Wall.Street.AV. Yep. Of course. Was just a suggestion to get more folks to stay on the video longer and learn from your knowledge without the distraction.
@@dangingert some people dont mind the music since it gets rid of the white noise from the mic
Sir steel authority of India. Sail is the short form but Google is finding different company i.e. Sailpoint technology an us based company
Sir one question I want to add tcs in portfolio but it shows tcs of new York stock exchange so what should I do
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
@@peterkelvin8351 🙏
But what happens when i buy more of the same stocks with a different price in the future. How do we add it in the excel?
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
THANK YOU SO MUCH FOR THE HELP BRO. I JUST GOT MINE SET UP.
Hi, is there a command to pull data for dividend that each company gives out? Or I have to take just percent per year and add it to market value of stock?
Wow, thank you so much for this help. What if you decide periodically to invest more money into the same stocks in your portfolio? Would you have to create a new sheet because the buy price is no longer the same? I might be silly for asking this.
Change the buying price to average buying price.
Remember, it's a weighted average.
kudos great job
I found this very helpful. But Can you please check the Template, It's showing errors at multiple places.
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
Breakthrough your mind! Thanks for great video!
Can we use this formula for mutual fund investments?
Thank you!!! you have done amazing job with this vidz.... i have learned alot
Thank you bud. I'm tired of writing my data by hand. It's time consuming
awesome..thanks a lot bro...
Nice educational video...how to add same ticker symbol listed on two different platforms. Eg. TD is listed on TSX as well as NYSE.
Thank you for the video. If you do not mind suggest one thing for your future videos is that please consider eliminating background music. It is very annoying and torturing after a few minutes. Whoever watching your videos or any other videos, they can play their own music if they need to. Thanks again.
good work sir, and thanks for the template. :)
How do I add sales to the sheet and track overall earnings?
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
where is brokerages and PAT?
Most experienced traders like Mr Elvis Hercules, would prefer to get the proper skills to analyze price charts in order to make their own trading decisions, but many traders, especially amateur traders, are still wondering really whether they accelerate their successful trading using only signaling services, don't get me wrong. Signals are good, especially if you find the right one, but it would also be wise if traders can analyze price charts positively and accurately and good trading results. If we take a close look at some of the main reasons people cannot make money investing / trading online. whether it is trading stocks, binary options, forex or cryptocurrencies, you will find that the problem is that traders are lazy and too dependent signaling services, and also do not understand the trade before starting it. So just in case it is best if traders, especially those who are still learning and practicing trading, should know these tips before entering any online investment scheme: 1. Use a signaling service. ... 2. Learn to use technical indicators. . 3. Trade stocks before trading binary options trading security. .. 5. Buy options of the right length for your trading style. For additional tips and trading strategies that can bring you $ 20-40 thousand per 4. Track your performance for each option month, contact him by mail, as He is ready to show interested traders, both beginners and professionals, how to trade with confidence and achieve success. .. and amateurs how to trade confidently and make good profits using strategies that fetches $ 20k$ 60k per month.
(elvishercules48@gmail.com
can you please explain how to use average volume i.e. =googlefinance("nse:"&a2, "volumeavg")
Thanks for this video.
Please explain how to track dividend income on spreadsheet..??
If possible please make video on dividend income tracker.
Thanks..!!
Awsome! Thanks :)
Excelent video, can we find the sector of each company with formula?
Very good
Brilliant! Is there any way to make a chart to show the changing data?
HI Mr.PRITESH , I WANT TO MAKE SHEET SHOWING 24 MONTH CLOSING PRIZE, AVERAGE OF 24 MONTH , ALERT ON THAT PRIZE ,FOR EX ;(TODAY IS 20-08-2020, I WANT TO MAKE A SHEET STARTING DATE 01--01-2018 AND 24TH MONTH DATE IS 31-12-2019 , MONTHLY CLOSING RATE AND AVERAGE OF THE CLOSING RATE , WHEN MARKET IS ON THE SHARE THAT SHOW AVERAGE PRICE SHOULD BE FLASH.) CAN YOU HELP ????
is to possible to do that with excel?
Super information,,,I am from sri lanka Unable track Sri Lanka stocks fro google finance why?
Very nice. Can you pls help me in downloading the Google sheet and get it sync the same file in local desktop
Nice
Nice, but if i need to compare my portfolio with benchmark(nifty50), how can i do it.
Sir, how can I compare my portfolio performance with index
Did you have a good way to track dividends ,ex dividend dates ,dividend income specifically for someone who is using m-finance (averaging in daily )
Yes, I use a simple spreadsheet to track the dividends. Just have to enter ex-dividend date and dividend amount, and everything else adds up in the same tracking sheet. Mail me here - kritesh [at] tradebrains [dot] in and I'll share it with you. Cheers!!
Thanks for sharing and demonstrating this sheet.
I would like to know if there is any way by which we can make it that way that we record multiple transactions in a day like, buy 10 in morning, sold 5 in afternoon, at the same time buy 10 more and the overall position.
Thank you for posting this. This is great 👍🏼. How do I update the price when I buy more shares of same company. What buying price should I put ?
Your Awesome! Thanks for this!
Excellent video Sir. Is possible to add a sheet for tracking day by day close price in order to generate portfolio graphs?
Awesome... !!!
Can we do it for Mutual Fund...
Please let me know.
Regards,
Thank you so much! I’m glad I didn’t have to download an app to do this for me!!! 😀
Thanks for posting, very helpful very informative video. Just to give kindly feedback here, hope you don't mind, that techno dance music in the background - oh it is so so terrible, awful. In future would be much better without that added. Thanks again.
Do you have such video on Stock Options??
Great video, I learnt so much! Thank you. I have a question... I have a few stocks in CAD $, how do I connect to Toronto's stock market so that I can see it in the value I bought it in instead of US $? Thank you so much!
Hi. You have to use the exchange code before symbol to get data from any stock exchange. For example, use TSE:AC to get data for Air Canada. Here 'TSE:' is exchange code and 'AC' is company symbol. I hope it helps.
Really helpful..
Hi, good information- where do you get the information on dividend?
Thanks in advance-
Isme industry kese add kre sir
Can you do this with Crypto?
Please let me know how to get the name of the company through ISIN code in Google Sheet
Hi Dude
This is great. But for some reason NIFTY and NIFTY Benchmark not working. Any idea why ?
Sir, please guide me how to convert this portfolio to Google Sheets, make in standalone PC by MS Excel and then transfer Excel file to mobile. 🙏🙏
google finance is unable to provide data for JHS and BEL of NSE as both id's are present NYSE aswell its giving priority to it and giving those data,any work around?
Pls ignore,got the work around, add it like NSE:JHS and it shows the data correctly
How can i track my monthly and yearly change
And weightage of company?
Thank you! I downloaded and tried to edit but I need access from you. How do I get this access?
You do not need access. Just make a copy of the sheet. Go to File--> 'Make a copy' and then you can edit the sheet.
@@TradeBrains i tried and was doing for all stocks listed on NSE(around 1600 stocks) but i found that price of some stocks were incorrect on the sheet
Helpful video, but the music was really quite annoying. I couldn't hear what you were saying sometimes, especially with your accent. I had to rewind a few times. Thanks for the video
Thank you. Very helpful. I just tried to add (TCS )Tata Consultancy Services Limited. but its adding a different company from NYSE: The New York Stock Exchange. both company use TCS. any method to select TCS from NSE
try NSE:TCS
@@atuldebadutta possibile to get from mcx gold price? To track gold bond
Thank you! It is helpful!
remove the high-volume music if you can. It is too loud as background music. Everything else is great. Thanks for the template.
How to add BSE and NSE stocks in same sheet ?
Bro i have a problem with this, it is not taking correct data in some cells like some of the 52 week high are wrong or some times it shows wrong price of stock. How to solve that problem??
Hi Sahil. The data on google sheets are provided by Google itself. We never faced the problem of getting the wrong data regarding 52-week-high data. Can you share which stock you were searching?
Helpful thing bud
What's with the music in the background? I find that very distracting because it's much more high-speed than the content of the video.
thank you, please update dates for the US mm/dd/yyyy. also , usd
does this work on stocks in non US markets?
Yes! But you have to use the stock exchange symbol as prefix before the ticker. Read the video description.
how to auto update 5ma 10 ma 20 ma 50 ma value in google excel sheet
i like your music. what is the name?
God bless!
does this update by itself or do you have to keep updating it
Have you found out