Download, Transform and Write Data to Excel with Python || Stock Analysis with Python Part 6
HTML-код
- Опубликовано: 22 июн 2022
- @Matt Macarty
#dataanalytics #pythonprogramming #stockmarket
Python and Excel - Learn how to use Data API to download, transform and export data to Excel in 5 minutes!
✅ Please SUBSCRIBE:
ruclips.net/user/subscription_...
Videos:
[Part 1]( • How to Get a List of ... )
[Part 2]( • How to Download S&P 50... )
[Part 3]( • How to Download and Sa... )
[Part 4]( • Stock Analysis with Py... )
[Part 5]( • Calculate Returns, Cre... )
[Part 6]( • Download, Transform an... )
[Part 7]( • Python for Stock Analy... )
[Part 8]( • Stocks About to Announ... )
[Part 9]( • How to Create a Stock ... )
[Part 10]( • Automate Stock Analysi... )
[Part 11]( • Python for Stock Analy... )
[Part 12]( • How to Calculate & Nor... )
**This video is for educational purposes only. The information provided should not be construed as investment advice. **
✅ Get the code:
github.com/mjmacarty/python-s...
✅ If you are interested in subscribing to a data bundle from EODHistoricalData, use this link for special pricing (I get a referral):
eodhistoricaldata.com/alphabench
Use Python extract columns of data from stored files for any number of securities
Just keeping commenting to boost your RUclips algorithm! Thanks again ahah
Thank you
Loving your work, can you do the same with mySQL?
Thank you. You mean storing data in a relational database rather than in . csv files? Yes there are a number of database drivers you can install to interact with MySQL, PostGres, etc. The Python standard library ships with sqlite , which in broad strokes behaves pretty much the same as MySQL, but with less overhead. Or do you mean something else?
@@MattMacarty thats what I meant, im currently working on it with sqlite because 180,000 rows of excel isnt really fast when using formulas
@@victorbozhkov7121 OK. Is sqlite also slow? You can directly import CSV into MySQL, but that process can be slow with large datasets.
How do you not have 10x more followers? I know why. People want get rich quick, instead of GOLD that will lead them on a journey. Thanks for your Algo-Trading series w/ python
Thanks. Glad it helped