将Yahoos Key Statistics Page中的精彩信息提取到Excel中 [英] Pulling sprecific info from Yahoos Key Statistics Page into Excel

问题描述

Hello， 

Hello, 

我目前正试图从雅虎的关键统计页面中提取财务信息。我能够在线找到一个脚本，但我无法弄清楚如何调整脚本以导入同一个excel选项卡上的所有数据，而不是为每个自动收报机创建一个新的单独选项卡
。我也只是试图提取3条信息：总债务（mrq），总现金（mrq），收入（ttm），NNet收入Avl与普通（ttm）：和市值（盘中）5：

I am currently trying to pull financial information from Yahoo's Key Statistics Page . I was able to find a script online but i cannot figure out how to adjust the script to import all of the data on the same excel tab rather than creating a new separate tab for every ticker. I am also only trying to pull 3 pieces of information: Total Debt (mrq), Total Cash (mrq), Revenue (ttm), NNet Income Avl to Common (ttm): and Market Cap (intraday)5:

任何人都可以提供帮助吗？谢谢!!

Can anyone assist? Thank you!!

推荐答案

Hi Solar

Hi Solar

I建议添加某种仅显示所需数据的概述表。这可以通过使用工作表公式来完成，这样您就不必触摸下载的现有代码。

I suggest to add some kind of overview sheet which displays only the required data. This can be done by using worksheet formulas so you do not have to touch the existing code you downloaded.

使用INDIRECT公式是因为它允许在不破坏公式的情况下删除数据表。运行宏后，将重新创建数据表，并且概览表上的公式仍然有效。

The INDIRECT formula is used because it allows to remove the data sheets without breaking the formulas. Once you run your macro the data sheets will be re-created and the formulas on the overview sheet will still work.

这有用吗？

干杯，卢卡

这篇关于将Yahoos Key Statistics Page中的精彩信息提取到Excel中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！