I took another query from this list and have been trying to modify it to get stock symbols and there wikipedia pages. But I am only getting 64 results. Am I doing something wrong, filtering the results?
Thanks in advance!
Hampton
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%...
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
These won't show up on a straight search. I'm not familiar with how searching for qualifiers is best done, but at least it narrows down the problem...
A.
On 13 October 2016 at 18:42, Hampton Snowball hamptonsnowball@gmail.com wrote:
I took another query from this list and have been trying to modify it to get stock symbols and there wikipedia pages. But I am only getting 64 results. Am I doing something wrong, filtering the results?
Thanks in advance!
Hampton
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
When I got to the 'what links here' for p249 seems like a lot more (hundreds) of entries:
https://www.wikidata.org/wiki/Special:WhatLinksHere/Property:P249
On Thu, Oct 13, 2016 at 2:20 PM, Andrew Gray andrew.gray@dunelm.org.uk wrote:
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
These won't show up on a straight search. I'm not familiar with how searching for qualifiers is best done, but at least it narrows down the problem...
A.
On 13 October 2016 at 18:42, Hampton Snowball hamptonsnowball@gmail.com wrote:
I took another query from this list and have been trying to modify it to
get
stock symbols and there wikipedia pages. But I am only getting 64
results.
Am I doing something wrong, filtering the results?
Thanks in advance!
Hampton
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
--
- Andrew Gray andrew.gray@dunelm.org.uk
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Thank you Andrew. You are pointing out that simply trying to export p249 alone is not working properly or needs a different query, I see.
On Thu, Oct 13, 2016 at 3:02 PM, Hampton Snowball <hamptonsnowball@gmail.com
wrote:
When I got to the 'what links here' for p249 seems like a lot more (hundreds) of entries:
https://www.wikidata.org/wiki/Special:WhatLinksHere/Property:P249
On Thu, Oct 13, 2016 at 2:20 PM, Andrew Gray andrew.gray@dunelm.org.uk wrote:
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
These won't show up on a straight search. I'm not familiar with how searching for qualifiers is best done, but at least it narrows down the problem...
A.
On 13 October 2016 at 18:42, Hampton Snowball hamptonsnowball@gmail.com wrote:
I took another query from this list and have been trying to modify it
to get
stock symbols and there wikipedia pages. But I am only getting 64
results.
Am I doing something wrong, filtering the results?
Thanks in advance!
Hampton
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
--
- Andrew Gray andrew.gray@dunelm.org.uk
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
On 13 October 2016 at 19:20, Andrew Gray andrew.gray@dunelm.org.uk wrote:
I'm not familiar with how searching for qualifiers is best done, but at least it narrows down the problem...
Probably worth asking on:
https://www.wikidata.org/wiki/WD:RAQ
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%...
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.
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@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 -
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@wikimedia.org
Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
As far as I can tell on https://www.wikidata.org/wiki/Q156578 VW indeed has three different stock symbols.
On Thu, Oct 13, 2016 at 1:34 PM Hampton Snowball hamptonsnowball@gmail.com wrote:
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@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%...
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@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