My old EIKON-formula =TR(RSearch("OPTION";"UnderlyingQuoteRIC:ALVG.DE StrikePrice:200 ExpiryDate:18

marcel.thaele
marcel.thaele
in Refinitiv Data Platform

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 ?

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @marcel.thaele ,

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

    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.

Answers

  • raksina.samasiri
    raksina.samasiri admin

    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.

Categories