Subject: Re: Grabbing Market Data During Day
The Googlefinance functions are fast and varied - and work seemlessly with Google Sheets:
https://support.google.com/doc...

Primer on their use:
https://blog.sheetgo.com/googl...

I used to scrape from Yahoo Finaance intto Excel, but that blew up about a year ago and, after spending hours trying to tweak it back to life, I made the plunge and switched to the above stuff - which lets me have a "live" spreadheet on my PC.



As an aside, ther are a few frustrations with unsupported functions I wanted - solutions as follows:

The US Dollar Index: USDX = 50.14348112 × EURUSD^-0.576 × USDJPY^0.136 × GBPUSD^-0.119 × USDCAD^0.091 × USDSEK^0.042 × USDCHF^0.036

Spot Gold: =MID(INDEX(importhtml("https://widget.nfusionsolution...","table",1),4,2),1,100)

Spot Silver: =MID(INDEX(importhtml("https://widget.nfusionsolution...","table",1),4,2),1,100)

Enjooy,
Jeff