On Refinitiv Workspace I can access .BATY0 and .BAUBIL historical data through to 1998 and 1997 respectively. However on Excel I cannot pull any data for Price Close.
How can I get this data in Excel?
Hi @DJ234, Thank you for reaching out!
Can you help me with the formula you are using currently in excel?
@ujjawal_khandelwal Attached
@DJ234
Data is available in the TR.CLOSEPRICE field.
=@RDP.Data(".BAUBIL;.BATY0","TR.CLOSEPRICE","Frq=AM Sdate=0D EDate=1990-01-01 CH=IN RH=date",B2)
For questions related to content like this, please reach out directly to the Helpdesk Support Team through LSEG Support for a prompt response.
That worked (partially) thanks! Now I can get data now back to 2015 in Excel.
How can I get data back to 1998/1998 per my screenshots above (as I alerady have this via LSEG Workspace)?
This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one. The best resource for content questions and Excel formulas is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.
Thanks. I created a new case: 16100405
