Google Sheets

Query voorbeelden

=IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","9")

=(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL";"Table";9)

=(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL";"Table";9);6;6))

=SUBSTITUTE((index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL";"Table";9);6;6));"*";"")

=SUBSTITUTE((index(IMPORTHTML("https://finviz.com/quote.ashx?t="&B2;"Table";9);7;6));"*";"")

=VALUE(SUBSTITUTE(SUBSTITUTE((index(IMPORTHTML("https://finviz.com/quote.ashx?t="&B2;"Table";9);7;6));"*";"");".";","))

Chrome Console code (om table nummer vast te stellen)

var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });

=EPS * POWER((1+growth);10)