Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TRTH /
avatar image
Question by vnigam · Jul 09, 2020 at 02:46 PM · TRTH

How do I pull Tick History Intraday Summaries report for ISIN using TRTH REST API?

I have been pulling RICs using the Tick history Intraday Summaries report and wanted to see if I can do the same using ISIN or CUSIP?

The GUI for these reports on dssscope allows only RICs, see attached screenshot below

ISIN is US912828ZX16 , it's a 2 year .125% coupon US Treasury note

trth.jpg (138.5 KiB)

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Gurpreet · Jul 09, 2020 at 06:02 PM

The sample I provided was the JSON message. If you are using Python dictionary, use this:

body = {
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest",
"ContentFieldNames": [
  "Open Bid",
  "Open Ask",
  "High Bid",
  "High Ask",
  "Low Bid",
  "Low Ask",
  "Close Bid",
  "Close Ask",
  "Volume"
],
"IdentifierList": {
  "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
  "InstrumentIdentifiers": [{
    "Identifier": "US912828ZX16",
    "IdentifierType": "Isin"
  }],
  "ValidationOptions": None,
  "UseUserPreferencesForValidationOptions": False
},
"Condition": {
  "MessageTimeStampIn": "LocalExchangeTime",        #GmtUtc
  "ReportDateRangeType": "Relative",                #Range
  "RelativeStartDaysAgo": 1,
  "RelativeStartTime": "09:00:00.000",
  "RelativeEndDaysAgo": 1,
  "RelativeEndTime": "17:15:00.000",
  "TimeRangeMode": "Inclusive",
  # "ExtractBy": "Ric",
  # "SortBy": "SingleByRic",
  "DateRangeTimeZone": "Eastern Time (US & Canada)", #"UTC-05:00",  #"Local Exchange Time Zone",
  "SummaryInterval": "OneMinute",
  "TimebarPersistence": True,
  "DisplaySourceRIC": False
}
}
}

and be sure to convert it into JSON before sending it to server like:

data = json.dumps(body)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Gurpreet · Jul 09, 2020 at 03:25 PM

Hi @vnigam, You can use Identifier type = Isin when making your request. E.g:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest",
    "ContentFieldNames": [
      "Close Ask",
      "Close Bid",
      "High Ask",
      "High Bid",
      "Low Ask",
      "Low Bid"
    ],

    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{
          "Identifier": "US912828ZX16",
          "IdentifierType": "Isin"
        }
      ],

      "ValidationOptions": null,
      "UseUserPreferencesForValidationOptions": false
    },

    "Condition": {
      "MessageTimeStampIn": "GmtUtc",
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2020-07-08T09:00:00",
      "QueryEndDate": "2020-07-08T17:00:00",
      "SummaryInterval": "TenMinutes",
      "TimebarPersistence": true,
      "DisplaySourceRIC": false
    }
  }
}
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by vnigam · Jul 09, 2020 at 03:39 PM

Hi Gurpreet,

Couple questions:

  1. My query is a schedule relative query, I updated it as below. But still getting this error: Can you confirm if my parameters are correct?

HTTP status of the response: 400

An error occured. Try to run this cell again. If it fails, re-run the previous cell.

2. I executed the query you sent above and I'm getting same error. Also the true, false and null are not in quotes in your query. my python interpreter is showing those as errors

requestBody={
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest",
    "ContentFieldNames": [
      "Open Bid",
      "Open Ask",
      "High Bid",
      "High Ask",
      "Low Bid",
      "Low Ask",
      "Close Bid",
      "Close Ask",
      "Volume"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{
        "Identifier": "US912828ZX16",
        "IdentifierType": "Isin"
      }],
      "ValidationOptions": "null",
      "UseUserPreferencesForValidationOptions":"false"
    },
    "Condition": {
      "MessageTimeStampIn": "LocalExchangeTime",        #GmtUtc
      "ReportDateRangeType": "Relative",                #Range
      "RelativeStartDaysAgo": 1,
      "RelativeStartTime": "09:00:00.000",
      "RelativeEndDaysAgo": 1,
      "RelativeEndTime": "17:15:00.000",
      "TimeRangeMode": "Inclusive",
      # "ExtractBy": "Ric",
      # "SortBy": "SingleByRic",
      "DateRangeTimeZone": "Eastern Time (US & Canada)", #"UTC-05:00",  #"Local Exchange Time Zone",
      "SummaryInterval": "OneMinute",
      "TimebarPersistence": "true",
      "DisplaySourceRIC": "false"
    }
  }
}
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
11 People are following this question.

Related Questions

Difference in bahaviour if instruments are validated before before populating a request

How to parse downloaded elektron timeseries?

TRTHv1 Qualifier in TimeAndSales/Trade for NSQ and NYQ

About GMT display issue

Error in retrieving TRTH contract info

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges