How to Pull a Stock's Industry Into Google Sheets
📈 Link to download all my Portfolio Trackers: https://www.patreon.com/thinkstocks
☑️ Follow me on Twitter: https://twitter.com/KeithFrislid
🎥 Here is the camera I use for my videos: https://amzn.to/2PB865Q
🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
https://www.sahg6dtr.com/28KL61/R74QP/
In this video, I will show you how to pull a stock's industry into google sheets! I'll admit, this one took me a while to figure out but I finally did it! You can now get the stocks industry into google sheets. I also show you how to create a shortlist of the industry breakdown of your portfolio which is useful if you want to stay diverse and not have too much money in one industry. To top it all off I also show you how to throw that data into a nice pie chart to better visualize the breakdown. If you like this video make sure to smash the like button, subscribe to my channel, and share this video!
Google Sheets Function to pull a stocks industry:
=if(isblank(A2),"",index(importxml("https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A2&"","//div[@class='sub-heading']//span[@class='right']"),1))
AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.
#googlesheets #stocksingooglesheets #googlefinance