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 ?
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.
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.