question

Upvotes
Accepted
5 2 4 8

Bug requesting timeseries with DataGrid

I'm trying to basically replicate the following excel formula using the DataGrid api:

=TR(".AXJO","TR.TradePriceClose.date;TR.TradePriceClose","SDate=20160101 EDate=20161010 Frq=D",B3)

To do that my request ends up looking like:

{
  "Entity": {
    "W": {
      "fields": [
        { "name": "TR.TradePriceClose.date" },
        { "name": "TR.TradePriceClose" }
      ],
      "instruments": [ ".AXJO" ],
      "parameters": { "SDate": "2016-01-01", "EDate": "2016-10-10", "Frq": "D" }
    },
    "E": "DataGrid"
  }
}

However while the excel formula works fine, the dates & close prices end up being returned misaligned when using DataGrid. The end of the response payload looks like the following:

...
[".AXJO", "2016-09-27T00:00:00Z", 5452.925],
[".AXJO", "2016-09-28T00:00:00Z", 5483.031],
[".AXJO", "2016-09-29T00:00:00Z", 5467.39],
[".AXJO", "2016-09-30T00:00:00Z", 5475.431],
[".AXJO", "2016-10-03T00:00:00Z", ""],
[".AXJO", "2016-10-04T00:00:00Z", ""],
[".AXJO", "2016-10-05T00:00:00Z", ""],
[".AXJO", "2016-10-06T00:00:00Z", ""],
[".AXJO", "2016-10-07T00:00:00Z", ""],
[".AXJO", "2016-10-10T00:00:00Z", ""] 

Note that 5475.431 is the close price for Oct 10. The number of blanks corresponds to the number of holidays in the window, so eg a request for the last 10 days of data will appear to have worked just fine.

eikoneikon-data-apiapierroreikon-app-studio
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
1.9k 7 10 16

@Charles

As of 5 May, I've received the test result as follows:

...
[".AXJO","2016-09-27T00:00:00Z",5405.9],
[".AXJO","2016-09-28T00:00:00Z",5412.4],
[".AXJO","2016-09-29T00:00:00Z",5471.3],
[".AXJO","2016-09-30T00:00:00Z",5435.9],
[".AXJO","2016-10-03T00:00:00Z",5478.5],
[".AXJO","2016-10-04T00:00:00Z",5484],
[".AXJO","2016-10-05T00:00:00Z",5452.9],
[".AXJO","2016-10-06T00:00:00Z",5483],
[".AXJO","2016-10-07T00:00:00Z",5467.4],
[".AXJO","2016-10-10T00:00:00Z",5475.4]

Below is the screenshot result comparing to TR Eikon Excel:

Please confirm whether it is the result that you expect or not.


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
76.7k 238 52 72

I can replicate this issue with UDF (cpurl://apps.cp./Apps/UDF). I have contacted the Data Grid team to verify the problem.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Jirapongse. I can't find any other way to get the correct date for the price, and TR.TradePriceClose isn't supported by ADC. Appreciate you guys looking into it. Oddly, unlike the currency problem I reported previously, this works fine in Excel.

@Charles

The developer would like to confirm the API that you are using to access the data grid. Is it App Studio - Web SDK (JET) or Eikon Scripting API (Python)?

I was actually just testing it directly with the UDF app; down the track it was for integration in a scripting api project.

Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.