How I Use Python to Import Stock Data into Google Sheets | Gspread and Yahoo_fin Packages
Hey ya'll! In this video I'm going to be showing you how I use Python to import stock data into Google Sheets. I'm using the gspread package (which enables you to connect your python script to the Google Sheets API) and the yahoo_fin package (which enables you to get a variety of data for stocks) to achieve this. I'm definitely not an expert, but I think I have enough knowledge to share this subject with you. Hopefully after this video you will have the knowledge and resources to do this yourself! You will need some external resources which I will link below.
TIMESTAMPS:
00:00 Intro
00:12 Why Python?
01:02 What You Need
01:27 Yahoo_fin
04:57 Gspread
06:45 Google Sheets Example
12:15 Quote
12:55 Outro
13:34 Disclaimer
How to download Python (Free):
• How to Install Python 3.8.2 on Window...
How to authorize your Python script to access a Google Sheets File:
• Access and Edit Google Sheets with Py...
Documentation and other info on the yahoo_fin package:
http://theautomatic.net/yahoo_fin-doc...
http://theautomatic.net/2018/01/25/co...
Check out FIRE Options Trading (he showed me the yahoo_fin package):
/ @fireoptions
Please Like, Subscribe, and Comment if you enjoyed this video. It helps other people see this content and it helps my channel grow. I really appreciate all the support. Thanks!
Also if you think others would enjoy my channel please share it with others: / @frankmularcik
Watch this other video of mine:
• Dividend Income Update ~ August 2020 ...
Follow me on Instagram: / frankmularcik
Follow me on Twitter: / frankmularcik
Disclaimer: I am not a financial advisor; this video is for entertainment and educational purposes only. Please do your own research before making any investment decisions.
