question

Upvotes
Accepted
Troy.Lewis avatar image
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.

wasin.w avatar image   wasin.w

Hello @Troy.Lewis

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

2 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
79.2k ●251 ●52 ●74

@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
Troy.Lewis avatar image
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.