What are the codes to use for Settlement Price and 1d Return for .NET API?

Marc_Belen24

We are looking for codes to use for Settlement Price and 1D Return for .NET API. Any RIC will do.

Marc_Belen24

https://community.developers.refinitiv.com/discussion/132392/what-are-the-codes-to-use-for-settlement-price-and-1d-return-for-net-api

Full query:

We are converting from Refinitiv Eikon to LSEG Workspace, and have APIs which extract securities prices for analysis.Our programmer needs some guidance to modify his code to work in the new environment. 

Can you introduce me to someone who can guide our programmer to write code that will work the LSEG Workspace API?

nick.zincone

Hi @Marc_Belen24

Can you post the specific Refinitiv Eikon API call to extract security prices? There is significant learning material for the .Net library on our dev portal. Based on the question, it appears you may need to utilize this interface to retrieve the data.

Marc_Belen24

https://community.developers.refinitiv.com/discussion/comment/126213#Comment_126213

Hello Nick thank you for the response, please see client's progression:

Our programmer has made some progress migrating the Eikon APIs to Workspace, however after utilizing the LSEG developer community resources he is still unable to get these 2 fields to retrieve data. 

Below is his code for the fields.

Is there anyone at LSEG in technical support who can debug this code or suggest alternative code that retrieves Settlement Price and 1Day Return?

1. Get Settlement Price    

 List<string> settlementFields = new List<string> { "TR.SettlementPrice", "TR.SettlementPrice.Date" };    var parameters = new Dictionary<string, string>(){    {"SDate", x.AsOfDate.ToString("yyyy-MM-dd")}, {"EDate", x.AsOfDate.ToString("yyyy-MM-dd")},    {"Frq", "D"}, {"CH", "Fd"}}; 

settlementData = eikon.GetData(new[] { x.TrTicker }, settlementFields, parameters); 

============

2. Get 1D Return 

Field Description: Daily Total Return 

    List<string> returnfields = new List<string>{    "TR.TotalReturn1D.date", "TR.TotalReturn1D"};    var returnParameters = new Dictionary<string, string>(){    {"SDate", x.AsOfDate.ToString("yyyy-MM-dd")}, {"EDate", x.AsOfDate.ToString("yyyy-MM-dd")},    {"Frq", "D"}, {"CH", "Fd"}};

returnData = eikon.GetData(new[] { x.TrTicker }, returnfields, returnParameters);

 

Maria_Aliwalas

Hi @nick.zincone

Is there anyway someone from your team can jump in on a call with the client? They have been requesting for a call for quite some time now.

Please see the below response from the client.

We looked at the link your dev team provided, and our programmer thinks the code has the potential to work.
He will try installing it tonight.

Please be aware that we are a small business, depending on LSEG data for our daily processes. We have been trying in good faith to solve the problem using LSEG documentation and forum resources for many days now. LSEG’s transition deadline is approaching, and our programmer’s time is limited. While I agree that it is nice to have public forum discussions to allow others to learn from our experiences, these indirect conversations have uncertain response times which are causing us delays in the project steps that depend on this needed code. Once working, we would be happy to share code in the form.

However, if the code does not work tonight, we will need to have a live consultation with your development team tomorrow, Tuesday June 10. I would appreciate it if you could prepare a representative for the possibility of a live call tomorrow, without trying to deflect or delay us any longer. Such a call would not take a lot of time as we would have a live screen available to test working and non-working API commands in parallel.

nick.zincone

https://community.developers.refinitiv.com/discussion/comment/126214#Comment_126214

Hi @Marc_Belen24,

Please see this answer:

is there a corresponding date field to the TR.SETTLEMENTPRICE field? — LSEG Developer Community