question

Upvotes
Accepted
Robby Stamper avatar image
23 ●1 ●0 ●3

TR.ISStatementLastUpdatedDate not working in excel formula

Hi, when I use the following command

=@TR("BBY","TR.ISStatementLastUpdatedDate","CH=Fd RH=IN",B2)

It returns 9/1/2020. However, if I go to Eikon and look at the income statement there is clearly shows income statement data for 10/31/2020. Shouldn't the date returned by the formula above be several weeks after 10/31/2020?


Many Thanks in advance,

Robby

eikoneikon-com-apiexcel
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Robby Stamper avatar image
23 ●1 ●0 ●3

I figured it out. The period must be defaulting to annual. If I set the Period=FQ0 in the parameters it works!

Thanks,


Robby

icon clock
10 |1500

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

Click below to post an Idea Post Idea