question

Upvotes
Accepted
Robby Stamper avatar image
23 ●4 ●4 ●5

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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
Robby Stamper avatar image
23 ●4 ●4 ●5

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 512.0 KiB each and 1.0 MiB total.

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.