How to Use the Yahoo Finance API in Python & Excel

In this video, I show you how to use the Yahoo Finance API in Python. The Yahoo Finance API allows you to get stock data, historical quotes, and financial information for companies listed on major exchanges.

Using the lessons in this video, you will be able to access historical and real-time stock data from Yahoo Finance using the Yahoo finance API.

You will also learn how to get data from the Yahoo Finance API to your excel spreadsheet, where you can analyze companies in a more user-friendly way.

In the end, you will also learn how to get the same data in your spreadsheet without coding!

📈 Free stock analysis spreadsheet templates:

🗣 Connect on social media:

0:00 Intro
0:25 Yahoo Finance API background
1:57 install Yfinance
3:02 How the Yahoo Finance API works
3:46 Using the Yahoo Finance API
6:38 Yahoo Finance API to Excel
10:56 No code Excel alternative
14:59 Conclusion

#yahoofinance #api #excel

[fabianfernandez]

For the wisesheets, I am trying to pull in the outstanding shares under the screener section and I am using = WISE("AMZN", "Shares Outstanding", "2023") ad it comes up as unavailable. Is there a different way of pulling data, if what you want is under the "Screener" section?

[rezrfar]

Thanks for sharing. It's really a good start. For quarterly_balancesheet, I'm getting "yfinance failed to decrypt Yahoo data response". Any work around or fix you'd recommend?

[Healthandwealth]

How do I make it so it will do this for any company? Like I don’t want to make an object for each company one at a tjme

[milenium]

Problem : I can't access to TNX US Treasury Bonds Rate - Last Price ? (historical prices)

[yuval_kahan]

So oldi usage haha now days we use chatgpt and python-excel built in
Wow, the improvement of tech is amaze me each time, after 11 months it's "old video"....

[mohamedelwardany]

i'm getting this error:
Exception: yfinance failed to decrypt Yahoo data response

[mrmxyzptlk]

TypeError: string indices must be integers, not 'str'

[diogoraucci]

me to :
TypeError: string indices must be integers, not 'str'

[HIENNGUYEN-brq]

I type:
import yfinance as yf

aapl = yf.Ticker("aapl")

# balance sheet and dividends





and Python shows:
PS D:\PYPTHON THUC HANH> & C:/Python311/python.exe "d:/PYPTHON THUC HANH/CCCC.py"
Traceback (most recent call last):
File "d:\PYPTHON THUC HANH\CCCC.py", line 1, in <module>
import yfinance as yf
ModuleNotFoundError: No module named 'yfinance'

What does it means?