Could you please build a macro that can extract daily data? Please see attached file.

Janice
Janice LSEG
edited April 17 in Eikon COM

Hello Team,

Hope you're okay today.

I'm raising this request on behalf of an external client. Kindly check the attachment, is it possible to build a macro for the above file?

I'm looking forward to your positive response.

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Janice

    Thank you for reaching out to us.

    I checked the excel file and it used the =@BDH function.

    I think it is similar to our =@RDP.Data function in the LSEG Workspace Excel.

    I tried this formula.

    =@RDP.Data("VODJ.J","TR.TurnOver;TR.Volume;TR.CompanyMarketCapitalization;TR.IssueSharesOutstanding(Scale=6);TR.PriceClose;TR.PriceClose.Date","SDate=2025-04-01 EDate=2025-04-16 CH=Fd RH=IN",B2)
    

    However, some values are different.

    Please contact the LSEG Workspace Excel support team directly for the Excel formula that can be used to retrieve those values.