TR.SharesOutstanding API rounding

@d.fecher

Eikon Data API .NET uses the DataFrame.LoadCSV function to create a DataFrame from CSV content.

The DataFrame.LoadCSV function uses System.Single for the values of TR.SharesOutstanding which causes the data to be rounded.

I have submitted this issue to the Microsoft.Data.Analysis team to investigate and fix this issue.

For the workaround, you need to call the GetDataRaw method to get the raw data and then convert the raw data to the data frame. The code looks like this:

List<string> fields = new List<string> {
"TR.SharesOutstanding",
"TR.SharesOutstanding.date"
};

Dictionary<string, string> parameters = new Dictionary<string, string> {
 {"SDate", "1D"},
 {"EDate", "-7AY"},
 {"RH", "IN"}
};

List<string> RICs = new List<string> { "FKR.MI^E22" }; // more RICs in the original code

var fetchedData = eikon.GetDataRaw(RICs, fields, parameters);
var dataResponses = JsonConvert.DeserializeObject<DataResponses>(fetchedData, new JsonSerializerSettings
{

});
var response = dataResponses.responses[0];
var col1 = response.data.Select(x => x[0]).ToList();
var col2 = response.data.Select(x => x[1]).ToList();
var col3 = response.data.Select(x => x[2]).ToList();            

StringDataFrameColumn ric = new StringDataFrameColumn(response.headers[0][0].displayName,col1.Select(x => x.ToObject<string>()).ToList());   
PrimitiveDataFrameColumn<int> data = new PrimitiveDataFrameColumn<int>(response.headers[0][1].displayName, col2.Select(x => x.ToObject<int>()).ToList());
PrimitiveDataFrameColumn<DateTime> date = new PrimitiveDataFrameColumn<DateTime>(response.headers[0][2].displayName, col3.Select(x => x.ToObject<DateTime>()).ToList());
var df = new DataFrame(ric, data, date);
Console.WriteLine(df);

The output is: