Using the LSEG COM library for Workspace in Excel VBA what is the best way to return company dividend information? TR.DivExDate etc.
@JasonBW
Thank you for reaching out to us.
To get the "TR" data items, you need to use the Fundamental and Reference. Please refer to the following resources.
You can use the Data Item Brower tool to search for fields and parameters.
Thank you @Jirapongse .
My code is now returning data, however this call: Set result = ld.GetData(Array("BOQ.AX"), Array("TR.DivUnadjustedNet", "TR.DivPeriodType", "TR.DivExDate", "TR.DivPayDate", "DivFrankedPercent"), "SDate=2025-10-27 DivPayType=CDI DateType=ED EDate=2026-01-28 CH=Fd RH=IN")
returns Empty values for DivPeriodType and DivFrankedPercent but returns good values from spreadsheet: =@RDP .Data($I$11,"TR.DivUnadjustedNet;TR.DivType;TR.DivExDate;TR.DivPayDate;TR.DivFrankedPercent","SDate=2025-10-27 DivPayType=CDI DateType=ED EDate=2026-01-28 CH=Fd RH=IN",K12). Can you please let me know why?
The field name (DivFrankedPercent) in the ld.GetData is incorrect. According to the @RDP formula, It must be TR.DivFrankedPercent and the TR.DivPeriodType must be TR.DivType.
Set result = ld.GetData(Array("BOQ.AX"), Array("TR.DivUnadjustedNet", "TR.DivType", "TR.DivExDate", "TR.DivPayDate", "TR.DivFrankedPercent"), "SDate=2025-10-27 DivPayType=CDI DateType=ED EDate=2026-01-28 CH=Fd RH=IN")
Thank you @Jirapongse
Much Appreciated
