How To Create a Simple Stock Portfolio Tracking Spreadsheet From Scratch Using Google - Part 2
How To Create a Simple Stock Portfolio Tracking Spreadsheet From Scratch Using Google – Part 2
Check out my recent release of my new 2.0 spreadsheet portfolio tracker product! • Best Dividend Stock Spreadsheet Portf... Very very cool!
This is a follow up video to my Part 1 tutorial video ( • How To Create a Simple Dividend Stock... ) where I've added a variety of things.
NOTE: Here is a link to a spreadsheet (https://bit.ly/2LASCJy) where I made a better/more correct stock transaction history sheet, so you can store all your transactions on it rather than by sheet per stock (you would just do an insert, and then drag down the appropriate cells). I accidentally said cost basis vs average price in this video, so that link I included should be more useful.
Support me & get Patreon perks ➜ / genexdividendinvestor
Join the Dividend Discord chat server: / discord
You can also download the discord smartphone app and then in the invite field put in kkSr5FY
Please LIKE, COMMENT and SUBSCRIBE to support this channel. Thanks, I really appreciate it!
Get more great info - Subscribe! ➜ https://www.youtube.com/c/GenExDivide...
Share this Video ➜ • How To Create a Simple Stock Portfoli...
Watch this Video next ➜ • Best Dividend Stock Spreadsheet Portf...
My Dividend Portfolio on M1 ➜ https://m1.finance/9gGguPKhh
Referral Link to M1 ➜ https://m1.finance/AUzJllYh-gGh
Instagram ➜ / genexdividendinvestor
Reddit ➜ / genxdividendinvestor
Twitter ➜ / genexdividend
Investing Books to read (as an Amazon Associate I earn from qualifying purchases):
The Intelligent Investor ➜ https://amzn.to/2WPwgtj
One Up on Wall Street ➜ https://amzn.to/2YTDAXt
Rich Dad, Poor Dad ➜ https://amzn.to/2SUCwOZ
The Richest Man in Babylon ➜ https://amzn.to/2SUHStw
A Random Walk Down Wall Street: The Time-Tested Strategy for Successful Investing ➜ https://amzn.to/2YUgjo4
The Bogleheads' Guide to Investing ➜ https://amzn.to/2STECPp
Other Books I Like (as an Amazon Associate I earn from qualifying purchases)
Skin in the Game ➜ https://amzn.to/3fD4lFt
How to Win Friends and Influence People ➜ https://amzn.to/3dxHI3p
The 7 Habits of Highly Effective People ➜ https://amzn.to/2WP86iv
The Five Dysfunctions of a Team: A Leadership Fable ➜ https://amzn.to/3fDXLhM
My Recording Gear (as an Amazon Associate I earn from qualifying purchases):
Blue Yeti Microphone - Blackout edition ➜ https://amzn.to/3cm40os
Professional Foam Windscreen Cover for Blue Yeti ➜ https://amzn.to/2YVNqYG
Boom Mic Stand to Clip Blue Yeti on Desk ➜ https://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. The data shared may be inaccurate.
INFO:
How do I create a logo?
Go into the cell, and insert-image-image in cell, google image search, and search for company logo. Click the one you want and then click insert.
How do I create the sparkline?
See Discord -- I can't use the brackets needed here per Google.
How do I create the 5 year Div CAGR?
=((J2/I2)^(1/5))-1
Where J2 is the dividend paid out in 2020 q1, and i2 is the dividend paid out in 2015 q1.
IEX
https://iexcloud.io/
API documentation for IEX:
https://iexcloud.io/docs/api/#api-ref...
ImportJSON code
http://www.chicagocomputerclasses.com...
I was hoping I could link all the other formulas here, but YouTube is blocking them out. So, if you log onto my Discord server, and click on the rules-and-faq-and-info channel, then click on the "FAQ..." document -- the formulas are all in there. Sorry about that -- didn't know Google had these limitations until after I posted my vid!
Copyright © 2020 Gen Ex Dividend Investor. All rights reserved.
#StockPortfolio #GoogleSpreadsheet