this one works better. thanks @shri
If you're familiar enough with html and browsers, inspect the price in chrome and copy the 'xpath' into the second part of the formula with the first bit being the URL ... can be made to work with pretty much any data on a publically available site, as long as they don't block the google docs/sheets crawler.
I noticed these tickers seem to be working again on google as of yesterday. No workaround required.
I'm curious what happened that meant just ETFs disappeared, but we'll probably never know.