Eikon Excel mnemonic for value of an economic series

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
Best Answer
-
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();
0
Answers
-
To retrieve timeseries of economic indicator values into Excel use =RHistory function.
=RHistory("aUSCPI/A","ECONOMIC.Timestamp;ECONOMIC.Value","INTERVAL:1MO",,"CH:Fd")
0 -
Awesome, thx!
0 -
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
0 -
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.
0 -
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
0 -
When setting up the request you should use .WithInterval(CommonInterval.Monthly) because the default interval is daily. And you should use .WithView("ECONOMIC") .
0 -
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
0 -
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.
0 -
Thanks! I hope I didn't break it
Robby
0 -
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.0 -
I used RDP.HistoricalPricing
It worked. Thanks.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 250 ETA
- 555 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛