question

Upvotes
Accepted
0 0 0 2

My old EIKON-formula =TR(RSearch("OPTION";"UnderlyingQuoteRIC:ALVG.DE StrikePrice:200 ExpiryDate:18.08.2023 CallPutOption:Call ExerciseStyle:A NBROWS:1");"TR.RIC") no longer works in the new Refinitiv-Excel.. Is there any replacement formula ?

My old EIKON-formula =TR(RSearch("OPTION";"UnderlyingQuoteRIC:ALVG.DE StrikePrice:200 ExpiryDate:18.08.2023 CallPutOption:Call ExerciseStyle:A NBROWS:1");"TR.RIC") no longer works in the new Refinitiv-Excel.. Is there any replacement formula ?

#productrefinitiv-data-platform
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
15.5k 32 5 10

Hi @marcel.thaele ,

As a reference, please find the resolution from the content specialist below

You should have "Refinitiv" or "R365" tab to work.
1. Click on Refinitiv Tab
2. Click on Search
3. Click on the Magnifying glass under Widget option
4. Choose Options (Search category)
5. Use all filters shown on my screenshot
6. Click on the Fx icon on the upper right part - set columns and click on Send.

In Eikon : =TR(RSearch("OPTION";"UnderlyingQuoteRIC:ALVG.DEStrikePrice:200 ExpiryDate:18.08.2023 CallPutOption:Call ExerciseStyle:A NBROWS:1");"TR.RIC")

Hope this helps, let me know for any further questions.
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
15.5k 32 5 10

Hi @marcel.thaele ,

Your question is about Eikon Excel rather than about API usage. The best approach is to reach out to Eikon support directly, by submitting Eikon Excel question via Refinitiv Helpdesk Online -> Product -> Eikon rather than posting on dev forums.

To be of help, I have opened a support case on your behalf, case 12760339, please expect an Eikon support expert to reach out to you shortly, via email address that you have registered on developers portal with.

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.