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 <smalys...@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 > smalys...@wikimedia.org > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata >
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata