-
Historical exchange data extraction
Hello, For a project I would like to extract monthly data. What I need is for each month historically to extract which stocks were in a specific exchange. For example: the names of all the stocks that where in the euronext Paris exchange in the month of march 2008. (all those that were active at that time, also those that…
-
PYTHON API Extraction Not Yielding Results
Hi Team, Hoping for your help in checking the code of the client below, for some reason, they are not receiving any results when querying for MarketDepth: Code: def ExtractRaw(token, json_payload): try: outputfilepath = str(_outputFilePath + _outputFileName + str(os.getpid()) + '.csv.gz') if os.path.exists(outputfilepath):…
-
How to get futures data for ES and BTC and AAPL?
I'm trying to get futures order book information for the E-mini (ES) and futures data for say Bitcoin: 0#BTC. Where can I get this information? Can you show me python code to use to get this order book data. This is how I get stock data. Is it similar? json_blob = { "ExtractionRequest": { "@odata.type":…
-
How do you pass in the correct RIC to a TickHistoryMarketDepthExtractionRequest
I have this code to get the sp_500 list of tickers: def get_sp500(): import requests import json url = "https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes" payload = json.dumps({ "ExtractionRequest": { "@odata.type":…
-
When do CSVs become available for download for all exchanges? I'm download ticker order book ric
Hi I'm making requests to download TickHistoryMarketDepth data. "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest", "IdentifierList": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",…
-
Missing data for 'End of Day' data pull on expired/ inactive RICs
I am trying to pull data on python through the end of day extraction url, for a number of expired RICs specifically for spreads on LCO, CL, HO, RB, LGO. For most of the spreads I have managed to pull all the daily data for High, Low, Last, Open and Volume successfully. However there are still many that have missing data. I…
-
How can I return the Exchange Code for a constituent instrument ric using the Search/HistoricalChain
I am using this API code for HistoricalChain Search but unable to get the Source/Exchange code. What is the reason? Product is Tick History https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalChainResolution { "Request": { "ChainRics": [ "0#.KQ150" ], "Range": { "Start": "2023-01-31T00:00:00.000Z", "End":…
-
Intraday FX data from DataScope Select API
Hey everyone, I'm trying to retrieve tick-level FX traded price data from the REST API. However, the code I'm using (attached below) isn't returning any data. I’d really appreciate any help—thanks in advance! { "ExtractionRequest": { "@odata.type":…
-
Tick History Intraday Summary default timezone
Can you advise me the default time zone value for below condition under Tick History Intraday Summary? DateRangeTimeZone MessageTimeStampIn
-
In Time and Sales report, how do we exclude "off book" records?
In the "Qualifiers" column in Time and Sales report, there are some entries which are Off Book Trades. How do we exclude this using the API ? Qualifiers S[ACT_FLAG1];S[CONDCODE_1];[CONDCODE_2];N [ELIGBL_TRD];Off Book Trades[USER];"SI "[TR_TRD_FLG];47------MP----[MMT_CLASS]
-
Can I ask if there is an endpoint in DSS where I can query to see just the notes portion of the r...
...esponse (the notes where it says how many RICs some chain RIC expanded to) so that I can determine how to best split the query? Can I ask if there is an endpoint in DSS where I can query to see just the notes portion of the response (the notes where it says how many RICs some chain RIC expanded to) so that I can…
-
Recommendation with using the https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/Ex...
...tractWithNotes without taking so much time I am trying to download reference history for futures option contracts. I was using this REST API: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/ReferenceHistory It was recommended that I change to use…
-
Tick History - Criteria Search - Pull all RICs starting with 0#
Hello, I am trying to extract all Chains for given exchange using criteria search but keep getting error. What am i missing in the code? Request: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalCriteriaSearch HTTP/1.1?Prefer=respond-async&Content-Type=application/json { "Request": { "RicPattern":…
-
tickhistory data extraction time
One of clients is interested in TickHistory time and sales data for FX such as NOKSEK= and SEKJPY=R. They would like to know the following points: * If they would like to extract 5 year history, what would be the best chunk to recommend to retrieve the tick data? e.g. 1 year or 5 year? I understand that in Best Practice…
-
XML File output format
I have a question regarding XML file format. Is it compatible with XML format required by Refinitiv Playback tool (testserver): https://developers.lseg.com/en/article-catalog/article/quick-start-guide-recording-and-playback-refinitiv-real-time-data? If not, can you please advise what toll s are available to us so we can…
