I want to write a python code to get valuation, change in price, news for a list of stocks via lseg.

Question

I want to write a python code to get valuation, change in price, news for a list of stocks via lseg. Help me how to do it? ALso, what is dac and username and how to find it?

Just have a few follow-ups.

* Not just headlines but can I get a summary too? Realized headlines don’t exactly tell what happened.
* Any way to filter headlines, like a lot of it is just price moments but I wanted more like anything industry related or something and not just that stock A was up 1%.
* Can I also get industry wise headlines? For example in India what all happened like any industry wide news that came?
* Also how to get news for a list of stocks that I have saved in a csv? I see you said I need to add R: so not sure if directly a list can be given?
* Also, please let me know if you have any interesting use cases of using python with lseg like any nice scripts?

Jirapongse · Answer

@Jeeva_1

Typically, we provide support for API users through our Q&A forum. Please advise the client to post any API-related questions here.

The News API uses the same news query as the Workspace News Monitor app. Therefore, the source can be specified in the news query and you may need to contact the Workspace Support team to verify the news query.

Additionally, to the best of my knowledge, the API may not have access to all articles displayed in News Monitor due to licensing or contractual restrictions. By the way, were you able to obtain the code and news query used by the client?

For the filings, please check the Filings API and these articles:

* Introduction To Filings - Python
* Using AI modeling to interpret 10-Q filings

The client may need to contact their LSEG account team or sales team directly regarding this Filings API.

Jeeva_1 · Answer

Hi @wasin.w V3 , client has come up with a follow up query:

I tried but it isn’t giving me the news that I am particularly looking for even after using filter on the platform and the news seem to be very . How to select source of news? Also how to get filings?

I am not sure but is it possible to connect over zoom call and resolve all these queries? Pls let me know.

wasin.w V3 · Answer

Continue:

Question 4: Also how to get news for a list of stocks that I have saved in a csv? I see you said I need to add R: so not sure if directly a list can be given?

Answer:

The  ld.news.get_headlines() statement does not support a direct list of RICs. The client can use the Python code to get a list of RICs from any sources (csv, text file, db, etc.), then convert that RICs list into the News query as follows:

RIC_List = ['LSEG.L', 'NVDA.O', 'GOOG.O', 'AAPL.O']

ric_query = " OR ".join([f"R:{ric}" for ric in RIC_List])

query = f"({ric_query})"

ld.news.get_headlines(query, count=20)

Question 6: While retrieving news, it mostly just shows stock performance news that it was up x5 or so but I wanted more from overall news like any filing, industry news affecting stock or any other important news ex of stock price movements.

Answer:

Unfortunately, I cannot answer this question. You may try to use the Workspace News Monitor app to get query that you want and check the Data Library news interfaces information on the following pages to help you:

* Data Library for Python Reference Guide document 
* Data Library EX-1.01.05-News.ipynb and EX-2.03.01-News.ipynb (more advance interface)

EXPLORE OUR SITES