Eikon Excel mnemonic for value of an economic series

Robby Stamper

Hi, I'm trying to retrieve the value of the economic series "aUSCPI/A", but TR.PriceClose doesn't have a value. What Mnemonic should I use to retrieve the monthly CPI level? Thanks, Robby

Robby Stamper

Hi, I am trying to get the ten year yield now. Can you suggest why it may not be working with the code below? I'm assuming that .WithView() should not be ECONOMIC. What view should I use? Thanks.

request = timeSeries.SetupDataRequest("91282CAE1=")

.WithView("ECONOMIC")

.WithAllFields()

.WithInterval(CommonInterval.Monthly)

.WithNumberOfPoints(1000)

.OnDataReceived(DataReceivedCallback)

.OnStatusUpdated(OnStatusUpdated)

.CreateAndSend();

Alex Putkov.1

To retrieve timeseries of economic indicator values into Excel use =RHistory function.

=RHistory("aUSCPI/A","ECONOMIC.Timestamp;ECONOMIC.Value","INTERVAL:1MO",,"CH:Fd")

Robby Stamper

Awesome, thx!

Robby Stamper

I'm actually trying to download the data via the COM interface using C#

When I create the rdata Com object, and subscribe, My OnUpdate() method receives the following error:

"The formula must contain at least one field or function."

instrumentList = "aUSCPI/A"

fieldsList = "ECONOMIC.Timestamp;ECONOMIC.Value"

requestParametersList = "INTERVAL:1MO"

displayParametersList = "CH:Fd"

Am I able to get RHistory() data through the COM interface? If so, could I see some sample code?

Thanks,

Robby

Alex Putkov.1

RHistory COM API can only be used in Excel process with Eikon Excel add-in loaded. If you're creating a custom .NET application, use Eikon .NET API instead. See the Time Series tutorial for an example of using this API for the retrieval of timeseries.

Robby Stamper

I have downloaded the DataApiUsageExampleTimeseriesData solution.

I modified the code to look up CPI data.

Console.WriteLine("[2] Time series request example");

Console.WriteLine("");

request = timeSeries.SetupDataRequest("aUSCPI/A")

//.WithView("BID")

//.WithAllFields()

//.WithInterval(CommonInterval.Monthly)

//.WithNumberOfPoints(10)

.OnDataReceived(DataReceivedCallback)

.OnStatusUpdated(OnStatusUpdated)

.CreateAndSend();

}

private void OnStatusUpdated(IRequestStatus obj)

{

throw new NotImplementedException();

}

If I run it, the OnStatusUpdated method gets fired and obj.Error = "unspecified" and DataReceivedCallBack never gets fired.

If I put back the ticker as the example had it, "EUR=", it works great.

Is my call correct for an Econ time series?

Thanks!

Robby

Alex Putkov.1

When setting up the request you should use .WithInterval(CommonInterval.Monthly) because the default interval is daily. And you should use .WithView("ECONOMIC") .

Robby Stamper

First, Thank you for your swift responses.

Second, This is my new Launch() method and it still fires the same "OnStatusUpdated" event rather than "DataReceivedCallback" event

public void Launch()

{

Console.WriteLine("[2] Time series request example");

Console.WriteLine("");

request = timeSeries.SetupDataRequest("aUSCPI/A")

.WithView("ECONOMIC")

.WithAllFields()

.WithInterval(CommonInterval.Monthly)

.WithNumberOfPoints(10)

.OnDataReceived(DataReceivedCallback)

.OnStatusUpdated(OnStatusUpdated)

.CreateAndSend();

}

Thanks in advance.

Robby

Alex Putkov.1

I just tried it on my end and reproduced the same behavior you experienced. The code should work. However, It looks like there's a problem with the backend for economic indicator timeseries at the moment. RHistory Excel function I provided at the top of this thread now returns "The time series server does not have enough resources to complete the request for: aUSCPI/A". The chart object in Eikon cannot display charts for economic indicators either.

I raised support case #09321086 on your behalf with Refinitiv Helpdesk. The Helpdesk will investigate the issue and will reach out to you when they have any update.

Robby Stamper

Thanks! I hope I didn't break it

Robby

Alex Putkov.1

@Robby Stamper

When asking a new question, please always start a new thread.
To answer your question, ECONOMIC view does not exist for bond RICs. To retrieve native bid yield for US Treasury notes and bonds you can use the default view or BID_YIELD view. For more info see "Views and intervals" section of "Time series" tutorial for Eikon .NET APIs.

m.petitjean

I used RDP.HistoricalPricing

It worked. Thanks.