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

Janice · 2025-04-16T13:46:53+00:00

There was an error rendering this rich post.

Share cover ratio Bloomberg daily downloads.xlsx

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.

Find more posts tagged with

excel

#content

Accepted answers

All comments

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.

EXPLORE OUR SITES