Post #2765 by rayvt on the Mechanical Investing board

Pause to imagine what posts would you want to read here from others. It will likely be kinder, or involve original research with data, or be detailed and thorough, or all of the above. In response, aim to write your own posts in such a way. This will systemically produce the most valuable boards.

- Manlobbi

Investment Strategies / Mechanical Investing ❤

Unthreaded | Threaded | Whole Thread (5)

Prev | Next

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

No. of Recommendations: 2

I use Tiingo to get the EOD prices of stocks that googlefinance() does not have, or symbols that go to the wrong stock (BDJ is one such).

GF also does not have the symbols for NAV of CEFs, but Tiingo does.

=index(importdata("https://api.tiingo.com/tiingo/daily/" & A16 & "/prices?token={}&format=csv"),2,7)

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

Print the post

Unthreaded | Threaded | Whole Thread (5)

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.