Hi Stas - Thank you so much for your response! It seems the difference
between 1 and 2 is that for the same company name, their are multiple
symbols?
In terms of labeling the symbols - i'd be nice to have that label
information (nyse) in another column, however I can get away with this as
is so thank you for your help!
On Thu, Oct 13, 2016 at 3:50 PM, Stas Malyshev <smalyshev(a)wikimedia.org>
wrote:
Hi!
There are only 73 entries (including some
duplicates) showing up for a
straight P249 search, which is a bit strange in any case -
https://query.wikidata.org/#SELECT%20%3Fitem%20%20%
3Fstock%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP249%20%3Fstock%20.%0A%20%7D
Sampling a few items suggests that most businesses don't use P249
directly, instead they use it as a qualifier on P414, eg
https://www.wikidata.org/wiki/Q156578 or
https://www.wikidata.org/wiki/Q156238
You can use something like this:
http://tinyurl.com/hdoqrjt
The key thing there is UNION - that's how you do "this or that".
Note though ticker symbols are not unique (they are per exchange) so you
may want to either group:
http://tinyurl.com/jmbrf4p or add stock
exchange name to it or do something else, depending on your case.
--
Stas Malyshev
smalyshev(a)wikimedia.org
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata