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
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#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
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Known Issues
- [.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
- 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
- Change the waiting time for the datagrid async (GetData) to 15 seconds
- Support .NET 6.0
- Depend on Microsoft.Data.Analysis 0.19.1
- 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
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.
-
.NETCoreApp 2.1
- Microsoft.Data.Analysis (>= 0.19.1)
- Microsoft.Extensions.Logging (>= 2.1.0)
- Newtonsoft.Json (>= 12.0.3)
-
.NETCoreApp 3.1
- Microsoft.Data.Analysis (>= 0.19.1)
- Microsoft.Extensions.Logging (>= 3.1.14)
- Newtonsoft.Json (>= 12.0.3)
-
.NETFramework 4.5
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 1.1.2)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.5.1
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 1.1.2)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.5.2
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 1.1.2)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.6
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 1.1.2)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.6.1
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 2.0.1)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.6.2
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 2.2.0)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.7
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 2.2.0)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.7.1
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 2.2.0)
- Newtonsoft.Json (>= 13.0.1)
-
.NETFramework 4.7.2
- Deedle (>= 2.3.0)
- Microsoft.Extensions.Logging (>= 2.2.0)
- Newtonsoft.Json (>= 13.0.1)
-
.NETStandard 2.0
- Microsoft.Data.Analysis (>= 0.19.1)
- Microsoft.Extensions.Logging (>= 2.0.0)
- Newtonsoft.Json (>= 12.0.3)
-
net5.0
- Microsoft.Data.Analysis (>= 0.19.1)
- Microsoft.Extensions.Logging (>= 5.0.0)
- Newtonsoft.Json (>= 12.0.3)
-
net6.0
- Microsoft.Data.Analysis (>= 0.19.1)
- Microsoft.Extensions.Logging (>= 6.0.0)
- Newtonsoft.Json (>= 12.0.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.