Can you help me confirm if this is possible using the lseg-data library in python?

HarveySaldana

Hi team. Im posting this on behalf of a UBS client. Can you help me confirm if this is possible using the lseg-data library in python?

I'm looking for a way to do the following:- Obtain a fairly recent list of 1000 earnings (results) news headlines/items for EMEA from before market close, each for a different ISIN- For each such news item, obtain the respective close price move from the day before the respective news item to the day of the news item- For each of the news items, also obtain the respective ISIN's main index's close price move from previous day to day of news. Ideally, I would like to do this in Excel via the Workspace Add-In. Alternatively, a version using the lseg-data library in python would also work for me.

Jirapongse

@HarveySaldana

Thank you for reaching out to us.

The LSEG Data Library for Python can retrieve news headlines and it use the same news queries used in the News Monitor App. I am not if we have any news queries that can retrieve recent list of 1000 earnings (results) news headlines/items for EMEA from before market close. Please check this with the helpdesk team.

To retrieve close prices, we need to provide instrument identifiers. The API uses the ld.get_data method to retrieve data. It is similar to the =RDP.Data formula in the Workspace Excel. It can't retrieve close prices from news items.

Some news headlines may have associated RICs so we can use these associated RICs to retrieve the required data from the TR.xxx fields.

However, It is better to contact the client's account team or sales team directly to discuss the solutions that we can provide to this client.