Yahoo Finance API (Stock Data Download) Dead? Other Options???

It looks like the ability to download current stock prices (and other data) from Yahoo Finance (as a CSV file) has been discontinued (since 11/1/17). I've been using the code below to download a bunch of data for a list of comma-separated ticker symbols (StockTickers). Now it always gives the dreaded Run-time Error '1004':

Please Login or Register  to view this content.

Is there another option to download current stock data? If so, sample VBA code would be very helpful. I found info for the IEX API, but I don't know how to translate that into VBA (or if that's even possible).
The most crucial data I need is Last Price (or most recent price). I'd also like to grab other data like 52-week high and low, book value, P/E ratio, etc. if it's available.

There are lots of thread on this topic. I think I saw one in the last 5 days. People who used Yahoo have now shifted to Google finance.

I found lots of online posts about Yahoo discontinuing the download of historical stock prices (back in May 2017), but few if any concerning this recent action. I'm not looking for historical data; I'm looking for current data.

I'd be glad to use Google Finance. Could you give me some more detailed info on how to code that in VBA? I imagine it's not as simple as replacing "yahoo" with "google" in my current code...