Workspace Excel Plugin : get last pricing dates and values

Nassim · 2025-02-04T06:12:19+00:00

There was an error rendering this rich post.

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,

Find more posts tagged with

excel

workspace

#content

Accepted answers

All comments

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.

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)

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

EXPLORE OUR SITES