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 -
yes and i tried asking a followup question or two - can you look at my followup messages? thanks0
-
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
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛