In this video, you'll learn exactly how to use the yfinance library in Python to extract real-time and historical data from Yahoo Finance — including stock prices, financial statements, income statements, balance sheets, and even Bitcoin data. Whether you're working with stocks, ETFs, or cryptocurrencies, this tutorial walks you through the full process step by step.
We’ll show you how to:
Install and use yfinance in PyCharm or any Python environment
Pull stock data for companies like Microsoft, Apple, Tesla, and more
Export financial data (like balance sheets or dividends) directly into Excel
Troubleshoot common issues with time zones and formatting
Plot financial charts using Matplotlib and visualize stock price trends
PLUS — we introduce an even faster and easier way to build powerful models right in Excel and Google Sheets using Wisesheets. With Wisesheets, you can:
Automatically retrieve stock data for over 80,000 global companies
Filter stocks based on financial metrics like ROIC, PE Ratio, Market Cap, and more
Use built-in templates to build dynamic models with just a few clicks
Compare company financials with real-time updates — no code required!
Whether you're a developer, analyst, or just getting into investing — this is your complete guide to automating your stock research using Python and Excel.
📌 Try Wisesheets here: https://www.wisesheets.io
📈 Free stock analysis spreadsheet templates:
1. Excel roaring kitty (DFV) analysis template: https://wisesheets.io/assets/discord_...
2. Excel discounted cash flow model (DCF): https://wisesheets.io/assets/dcf.xlsx
3. Google Sheets stock tracker: https://docs.google.com/spreadsheets/...
4. Google Sheets roaring kitty (DFV) analysis template: https://docs.google.com/spreadsheets/...
5. ETF/Funds Comparison: https://wisesheets-templates.s3.us-ea...
🗣 Connect on social media:
https://www.tiktok.com/@wisesheets?la...
/ wisesheets
/ discord
https://x.com/wisesheets
#financialanalysis #investing #stockanalysis #yahoofinance #python #yfinance
0:00 Intro
0:33 Installing the YFinance Library
1:25 Pulling Stock Data from Yahoo Finance
6:38 Plotting Our Data
9:17 Incorporating The Data in Excel
13:58 An Alternative for the YFinance API
On this page of the site you can watch the video online YFinance API Full PythonTutorial with a duration of hours minute second in good quality, which was uploaded by the user Wisesheets Investing 24 May 2025, share the link with friends and acquaintances, this video has already been watched 11,724 times on youtube and it was liked by 139 viewers. Enjoy your viewing!