How to get stock prices in Excel using Python
7-Day Challenge
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet
There is a fantastic library called yfinance that will fetch any stock price you need from yahoo finance.
Install yfinance
pip3 install yfinanceDownload any stock prices
# We import the library
import yfinance
# We fetch AAPL stock prices for a one year period
df = yfinance.download(["AAPL"], period='1y')
# We then save it as excel file
df.to_excel("apple_prices.xlsx")Here you are! You now know how to download stock price and save it as an excel file.
7-Day Challenge
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet
Related Articles
Continue your learning journey with these related topics
Requests
1 min readHow to use requests in Python
Use 'requests' library in python to send HTTP requests and receive response, also pass headers, cookies, json payload in the request
3/5/2023Read More
Advanced
1 min readHow to compute Bitcoin volatility in Python
The yield keyword in Python allows functions to produce a series of values over time, making it efficient for handling large data sets or for producing a series of values for iteration.
2/21/2023Read More
AI
1 min readHow to analyze the correlation between two variables
Discover various methods to analyze the correlation between two variables in Python using functions such as numpy.corrcoef(), pandas.DataFrame.corr(), scipy.stats.pearsonr(), scipy.stats.spearmanr() and seaborn.pairplot() to understand the relationship between the variables.
2/20/2023Read More
Free Newsletter
Master Data Science in Days, Not Months 🚀
Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚
Weekly simple and practical lessons
Access to ready to use code examples
Skip the math, focus on results
Learn while drinking your coffee