How To Create a Simple Dividend Stock Portfolio Tracking Spreadsheet From Scratch Using Google Pt 1
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- How To Create a Simple Dividend Stock Portfolio Tracking Spreadsheet From Scratch Using Google - Part 1
I had a request from a subscriber to create a guide on how you can create a spreadsheet to track your stocks / portfolio in Google(Sheets). So, here it is!
Check out my recent release of my new 2.0 spreadsheet portfolio tracker product! • Best Dividend Stock Sp... Very very cool!
Support me & get Patreon perks ➜ / genexdividendinvestor
Please LIKE, COMMENT and SUBSCRIBE to support this channel - it helps me immensely! Also, please SHARE this video with your friends :) Thank you, I really appreciate it! Also note that Google has some bugs which can cause display issues when you scrape too many websites or call too many API functions (i.e. timeout issues), which can then yield display bugs -- hopefully Google will fix this (and increase the timeout), but if you find that happening too much then I'd use less screenscraping and call less functions...
Please join my free Investing Discord chat server that has thousands of dividend investors on it: / discord
Get more great info - Subscribe! ➜ th-cam.com/users/GenExDivide...
Share this Video ➜ • How To Create a Simple...
BTW -- the best way to add a logo into a spreadsheet cell is go into the cell, and insert image then image in cell, google image search, and search for company logo. Click the one you want and then click insert.
Watch this Video next ➜ • Best Dividend Stock Sp...
Feel free to ask questions on Instagram, Twitter, Reddit, Discord or here on TH-cam. Listen to my videos as Podcasts on Spotify, SoundCloud, iTunes, etc.
My Dividend Portfolio on M1 ➜ m1.finance/9gGguPKhh
Referral Link to M1 ➜ m1.finance/AUzJllYh-gGh
Instagram ➜ / genexdividendinvestor
Reddit ➜ / genxdividendinvestor
Twitter ➜ / genexdividend
Listen to my Videos as Podcasts on iTunes ➜ podcasts.apple.com/us/podcast...
Listen to my Videos as Podcasts on SoundCloud ➜ / genexdividendinvestor
Listen to my Videos as Podcasts on Spotify ➜ open.spotify.com/show/0svL2Bw...
Chat with me on my Dividend Discord Server ➜ / discord
Investing Books to read (as an Amazon Associate I earn from qualifying purchases):
The Intelligent Investor ➜ amzn.to/2WPwgtj
One Up on Wall Street ➜ amzn.to/2YTDAXt
Rich Dad, Poor Dad ➜ amzn.to/2SUCwOZ
The Richest Man in Babylon ➜ amzn.to/2SUHStw
A Random Walk Down Wall Street: The Time-Tested Strategy for Successful Investing ➜ amzn.to/2YUgjo4
The Bogleheads' Guide to Investing ➜ amzn.to/2STECPp
Other Books I Like (as an Amazon Associate I earn from qualifying purchases)
Skin in the Game ➜ amzn.to/3fD4lFt
How to Win Friends and Influence People ➜ amzn.to/3dxHI3p
The 7 Habits of Highly Effective People ➜ amzn.to/2WP86iv
The Five Dysfunctions of a Team: A Leadership Fable ➜ amzn.to/3fDXLhM
My Recording Gear (as an Amazon Associate I earn from qualifying purchases):
Blue Yeti Microphone - Blackout edition ➜ amzn.to/3cm40os
Professional Foam Windscreen Cover for Blue Yeti ➜ amzn.to/2YVNqYG
Boom Mic Stand to Clip Blue Yeti on Desk ➜ amzn.to/2WHsBxs
Disclaimer: I am not a financial adviser. These videos are for entertainment, inspiration, and educational purposes only. Investing of any kind involves risk. I am only sharing my opinion with no guarantee of gains or losses on investments. Please consult an appropriate adviser and do your own research before making any decisions on anything. I am not responsible or liable for any actions you take.
Copyright © 2019 Gen Ex Dividend Investor. All rights reserved.
#DividendPortfolio #DividendInvesting #GoogleSpreadsheet
![เกิดใหม่ทั้งทีก็เป็นสไลม์ไปซะแล้ว ซีซั่น 3 - ตอนที่ 61 [ซับไทย]](http://i.ytimg.com/vi/ux_yeQTff6E/mqdefault.jpg)
UPDATE -- Check out my recent release of my new 2.0 spreadsheet portfolio tracker product! th-cam.com/video/qAV8D5r1I_M/w-d-xo.html Very very cool!
Don't forget to SUBSCRIBE and LIKE this video as a simple way to thank me. It really helps the channel ! Thanks, I appreciate it!
Support me & get Patreon perks ➜ www.patreon.com/genexdividendinvestor
Please join my free investing Dividend Discord chat server with over 2500 dividend investors on it: discord.gg/kkSr5FY
Also, I forgot to show how you can add logo's in this video - the best way to add a logo into a spreadsheet cell is go into the cell, and insert image then image in cell, google image search, and search for company logo. Click the one you want and then click insert.
Google has some timeout bugs where it can cause issues sometimes if you are scraping too many websites or if they have timeout issues which can lead to display issues. Hopefully Google will resolve this!
Also, Gurufocus changed their site so you can't scrape CAGR from it, but I list the new formula in the FAQ document on my Discord (as its the easiest centralized way I can update the info).
@@jerijenee You could use =index(importhtml("finviz.com/quote.ashx?t=jnj", "table", 11),11,8) Though, the more you scrape HTML, the more issues Google unfortunately has. I bet they will resolve this issue someday, but its annoying.
@@GenExDividendInvestor Thanks but new problem, I had to change it to look up Dividend 3.80 on the table which worked but it puts (*)3.80(*) in the cell and unable to change it to $ amount and throws off the rest of the data cells. Still playing with it
@@osros Hmm I'm not sure I see why it would do that. If you want to share your spreadsheet with me with edit rights then I can take a look.. or explain it more... #Partner22
@GenExDividendInvestor, great content here. I am not having success pulling the 3 yr CAGR from gurufocus. My my command is =abs(index(IMPORTHTML(CONCATENATE("www:gurufocus.com/stock/", C3, "/summary"),"table", 7),4,2))/100 and is returning #NA ( with the hovering message reading, " could not fetch www:gurufocus.com/stock/", C3, "/summary". Any thoughts? Any other sites you use to pull a 5 or 10 year div CAGR? #partner18
@@GenExDividendInvestor , great content here. I am not having success pulling the 3 yr CAGR from gurufocus. My my command is =abs(index(IMPORTHTML(CONCATENATE("www:gurufocus.com/stock/", C3, "/summary"),"table", 7),4,2))/100 and is returning #NA ( with the hovering message reading, " could not fetch www:gurufocus.com/stock/", C3, "/summary". Any thoughts? Any other sites you use to pull a 5 or 10 year div CAGR? #partner18
I'm subbing, sharing and liking because you were unselfish and shared this with us, not trying to sell it like everyone else. You will blow this channel up fo sho in due time little brother!!!
Thanks! I like to teach people to fish so hopefully my vids will help folks out :) #Partner47
Facts
@Expanse Half thought much?
I can't thank you enough for this tutorial, very appreciated.
No prob, if you have any questions, drop me a note here :) #Partner28
It's probably sad how blown away and in awe I was of this. I'm so thankful for people out there who are smarter or more talented than me at these things. Thank you thank you thank you!
Thanks and you're welcome :) But I'm not smarter or more talented than you -- I've probably just spent more time learning how googlesheets work.
This was a great step by step.. My only issue was manipulating the CAGR field. I figured that the chart number he was using to pull data from was 7 and mine was 8. worked perfectly!
Cool, I did an entire video on CAGR if you want to check it out :) #Partner27
I was looking through your old videos and saw this one. Very informative and easy to use guide. I started in July with your referral link on M1. Added about a thousand dollars to it and kind of played with the account till around September. Then decided to get more serious about investing into it. I've been adding 900 to 1000 a month since. I'm up to 7000, nothing extravagantly huge, but I've set up a plan. In two years I'm going to try to add 2000 a month. Somewhere in 2026 I figure to have 100k, and 2036 looking to be 500k. Those may be lofty goals, but I see that dividend snowball rolling hard. lol
Thanks for all your videos.
Dwayne
Ahh cool and thanks! The hardest part is starting and the next hardest part will be not quitting during times of fear. Keep investing in good assets and over the long run I think you will be blown away by where you end up.
@@GenExDividendInvestor So far my account is doing great. Especially compared to the S&P.
Yours is the best spreadsheet tutorial. Clear, accurate, etc..others don't specify how they create the formulas, or the formulas are two long without explanation. You are talented, almost an intellectual artist for the dividend enthusiast.
Thanks! On my Discord I created a FAQ and at the bottom of it I have a link to a google doc that has all the formulas folks can cut and paste if they want.
@@GenExDividendInvestor Yes, I signed up for that and have to do that...my sheet has gone to hell with companies dropping out the tracking ability. Yours is the only cogent and clear tutorial....I hate to lose my sheet
@@edwardmcdonald8194 Yeah that's part of why I ended up making a spreadsheet as a tool I sell as a service is because there were some limitations with google...
I'm subbing, liking etc. for all of the info that you gave away here. Thank you so much. I'm new to this and quality info like this is hard to come by. Thank you.
Hey thanks, I appreciate it :)
Best TH-cam videos ever. Very informative! God bless you and your channel ! Thank you for all of your vids
Thanks, Angel :)
This will be my first time creating a spreedsheet. This was super helpful. Thanks.
Glad it was helpful! I have a Discord with a channel just for people who are making their own spreadsheet :)
THANK YOU for the introduction. I just started investing and this video help a lot.
Welcome :)
Speechless tbh, I never though to stumble upon such a great person. I have like and I will be a loyal subscriber !
Thanks, Andres, very nice of you to say that :) You should jump on my Discord -- we have lots of investors from all around the world on it :) discord.gg/kkSr5FY
Hello ...Just wanted to say thanks for all your time and hard work on the video that broke down the dividend tracking spreadsheet. Awesome job could not have done it without your help just became a fan I subscribed to your channel and will be catching all your videos thanks again I'll be watching.
Rudy Black Awesome, thanks :). You should check out my free discord... we have over 2500 dividend investors on it :)
Excellent explanation.....I love Google Spreadsheets to track investments....great job!
Thanks, I wasn't even planning on making this video until a subscriber suggested it, and then it turns out being my most popular video, lol.
Exactly what I was looking for thank you so much.
Broccoli Awesome! Tell me if you have any questions :). #Partner23
Super helpful thanks! Eventually I want to set things up so that I can pull my portfolio data into a spreadsheet like this so I don't have to manually update the # of shares column. Then the only thing I'd need to update is the dividend yield as it increases or if it gets cut 🙄
Cool.. Google has some bugs which can cause their spreadsheet to time out if you make too many API connections, so I'll probably make a follow up video on another api that can be used... #Partner34
What a beautiful job of explaining this stuff. You have a great way of presenting this information.
Thanks, Joseph :)
My life may be boring but the google finance function is the single coolest thing I've seen
I know, right? It’s not perfect but it’s pretty cool :)
from Brazil and i got to say great job!!! be sure to make more content like that
Thanks, Walter. I love hearing from people around the world :) #Partner28
Awesome video! So simple to follow along. Thank you!!
Thanks :)
Your video is wonderful. I have to refer back to it when I buy a new stock.
Thanks, glad you enjoy it :)
Thank you so much for this video. I just started investing in January of this year and found your channel two weeks ago. Thank you for breaking down all 25 companies. Also, for helping me learn how to create a spreadsheet to help track my investments.🙏
You're welcome :) Google has some issues where its api croaks sometimes (like if you open too many calls from a single spreadsheet), so at some point I'll do an update showing how you can use another service to get data... #Partner33
GenExDividendInvestor I’m experiencing that now. Thank you for the update and kind reply.
New to tour Chanel just want to say thanks for this info and looking forward to your videos. 👍👍
Cool, thanks for joining up and watching :) #Partner37
Subscribed because of this video alone. Thank you so much and great work
Thanks, glad you liked it. I'm going to be releasing a significant update which goes way beyond just a portfolio tracker that I'm beta'ing with my Patreon Aristocrats and Kings right now :) It will be for those who remain higher tier Patreons, but I think folks are gonna be blown away ;)
Wow this was very detailed! Good info, mine is just the price I bought it at and the dividend it pays but similar concept.
Thanks! As long as you are tracking metrics than are relevant to you, it's all good!
Very well explained. Thanks for sharing.
Thanks, Bob. I appreciate it :)
Thanks man really helpful video..
You got yourself a new subscriber keep up the good work
Thanks, Hassan... I appreciate your support and kind words :)
An instant like and sub. Thank you so much for showing how to do this.
Thanks, I'm glad you enjoyed it :) I wasn't even planning to make this vid and then a sub asked when I first started my channel so I made it, and boom it became my most popular video ever, lol
Great way to track your progress. Dividend investing is a long but rewarding journey.
Definitely... An eternity, for future generations as well :) Thanks!
Gee, thanks for the info. I finally had some time to complete this.
Awesome... if you have any questions feel free to drop by my discord (link in description) #Partner48
A great way to pull in all the latest prices in (almost) real-time. And the ease to make sparklines is quite impressive. What sucks a bit is that you still have to go elsewhere to get the dividends. This would be really awesome if that process was automated as well.
Hopefully this gives you the tools you need to evolve it to your liking :)
Thank you 🙏 this has helped me sooo much to help keep track of my investments
Great, I'm glad it helped :)
This tutorial is TH-cam gold. Very informative and easy to follow. Should consider doing additional tutorials in the future. #Partner4
Thanks If you have any suggestions what would be useful, toss em my way... #Partner29
The spreadsheet video is blowing up! All the best.
Haha ya, and it was a sub who asked me to make it, lol. #Partner25
Thankyou Very Much for this! Much LOVE!
You are welcome, glad you found it useful :)
Thank you so much! I've been looking for a good tracker and this one is legit. Thanks for teaching me to fish!
Cool, glad you like it :) I am thinking about doing another one pulling from api's that you need to register for (to get around google api latencies as well as websites that change their format and can break your imports)... #Partner29
This tutorial just helped me setup my dividend tracker. Thank you so much! Very useful.
창창 Great :) #Partner37
Great video! Thanks for doing this.
Thanks, I appreciate it :) #Partner35
This was a great video, thanks for the walk through!
You are welcome! Happy Sunday :) #Partner33
Thank you so much for this, absolutely amazing!
You’re welcome :) #Partner40
great video one of the best i seen
Thank you, that means the world to me :)
I have to say a BIG thank you for this video, totally awesome, pity I saw this today, love all of your videos. Thanks again man, truly appreciate it.
Thanks, and you're welcome my friend :) #Partner47
Really good tutorial thank you :3
You're welcome.. I'm going to be doing a massive upgrade with functionality you haven't seen anywhere (though it will be only free for my Patreons who remain Kings/Aristocrats).. I'll be doing a video soon to show my ny 2.0 product functionality :) It'll blow people away I think...
Great video! Very helpful
Thanks, I'm glad you liked it :)
Really helpful. Thank you.
Thanks! You’re welcome, friend :)
Dude I did not know that google sheets had the ability to load stock data!!!! SUBSCRIBED!!
Pretty cool, huh? :)
Thank you for making this, very informative! Liked & Subbed!
Thanks & you’re welcome!
Clean nice and organized
Thanks, I appreciate it :)
Wow. I had no idea google sheets could even do some of these functions.😳
You do fun things in Scotland, I do fun things in spreadsheets! They both are excit... no.. never mind, Scotland is better!
Good stuff! 🔥🔥
Thanks, I appreciate it!
Thanks for making a video regarding this topic. Dropped a like 👍
Thanks!
@@GenExDividendInvestor I just built it now. Just a question I need to add in Canadian amounts for stocks prices but google finance does in USD.
Got it =googlefinance(“tse:symbol”,”price”).
This is the greatest video on the interwebs!
lol.. I don't know why I crackup when I hear "interweb"... #Partner28
@@GenExDividendInvestor Yeah me too lol
Thank you for the magnificent instruction! I spent all of Sunday afternoon replecating your chart. Let us know what we can do to help your efforts!
Join up on my Discord :) Its a fun free place with thousands of dividend investors (and non-dividend investors). discord.gg/kkSr5FY
Great video, so helpful for those just getting started. I use a google sheets add-on called Sheets Market Data that is really great as well, you should check it out, it gives dividend data for individual stocks as well.
Cool, thanks for the tip!
Thank you so much for this
You are most welcome, Deborah :)
Thank you alot! this was very helpful...a new subscriber:)
You’re most welcome... Cool, I’m glad you liked it. #Partner45
Thank you very much! I subscribed :)
Cool, glad you found it of value :) Happy Sunday! #Partner25
Thank you! Subscriber now for sure!
Thanks, David, I appreciate it :)
This is phenomenal, thank you very much!
Thanks, I appreciate it. TGIF :) #Partner28
Was looking for a way to track on spreadsheet. Great template 🤙
Thanks, I appreciate it!
Thank you for this. Very useful. One question: How do I alphabetize row A without mixing the Ticker into it and messing it up?
Sure. Highlight the rows you want to sort by clicking on the left most row and drag down. You could sort ascending or descending based on any column you want -- so alphabetically or based on market value or whatever. Then once the rows are higlighted, select Data (on the top menu bar), then select sort range... then for sort by you select whatever column you want. Then you select a->z or z->a depending on if you want it ascending or descending order. I don't highlight my total row on the bottom (so it isn't sorted). If you have frozen the top row then you can select that too and it won't sort.
I subbed and gave you the thumbs up, simply because of this
Thanks Keith :) #Partner48
Fantastic video, you deserve all the Likes and Subscribes and you didn't even ask for them in this video. Quick question, I'd like to add a row to show the average price of the shares bought from XYZ company for instance. it helps me compare it to the current market price. I'm not sure if anyone else asked this question, but I keep adding stocks from a specific company when the price is right depending on how much money I have at that moment. and every-time the price is different from the one's previously bought. Hence this row would be extremely helpful.
Thanks.. I actually show how to calculate average price per share (as part of a cost basis calculation, even though its not cost basis, per se) in the part 2 video.
I've been binge watching your deep analysis videos since yesterday when I found your channel. Dividend investing is a maze and your take on fundamentals is super refreshing my man. Wishing you great prosperity from Sweden! #Partner7
Ahh cool, I appreciate it. You should jump in the discord -- we have dividend investors from all around the world in here :) discord.gg/kkSr5FY #Partner35
Thank you so much for the tutorial! Quick question; How do you combine the stocks from the same sector to show as one in the pie graph? For instance PFE and JNJ both to show under HEALTHCARE. Thank you!
You're welcome. Click the aggregate check box when you make your graph (its one of the settings in the right hand side pop-up window).
Absolutely impressed..
Glad you enjoyed it :)
Thanks so much for this
Allen Lai You are most welcome :) #Partner39
Thank you so much GenExDividendInvestor its amazing to get this. Can i ask you one question, please. The formula in Portfolio Allocation was $M$ i trade with £ sterling would that matter?
You're welcome. You can stay in the same currency for your spreadsheet, or you can use currency conversion functions. As long as the math works out, then I'm not sure if what currency you use matters... #Partner48
Really helpful video man! All investors should make their own spreadsheet imo.
Thanks.. I think its helpful to learn how to do it, so you can customize and get exactly what you want.. But I can understand why others don't ;) #Partner27
Nice! 👍I use excel and Google sheets.
Nice! Yeah, it's hard not to use old faithful (excel) :)
Hi awesome video! Is there a way to automate google sheets to actually grab the annual dividend rate as well or do we have to always manually enter it?
Thanks. You can pull the dividend from finviz using inporthtml or you can pull from the old nasdaq site with importxml. #Partner37
Great tutorial! Made a spreadsheet and shared it on my portfolio update this week!
Thanks, glad you liked it :) #Partner37
Yours is the clearest..".keep it simple stupid" is the motto applied to me..
Glad you like it :)
Great video, I personally struggle with spreadsheets. I want to make a new one now!
Haha, awesome. One of my favorite things to do is to update my spreadsheet with dividend income.. Its crazy how much I love doing that
I just made the same spreadsheet, stopping your video every 30 seconds while I updated my personal spreadsheet . Are you okay if I link to this video on a future video? I think this will help a lot of non tech people.
@@FirefightersFinancialToolbox Sure :)
Thank you!
You are welcome.. you should see the 2.0 spreadsheet I'm making ;)
Great video, this will help out beginners a lot!
Thanks, Alisher :) Yeah, hopefully those not too versed with Google can start leveraging its capabilities more.
Thanks so much for this. I never used a spreadsheet before, this was a big help. I even got the sparkline to work!
Sure :) I debated between just giving a link to the spreadsheet vs forcing people to actually learn it, but I think if you go through a bit of struggle you have a better chance of learning stuff.. and you know.. teach someone to fish... #Partner22
@@GenExDividendInvestor Yes it's much better to learn, then I can add in what I want. I went hog wild and have 20 columns now.
One question, if I move columns around after the fact does that screw up my formulas because the letter will change?
@@stephaniesommers407 Oops, your comment went to spam for some reason.. I just found it. If you insert columns then all the formulas should auto-adjust and be ok. #Partner23
great vid. thanks!
Glad you like it.. I'm gonna work on a part 2 to share other info that folks would be interested in :) #Partner48
@@GenExDividendInvestor please do i learned a ton. i love excel but do not know sheets well. this was amazing. it will help me a ton.
simply wow, thank you for taking the time to create and post- i been looking for something that doesnt not cost me money...bad enough im trying to dividend invest. Like and sub and comment for that algo !
Thanks, I appreciate it :) Yeah, I see so many people selling these, so thought I'd just show how to make a basic one. Google has some limitations if you make too many calls to apis (it can timeout), so I'll make another video at some point showing some other options... #Partner34
Hi! Thanks for great video tutorial! I have one question. How do you combine industry in the pie chart so it does not show duplicate?
Thanks! Click the "Aggregate" input field when you first create it. #Partner24
Hi, awesome video, is there a way to put the actual payout (ie, the quarterly or monthly payout of dividend), and can you track if you reinvested the dividend?
Army Joe_98 yeah, I’d just add a new tab and then track whatever you wanted... you just gotta think what pieces of info you want and then put those in... #Partner48
Hi thank you so much for the information anyways do you know any way to get the annual dividend automatically?
You could try =regexextract(index(ImportHtml("finviz.com/quote.ashx?t="&A2, "table", 11),7,2),"/*[0-9.]+/*") where a2 is where the ticker is....
None of the commands worked for me untill i changed the " , " into an "; ". now it works perfectly
Petter Johansson I’ve learned that outside the US google has changed its apis (strangely), and hardly has documented it... ; instead of , is one example.. sometimes functions just don’t work unless you set your worksheet as being in the US.. #Partner37
@@GenExDividendInvestor To make the green/red color work on my swedish shet I made a colum of the older prices and one colum of todays prices
I made all the sparklines red to begin with and then
Right clicking the sparkline > formating > Add a rule > customized rule (Bottom)> type in =O2
Great video! Thank you sir! Only thing is that i cant get 3Y div. Cant finde or something like that. But great work 👏👏👏
Thanks.. can you pull 3 year div cagr for jnj with this? =index(importhtml("www.gurufocus.com/stock/jnj", "table", 8),4,2) #Partner33
@@GenExDividendInvestor it works, i put on hands symbol for stock and it works. Thank you very much 👌
Thanks so much!!!!
You’re most welcome.
Thank You!!!!
You are welcome :) #Partner48
Thank you! Awesome tutorial! You are so generous with your knowledge. 😊
Thanks :). I’m working on a part 2 video to answer some questions posed... #Partner48
You might have a small channel, but i like the content alot! I hope you can make a decent income off this channel.
Thanks, Roger :) I think it will be like dividend investing.. It starts off slow, but then if you keep it at and focus on quality, it will grow -- until one day it surprises you :) #Partner48
You are amazing !!!!!!!!!!!!!!!!!!!!!!!
Glad you like it. Stay tuned for a version I let my Patreon Aristocrats and Kings use which is 10x more impressive :)
Thanks for your hard work teaching us this.
You are welcome, my friend :) #Partner44
@@GenExDividendInvestor I'm struggling to get the sparkline to work. I have copied your formula word for word. Spelt colour both the American way and British way but to no prevail. Any chance you can throw some suggestions?
@@AADadrah Share a sanitized version of your spreadsheet with me and give me write permissions and I'll show you gen.x.dividend.investor@gmail.com #Partner44
@@GenExDividendInvestor Thanks for this, I've emailed it over to you. Sorry for putting you out of your way. Your communication with your audience is great! I haven't seen anyone on this platform like it. Thanks again.
@@AADadrah Done and no worries. Jump on my discord if you want to chat with me and over a thousand other investors :) #Partner44
Thank you !!!!
Welcome, my friend :)
Thank you so much
You’re welcome :)
I finally got that long sparkline thing to work so, if your ticker is also A2, see if copying this will help. I literally just followed everything he said, awesome vid. =SPARKLINE(Googlefinance($A2,"price", TODAY()-365,today(),"weekly"),{"charttype","line";"linewidth",3;"color",IF(googlefinance(A2,"price")
Cool and thanks :) #Partner34
@@GenExDividendInvestor hey, could you help me with the same sparkline but for 7 days instead of a year? I tried changing the code but i couldn't do it right. Thanks for the guide by the way, very helpfull.
@@spectrius112 Thanks.. try this =SPARKLINE(GOOGLEFINANCE($A2,"price",TODAY()-7,TODAY(),"daily"),{"charttype","line";"linewidth",3;"color", if(googlefinance(A2,"price")
@@GenExDividendInvestor it worked, thank you!
Thanks for the tip, i been wanting to create one , but i have a mac and have been running into problems because it is old , but i will definitely try google sheets 👍🏻
Maximino Alvarez Ya I like it for being free, lol. Thx for watching :) #Partner24
GenExDividendInvestor quick question, i did the sheet already and its awesome thank you, but for annual payout and dividend is there a command that we can enter , so it updates the dividend by itself year after year since companies tend to increase it? 👍🏻
@@spain77777 You could use something like this =regexextract(index(ImportHtml("finviz.com/quote.ashx?t="&A2, "table", 11),7,2),"/*[0-9.]+/*") , where a2 is jnj or whatever. What I do is more complex and have one column for a manual dividend, one for an automatic one... and then do a conditional what the manual doesn't equal the automatic, so that my dividend is highlighted when it increases or decreases.. then I set my manual back to my automatic to clear the highlight. #Partner24
GenExDividendInvestor wow thank you, the number at the end of the formula are the same for all the stocks ?? Sorry i am just trying to understand 👍🏻
@@spain77777 the 2 would change.. &A2 means use the ticker in cell A2. So, if you dragged that formula down over a few rows, then each time you dragged it the formula would change to A3, then A4, etc.. i.e. each row would refer to the ticker in that row in column A. #Partner24
Great video, I cant wait to implement some of the ideas that I learned here today.
Thanks, glad it was helpful! :)
Thank You!
You're welcome! Happy Sunday :) #Partner29
Spreadsheets a great way of highlighting opportunities or deficiencies in your portfolio. Thanks for sharing!
Yeah, I love looking over the data... Thanks :)
Hey there! Thank you so much for making this video. I am new to dividend investing and this is EXTREMELY helpful! I'm having an issue with the "strikeline" and can't figure out how to get it to work. Any way you could assist me please?
Of course. If you look at in the description of this video I share my free Discord server. On there I have a FAQ channel and in the channel is a FAQ document where I list the formulas (like the complicated sparkline formula) so you can copy it directly into your spreadsheet and just change the references to the cell your ticker is in. I'm also on my Discord constantly, so if you get stuck, you can PM me and make a copy of your spreadsheet, delete any sensitive info, and then share it with me email, and I can login directly into your copy of your spreadsheet and put the formulas in.
@@GenExDividendInvestor thank you! Signing up for Discord now
Hey great video, how would I go about changing the currency to GBP from USD cant figure it out without messing with the formula.
=A1*GOOGLEFINANCE("CURRENCY:GBPUSD")
Is there any way to draw from the canadian stock exchange for tickers?
Also is there a way to get a live currency exchange calculation in a cell (like a stock price updating) drawing off of google data?
Yes. I’ve posted a spreadsheet document in the faq channel and document on my Discord. Check that out for answers.