Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
FinancialData - how to find ticker symbols?
194 views
Skip to first unread message
Mikael
Nov 8, 2011, 7:19:19 AM11/8/11
to
Hi everyone,
I am trying to retrieve data for some European stocks using FinancialData but I am having difficulties to find the corresponding ticker symbols for the stocks I am interested in.
As an example suppose I am interested in German Siemnens or Swedish Volvo stocks. I understand that I can use
FinancialData["Exchanges"]
to find the names of exchanges but I have not been able to find the ticker symbol for those stocks I am looking for.
I wonder also what would be the general way of doing this if I just know the name of a company and the country where it is traded. Thanks.
I am trying to retrieve data for some European stocks using FinancialData but I am having difficulties to find the corresponding ticker symbols for the stocks I am interested in.
As an example suppose I am interested in German Siemnens or Swedish Volvo stocks. I understand that I can use
FinancialData["Exchanges"]
to find the names of exchanges but I have not been able to find the ticker symbol for those stocks I am looking for.
I wonder also what would be the general way of doing this if I just know the name of a company and the country where it is traded. Thanks.
Chris Degnen
Nov 9, 2011, 6:31:11 AM11/9/11
to
My method has been to Google the stock, e.g. Siemens, finding "SI".
Then look up possible tickers to find a match
possibles = FinancialData["*:SI", "Lookup"]
Check the names and exchanges
FinancialData[#, "Name"] & /@ possibles
FinancialData[#, "Exchange"] & /@ possibles
And finally check the quote matches what I expect:
FinancialData["NYSE:SI"]
Then look up possible tickers to find a match
possibles = FinancialData["*:SI", "Lookup"]
Check the names and exchanges
FinancialData[#, "Name"] & /@ possibles
FinancialData[#, "Exchange"] & /@ possibles
And finally check the quote matches what I expect:
FinancialData["NYSE:SI"]
Mikael
Nov 10, 2011, 6:57:42 AM11/10/11
to
Thanks Chris, that is basically what I have been doing too.
I thought there might be a more systematic way of doing this but judging from lack of replies I guess that is what we have to do.
I thought there might be a more systematic way of doing this but judging from lack of replies I guess that is what we have to do.
Brett Champion
Nov 10, 2011, 7:12:00 AM11/10/11
to
On Nov 8, 2011, at 6:15 AM, Mikael wrote:
> Hi everyone,
>
> I am trying to retrieve data for some European stocks using
FinancialData but I am having difficulties to find the corresponding
ticker symbols for the stocks I am interested in.
>
> As an example suppose I am interested in German Siemnens or Swedish
Volvo stocks. I understand that I can use
>
> FinancialData["Exchanges"]
>
> to find the names of exchanges but I have not been able to find the
ticker symbol for those stocks I am looking for.
>
> I wonder also what would be the general way of doing this if I just
know the name of a company and the country where it is traded. Thanks.
>
I use Wolfram|Alpha for this. In a new cell, type '=volvo stock' and
> Hi everyone,
>
> I am trying to retrieve data for some European stocks using
FinancialData but I am having difficulties to find the corresponding
ticker symbols for the stocks I am interested in.
>
> As an example suppose I am interested in German Siemnens or Swedish
Volvo stocks. I understand that I can use
>
> FinancialData["Exchanges"]
>
> to find the names of exchanges but I have not been able to find the
ticker symbol for those stocks I am looking for.
>
> I wonder also what would be the general way of doing this if I just
know the name of a company and the country where it is traded. Thanks.
>
it tells me I want FinancialData["PK:VOLVY"]. (Without the 'stock'
Siemens defaults to the unit instead of the company.)
Brett
0 new messages