Post #4780 by mungofitch on the Mechanical Investing board

Please be patient and understanding when interacting with others, and avoid getting frustrated or upset if someone does not respond to your posts or if a discussion does not go as you expected. Remember that everyone is entitled to express their own perspectives. Furthermore, even when you don't entirely agree, try to benefit in some way from it.

- Manlobbi

Investment Strategies / Mechanical Investing

Unthreaded | Threaded | Whole Thread (16)

Prev | Next

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

No. of Recommendations: 9

Although it's a bit ugly, you can scrape the yahoo historical quotes page.
Pull it up, select all the data, cut, then paste it into Excel (edit/paste/special/text).

I believe you can not longer do that...on my browser, at least, they have managed to block the copy function.

But you can simply go to the history tab, choose your date range, then "File | Save As | xxx.txt", and open that file in Excel. The data table starts a couple of hundred lines from the top. You can get very deep history this way.

Jim

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

Print the post

Unthreaded | Threaded | Whole Thread (16)

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.