EikonDataAPI 0.5.0

dotnet add package EikonDataAPI --version 0.5.0
NuGet\Install-Package EikonDataAPI -Version 0.5.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="EikonDataAPI" Version="0.5.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add EikonDataAPI --version 0.5.0
#r "nuget: EikonDataAPI, 0.5.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install EikonDataAPI as a Cake Addin
#addin nuget:?package=EikonDataAPI&version=0.5.0

// Install EikonDataAPI as a Cake Tool
#tool nuget:?package=EikonDataAPI&version=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

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

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 is compatible.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 is compatible. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net45 is compatible.  net451 is compatible.  net452 is compatible.  net46 is compatible.  net461 is compatible.  net462 is compatible.  net463 was computed.  net47 is compatible.  net471 is compatible.  net472 is compatible.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.5.0 1,624 5/17/2022
0.4.9 1,333 4/21/2022
0.4.8 1,179 12/17/2021
0.4.7 1,275 10/1/2021
0.4.6 2,196 6/23/2021
0.4.5 1,218 4/27/2021
0.4.3 8,307 3/29/2018