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 ?

Find more posts tagged with

refinitiv-data-platform

#product

Accepted answers

raksina.samasiri

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.

All comments

raksina.samasiri

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.

raksina.samasiri

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.

EXPLORE OUR SITES