BTW, Deriscope look like a deeply thought out research effort
Thanks for the nice words! I have indeed invested a lot of effort into this product. It is actually not a "research effort" any more as it has already reached version 3.0 and meant to be used in production. My biggest need is ... PROMOTION! But that's another story.
BTW, I note that the IEX list seems to include hundreds of exchange-traded products.
It does. IEX delives 8,507 tickers broken down as:
Common Stock: 5,416
Preferred Series: 525
And my favorite: we don't have to wait for them to do it.
I fully agree with you on that!
What way of getting the data to your user's spreadsheets would work best for you? Would a CSV/text file with symbols that produce valid data from AV hosted on GitHub pages ...
The way I get data for my existing providers right now is two-fold:
For IEX I simply use their api here. It returns a json output.
For Yahoo Finance I use hard-coded text files that I have created myself.
I guess the best for me would be something similar to what IEX does. A url that returns the data either in json or csv.
Needless to say that if you provide me with such a utility, I will obviously mention your name and effort in the part of the Deriscope application where interactive usage description is displayed. Provided you have nothing against it of course!