OPEN_PRC column in data table only returns ints not doubles
When requesting quarterly/3 month historical data from the Summaries API the data type for the OPEN_PRC column is defined as Int64 which means we're missing data precision for the values. I'm attaching a screen shot of the resulting table...
You can see that the 6 rows in the OPEN_PRC column are all integers.
The code to duplicate the issue...
// Create the platform session.
using ISession session = Sessions.GetSession();
// Open the session
session.Open();
var def = Summaries.Definition()
.Universe("IBM.N")
.Interval(Summaries.Interval.P3M)
.TimestampLabel(Summaries.TimestampLabel.startPeriod)
.Fields("OPEN_PRC", "HIGH_1", "LOW_1", "TRDPRC_1", "ACVOL_UNS", "NUM_MOVES")
.Sessions(HistoricalPricing.Sessions.normal)
.Count(1250)
.Start("2023-01-02T00:00:00Z")
.End("2024-05-28T00:00:00Z")
.GetData();
Common.DisplayTable("Summary for ", dev);
Other instruments do not have the same problem with OPEN_PRC nor do different intervals. Here's a shot of the Visual Studio debugger showing the data type of the OPEN_PRC column...
Best Answer
-
Hello @cory.schmidt.1
I've investigated the issue and there seems a problem with the algorithm deciding the column types.
When data is retrieved from the backend, the first row looks contains an OPEN_PRC value of "190"
Because it is missing precision (it should be "190.00"), this makes the JTokenType for the colum itself to be considered an integer. Afterwards, when creating the data rows, all OPEN_PRC values will be approximated.
I have opened a bug in our backlog and will work towards a fix immediately.
Br,
Cristian
0
Answers
-
Looking at the result, I can see the first hit (row) does contain an open value represented as an integer - which presumably is mistakenly dictating the column type as an integer as opposed to a float. I can also see subsequent values as floats.
I'll report this to the dev team to investigate - thanks for raising.
0 -
I tried loading the new DLLs and am still seeing the same behavior...
Screen shot from the loaded modules list in VS...
0 -
Hello @cory.schmidt.1
Apologies for the mistake!
I tested the BAMS packages in a new console application and it seems that the bug fix is not contained inside them! To remediate the situation I re-created the packages, tested them using a private feed and a console app to double check and redeployed them to BAMS again, then I downloaded the BAMS packages and tested for a 3rd time.
Please download the same version (1.0.7) a second time from BAMS.
Results below from me testing the BAMS packages:
0 -
That did the trick. Thanks for the update.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 中文论坛