question

Upvotes
Accepted
1 1 1 1

how do i get a specific close price using Eikon Excel Add-in?

Hi All,


I want to pull closing prices for a RIN ."BAID" based on a column containing historical dates in excel. How could i go about doing this? So far I have only been able to pull the most recent closing price using:


=@TR(".BAID","TR.CLOSEPRICE")


I have a column with dates written as below and want to pull values matching those dates. Ideally, i tried the below, but it did not work:


=TR(".BAID", "TR.CLOSEPRICE", "Date=" & TEXT(H96, "yyyy-mm-dd")


1693496770641.png


Thanks.

eikon#product#contentexcel
1693496808279.png (2.9 KiB)
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
80.3k 259 52 75

@Troy.Lewis

Thank you for reaching out to us.

You can use the SDate and EDate parameters, as shown below.

1693540287614.png

If this doesn't meet your requirement, please contact the Eikon Excel support team directly via MyRefinitiv.


1693540287614.png (37.2 KiB)
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
1 1 1 1

Thanks, this didn't answer my question unfortunately, i'll reach out to support.

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.