问题描述
直到几天前，这个 importxml 正在从 yahoo Finance 导入当前价格，但是它现在停止工作了，我不知道为什么.有没有人能够建议修复?非常感谢.
Until a few days ago this importxml was importing the current price from yahoo finance however it's now stopped working and I can't figure out why. Is anyone able to suggest a fix? Thanks a lot.
=INDEX(IMPORTXML("https://finance.yahoo.com/quote/SGLN.L","//*[@id='quote-header-info']/div[3]/div[1]/div/span[1]"),1)
推荐答案
似乎 Yahoo 更改了他们网站中的一些内容，导致导入公式不再适用于 Yahoo Finance 中的某些网页以及一些股票.这是 SGLN.L 代码和仍在工作的 AAPL 代码的 IMPORTXML 命令的结果.
It seems that Yahoo changed some things in their website and it resulted to the import formula not to work anymore for some of the webpage in Yahoo Finance as well as for some tickers. This is the result of the IMPORTXML command for the SGLN.L ticker and for the AAPL ticker which is still working.
就目前而言，我建议您寻找另一个网站/数据源，该网站/数据源将为您提供与那些不可用/不可刮取的代码所需的相同信息.另一种选择是等待雅虎解决此问题.
For now, I suggest finding another website/data source that will give you the same information that you need for those unavailable/unscrapeable tickers. Another option would be to wait for yahoo to fix this issue.
这篇关于IMPORTXML 雅虎财经不再工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！