Client is using Eikon C# API, would like to get settlement price
I am using the Eikon C# API.
I'm given a DataChunk object in my callback, which contains an IEnumerable<IData> called Records; this is the data returned from Eikon, set up via this call:
timeSeriesReq_ = DataServices.Instance.TimeSeries.SetupDataRequest().WithRic(ticker_)
.From(start)
.To(end)
.OnDataReceived(OnTimeSeriesData)
.WithView("TRDPRC_1")
.WithInterval(CommonInterval.Daily)
.CreateAndSend();
The items in the DataChunk.Records enumerable can be converted to BarRecords (which contains fields high/low/open/close/timestamp), or TickRecords (if you asked for a CommonInterval.Tick interval; these contain Value/Volume/Timestamp fields).
Nothing I've seen gives me a field anything like SETTLEMENT or SETTLEMENTPRICE, and certainly not TR_SETTLEMENTPRICE. What do I need to request to get the settlement price please?
Best Answer
-
The original question does not provide any RIC being used.
So I picked up "TRDEBMc1" which has a SETTLE view for the demonstration purpose.
GCZ4 and GCZ5 are not a valid RIC code?
Regarding to the content inside the ALT_SETTLE view or any other available views and content availability:
This forum is not the best place to ask about content questions.
For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/So I would suggest you use Eikon Excel to try to retrieve the data you are looking for, then you can do that same on API.
0
Answers
-
0
-
Hi @chavalit.jintamalit. I'm monitoring Myline's case since she's currently out of the office. The client has a follow-up question on this:
"I had been using view TRDPRC_1, as per the code I sent you yesterday. If I change that to use the view SETTLE, I don't get any callbacks from the TimeSeries, i.e. I receive no data at all?"
Thanks in advance!0 -
0
-
Hi @Alex.Conti @RafaelAdrian.Ingaran
I can get the data using TRDEBMc1 RIC code with SETTLE view:
You can check the data using Eikon Excel.
0 -
Hello @chavalit.jintamalit
I received a follow up question from the client
Thank you, but for what I'm trying to do, this just isn't the case?! I don't know if it's something to do with the RICs I require (all available contracts for gold, silver and copper futures), the fact that it's metals, or what, but when I use the following code, I get absolutely zero callbacks into the OnTimeSeriesData(...) function:
In this particular case, the start date is 02 Dec 2020 and the end date is 04 Dec 2020. Settlement prices are available (obviously; the CME website shows them), yet I get nothing back?
If I use the view TRDPRC_1, I get data - but not every day for all contracts (there should be a settlement price for all contracts, even if they haven't traded), so that isn't settlement prices either.
What's going on?
0 -
Hello @myline.sevilla,
GCZ0 instrument has no SETTLE view available.
I.e.
_viewListRequest = timeSeries.GetViewList("GCZ0", ViewsCallback);
Results in
Views available
ALT_SETTLE/1:Daily/DATE
ASK/1:Tick/Timestamp
BID/1:Tick/Timestamp
BLKVOLUM/1:Daily/Timestamp
FLOOR_VOL/1:Daily/DATE
LOLIMIT/1:Tick/Timestamp
LTR/1:Daily/Timestamp
MARKET OPEN INTEREST/1:Daily/DATE
MID_PRICE/1:Tick/Timestamp
NDA_RAW/1:Daily/DATE
NETCHNG_1/1:Tick/Timestamp
OPINT_1/1:Tick/Timestamp
PCTCHNG/1:Tick/Timestamp
TOT_VOLUME/1:Daily/Timestamp
TRDPRC_1/1:Tick/Timestamp
TSDB_RAW/1:Minute/TSDB_CloseTime
TSFCP_RAW/1:Minute/TSDB_CloseTime
UPLIMIT/1:Tick/Timestamp
VWAP/1:Tick/TimestampThe RIC provided by @chavalit.jintamalit "TRDEBMc1" has SETTLE view available:
Views available
ASK/1:Tick/Timestamp
BID/1:Tick/Timestamp
NDA_RAW/1:Daily/DATE
SETTLE/1:Daily/DATE
TRDPRC_1/1:Tick/Timestamp
TSDB_RAW/1:Minute/TSDB_CloseTime
TSFCP_RAW/1:Minute/TSDB_CloseTimeYou will be able to request SETTLE view and get values
Console.WriteLine(
"{0}: <RIC_REQUESTED> values {1} {2} ",
trade.Timestamp.Value.ToShortDateString(),
trade.Values.ElementAt(0),
trade.Values.ElementAt(1)
);results in
11/24/2020: <RIC_REQUESTED> values 35 11/24/2020 12:00:00 AM
11/25/2020: <RIC_REQUESTED> values 36.8 11/25/2020 12:00:00 AM
11/26/2020: <RIC_REQUESTED> values 39.3 11/26/2020 12:00:00 AM
11/27/2020: <RIC_REQUESTED> values 40.1 11/27/2020 12:00:00 AM
11/30/2020: <RIC_REQUESTED> values 45.55 11/30/2020 12:00:00 AM
12/1/2020: <RIC_REQUESTED> values 43.5 12/1/2020 12:00:00 AM
12/2/2020: <RIC_REQUESTED> values 44.15 12/2/2020 12:00:00 AM
12/3/2020: <RIC_REQUESTED> values 43.15 12/3/2020 12:00:00 AM
12/4/2020: <RIC_REQUESTED> values 46.45 12/4/2020 12:00:00 AM
12/7/2020: <RIC_REQUESTED> values 45.3 12/7/2020 12:00:00 AMHope this helps
0 -
Thanks, but again, this doesn't answer my question: for any futures contract for GC, HG, SI, there is no SETTLE view, so how do I retrieve settlement prices for these futures contracts? I have no idea where TRDEBMc1 came from, I don't have any interest in retrieving data for it. But the fact that it has a SETTLE view, but GCZ0 (for example) doesn't is weird - they all have settlement prices?
0 -
Try:
request = timeSeries.SetupDataRequest("GCZ0")
.WithView("ALT_SETTLE")
.WithAllFields()
.WithInterval(CommonInterval.Daily)
.WithNumberOfPoints(10)
.OnDataReceived(DataReceivedCallback)
.CreateAndSend();
}And
foreach (IData data in chunk.Records.AsEnumerable())
{
Console.WriteLine(
"<RIC_REQUESTED> values: {0} {1} ",
data.Values.ElementAt(0).ToString(),
data.Values.ElementAt(1).ToString()
);
}I see values, are they it:
<RIC_REQUESTED> values: 1415.7 12/22/2017 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 12/26/2017 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 12/27/2017 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 12/28/2017 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 12/29/2017 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 1/2/2018 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 1/3/2018 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 1/4/2018 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 1/5/2018 12:00:00 AM
<RIC_REQUESTED> values: 1415.7 1/8/2018 12:00:00 AM0 -
Again, thanks, but I don't think that's correct either - that view gives prices for GCZ0, but if I ask it for GCZ4 or GCZ5 I get nothing. These contracts have settlement prices, even if there were no actual trades, so that view isn't the settlement price either.
0 -
That's interesting, thank you. I should have put at the beginning that I require data for gold, silver and copper CME futures, all available contracts.
And this begs the question: why aren't GCZ4 and GCZ5 valid RICs? Dec 2024 and Dec 2025 are valid contracts on the CME, and they have settlement prices, how come they're not available via Eikon?
0 -
I do not know the answer as to why the GCZ4 and GCZ5 are invalid.
Or how would Dec 2024 and Dec 2025 content available on Eikon?
Please use the same ticket that you have with helpdesk to ask this content question.
0 -
Hi Julian,
For Dec 2024 and Dec 2025, please use RICs GCZ24 and GCZ25.
Thanks,
Myline
0 -
For CME gold, silver and copper futures the settlement prices are in the view TRDPRC_1, field 'Close'.
0
Categories
- All Categories
- 6 AHS
- 39 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛