EikonDataAPI 0.5.0

.NET 5.0 .NET Core 2.1 .NET Standard 2.0 .NET Framework 4.5
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 Versions
.NET net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows
.NET Core netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1
.NET Standard netstandard2.0 netstandard2.1
.NET Framework net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 net481
MonoAndroid monoandroid
MonoMac monomac
MonoTouch monotouch
Tizen tizen40 tizen60
Xamarin.iOS xamarinios
Xamarin.Mac xamarinmac
Xamarin.TVOS xamarintvos
Xamarin.WatchOS xamarinwatchos
Compatible target framework(s)
Additional computed target framework(s)
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 511 5/17/2022
0.4.9 431 4/21/2022
0.4.8 332 12/17/2021
0.4.7 408 10/1/2021
0.4.6 950 6/23/2021
0.4.5 391 4/27/2021
0.4.3 6,820 3/29/2018