atreadw1492 / yahoo_fin

Scrape stock price history from new (Spring 2017) Yahoo Finance layout
MIT License
286 stars 125 forks source link

"Value Error: No tables found" in tickers_dow() #36

Closed sboteroarango closed 3 years ago

sboteroarango commented 3 years ago

import yahoo_fin.stock_info as si list=si.tickers_dow() print(list)

this returns the error

PanPip commented 3 years ago

I'm having the same issue as @sboteroarango.

Full error message:

  File "C:\...\lib\site-packages\yahoo_fin\stock_info.py", line 204, in tickers_dow
    table = pd.read_html(site)[0]
  File "C:\...\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper
    return func(*args, **kwargs)
  File "C:\...\lib\site-packages\pandas\io\html.py", line 1086, in read_html
    return _parse(
  File "C:\...\lib\site-packages\pandas\io\html.py", line 917, in _parse
    raise retained
  File "C:\...\lib\site-packages\pandas\io\html.py", line 898, in _parse
    tables = p.parse_tables()
  File "C:\...\lib\site-packages\pandas\io\html.py", line 217, in parse_tables
    tables = self._parse_tables(self._build_doc(), self.match, self.attrs)
  File "C:\...\lib\site-packages\pandas\io\html.py", line 547, in _parse_tables
    raise ValueError("No tables found")
ValueError: No tables found

Versions:

atreadw1492 commented 3 years ago

I'll be making a patch for this within the next week.

foobash commented 3 years ago

Is there a work around? (I'm new to the package). Is there a backup of a string of tickers?

tony8688 commented 3 years ago

HI @atreadw1492 is patch already out? and where/how can I apply for it, or would you push a new version of the package with the fix?

atreadw1492 commented 3 years ago

@tony8688 I uploaded the patch to PyPI today (and Github), so if you download the latest version (0.8.8), it should work now.

4F2E4A2E commented 1 year ago

Thank you for this outstanding lib!

I was encountering the same problem and could solve it by adding the following dependencies:

[tool.poetry.dependencies]
python = "3.10.3"
yahoo-fin = {url = "https://files.pythonhosted.org/packages/da/d2/0ac82f1b28492ad49664f630ed8157938d5be808428c7cef81cbd018ae41/yahoo_fin-0.8.9.1.tar.gz"}
requests-html = {url = "https://files.pythonhosted.org/packages/86/76/27a8fd44f43d265af17e75be753b6ebf67c93b1d4dc7cf6eb6ea2d03a13c/requests-html-0.10.0.tar.gz"}
html5lib = {url = "https://files.pythonhosted.org/packages/ac/b6/b55c3f49042f1df3dcd422b7f224f939892ee94f22abcf503a9b7339eaf2/html5lib-1.1.tar.gz"}
pandas = "1.4.3"
feedparser = "6.0.10"
requests = "2.28.1"