No. of Recommendations: 11
The Googlefinance functions are fast and varied - and work seemlessly with Google Sheets:
Google: GOOGLEFINANCE - Google Docs Editors HelpPrimer on their use:
blog.sheetgo.com - Googlefinance formula google sheetsI 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.nfusionsolutions.com/widget/table/5...","table",1),4,2),1,100)
Spot Silver: =MID(INDEX(importhtml("
https://widget.nfusionsolutions.com/widget/table/5...","table",1),4,2),1,100)
Enjooy,
Jeff
