EikonDataAPI 0.5.0

Known Issues

1. [.dotnet core, .NET 5.0, .NET 6.0] The data (289203891) in the data frame is rounded to 289203900. https://community.developers.refinitiv.com/questions/94333/trsharesoutstanding-api-rounding.html. This issue has been submitted to the Microsoft.Data.Analysis team https://github.com/dotnet/machinelearning/issues/6221

Changes Log 0.5.0

1. Fix the problem when converting JSON to the Deedle dataframe (.NET Framework). It can detect the floating point values in the column when the first entry in the column is an integer or string (missing value). https://community.developers.refinitiv.com/questions/93235/eikon-api-results-incorrect-for-rics-at-the-back-o.html

Changes Log 0.4.9

1. Change the waiting time for the datagrid async (GetData) to 15 seconds
2. Support .NET 6.0
3. Depend on Microsoft.Data.Analysis 0.19.1
4. Fix the following bug by handling comma characters in the datagrid response values (GetData). Change the number format to use ',' as a decimal point and run the following code. https://community.developers.refinitiv.com/questions/92344/eikondataapi-for-net-issue-data-not-received.html

eikon.GetData("EUR=","CF_LAST");

System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at Microsoft.Data.Analysis.DataFrame.GetColumnName(String[] columnNames, Int32 columnIndex)
   at Microsoft.Data.Analysis.DataFrame.CreateColumn(Type kind, String[] columnNames, Int32 columnIndex)
   at Microsoft.Data.Analysis.DataFrame.LoadCsv(Stream csvStream, Char separator, Boolean header, String[] columnNames, Type[] dataTypes, Int64 numberOfRowsToRead, Int32 guessRows, Boolean addIndexColumn, Encoding encoding)
   at EikonDataAPI.DataGrid.CreateDataFrame(DataResponse response) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\DataGrid.cs:line 51
   at EikonDataAPI.DataGrid.GetData(String instrument, String field, Dictionary`2 parameters) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\DataGrid.cs:line 105
   at EikonDataAPI.Eikon.GetData(String instrument, String field, Dictionary`2 parameters) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\Eikon.cs:line 26

Changes Log 0.4.8

Fixed a bug when using the GetTimeSeries method: https://community.developers.refinitiv.com/questions/88648/how-to-get-in-c-the-same-data-as-in-python-with-ei.html

var historicalData = eikon.GetTimeSeries(
    "GFRUKBWE1",                  //a single RIC to retrieve historical data for
    new DateTime(2021, 1, 1),  //starting date of the historical range
    new DateTime(2021, 4, 10)  //end date of the historical range
    );
historicalData

It threw the following exceptions:

System.ArgumentException: Can not convert Null to Double.
   at Newtonsoft.Json.Linq.JToken.op_Explicit(JToken value)
   at Newtonsoft.Json.Linq.JToken.ToObject(Type objectType)
   at Newtonsoft.Json.Linq.JToken.ToObject[T]()
   at System.Linq.Enumerable.SelectListIterator`2.ToList()
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at EikonDataAPI.TimeSeries.CreateNonNormalizedFrame(TimeSeriesResponse response) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\TimeSeries.cs:line 53
   at EikonDataAPI.TimeSeries.CreateFrame(TimeSeriesResponse response, Boolean normalize) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\TimeSeries.cs:line 142
   at EikonDataAPI.TimeSeries.GetTimeSeries(String ric, DateTime startDate, DateTime endDate, Nullable`1 interval, IEnumerable`1 fields, Nullable`1 count, Nullable`1 calendar, Nullable`1 corax) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\TimeSeries.cs:line 175
   at EikonDataAPI.Eikon.GetTimeSeries(String ric, DateTime startDate, DateTime endDate, Nullable`1 interval, IEnumerable`1 fields, Nullable`1 count, Nullable`1 calendar, Nullable`1 corax) in C:\Users\U8009686\source\repos\EikonDataAPI20191204\EikonDataAPI\EikonDataAPI_CORE20\DataFrame\Impl\Eikon.cs:line 48
   at Submission#10.<<Initialize>>d__0.MoveNext()

Changes Log 0.4.7

• Fixed a bug when guessing the data types in the response. By default, it uses 10 rows. In 0.4.7, it uses all rows in the response to guess the data types. https://community.developers.refinitiv.com/questions/85421/data-conversion-bug.html

var result1 = eikon.GetData(new List<string>() { "0#1KWH2+" }, new List<String>() { "STL_IMPVLT" }, parameters: new Dictionary<string, string>() { });
var result2 = eikon.GetData(new List<string>() { "0#1KWX1+" }, new List<String>() { "STL_IMPVLT" }, parameters: new Dictionary<string, string>() { });

>System.FormatException: 'String '57.61' was not recognized as a valid Boolean.'

Changes Log 0.4.6

• Change the package description to Refinitiv

Changes Log 0.4.5

• Try to downgrade Newtonsoft.Json from 13.0.1 to 12.0.3 due to the problem in dotnet-interactive

System.IO.FileLoadException: Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed'. Could not find or load a specific file. (0x80131621)
File name: 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed'

Changes Log 0.4.4

• Add .NET 4.6.2, 4.7, 4.7.1, and 4.7.2 libraries
• Add .NET Core 2.1, 3.1, and 5.0 libraries
• Support (DataFrame) Microsoft.Data.Analysis for .NET Core
• Update DataGrid to use DataGrid_Async to avoid timeout issue
• Update the profile to look for the .portinuse file in the Refinitiv folder
• Fix the get_data method when there is a first zero in the column with the double data type

Usage

• .NET Libraries for Eikon Data APIs Quick Start
• Using .NET Core in Jupyter Notebook
• Getting started with C# DataFrame and XPlot.Ploty
• Getting Started with Eikon Data API .NET in Jupyter Notebook