Google Sheets
Uit dotSearch
Versie door 24.132.32.135 (Overleg) op 10 okt 2022 om 08:49 (Nieuwe pagina aangemaakt met '=IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","9") =(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL";"Table";9) =(index(IMPORTHTML("https://fin...')
=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));"*";"");".";","))
var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); });
=EPS * POWER((1+growth);10)
