For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 1

Retrieve mp3, presentation and transcripts of corporate analyst meetings eikon api

Is there any way to retrieve mp3, presentation and transcripts of corporate analyst meetings via the eikon api?

Regarding the transcripts, I read that it seems not to be possible to get them but I was thinking that there should be a way to get the list of events via news searching (as opposed to the events app). From them on it simple.

Anyway, I could use some help in retrieving the presentations and mp3s

thanks


eikon-data-apipython api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
6.7k 8 6 7

@mbraun.ese You can retrieve news for just transcripts which can give you the data and time of the release. Please try:

df = ek.get_news_headlines('Source:TRANS',count=100)
df

1636541951567.png

for all companies . You can see the company name in between the date and 'Earnings Call'- but if you wanted to focus on one company - say IBM:

df = ek.get_news_headlines('Source:TRANS AND R:IBM.N',count=100)
df

News History in Eikon goes back 15 months so if you wanted to get all transcripts for all companies you would need to iterate as the maximum number of headlines returned per is max 100. Remember you are only allowed 10,000 API calls per day. So be careful. Here I illustrate with 3 Days of all transcripts.

from datetime import datetime, timedelta
now = datetime.now()
maxenddate = now - timedelta(days=3) #upto months=15
print(now, maxenddate)
newsdf = pd.DataFrame()
startdf=now

while startdf >= maxenddate:
    try:
        df1 = ek.get_news_headlines(query ='Source:TRANS', date_to = startdf, count=100)
        startdf = df1['versionCreated'].min().replace(second=0,microsecond=0,tzinfo=None).strftime('%Y/%m/%d %H:%M')
        startdf = datetime.strptime(startdf,'%Y/%m/%d %H:%M')
        if len(df1):
            newsdf = pd.concat([newsdf, df1], axis=0)
        else:
            newsdf = df1
    except Exception:
        break

newsdf.info()

I hope this can help.


1636541951567.png (382.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 0 1

Many thanks @jason.ramchandani01. I can download the headlines and story id but then the story id does not lead me to the text of the transcript of the meeting but to what seems to be a webpage. When I try to open it, I get neither the transcript nor the file.


df = ek.get_news_headlines(query='Topic:FWP AND R:HCDI.O')

for idx, storyId in enumerate(df['storyId'].values): #for each row in our df dataframe

newsText = ek.get_news_story(storyId) #get the news story

df['newsText'] = newsText



versionCreatedtextstoryIdsourceCodenewsText18:03.32021-09-27 10:27:42.613000+00:00Harbor Custom Development, Inc. -- FWPurn:newsml: reuters.com:20210927:nEOL7ytM0l:2NS:EDG<div class="storyContent" lang="en"><p><a href="reuters://screen/verb=Open/url=cpurl%3A%2F%2Fviews.cp.%2Ffilings%2Ffilings.viewer% 2FDownload.aspx%3FDocumentId%3D55077728%26ContentFormat%3Dpdf%26ApplicationId%3DEikonNewsAlertMonitoringView" data-type="cpurl" data-cpurl="cpurl://views.cp./filings/filings.viewer/Download.aspx?DocumentId=55077728&ContentFormat=pdf&ApplicationId=EikonNewsAlertMonitoringView" translate="no"> http://filings.ica.int.thomsonreuters.com/filings.viewer/Download.aspx...</a></p></div>;


requests.get('https://amers1.apps.cp.thomsonreuters.com/web/Apps/AdvEvents?app=EventsViewer&type=presentations&eid=138897009411

')

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 0 1

That didn't paste correctly, sorry.

18:03.3
versionCreated
2021-09-27 10:27:42.613000+00:00

text
Harbor Custom Development, Inc. -- FWP


storyId

urn:newsml: reuters.com:20210927:nEOL7ytM0l:2


sourceCode

NS:EDG


newsText

<div class="storyContent" lang="en"><p><a href="reuters://screen/verb=Open/url=cpurl%3A%2F%2Fviews.cp.%2Ffilings%2Ffilings.viewer% 2FDownload.aspx%3FDocumentId%3D55077728%26ContentFormat%3Dpdf%26ApplicationId%3DEikonNewsAlertMonitoringView" data-type="cpurl" data-cpurl="cpurl://views.cp./filings/filings.viewer/Download.aspx?DocumentId=55077728&ContentFormat=pdf&ApplicationId=EikonNewsAlertMonitoringView" translate="no"> http://filings.ica.int.thomsonreuters.com/filings.viewer/Download.aspx...</a></p></div>;


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
6.7k 8 6 7

@mbraun.ese So this works for me - for a transcript news item it gets the link and opens the transcript in a new browser window:

import re 
import webbrowser

text1 = ek.get_news_story('urn:newsml:reuters.com:20211110:nTRN1sXnWG:1')
webbrowser.open(re.findall(r'(https?://[^\s]+)', text1)[0])

1637156603099.png

From there you can download the file. Is this what you want?


1637156603099.png (386.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea