Post #2133 by OrmontUS on the Mechanical Investing board

Investment Strategies / Mechanical Investing

Unthreaded | Threaded | Whole Thread (8)

Post New | Post Reply | Report Post | Recommend It!

No. of Recommendations: 11

The Googlefinance functions are fast and varied - and work seemlessly with Google Sheets:
https://support.google.com/docs/answer/3093281?hl=...

Primer on their use:
https://blog.sheetgo.com/google-sheets-formulas/go...

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.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

Post New | Post Reply | Report Post | Recommend It!

Print the post

Unthreaded | Threaded | Whole Thread (8)

Prev | Next

Announcements

Mechanical Investing FAQ

Contact Shrewd'm
Contact the developer of these message boards.

A community forum supporting civilized, and highly helpful, self-educating investors that come together for Shrewdness and merry spirits. These message boards closely follow the look and feel of the old message boards at boards.fool.com prior to the boards redirected to discussion.fool.com. Shrewd'm is not affiliated with the comprehensive and excellent investment website, The Motley Fool (TMF), in any way. The Shrewd commmunity here has owed, and continues to owe, gratitude to The Motley Fool for nurturing a culture of jovial irreverence towards Wall St, and that tradition will continue here.