Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by bibin.jose · Oct 08, 2019 at 09:25 PM · eikoneikon-data-apirfaeikon-com-api.net

.NET examples for getting basis,contract month and last values

I was trying to get basis, contract month and last values for SOYBCHSSVG-C1 . Since I learned that getting history not possible with python I switched to .NET.

Here most of the examples show how to get the open, close, high and low with examples like


foreach (IBarData bar in chunk.Records.ToBarRecords())

{

if (bar.Open.HasValue && bar.High.HasValue && bar.Low.HasValue && bar.Close.HasValue && bar.Timestamp.HasValue)

{



it will be great if anyone can give some examples of how to deal with the basis, contract month and last values


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 Jirapongse · Oct 10, 2019 at 09:22 AM

@bibin.jose

The code to retrieve that data is:

            ITimeSeriesDataRequest tsRequest = timeSeries.SetupDataRequest("SOYBCHSSVG-C1")
                      .WithView("NDA_RAW")
                      .From(DateTime.Today.AddMonths(-1))
                      .WithInterval(CommonInterval.Daily)
                      .OnDataReceived(chunk =>
                      {
                          Console.WriteLine("{0}", chunk.Ric);
                          foreach (IData record in chunk.Records)
                          {
                              foreach (string field in record.Keys)
                              {
                                  Console.Write("{0}:{1} ", field, record[field]);
                              }
                              Console.WriteLine("");
                          }
                      })
                      .CreateAndSend();


The output is:


The code uses the ITimeSeriesDataService to retrieve historical data. For more information, please refer to the Time Series tutorial.


output.png (49.2 KiB)
Comment
bibin.jose

People who like this

1 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 Jirapongse · Oct 09, 2019 at 03:35 AM

@bibin.jose

If the data is below, the answer could be similar to this thread.

The chain RIC is 0#SOYBCHSSVG:. The fields could be "DSPLY_NAME", "DATE_RANGE","PRIMACT_1", and "GEN_VAL1". However, you need to contact the content support team via my.refinitiv.com for confirmation regarding RICs and fields.

The code looks like:

IRealtimeService realtime;
...
            
            List<string> rics = new List<string>();
            var chainRequest = realtime.GetChain("0#SOYBCHSSVG:", true, constituents =>
            {
                // Iterate through chain constituents
                foreach (var constituentRic in constituents)
                {               
                   // Console.WriteLine("{0}", constituentRic);
                    rics.Add(constituentRic);

                }
                var snapRequest = realtime.SetupDataRequest(rics).WithFields(new List<string> {"DSPLY_NAME", "DATE_RANGE","PRIMACT_1","GEN_VAL1"}).OnDataReceived(
                    update =>
                    {
                        foreach (var record in update)
                        {
                            Console.Write("{0} ", record.Key);
                            foreach (var val in record.Value)
                            {
                               // Console.WriteLine("{0} : {1}", val.Key, val.Value.Value.ToString());
                                Console.Write("{0}\t", val.Value.Value.ToString());
                            }
                            Console.WriteLine("");
                        }
                    }
                    ).CreateAndSend();
            });

The output is:


The code uses real-time data API to retrieve the data. For more information, please refer to the Real-time data tutorial.


soy.png (51.7 KiB)
output.png (20.6 KiB)
Comment
bibin.jose

People who like this

1 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 bibin.jose · Oct 09, 2019 at 01:53 PM

@jirapongse.phuriphanvichai


Thank you. I am looking for something like this.



I know what is the RIC's but not sure about the fields.


I a trying to get the historical data like this. Is this possible?



eikon12.jpg (54.3 KiB)
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 >
9 People are following this question.

Related Questions

Eikon .NET API DispatcherFrame

How to convert timeseries quotes from original currency to e.g. EUR?

How can I use the .NET API in batch(non-callback) query mode?

Eikon .Net API accepts 2-3 time series requests and returns data but then hangs without throwing any errors thrown.

.NET API - Realtime eligibility

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges