No video

Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets

  Рет қаралды 956,386

Brian Turgeon

Brian Turgeon

Күн бұрын

Easily build a complete stock watchlist in Google Sheets.
Here's my template for this sheet:
docs.google.co...
Links to referenced videos can be found below:
GOOGLE FINANCE:
• USING GOOGLE FINANCE T...
CUSTOM # FORMAT (POS. OR NEG.):
• FORMAT POSITIVE AND NE...
CUSTOM # FORMAT (LARGE NUMBERS):
• CUSTOM NUMBER FORMATTI...
INDEX FUNCTION:
• INDEX FUNCTION TUTORIA...
IF ERROR:
• FIXING ERROR MESSAGES ...
ALTERNATING COLORS:
• ADDING ALTERNATING COL...
REFERENCE CELLS:
• REFERENCE CELLS With T...
#GoogleFinance #StockWatchlist #StockTracker

Пікірлер: 795
@brianturgeon
@brianturgeon Жыл бұрын
Here's the link for my template! Feel free to use it for yourself! docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV7ANkBZK027RI_CouSsDM0XfmQ/edit?usp=sharing
@About__Crypto
@About__Crypto Жыл бұрын
Hello. Can You tell me, please? Is it possible to do it with CRYPTOCURRENCIES... Can You Help Me PLEASE?
@mrevosus
@mrevosus Жыл бұрын
Pretty cool, thanks!
@ekonomia2040
@ekonomia2040 Жыл бұрын
i cant edit it
@lloydfisher1328
@lloydfisher1328 Жыл бұрын
Question: can you tell or show, how to make the cell change color (red or green) based on days progress? The green or red text is fine but it would be much easier to follow when the entire cell is either red or green. thanks much
@edwardmccole2121
@edwardmccole2121 Жыл бұрын
This file shared can not be copied for own use
@greenquake11931
@greenquake11931 11 ай бұрын
The key to big returns is not big moving stocks. It's managing risk in relationship to reward. Having the correct size on and turning your edge as many times as necessary to reach your goal. That holds true from long term investing to day trading.
@helenoliver4838
@helenoliver4838 11 ай бұрын
May I ask which stocks are good? I've been looking at a few different ones but want other opinions as well.
@theresagarcia1218
@theresagarcia1218 11 ай бұрын
@@helenoliver4838
@helenoliver4838
@helenoliver4838 11 ай бұрын
@@theresagarcia1218 Are you in touch with a Financial-Adviser ? is your experience much better than investing on your own?
@theresagarcia1218
@theresagarcia1218 11 ай бұрын
@@helenoliver4838 Yes I am in touch with a Financial Adviser and for the past 6months, I've been able to stay afloat the market crashes and I've watched my portfolio grow by over 40% these past few months.
@helenoliver4838
@helenoliver4838 11 ай бұрын
@@theresagarcia1218 Wow, that's remarkable, who is your FA and how do you suggest I reach out to him/her?
@84gaynor
@84gaynor 4 ай бұрын
While this provide an actual explanation of the market and how you value stocks. After buying stocks for just over 10 years, i'm still struggling to make gains. How do i adjust or revamp my $2M portfolio? should i consider some defensive investments?
@sommersalt88
@sommersalt88 4 ай бұрын
Agreed, my portfolio is well-matched for every market season yielding 85% from early last year to date. I and my advisr are working on a 7 figure ballpark goal, tho this could take another year. IMO, financial advisors are the most sought-after professionals after doctors.
@gagnepaingilly
@gagnepaingilly 4 ай бұрын
great gains there! mind sharing details of your advisor pleas? i've started gaining more cash flow with my employment and looking at putting money into stocks and alternative assets that can help build wealth over time
@sommersalt88
@sommersalt88 4 ай бұрын
She goes by ‘’Jennifer Leigh Hickman’ I suggest you look her up. To be honest, I almost didn't buy the idea of letting someone handle growing my finance, but so glad I did.
@gagnepaingilly
@gagnepaingilly 4 ай бұрын
Thank you for sharing, I must say, Jennifer appears to be quite knowledgeable. After coming across her web page, I went through her resume and it was quite impressive. I reached out and scheduled a call
@khuti007
@khuti007 3 ай бұрын
10yrs, no gains. WTF Its been the biggest bull market EVER. You may have missed it, better luck next time. Hope your young.
@ExxonMobilCompany
@ExxonMobilCompany Жыл бұрын
These market uncertainties, which got the best of me in 2020 and left me holding worthless positions in the market, are the reason I don't base my market judgments and decisions on rumors and heresays. I had to completely revamp my portfolio with the help of an advisor before I started seeing any notable results in my portfolio, and I've been working with the same advisor and have scaled up 750k.
@marcelrobert9569
@marcelrobert9569 Жыл бұрын
Do not forget to keep this in mind. There are happy and unhappy days. Although it's a zero-sum game, remember to diversify your holdings so that when one performs poorly, the others do as well. Furthermore, spend carefully and invest wisely. Hiring a skilled specialist with a platform that offers a variety of investing possibilities can help you do this. You may even get more by doing this, and you leave little space for regrets.
@obodoaghahenry9297
@obodoaghahenry9297 Жыл бұрын
@@jamesvigor6409 Will you kindly suggest a professional with a range of investment options? This is very unusual, and I look forward to hearing from you.
@robertlucas8288
@robertlucas8288 Жыл бұрын
@@jamesvigor6409 Insightful... I curiously looked up her name on the internet and I found her site, thanks for sharing
@stjepanhauser7595
@stjepanhauser7595 Жыл бұрын
Buying a stock is easy, but buying the right stock without a time-tested strategy is incredibly hard. Hence what are the best stocks to buy now or put on a watchlist? I’ve been trying to grow my portfolio of $260K for sometime now, my major challenge is not knowing the best entry and exit strategies... I would greatly appreciate any suggestions.
@jasonabidin4448
@jasonabidin4448 5 ай бұрын
TIMSYKES
@cuddyb9631
@cuddyb9631 Жыл бұрын
Roughly £120k in my portfolio are in tech/TSLA stocks, can I get an advice on any other stocks that I can acquire to diversify my reserve across multiple markets while creating a comprehensive portfolio allocation that balances my concerns of risk aversion and returns that meet yearly inflation.
@KingDavid-jj7tk
@KingDavid-jj7tk Жыл бұрын
You need to hire a financial advisor to help you diversify your portfolio by including Mutual Funds, Etf's, the 11 GICS groups, inflation-indexed bonds, and stocks of companies with reliable cash flows rather than growth stocks, where prices were based on future prospective earnings.
@martinerJuhel1
@martinerJuhel1 Жыл бұрын
I feel sad that even though I am investing, I don't have the brain power to dig through how each company is doing, is this a good time to buy stocks or not, my reserve of $450K is laying waste to inflation and I don't know what to do at this point tbh, I need solid data on market trajectory
@EvanQuiel4
@EvanQuiel4 Жыл бұрын
It all depends on how long you're willing to hold for stocks might likely tank further, but making serious gains in this downtrend wouldn't be a problem if you're an expert
@worldclass097
@worldclass097 Жыл бұрын
@@freddiethesoundboy4 think you could recommend this coach that guides you, I've been looking into advisors myself and I'd really need guidance to scale through
@georgezap762
@georgezap762 Жыл бұрын
Invest in real estate and earn passive income.
@killumination87
@killumination87 Жыл бұрын
Be a private lender, register your security interest. earn HIGH interest payments for 1 year. get paid out. I dont know much about finances take it with a grain of salt..
@beefcake1876
@beefcake1876 Жыл бұрын
cars and women
@TheElevenBravo
@TheElevenBravo Жыл бұрын
Great video, great narration, great insights! - No BS fillers, straight-to-the-point instructions! Truly amazing work, sir, and I thank you so much for it, Brian.
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@JefferyDuns
@JefferyDuns 6 ай бұрын
I'm mostly in cash and waiting for the stock market to re-level on the reality of our situation. Or is gold the best pick to avoid a crunch and maximize my savings I'd love to hear your opinions.
@PhilipDunk
@PhilipDunk 6 ай бұрын
we are living in a command economy. no way I'm buying into a market where the indexes are at all time highs
@hankmarks69
@hankmarks69 6 ай бұрын
reminds me of the guy who sold all his stocks in like 1928 and everyone was calling him a chump, then the market crashed and he bought back in after a few years and made a killing, whereas many people got burnt
@PatrickLloyd-
@PatrickLloyd- 6 ай бұрын
The issue is most people have the “I want to do it myself mentality” but not equipped for a crash. Ideally, advisors are perfect reps for investing jobs and at first-hand experience, my portfolio has yielded over 300%, summing up nearly $1m, since covid outbreak to date.
@Dannyholt33
@Dannyholt33 6 ай бұрын
massive gains! mind sharing details of your financial advisr please? i've started gaining more cash flow with my employment and looking at putting money into stocks and alternative assets that can help build wealth over time
@PatrickLloyd-
@PatrickLloyd- 6 ай бұрын
“Melissa Rose Francks’’ You can easily look her up, she has years of financiaI market experience.
@michaelschiemer3
@michaelschiemer3 5 ай бұрын
My portfolio for the past 30 years has always been self managed and I own 3 shares of Berkshire Hathaway Class A stock (BRK:A) which I bought in at about $17,000 during the mid 90s, I’m currently liquidating some of these positions to incoporate new Gen. Stocks, but am I better off re-investing into Gold as it seems stocks are a little too unstable right now.
@Rachadrian
@Rachadrian 5 ай бұрын
Invest in real estate, ETFs and high-yield savings account.
@Quasoncaviness2
@Quasoncaviness2 5 ай бұрын
Just buy Gold and protect your assets, the stock market is a rollercoaster.
@Dantursi1
@Dantursi1 5 ай бұрын
@@Quasoncaviness2 The market is not necessarily a rollercoaster if you know your way around the market, there are various opportunities in the present market to accrue good profit, If you are not too savvy with the market, just buy and hold on strong companies with good earnings, or consult with advisors on ETFs and actively managed funds.
@CindyValenti
@CindyValenti 5 ай бұрын
who is your financial coach, do you mind hooking me up?
@Dantursi1
@Dantursi1 5 ай бұрын
Certainly, there are a handful of experts in the field. I've experimented with a few over the past years, but I've been stuck with Melissa Rose Francks for about five years now, and her performance has been consistently impressive.
@AdamMontoya6326
@AdamMontoya6326 6 ай бұрын
I will be forever grateful to you, you changed my entire life and I will continue to preach on your behalf for the whole world to hear you saved me from huge financial debt with just a small investment, thank you Anna Williams
@julienolke-vx5lk
@julienolke-vx5lk 6 ай бұрын
The first step to successful investing is figuring out your goals and risk tolerance either on your own or with the help of a financial professional but is very advisable you make use of a professional.
@LiamMason206
@LiamMason206 6 ай бұрын
Wow. I'm a bit perplexed seeing her been mentioned here also Didn’t know she has been good to so many people too this is wonderful, i'm in my fifth trade with her and it has been super.
@JohnAlbert209
@JohnAlbert209 6 ай бұрын
What impresses me most about Anna Williams is how well she explains basic concept of winning before actually letting you use her trade signals. This goes a long way to ensure winning trades.
@DonaldHuge
@DonaldHuge 6 ай бұрын
Isn't that the same Mrs Anna Williams that my neighbours are talking about, she has to be a perfect expert for people to talk about her so well
@karenrobinson598
@karenrobinson598 6 ай бұрын
I'm new at this, please how can I reach her?
@CATFISHTYLER
@CATFISHTYLER 7 күн бұрын
I can't even imagine how long it must have taken you to learn all of this. It would take a college course to figure this all out. It took me over three hours to complete my charts and I had to pause and rewind the video many many times to make sure I got it all down correctly. Amazing video and I'm sure many many viewers would agree. Lastly... although it was awesome... I'm not sure this would be fun for many...LOL
@mauriciomule1236
@mauriciomule1236 10 ай бұрын
The video on the stock dashboard is outstanding, offering detailed and clear explanations. I found your presentation to be highly informative and educational. Thank you for this exceptional video
@DonShader
@DonShader 2 ай бұрын
This was great. I'm 72 years old and even though it took a couple days, I managed to follow along, find my own mistakes and ultimately made it work as instructed. This was fun and it will be very useful. What's next?
@caroamira
@caroamira Жыл бұрын
Despite the fact that I invest, I am saddened by my inability to evaluate each company's performance and determine whether or not this is the ideal time to purchase stocks. My monetary stockpile is being depleted by inflation. At this stage, I need accurate market trajectory data, but I'm not sure what to do.
@thifannybright
@thifannybright Жыл бұрын
Particularly in this weak market, there are several opportunities to generate excellent returns, but such intricate transactions can only be carried out by seasoned market professionals.
@marenschmitz
@marenschmitz Жыл бұрын
I suggest that you look for a mentor or knowledgeable advisor, particularly in light of the current economic climate.
@naomimarink
@naomimarink Жыл бұрын
@@marenschmitz I completely agree, which is why I prefer to delegate daily decision-making to an investing coach. It is nearly impossible for them to underperform given their specialized knowledge and research, as well as the fact that every one of their abilities is geared toward utilizing risk for its asymmetrical potential and mitigating it as a buffer against certain bad turns. I've been working with an investment coach for over two years and have made over a quarter million dollar.
@jamesbifulco
@jamesbifulco Жыл бұрын
@@naomimarink I've been thinking about going that route. I've been holding onto a lot of stocks, but they're starting to lose value, and I'm not sure if I should retain them or sell them. I think hiring your investment coach would help me restructure my portfolio.
@shashanksingh5449
@shashanksingh5449 3 жыл бұрын
amazing! I was looking for this kind of a video only and you explained it very nicely. And the red and green colour in change was like a cherry on top. can't believe only so less people have watched it
@brianturgeon
@brianturgeon 3 жыл бұрын
Thank you so much!
@arlrmr
@arlrmr 2 жыл бұрын
Highest level of clarity and competence. Such a pleasure to learn from you. Thank you.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you very much!
@junaidafzal
@junaidafzal Жыл бұрын
25 mins, worth spending on a very useful video. very accurate and up to the mark for anybody who has zero knowledge of programming/coding. sub and liked the video :)
@brianturgeon
@brianturgeon Жыл бұрын
Thanks so much!
@VideoVaultification
@VideoVaultification 2 жыл бұрын
Man, thank you and then some. I had over 170 stocks in various watch lists in my TD Ameritrade account and trying to scroll and find was painful. With what I built from your guidance I'm golden and life is so much simpler.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you! So glad it could help!
@Alfredosanchez-fq7ty
@Alfredosanchez-fq7ty 4 ай бұрын
Brother I just want to take the time to thank you so much for your videos…I really found what I was looking for 👏🏼👏🏼👏🏼
@ngkenzy
@ngkenzy Жыл бұрын
I really appreciate the hard work you put into this and am so grateful that you shared it with us. Thank you!
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@kolokotok
@kolokotok 6 ай бұрын
Thank-you so much Brian for putting together this incredible video (learned a lot) and sharing your template. As a tip to my fellow Canadians, if you want to track Canadian stocks use the prefix TSE for your ticker symbol e.g. TSE:TD (for Toronto Dominion bank). If you just use ticker TD without the TSE ... you will get TD in USD from NYSE. My 2 cents
@RegulusVi
@RegulusVi Жыл бұрын
Wow! That's great! I was trying to work with free API and outdated stock stats. Never knew it was possible to produce such an amazing thing with Google Sheets. Thanks a lot.
@CATFISHTYLER
@CATFISHTYLER 8 күн бұрын
This was a very well created video and I really appreciate you showing everyone this process. A great tool for any trader. Cheers and I will be happy to subscribe and share your info with all my viewers. Awesome..!!!
@JAYBLAK00
@JAYBLAK00 6 ай бұрын
My brother, you have done something in a short video that numerous other videos and training classes could never do for me. You taught me how to create a spreadsheet! Oh, my God! Thanks I appreciate it now I can actually do this with other things too. Wow! Lol.
@bea59kaiwalyakhairnar37
@bea59kaiwalyakhairnar37 6 ай бұрын
While watching the movie "DUMP MONEY" i saw google sheet of Roaring kitty. I wanted to make the somewhat similar portfolio dashboards and I found your video. Thank you for sharing such a wonderful information.
@fibtrader108
@fibtrader108 2 жыл бұрын
This is amazing Brian. Only few weeks back I tried using Google sheets for stock screening. I have been struggling. This video helped me make my customised sheet. Thanks again. Looking forward to more educational videos from you.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you!
@JosefTorkelsen
@JosefTorkelsen 2 жыл бұрын
This is amazing! I loved it and learned a lot! Weird that brokerage platforms don't have something like this built in such as the 250 day chart.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you!
@williamg8146
@williamg8146 2 жыл бұрын
@@brianturgeon Brian, would you have an email address, I have a question..?
@nriqueog
@nriqueog 2 жыл бұрын
@@brianturgeon Very IMPRESSED with this sheet. Shame it was hard to see the input boxes while you were working. Is there a way to make them bigger so we see exactly what your typing in?
@brianturgeon
@brianturgeon 2 жыл бұрын
@@nriqueog Thank you and that's a great idea. I'll try to make that happen in future videos and possibly an adapted version of this one
@nriqueog
@nriqueog 2 жыл бұрын
@@brianturgeon That would be really cool to see in an updated one. Thnx!
@bensahin
@bensahin 5 ай бұрын
This is one of the best videos I watched about google finance formulas
@ShareTreck
@ShareTreck 2 жыл бұрын
I loved this video. I was using the stock function in Excel and was not getting all data elements. Thanks!! nice tutorial!!
@BabuLal-lx8kw
@BabuLal-lx8kw Жыл бұрын
One of the best tutorial I have seen on this platform for Stock selection Kudos to your efforts
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@smrutikar
@smrutikar 4 күн бұрын
Excellent tutorial and your template helped put the price movement charts in my watchlist. Thanks :)
@BadPhD777
@BadPhD777 Жыл бұрын
Just found this video. WOW! I never knew there was so much to do with the GOOGLEFINANCE function! Thanks!
@GJAndy
@GJAndy 2 жыл бұрын
This is an excellent tutorial on Google Sheets and importing data from Google Finance.. Was able to follow it to the T and create a stock sheet for myself.. Thanks ever so much for creating and posting such and wonderful tutorial... Really like the 250 day chart idea and the capability to change it to whatever I want. Have a good and safe day..... All the best to you...
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you so much! Really appreciate it
@lindsayk3599
@lindsayk3599 Жыл бұрын
Thanks Brian. I have been trying to do the same task for the last month or so. You solved it except yours is much better than the results I was looking for. I would like to see a video on a good method for sorting the results so I can quickly see all my target stocks trending up. Keep up the great work.
@brianturgeon
@brianturgeon Жыл бұрын
Thank you so much!
@SouKube
@SouKube Жыл бұрын
Great to find this. And thanks for explaining it so well, and the video is very well made too. Could you compare it with Excel Power Query getting data from live pages, and how relevant doing it on Google would be. If anyone else has any views, would love to hear. Cheers!
@mbilly3013
@mbilly3013 Ай бұрын
nice tutorial..building blocks for more advanced setup. thank you for the sharing the template.
@vincentmaldon7707
@vincentmaldon7707 2 жыл бұрын
You are an amazing teacher - thank you so much for this. I subscribed and can't wait to see more of your videos.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you so much!
@gurbirsingh68
@gurbirsingh68 2 жыл бұрын
Superb. Was looking to make this for quite some time. Regards from India 🇮🇳
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you! Appreciate it
@edfawssett4140
@edfawssett4140 Жыл бұрын
Genius, thanks Brian. I started off following along, but struggled with the more complex bits, and ended up using the one you kindly made available.
@aaronl1251
@aaronl1251 Жыл бұрын
Just wantd to say thanks for creating this. I had another google sheet that wasn't as feature rich, but this added a few really nice touches.
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@lasombra325
@lasombra325 2 ай бұрын
El mejor video que he visto en mucho tiempo , excelente maestro y comparte su saber generosamente
@hansonsanatra4080
@hansonsanatra4080 6 ай бұрын
Brian, you are a treasure, the best spreadsheet tutorial i have ever seen, Excellent. and thank you for your permission to copy your template.
@brianturgeon
@brianturgeon 6 ай бұрын
Thank you!
@kuljinderbrar
@kuljinderbrar 2 жыл бұрын
Very good information....i am seeing this video by clicking back again and taking photos of formulas by mobile.....
@brianturgeon
@brianturgeon 2 жыл бұрын
That's awesome! Thank you
@tcostales
@tcostales 2 жыл бұрын
This was a great video. Your voice and tempo were on point. The content was great, and the explanation of the "how-to" was detailed enough. Great job, and thank you for the video.
@scotts1882
@scotts1882 2 жыл бұрын
Duuuude thanks so much. So grateful this appeared in my videos, I had created a spreadsheet a year ago for my portfolio that I use almost daily but learned so much to improve it now Thanks
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you! Glad it helped
@puransingh6999
@puransingh6999 Жыл бұрын
ur great personalty, (Achyutam Keshwam Krishan damodaram, Ram narayanam Janki balabham)
@Petersworld77
@Petersworld77 2 ай бұрын
I’m new to google sheets, this is great info thanks
@Me-Roland.A.Feliers
@Me-Roland.A.Feliers 2 жыл бұрын
Thanks. Dank je wel. Zeer instructieve en eenduidige presentatie. Perfecte Informatie.🐼
@juicygaming69
@juicygaming69 Жыл бұрын
Deadly weapon sir thank you so much for this valuable video. Love from INDIA.
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@chiragmr7109
@chiragmr7109 2 жыл бұрын
Fantastic video, lot of information i learned today. Wishes from india🇮🇳
@chrislitteljohn7409
@chrislitteljohn7409 2 жыл бұрын
I like this tutorial … thanks so much! I was able to follow along and create the same spread sheet for myself. I am curious if or how it might be possible to have both green spark lines like you have but if they depict a downtrend they turned red all depending upon what the trend was over the past 250 days. brilliant tutorial!
@ageens
@ageens Жыл бұрын
take just pct_change + or - sign as colour switch. Just Not sure hot to implement it in the sheets yet w/o creating additional column for switches, but that would be what I could do in python :D
@scotttaylor3334
@scotttaylor3334 2 жыл бұрын
Great videos. I have implemented most of your suggestions into my stock tracker. In watching this video, it struck me how telling the last part of it is. When you extend the look back to 500 days, you comment about how most of the charts reflect when the pandemic hit. It's interesting to look at the companies you chose and how their charts responded to the pandemic. Amazon, Tesla, Facebook, Microsoft and Apple took off. Delta, United and Spirit fell off the face of a cliff and have struggled to make it halfway back to where they were. I didn't read all the other comments, so I'm not sure if somebody else already pointed this out. In any case, keep up the great work.
@brianturgeon
@brianturgeon 2 жыл бұрын
Great comment, it is really interesting when you compare all those companies over that span. Thanks for watching!
@Trading-With-Fun
@Trading-With-Fun 2 жыл бұрын
Your Knowledge & Teaching skill is awesome, also you provide great knowledge. Heartly thanks ...:)
@PWan-xs7hh
@PWan-xs7hh 2 жыл бұрын
very practical and useful, even though I do not have mathematic or computer science background, it is amazing to know so many spreadsheet functions
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you!
@jacoblee6913
@jacoblee6913 Жыл бұрын
Amazing work! I reference it often to make small changes to tailor to my needs. Thank you!
@yokse182
@yokse182 2 жыл бұрын
I love to do this dashboards on google spreadsheet too. I learned some tricks from your video. Thanks for sharing!
@user-zl3kc3pp6w
@user-zl3kc3pp6w 2 жыл бұрын
Thank you SOOOO much...you saved me :):):) love from South Korea
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you! 🇰🇷
@lbl8
@lbl8 Жыл бұрын
Thanks Brian. I appreciate you posting this. I learned a bit more things with google sheets. Keep up the good work!
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@mohsenmohimani344
@mohsenmohimani344 2 жыл бұрын
Thank you very much; it really helped a lot, How do you drag the cell to copy, and past
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you! To drag and paste cells you highlight the range you want to copy and then click and drag the little blue box in the bottom right corner to the area which you want to paste to. Hope that helps
@CM_Burns
@CM_Burns 2 жыл бұрын
KZbin algos work in mysterious ways to recommend this video to me.
@himanshujain6057
@himanshujain6057 2 жыл бұрын
Your teaching style is so unique and easy, Awesome.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you so much!
@srinaga1975
@srinaga1975 2 жыл бұрын
Excellent video; I was searching for this only last 2 days; Thank you for doing step by step
@vishalpawar8.6.86
@vishalpawar8.6.86 2 жыл бұрын
Thanks Bud...Love from India.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you!
@kamjai1
@kamjai1 8 күн бұрын
Thank you, Brian, I really appreciate it.
@CharlieMoneyPH1
@CharlieMoneyPH1 6 ай бұрын
This nice , man. I will try it myself, even if Im not a excel expert. Thanks for sharing.
@shihabva
@shihabva 4 ай бұрын
Thank you so much Brian for this outstanding video 🎉 🙏
@femorous
@femorous Жыл бұрын
Very cool and super useful! You went about the design at the right speed so it was easy to follow. Thanks
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@smokyhillbonsai-gerrettmor6373
@smokyhillbonsai-gerrettmor6373 6 ай бұрын
I had a great time following along and creating my own chart! Thanks!
@InformationEngineer59
@InformationEngineer59 9 ай бұрын
Soooo exactly what I was looking for, thanks.
@Thewesrobertson
@Thewesrobertson 4 ай бұрын
Great info and video. Clear and concise.
@marius9897
@marius9897 2 жыл бұрын
Thank you for sharing this useful chart. Upon recreating it for myself, I have learned more about Google Sheets.
@TimKretschmann
@TimKretschmann 2 жыл бұрын
Very instructive and easy to follow without being horribly slow.
@brianturgeon
@brianturgeon 2 жыл бұрын
Thank you!
@vikasmehan
@vikasmehan Жыл бұрын
Super super nice. Learnt so much from this single video. Thanks a lot for sharing your knowledge to the world
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@87smking
@87smking Жыл бұрын
great vid! can't believe I followed along and it felt like a breeze ..
@brianturgeon
@brianturgeon Жыл бұрын
Glad to hear that!
@brijbrij934
@brijbrij934 4 ай бұрын
many thanks for sharing the video and also sharing the sheet......👌
@fastamv.9896
@fastamv.9896 2 жыл бұрын
Drat I was hoping this would be what I was looking for, then I noticed the bottom of the screen!!
@findMeOnYoutube350
@findMeOnYoutube350 6 ай бұрын
Thanks for sharing.. Now we can do our own manipulation of data by fetching it :) Hope to see some videos on google finance explaining different functions and attributes of it and its usages. Cheers :)
@iHopefulee
@iHopefulee 6 ай бұрын
what a beautiful skill you have, I just learned a lot. Thank u so much
@AndreFortier
@AndreFortier 3 ай бұрын
Awesome video, well presented and so useful. Thank you.
@Aaronandliv
@Aaronandliv Жыл бұрын
Would love a tutorial to show my portfolios performance of those stocks using the same data
@LSFprepper
@LSFprepper 6 ай бұрын
I'd like to see you make a version for precious metal spot prices for bullion and rounds. This was a lot more information than I had expected, but I'm not into stocks like I am into precious metals.
@amiiiraj
@amiiiraj Жыл бұрын
amazing.. i am desperately looking for this .. Thankyou So Much
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
@simiope9808
@simiope9808 2 жыл бұрын
It will be unjust to you if I don’t leave a comment here after learning massively from you. You just shared an amazing knowledge. Q1. Please, how can I add my unit of stocks to know if I’m in upward or downward trend? Q2. How do I add to my stocks without losing the initial unit and additional unit prices Just to Keep tab on all my asset purchased progress generally.
@ozcanonal
@ozcanonal 9 ай бұрын
I learned a lot. Thank you for this very usefull video.
@chrisselby1767
@chrisselby1767 2 жыл бұрын
Unless im sadly mistaken the price function 5 days ago works well for companies listed on the U.S. exchanges, but does not function for companies listed on the London Stock Exchange.
@BernieD940
@BernieD940 4 ай бұрын
Outstanding presentation! Thank You
@nosbigibby
@nosbigibby 4 ай бұрын
I love this sheet! One problem though is that Column C doesn't turn red if the stock is negative over the specified time period. It's always green. Do you know how we can change the formula, so that the "500 day chart" or whatever day you choose will have a conditional formatting so that the chart turns red if the stock is negative over the specified time?
@johnmoncada8101
@johnmoncada8101 6 ай бұрын
Hey man, thanks so much for this. I really learned this now and will definitely use this for sure
@robinson101011
@robinson101011 2 жыл бұрын
Amazing video! I knew something like this was possible, but had no clue on how to do it. Thanks for the video.
@brianturgeon
@brianturgeon 2 жыл бұрын
Appreciate it!
@ssunkite1
@ssunkite1 6 ай бұрын
Superb educational channel. Thanks for teaching and sharing your knowledge. Subscribed.
@MrRKHC
@MrRKHC 8 ай бұрын
Great video, thanks for this tutorial, I learn from it a lot.
@elkabong5547
@elkabong5547 7 ай бұрын
Very nice spreadsheet! Thank you for sharing your hard work.This would have taken days to reproduce.
@nigelteong
@nigelteong 2 жыл бұрын
Love it… finally found someone to teach me this
@yuong8139
@yuong8139 Жыл бұрын
Thank you very much!! This has been alot of help!
@sumitedits6205
@sumitedits6205 2 жыл бұрын
wooow amazing.. Learnt a lot from this. thanks for this video :)
@mark6830
@mark6830 2 жыл бұрын
Is there a way to make the Change % to an hourly or minutes rather than days e.g. 4hr or 2hr time period?
@arvindkumar-eu6vb
@arvindkumar-eu6vb 6 ай бұрын
Hey brian, it is a great video indeed. I wish to know the google fincance abbrevation for "price to book value ' of a stock.
@colinchiu7113
@colinchiu7113 7 ай бұрын
Amazing! So many little tricks. Thanks for sharing this!
@gouravhalder2769
@gouravhalder2769 Жыл бұрын
Just superb👌 complete clean & clear video. Appreciate your hard work.
@brianturgeon
@brianturgeon Жыл бұрын
Thank you!
6 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 177 М.
Doing This Instead Of Studying.. 😳
00:12
Jojo Sim
Рет қаралды 33 МЛН
If Barbie came to life! 💝
00:37
Meow-some! Reacts
Рет қаралды 60 МЛН
WORLD'S SHORTEST WOMAN
00:58
Stokes Twins
Рет қаралды 182 МЛН
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 154 М.
Create a Live Stock Portfolio Tracker in Excel  | No Microsoft 365 Required
21:02
Ryan O'Connell, CFA, FRM
Рет қаралды 58 М.
How To Make A Stock Watchlist In Google Sheets
33:51
Think Stocks
Рет қаралды 122 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 149 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 501 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 247 М.
Beginners Google Sheets Tutorial - Lesson 1
43:16
Teacher's Tech
Рет қаралды 207 М.
Stock Portfolio Tracker Spreadsheet - Google Sheets Template
43:44
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 174 М.
Doing This Instead Of Studying.. 😳
00:12
Jojo Sim
Рет қаралды 33 МЛН