Hi @mjg ,
Have you had a look at the EX-2.05.01-Symbology.ipynb examples? Do they provide the answer you're after?
python u.s. ticker to permid lookup

using the python eikon data API, what is the easiest way to go from U.S. Stock ticker ('AAPL') or at worst ('AAPL.O' as necessary) to PermID?
if my focus is just on U.S. listed stocks just on Nyse and Nasdaq, is there a simple way to pull down a lookup of ticker to permid?
if there isn't a 'simple' solution for major u.s. stocks, what is the least complicated/most efficient way to pull a lookup table of ticker to permid
Best Answer
-
Hi @mjg ,
Have you had a look at the EX-2.05.01-Symbology.ipynb examples? Do they provide the answer you're after?0
Answers
-
thanks that definitely helps move things forward, but i am not quite at the solution i need yet
2 questions on 2 paths that could get me there
1. is there just some file that exists for all US equities thath as all of this data preloaded that i can just access more natively?
2. i now see in that notebook there is evidence i can pass a 'Ticker Symbol' (i.e. AAPL and not AAPL.O) using
symbol_conversion.TICKER_SYMBOL => TickerSymbol
is there any documentation around how the ticker symbols are defined, to make sure i am not making any bad assumptions?
0 -
put another way, if i enter a symbol like MUR this way, does it default to the U.S. MUR (murphy oil) vs the Canadian MUR (Murchison materials)?
response = symbol_conversion.Definition(
symbols=["MUR"],
).get_data()
is the why/how about that documented somewhere? thanks
0 -
0
-
what about PBRa, LGFa, BRKb, CWENa, etc
how do i pass those in as TickerSymbol
and how would i go about understanding why that is
0 -
and finally why, when i query for TickerSymbol = 'PXD', for example, does RIC not come back with PXD.N but rather just PXD. in other words, why does RIC sometimes have the .N or .O suffix and sometimes not when queried with a standard US TickerSymbol
0 -
Hi @mjg ,
1. For an excel file with all the data you're after, you can use screener and pandas' to_csv function.
2. For documentation on the RD lib, please see the Dev. Port..For further information (e.g.: answering your content questions about Ticker Nomenclature in coments below); please ask on my.refinitiv.
0 -
you are suggesting i use a screener to generate the table for all US equities? and just make sure to query for all the pertinent symbology output fields for each? just trying to clarify your suggestion - thanks -
the question becomes circular when we talk about U.S. Equities, and then it starts to beg the question - well what about US ADRs? do i need to have a 'special screener' for those?... and so on ...
0 -
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 650 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛