Workspace Excel Plugin : get last pricing dates and values

Nassim
Nassim Newcomer
edited February 4 in Refinitiv Data Platform

Good morning all,

I hope this message finds you well.

I am writing to seek assistance with the LSEG Workspace Excel plugin. Specifically, I need help with retrieving the last pricing date of the year and its value for a security using the Workspace Excel plugin. Despite my efforts, I am unable to achieve the desired result.

I kindly ask you to provide me some guidance on the way to achieve.

Thank you in advance for your support.

Best regards,

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Nassim

    Thank you for reaching out to us.

    In the LSEG Workspace Excel, you can use the Formula Builder tool to create Workspace Excel formulas to get data.

    image.png

    For example, the following formula is used to retrive the close price's date and value.

    =@RDP.Data("LSEG.L","TR.PriceClose.Date,TR.PriceClose","CH=Fd RH=IN",B2)
    image.png

    For questions regarding the Workspace Excel, please contact the helpdesk team direcly via MyAccount.

Categories