Use DSS api from a python call
hi,
I have the below code to fetch EOD data via eikon api. I frequently end up with connectivity issues - sometimes no data retireved, sometime partial data retrieved.
I have been asked to use DSS api instead. Can you please provide me with a alternate version of ek.get_data()? My code is:-
ek.set_app_key("2580e18557624af8a1ab810fc5012449982e0407") isin_list = ['US911312BW51', 'US836205AT15', 'US015271AU38'] date_str = '2024-06-30' df, err = ek.get_data(
instruments=isin_list,
fields=reuters_fields,
parameters={
'SDate': date_str,
'CH': 'IN;Fd',
'RH': 'date',
'EventType': 'ALL'
}
)
Answers
-
The Reuters fields that I am looking to extract as-of a given historical date are:-
reuters_fields = [
'TR.ZSPREAD', 'TR.MODIFIEDDURATION', 'TR.YIELDTOMATURITY',
'TR.FiIndustrySector', 'TR.FiCountry', 'TR.FiCurrency',
'TR.FiMaturityDate' # 'TR.FiMoodysRating', 'TR.FiIssuerFitchLongRating'
]0 -
Going through the tutorials and other posts in this forum, I've managed to come up with a python code to connect to DSS Rest API and get the pricing info. Shown below is my request payload:
{"ExtractionRequest": {"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest", "ContentFieldNames": ["Z Spread", "Modified Duration", "Bid Yield", "ISIN", "RIC", "Trade Date"], "IdentifierList": {"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [{"IdentifierType": "Isin", "Identifier": "US911312BW51"}, {"IdentifierType": "Isin", "Identifier": "US836205AT15"}]}, "Condition": {"QueryStartDate": "2024-06-30T00:00:00.000Z", "QueryEndDate": "2024-07-02T00:00:00.000Z"}}}
However, I couldn;t find any examples on how to extract:-
- Issuer (Ex: AAPL, MSFT)
- Issuer sector (Ex: Auto / Manu etc)
- Country Iso code of Issuance (Ex: US, EU, BR etc)
What is the end-point I should target for these end-of-day non price related information?
Thanks
0 -
I tried the below request, but I get a aut
"ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.OwnershipExtractionRequest", "ContentFieldNames": ["Issuer Name", "Currency Code", "Issuer Sector", "Owner Type", "Owner Country"], "IdentifierList":{ "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList", "InstrumentIdentifiers": [{"IdentifierType": "Isin", "Identifier": "US911312BW51"}, {"IdentifierType": "Isin", "Identifier": "US836205AT15"}]} }
I get the below error:
Exception occurred: Error: Status Code:403 Message:{"error":{"message":"No permission for template \"OwnershipReportTemplate\"."}}
Am I on the right track?
Thanks,
Sumit
0 -
Thank you for reaching out to us.
According to the error (No permission for template), this indicates that your account don't have a permission to use the OwnershipExtractionRequest report template. Please contact your LSEG account team or Sales team directly to verify this.
To find the required fields, you can refer to the LSEG DataScope Select Data Content Guide that provides definitions of all of the data fields available in LSEG DataScope Select. Otherwise, you can contact the DSS support team directly via MyAccoutnt and ask for fields and report templates that can provide the required data.
0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 613 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
- 248 ETA
- 552 WebSocket API
- 37 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
- 629 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 86 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛