How to extract adjusted BPV for FGBLc1=CTD using python api from DSS
hi,
I would like to download the daily BPV time-series for
- FGBLc1=CTD
- FGBSc1=CTD
- FGBMc1=CTD
- FGBLc1=CTD
How can I do that via a python api?
Regards
Sumit
Best Answer
-
I only found the Quote - BPV field in the Tick History Time and Sales report template.
Please contact the DSS support team directly via MyRefinitiv to verify if this field is avaiable in DSS report templates.
0
Answers
-
Thank you for reaching out to us.
I assume that you are using Datascope Select REST API.
To extract the data through DSS, you need to have instruments, report templates, and content fields that can provide the requried data.
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.
I found the Quote - BPV field in the Tick History Time and Sales report template which belong to the LSEG Tick History product.
After that, you can test the request message in Postman. Please refer to the Datascope Select or Tick History tutorials. If the request message works, you can use Postman to generate the Python cdoe for you, as mentioned in this Generate code for a REST API call using Postman in just a few clicks article.
For example:
This Tick History Time and Sales template provides tick data and the request message is:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
"ContentFieldNames": [
"Quote - BPV"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [{
"Identifier": "FGBLc1=CTD",
"IdentifierType": "Ric"
}],"ValidationOptions":{"AllowHistoricalInstruments": true,"AllowOpenAccessInstruments":true}
},
"Condition": {
"MessageTimeStampIn": "GmtUtc",
"ApplyCorrectionsAndCancellations": false,
"ReportDateRangeType": "Range",
"QueryStartDate": "2024-01-01T00:00:00.000Z",
"QueryEndDate": "2024-01-20T12:00:00.000Z",
"DisplaySourceRIC": true
}
}
}Send this message to the https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw endpoint with the HTTP Post method. The output looks like this:
#RIC,Alias Underlying RIC,Domain,Date-Time,GMT Offset,Type,BPV
FGBLc1=CTD,,Market Price,2024-01-01T00:31:51.111376995Z,+0,Quote,8.382
FGBLc1=CTD,,Market Price,2024-01-01T01:31:51.116361300Z,+0,Quote,8.382
FGBLc1=CTD,,Market Price,2024-01-01T02:31:51.121392371Z,+0,Quote,8.382
FGBLc1=CTD,,Market Price,2024-01-01T03:31:51.126400940Z,+0,Quote,8.382If you are unable to find the required content fields, please contact the DSS support team directly via MyRefinitiv. The support team will verify the required content fields for you.
0 -
Thanks you so much for the quick response. I copied the above and hit send. I get this... Also attached is my header with the Authorization key
{
"error": {
"message": "No permission for template \"TickHistoryTimeAndSalesReportTemplate\"."
}
}0 -
Hi- just realised this example is using tickHistory. Do you have an example using DSS?0
Categories
- All Categories
- 6 AHS
- 37 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 中文论坛