Datastream DSWS: fundamentals date
Hi - I'm using WC07240 (Net Sales), but I have a problem when I set the variable dtAsOfDate to previous business day which gives me NA for my stocks. I want to see the relevant value + date for this item for my stocks - but how can I get this?
Date = new DSSnapshotDate(DSDateType.Absolute(dtAsOFDate)
Best Answer
-
Please try the following code.
var DataRequest = new DSDataRequest()
{
Instrument = new DSInstrument(new string[] { "U:IBM","Q:PTTB" }),
DataTypes = new DSDataTypes("WC07240"),
Date = new DSTimeSeriesDate(DSDateType.Literal(DSDateLiterals.YearToEnd), DSDateType.Literal(DSDateLiterals.Time), DSDateFrequency.Yearly)
//Date = new DSSnapshotDate(DSDateType.Literal(DSDateLiterals.YearToEnd))
};The output is:
If it still doesn't work, please contact the Datastream support team directly via MyRefinitiv and ask for the formula and parameters used to retrieve the required data. It could be parameters for the Datastream Excel-Addin. Then, we can use the same parameters in the .NET code.
0
Answers
-
Thanks for reaching out to us.
To get dates, you may use the TimeSeries request instead.
The code looks like this:
var DataRequest = new DSDataRequest()
{
Instrument = new DSInstrument("U:IBM"),
DataTypes = new DSDataTypes("WC07240"),
Date = new DSTimeSeriesDate(DSDateType.Literal("-2Y"), DSDateType.Literal(DSDateLiterals.LatestDate), DSDateFrequency.Yearly),
//Date = new DSSnapshotDate(DSDateType.Literal(DSDateLiterals.LatestDate))
};
var response = DSClient.DataService.GetData(DataRequest);
for(int i = 0;i < response.Dates.Length; i++)
{
Console.WriteLine("{0}: {1}",response.Dates[i],response.DataTypeValues[0].SymbolValues[0].GetValue<double[]>()[i]);
}The output is:
From the output, the data for 2022 is not available.
I hope this will help.
0 -
Thanks Jirapongse.
What I really do want is the LAST (LATEST) reported FY0, so for IBM example would be 2021. What is the code that would be point to this? I have a number of stocks so don't want to see NaN as you would see above as the 'latest date'. Thanks, HG.
0
Categories
- All Categories
- 6 AHS
- 37 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛