*I’d like to build a dynamic stock screener to use in excel. More specifically, I’d like to mirror the stock screener from Finviz (https://finviz.com/screener.ashx).
I’m aware google sheets has a syntax to pull stock data automatically, but it doesn’t allow to pull sector/ industry taxonomy. Also, google sheets does give you the functionally to pull HTML tables using =importhtml but I’m not so sure how to use this.*
Any help would be appreciated.
Ps. I can’t afford to pay for Capitaliq or Bloomberg. The market has not been friendly to me.
Thanks!
-A