question

Upvotes
Accepted
Nitin_Sharma avatar image
1 ●0 ●0 ●0

TickHistoryTimeAndSales: Can we Retrieve all columns which we get in available field list and with same column names

Hello Team,

We are performing following steps:

1. Getting list of available columns for TickHistoryTimeAndSales. i.e approx 372 coumns

2. Based on these columns we are creating table.

3. Retrieve data and trying to push data in table created in above step . i.e approx 290 columns

Problem: CSV data retrieved in step 3, contains less number of columns and the header column names are abbreviated names, not the same as we get in step 1.

For Example:

Available Fields Name Received:

Quote - CDS Dollar Value Of 1 Basis Point

Trade - Exchange For Swaps Volume

Correction - Original Sequence Number


Actual Fields recived:

CDS Dollar Value Of 1 Basis Pt

Exch For Swaps Vol

Original Seq. No.


How can we get same number of columns and with exact same field name in step 3 as we get in step 2?

Thanks.


tick-history-rest-api
icon clock
10 |1500

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

zoya faberov avatar image   zoya faberov

Hello @Nitin_Sharma,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,

-AHS

chavalit-jintamalit avatar image   chavalit-jintamalit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS


1 Answer

· Write an Answer
Upvotes
Accepted
veerapath.rungruengrayubkul avatar image
11.3k ●25 ●9 ●14

Hi@Nitin_Sharma,

I have seen the same result on both GUI and REST API. The field number difference could be due to the way the result is regenerated.

For example, the following request contains 7 fields.

{ "ExtractionRequest": 
    { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest", 
      "ContentFieldNames": [
             "Quote - Exchange Time",
            "Correction - Ask Price",
            "Correction - Bid Price",
            "Quote - Ask Price",
            "Quote - Bid Price",
            "Trade - Ask Price",
            "Trade - Bid Price"
        ] , "IdentifierList": {"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
        "InstrumentIdentifiers": [
            {"Identifier": "AAPL.O",
            "IdentifierType": "Ric"
            }

The request generates only 4 data fields; "Type","Bid Price","Ask Price","Exch Time" As you see, TRTH combines the fields of each asset type and differentiate them with the "Type" field. This could be a reason why the number of fields are difference.

#RICAlias Underlying RICDomainDate-TimeGMT OffsetTypeBid PriceAsk PriceExch TimeAAPL.O
Market Price2020-01-31T17:00:00.189157913Z-5Quote316.75316.800:00.2AAPL.O
Market Price2020-01-31T17:00:00.241179076Z-5Trade316.75316.8
AAPL.O
Market Price2020-01-31T17:00:00.292697303Z-5Quote316.75316.800:00.3AAPL.O
Market Price2020-01-31T17:00:00.329169722Z-5Quote316.75316.7900:00.3AAPL.O
Market Price2020-01-31T17:00:00.411913813Z-5Trade316.75316.79
AAPL.O
Market Price2020-01-31T17:00:00.532239237Z-5Quote316.75316.7900:00.5AAPL.O
Market Price2020-01-31T17:00:00.604227938Z-5Trade316.75316.79
AAPL.O
Market Price2020-01-31T17:00:00.688233791Z-5Quote316.75316.7700:00.7AAPL.O
Market Price2020-01-31T17:00:00.851694641Z-5Quote316.75316.7700:00.8AAPL.O
Market Price2020-01-31T17:00:01.058700932Z-5Trade316.75316.77
AAPL.O
Market Price2020-01-31T17:00:01.104259058Z-5Trade316.75316.77


With regard to the field name difference, I have the same result as well but cannot find any options. I would suggest you raise these issues to TRTH Content support via MyRefinitivfor further investigation and explanation.

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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