Harish V
1 min readAug 24, 2020

--

Here's the actual string you can use :)

=if (C5 <> "", ifna(1*Substitute(Substitute(INDEX(IMPORTHTML("https://finviz.com/quote.ashx?t="&SUBSTITUTE(C5,".","-"),"table",11),4,4),"*",""),"-",""),0),"")

Replace C5 with your cell number

--

--

Responses (1)