Google Sheets: verschil tussen versies
Uit dotSearch
(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...') |
|||
| (Een tussenliggende versie door dezelfde gebruiker niet weergegeven) | |||
| Regel 1: | Regel 1: | ||
| + | '''Query voorbeelden''' | ||
| + | |||
=IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL","Table","9") | =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) | ||
| + | |||
=(index(IMPORTHTML("https://finviz.com/quote.ashx?t=AAPL";"Table";9);6;6)) | =(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=AAPL";"Table";9);6;6));"*";"") | ||
| + | |||
=SUBSTITUTE((index(IMPORTHTML("https://finviz.com/quote.ashx?t="&B2;"Table";9);7;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));"*";"");".";",")) | =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); }); | var i = 1; [].forEach.call(document.querySelectorAll('table'), function(x) { console.log(i++, x); }); | ||
| + | |||
=EPS * POWER((1+growth);10) | =EPS * POWER((1+growth);10) | ||
Huidige versie van 10 okt 2022 om 08:50
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)
