dburger/gist:e0bea3d4135932be13bf80b1ca2f66f4

Created January 27, 2021 15:58

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dburger/e0bea3d4135932be13bf80b1ca2f66f4.js"></script>
Save dburger/e0bea3d4135932be13bf80b1ca2f66f4 to your computer and use it in GitHub Desktop.

Download ZIP

Google Sheets finviz lookup function.

Raw

gistfile1.txt

=VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTHTML("http://finviz.com/quote.ashx?t="&A3, "table", 8), 12, 6), "*", ""), "%", ""))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment