While this provide an actual explanation of the market, on how you buy your 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?
@sommersalt887 ай бұрын
In this current unstable markets, It is advisable to diversify while retaining 70-80% in secure investments. looking at the worth of your portfolio, you should consider financial advisory.
@84gaynor7 ай бұрын
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.
@84gaynor7 ай бұрын
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.
@Curbalnk7 ай бұрын
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
@miroszn3 жыл бұрын
English is not my mother's language, and I usually skip tutorials where authors try to be quick or don't care about pronunciation, yet the Internet has an international audience. You are a gifted educator. I learned a lot here. Thank you and good luck.
@stepheneuloth38263 жыл бұрын
I found a ton of value in your videos and sincerely thanks! I wanted to give back a bit by adding some formulas to support the Market Cap Formulas for T, B, M: 1- in outside cell=if(isblank($B$3),"",GOOGLEFINANCE($B$3,"marketcap")) 2- Count the length of characters =LEN(L7) 3- Add a T, B or M =if(AND(K8=20),"T",if(AND(K8=16),"B",if(AND(K8=13),"M"))) 4- Round Up the Market Cap =ROUNDUP(if(AND(K8=20),L7/1000000000000,if(AND(K8=16),L7/1000000000,if(AND(K8=13),L7/1000000)))) 5- Concat in the dashboard =CONCAT("$",CONCAT(M8,L8)) Might have missed something but I hope this helps - thanks again Think Stocks! - I am Thinking Stocks!!!
@ThinkStocks3 жыл бұрын
This is great info! Thanks Stephen!
@jeremiahburkett41723 жыл бұрын
When they say resources, you are one of em. Ty
@TecNificant3 жыл бұрын
Another great tutorial. I added this as a sheet to the portfolio tracker. Keep em coming....:-)
@ThinkStocks3 жыл бұрын
Will do!
@David-jv7ot3 жыл бұрын
My Friend you have just improved so much for me and my trading, liked and subscribed is all i can do to say thank you so much for a brilliantly put together tutorial, and so well explained, congratulations
@ThinkStocks3 жыл бұрын
I'm glad you enjoyed it! I got plenty more to come!
@David-jv7ot3 жыл бұрын
@@ThinkStocks Fantastic, i have been trying to figure away to pull the Average True Range from GoogleFinance but that seems pretty impossible but " hey ho" thank you once again
@hmubarakail9 ай бұрын
THANK YOU SIR , I CREATED SAME GOOGLE SHEET VIA YOUR WORTHFULL VIDEO , THANK YOU SO MUCH FOR YOUR VALUABLE VIDEO.
@Vallyy77 Жыл бұрын
Amazing work with Excel (google sheet).👏👏👏👏
@kalyanakumar-b9y6 ай бұрын
Just finished doing it. Great tool to help me look at the trends. Thanks very much.
@rameshkumar33783 жыл бұрын
BEST CHANNEL FOR LEARNING
@PriankaEvangelineSLP3 жыл бұрын
So useful! Liked and subscribed. ❤️ Thank u
@padraigmarley2844 Жыл бұрын
Thanks for this. I used your formula and put in the 6 stocks I own, they're all buys. YAY 😀
@stephensmith9504 Жыл бұрын
Great videos mate, very very helpful for a noob like me, appreciate
@Matta-bv5ms6 ай бұрын
This is realy awsome,👌👌 can we draw trendlines on the google sheets, or can we add up in this chart itself? your guidance awaited.👌
@richardluna19963 жыл бұрын
Love it. Did not know how great Google Sheets are until I started watching your channel...thanks
@rohinisharma33407 ай бұрын
Awesome bro
@cpprulez3 жыл бұрын
Really enjoy these videos. Small suggestion: instead of duplicating the single stock signal, it can be taken directly from the watchlist. I think something like =INDEX(A13:H50, MATCH(B3,A13:A50), 2) will do.
@ThinkStocks3 жыл бұрын
Very interesting! Thanks for that!
@cpprulez3 жыл бұрын
Welcome :) I'm more of a Mac Numbers user, but I find your videos on google spreadsheets very helpful, thanks!
@ThinkStocks3 жыл бұрын
Glad you find them useful!
@mjs28s3 жыл бұрын
VLOOKUP works too for any data that you are repeating, just look it up from the main dataset.. I use that often. Seems like when I have too many cells going out to the internet for the same data that my spreadsheet doesn't update properly so I started grabbing data one time and then just copying it around within the sheet (or tabs) as needed. Took awhile to get there but once I got my spreadsheet wired down to what I wanted it was pretty easy to clean up and just query Google Finance one time, then all data across multiple tabs just grabs the data from within the spreadsheet. Love google sheets!
@ThinkStocks3 жыл бұрын
I'll have to start incorporating VLOOKUP!
@VENKATRAMANIYER-g7b7 ай бұрын
Too good and your explanation is excellent. My question is whether we can show the price line [along with sparkline] as we do the the graph. Looking forward for more videos... Regards
@pablogo34042 жыл бұрын
Yoooo! Bad ass! Just subbed and following you like a Hawk! Thanks for this!!!!
@rohitpriyadarshi62202 жыл бұрын
Thanks for the content. Really liked this ....
@OLGMC3 жыл бұрын
I dont know if you already did one but a portfolio for people that have stocks with different currencies would be a big help! You already helped out a lot but some handy functions these portfolios have require all the numbers to be the same currency :/
@ThinkStocks3 жыл бұрын
I did one! International portfolio tracker. Posted it a few weeks ago
@OLGMC3 жыл бұрын
@@ThinkStocks awesome, I'll go check it out!
@jr44872 жыл бұрын
excellent content, subscribed and liked it!
@bullpat14793 жыл бұрын
Great work I apply this Nifty it's work Thanks sir With love from India
@ThinkStocks3 жыл бұрын
Glad you like it and it works for you!
@eskay19597 ай бұрын
Awesome presentation. A great learning. Thanks for sharing.
@VIJAIKUMARRGH3 жыл бұрын
the vedio was awesome to make our watch list thankyou somuch my query upon the video that make the macd and rsi indicator signal implement on the google sheet is very useful to trade knwoledge
@ykam93133 жыл бұрын
Thanks Man!!!! your video hits different
@jeremiahburkett41723 жыл бұрын
Don’t it though.
@HelloBhujpur2 жыл бұрын
Excellent Video. Thank You so much.. .
@rarunkumar1000 Жыл бұрын
Great video🤩🤩
@Nigromancy3 жыл бұрын
HAHA Thanks for reminding me to smash the like button! Your Awesome!
@ThinkStocks3 жыл бұрын
Thanks for smashing it!
@javierloa91973 жыл бұрын
Stack market! Love it! hahaha :)
@alexh.79293 жыл бұрын
Great video. Similar to what you would do in Excel but easier.
@zenitzuboy89023 жыл бұрын
Great video. Thank you for your time to post this video
@DLCShark3 жыл бұрын
I followed your instructions on how to make a portfolio. Then someone else’s for a watch list. Guess who’s about to redo the whole Google sheet?
@billcliinton10053 жыл бұрын
Big help! Thanks!
@Saad_TheGod3 жыл бұрын
Great Vid!
@sateshraj17423 жыл бұрын
Great work 👍🏻🙏🏻
@mfatihd887 ай бұрын
thank you
@djherro9238 Жыл бұрын
I dont know if you still read these messages, Im a little confused by the signal on the top section and its formatting, as I entered the format correctly and it correctly gave the info, however the signal from the bottom section had an equation using your target buy and target sell, this gave results whether to hold sell or buy, when we use the format for the top section, we only use the 52 week high and low, for me this makes coca colas stock state sell on the bottom, but hold and the top! Any reason this would happen?
@abhi0fight3 жыл бұрын
I want to like this video 10 times.
@keeganwidmyer58223 жыл бұрын
Great video! Could you make a dividend tracker video if you don’t have one up already?
@ThinkStocks3 жыл бұрын
I do have a couple trackers that tracks dividends but I am coming out with a video dedicated to dividend stocks and tracking your dividend income!
@keeganwidmyer58223 жыл бұрын
@@ThinkStocks Ok, awesome! Have you uploaded anything about a Cryptocurrency tracker for Google Sheets yet? This is because I can't figure out how to use the ticker to import data for crypto in Google Sheets.
@ThinkStocks3 жыл бұрын
That tutorial is coming out this Friday!
@murators4732 Жыл бұрын
Amazing!! How can we also implement indicator values? Like macd and a signal for macd cross❤❤❤
@wsround Жыл бұрын
I have been trying to find a script for googlefinance that would give me the 52 week high and 52 week low on a particular date. I have been looking at this sheet and noticed that you did a graph for a stock from it's past and I noticed that when you don't add the sparkline it shows the actual prices for that day but I was looking for a way to find the 52 week high and low so tried replacing the price to 52low and 52 high but that didn't work. Is there a way to get it for a past date?
@michaelstevens35493 жыл бұрын
Great video...keep up the good work. And yes, I hit the "Like Button". LOL
@ThinkStocks3 жыл бұрын
Thanks!
@DrunknOdin2 жыл бұрын
Think you could make a video on how you are able to determine which chart/table you are pulling in from. For example on FINVIZ you're able to scrape data from table 8 but how did you know that is table 8? Thanks a bunch love you videos.
@是熙2 жыл бұрын
Love this
@terry23463 жыл бұрын
I had to slow you down a bit as my keyboarding skills aren't the greatest but it turned out great! Thanks so much! Now just need to add in the initial cost and number of shares and good to go.
@puransingh6999 Жыл бұрын
UR GREAT PERSONALTY
@kevinkweya4 ай бұрын
Another way you can format the Market Cap instead of using the long formula is to go into more formats > custom number formats > then paste this in the field ($#,##0,,," B") DO NOT ADD THE BRACKETS. that should change it to billions and just deduct the comma's to get to the millions
@willhatt673 жыл бұрын
Great content thanks, helps a lot. Wonder if you can point me in the right direction with a formula I’m struggling with. I have 2 columns that I want to show, in a third column the percentage of the two columns, at the moment I have =(A-B)/B. This works if A is larger than B showing the correct percentage but if B is larger than A it shows the wrong percent. Basically I’m trying to show a + or - percent between the two columns. Hope you can help.
@easylearningwithRP3 жыл бұрын
Thanks for Nice and Informative video, just suggest to use Custom Format for Market Cap -> #,##0,,,"B" instead of putting formula.
@supernico28793 жыл бұрын
Thanks you so much, gorgeous job ! very helpfull
@ImVengeanceee3 жыл бұрын
Great content bro, thanks!!
@lasanthadilhan82813 жыл бұрын
Thanks 🙏 I made it same
@BurhanAhmadiАй бұрын
#,##0,,, " B" Format=Number=Customer Number format, should easily fix the Market Cap thingy. Great video by the way.
@SuperKevinFS3 жыл бұрын
EXCELLENT VIDEO
@July-ct7pp3 жыл бұрын
"If you haven't hit that like button that's just disrespectful" LMAO I was so into the video I forgot to hit that smash like button thanks for the reminder lol I hit that button so hard
@ThinkStocks3 жыл бұрын
Lmao😂😂😂 thanks!
@jasonr31653 жыл бұрын
How comes this channel only has 9.45k subscribers.
@ThinkStocks3 жыл бұрын
Honestly my favorite kind of comment! Slow and steady growth
@vdogra13 жыл бұрын
Great tutorial in making a portfolio tracker!!! Having an issue with the 'Purchase' price calculation, when we have multiple transactions of buy and sell. The purchase price comes off. Is there any other way to calculate it?
@jefffox8991 Жыл бұрын
For market cap, instead of dividing by 1 billion, set custom number format to $#,##0,,," B"
@manojmakwana965 Жыл бұрын
Can you make another video in moving Average by customised with working day only
@sahithbasani44752 жыл бұрын
hello sir i like this vedio and also could u please tell us how to creat our own ones ?
@mickommers3 жыл бұрын
It's a good video. One thing I do not understand, can this sheet communicates with your crypto provider? So if you put a coin on sale, is this happening real time. or do you have to do this separate? thanks in advance for the answer
@mahfouz83973 жыл бұрын
That is wonderful, thank you very much
@ThinkStocks3 жыл бұрын
You're welcome!
@pedrocunha66803 жыл бұрын
if someone have problems with the functions, just change "," to ";" !!!!
@miroszn3 жыл бұрын
You've made my day. Thanks
@spazier162 жыл бұрын
I LOVE YOU
@hemilcivil39098 ай бұрын
Nice sir
@mohammadfarooque2116 Жыл бұрын
sir can u make a vedio ema cross over signal in live market for stock ..........multi time frame
@PlanBMarketing Жыл бұрын
Can you make a watch list of stocks that use the MACD indicator as a buy sell alert?
@etiennemolly7893 Жыл бұрын
When using googlefinance you use the cell reference not the ticker value directly. This is very practical as you show however can you easily sort such a list to have the shares in alphabetical order ? When I tried this previously it seems to loose the references
@jefffox8991 Жыл бұрын
Maybe try locking the cell references. If they are locked, try modifying the lock
@ngo56143 жыл бұрын
awesome, thank you
@amitc3coral18 ай бұрын
Superb
@jsirin7558 ай бұрын
Its target of buy and Target of sell really work?
@arielsigler9482 жыл бұрын
Hi Thank you so much. How can I create a graph view of my total portfolio value over few days, weeks and so on. Actually a trend line of my portfolio. Thank you
@marysmith3710 Жыл бұрын
Can you add ex dividend date & dividend payment date?
@loustj78003 жыл бұрын
I have a column (H) and a column ( I). I want to conditionally format H18 so that if the number in H18 is greater than the number in I18 the color of the cell will change to dark green. If h18 is less than i18 the cell would be red. Could you give me a formula that I could use to accomplish that? Thank you
@urayys3 жыл бұрын
Pulling data from finviz and removing the * from the imported data, google sheets only recognizing information as text and can't get it as data. Any idea on how to covert to data? great vids thanks
@TheRobFather3 жыл бұрын
Thank you very much, your freaking awesome.
@ThinkStocks3 жыл бұрын
Thanks man!
@TheRobFather3 жыл бұрын
@@ThinkStocks Ive been watching ur vids since 1 am lol.
@ThinkStocks3 жыл бұрын
Lol, thanks for helping boost my KZbin algorithm!
@edwinani52592 жыл бұрын
Google finance deals automatically with NYSE, NASDAQ and TSE (Toronto STocks). What about other exchanges such as TSX-V and NEO exchange, do you know how I can plug them into the tracker? Thank you by the way for your videos. I'm a beginner and I learn a lot.
@metano2280 Жыл бұрын
How do I correct this formula to signal error appears =IF(B4>((B6-B7)*0.85+B7);"SELL";IF(B4
@robira13133 жыл бұрын
In my stock tracker, can I have a cell display YESTERDAY'S end value?
@sadashivb51003 жыл бұрын
Great video...pls make how to track Roc Rock debit /equity Ratio
@maxiperelli85703 жыл бұрын
What time frame is the buy and sell weekly or monthly ?
@vishalkamath83273 жыл бұрын
Hello Sir, What to do with Indian Market i.e Nse..?? How to pull data from finviz for indian market portfolio? Please explain.. Tc
@iansnow28303 жыл бұрын
How do you view stocks from different markets?
@safvansaiyad95272 жыл бұрын
I am get formula parse error when I enter a target buy formula what to do?
@manfredadams32523 жыл бұрын
WTB: Intuitive display of where current value falls within 52w h/l or 5 year yield/5 year price/book using a single cell instead of 3. Normalize the value and draw 3 symbols perhaps? Cheat with ascii art? L---*--------H Not sure what the limitations are but such a widget would sure be an watchlist upgrade.
@recantodogalo9488 Жыл бұрын
SHOW DE BOLA!
@ateeqbashiruddin14793 жыл бұрын
Hi, Thanks for doing this. Is there any way to add Canadian stocks on to this watchlist?
@iceman54133 жыл бұрын
Yes. Depending on which market the stock is trading on, just use "tse:ticker", "cnsx:ticker" or "cvs:ticker". Those are the ones I'm familiar with. So to sum it up, type in the exchange, then a colon, then the ticker symbol. No spaces, no quotations.
@JDJRN2 жыл бұрын
Is there any way to build a formula that will build off of goggle's chart gain/loss in %/$ that shows above their chart? I would like to see the average +/- of a stock for any year that I enter, not just the 5yr and 10yr option they have available? I don't need the chart, I would just like the % and $ amount for any time period that I enter
@mamiefrazier86829 минут бұрын
Are you using a PC
@TL-zp9nz Жыл бұрын
Anyone willing to help me please why I failed? I typed excatly the same signal but for what reason for no result.
@kimekberg74342 жыл бұрын
Quick question like a year later but, is there a way to color the sparkline? Have tried some ways but hasn't got it to work. Ty :)
@ThinkStocks2 жыл бұрын
Yes! Just change the text color and it will change the sparkline color
@jefffox8991 Жыл бұрын
It can be changed in the formula by adding {"color", "green} or {"charttype", "column"}
@edwardbrandt75663 жыл бұрын
Cool stuff!:)
@rsiexpress2 жыл бұрын
gREAT wORK
@observation-room Жыл бұрын
Column B says Singal, what is that?
@lewinmg3 ай бұрын
hahah...funny. i thought the same thing, its supposed to be "Signal". He misspelled it
@uttammore3663 жыл бұрын
Is this setup working in NSE from India please reply 🙏🙏🙏
@ThinkStocks3 жыл бұрын
Yes it should work for any international stock!
@uttammore3663 жыл бұрын
Yes I have make it's in Indian style hope it will work, I have spent too much time this experiment 🙏🙏
@RetroModeDays2 жыл бұрын
My sparkline is not working
@aaronalphonso92293 жыл бұрын
You could have just used lookup formulas for the widget part
@RoadRunner-Dollars3 жыл бұрын
google finance is broken they did an update? i cant fetch data for these anymore :(
@augustin99993 жыл бұрын
How to find the value of a stock on two dates?
@Toohottorot3 жыл бұрын
fixed the issue with the market cap buy just adding an if statement that says if it's less that 1B, then do the formula for millions. =if(GOOGLEFINANCE(B3,"marketcap")>1000000000,"$"&Trunc(GOOGLEFINANCE(B3,"marketcap")/1000000000)&"B","$"&Trunc(GOOGLEFINANCE(B3,"marketcap")/1000000)&"M")