晨星整合 [英] Morning Star Integration

问题描述

我一直在尝试制作一个全面的Google表格，其中包含有关不同库存的信息，可以针对学校项目动态添加和删除库存.为此，我对使用IMPORTHTML从表中加载数据进行了一些研究，并提出了以下建议:

I've been trying to make a comprehensive Google Sheet containing information about different stocks that can have stocks dynamically added and removed for a school project. To that end, I've done some research into loading data from tables with IMPORTHTML, and come up with this:

=IMPORTHTML(CONCAT("http://financials.morningstar.com/ratios/r.html?t=", B3),"table", 1)

其中B3是NFLX或将要添加的任何其他股票报价器.但是，Sheets会返回导入的内容为空"，我不知道为什么.

Where B3 is NFLX or any other stock ticker that would be added. However, Sheets is returning with `Imported content is empty", and I've got no clue why.

推荐答案

我无法告诉您Ahmed Masud在哪里获得了链接(我也想知道).我得到很多 来自Morningstar的数据，它们可能很奇怪.但是，使用他的链接，您可以 键比并使用importhtml清理结果数据，并使用以下代码引用您的B3单元:

I can't tell you where Ahmed Masud got the link (and I would like to know too). I get a lot of data from morningstar and they can be strange. However, using his link, you can get the Key Ratios and clean the resulting data with importhtml and also reference your B3 cell with this:

   =arrayformula(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IMPORTHTML("http://financials.morningstar.com/finan/financials/getFinancePart.html?t=XNAS:"& B3 &"&region=usa&culture=en-US&ops=clear","table", 1), "<\/td>" , "" ),"<\/tr>",""),"<\/th>",""),"<\/thead>",""),"<\/span>",""))

对不起，我输入了错误的公式.这将获得B3条目.

Sorry, I put in the wrong formula. This will get the B3 entry.

这将获得所有权:

=arrayformula(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IMPORTHTML("http://investors.morningstar.com/ownership/shareholders-overview.html?t=XNAS:"& B3 &"&region=usa&culture=en-US&ops=clear","table", 4), "<\/td>" , "" ),"<\/tr>",""),"<\/th>",""),"<\/thead>",""),"<\/span>",""))

同样，股票代码应在B3中.

Again the stock symbol should be in B3.

这篇关于晨星整合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！