Post #3272 by Aussi on the Mechanical Investing board

Investment Strategies / Mechanical Investing

Unthreaded | Threaded | Whole Thread (13)

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

No. of Recommendations: 8

The source that Elan mentioned for retrieving pricing (Jason Strimpel http://finance.jasonstrimpel.com/bulk-stock-downlo...) has not been working for the last few weeks so I am trying Wisesheets that was also mentioned. For Excel, Wisesheets does not work on Excel 2019 for retrieving pricing, it does work for getting other data. They advised that you need Microsoft 365. On Goooglesheets it works fine. The only issue I have noticed is that although there is a formula for adjusted prices, the most recent dividend is not included (at least in the three stocks I checked, XOM, APPL and GOOG). I have written to them and received a reply that they would check with their vendor.

Aussi

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

Print the post

Unthreaded | Threaded | Whole Thread (13)

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.