Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
In Eikon, news code [HNXB] contains headlines with links to download the file. Is there a way for us to download the data frame directly via Codebook? I'm only able to get the headlines but couldn't find a code that would extract the data directly.
ek.get_news_headlines(query = 'HNXB', count=10)
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi @chavalit.jintamalit, the client has a follow-up question, could you please help the client?
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
Step 1: get headline
Step 2: get story id
I can only add 2 pictures in an answer, so please see further comment on this answer for more detail.
Step 3: get Side by Side API token with Eikon Desktop
Step 4: prepare Side by Side API command
Step 5: open the URL using the prepared command
url = 'http://127.0.0.1:9000/sxs/v1'
headers = {
'Content-Type': 'application/json',
}
response = requests.request('POST', url, data=commandString, headers=headers)
print(response.text)
@chrisma.salut So im thinking that you are looking to retrieve the news stories - so get_news headlines returns a dataframe of max 100 items per API call corresponding to a query you give it - in your case 'HNXB'.
df = ek.get_news_headlines(query = 'HNXB', count=10) df
So this returns a dataframe of 10 headline items and you need to pass the storyId to a second API called get_news_story - which will return you the html formatted story text. The folllowing routine stores the formatted html news story in a new column called storytext.
df['storytext'] = '' for i, uri in enumerate(df['storyId']): df['storytext'][i] = ek.get_news_story(uri) df
You can display the story using:
from IPython.display import HTML HTML(df['storytext'][0])
I have noticed in your query the news story text is actually a download link - if you changed the query to say VOD.L and repeated the exercise - it would display a news item. It is working correctly. I hope this can help.
Hello Chavalit,
Thank you for your assistance on this query. Client can't get past step 3 as they are getting an error. Any idea what's causing this?
Could you please take another look, I think you were intended to be tagged.
Thanks
Hi all, I dont verified your answers because it doenst match the requirement : downloading the file not the news. I found out my own way without applying any side to side api :
###1. get the table news
###2. get the story id
###2. get the file (downloaded in download folder)
df1Id=df1[df1['date']== a]['storyId'][0]
df1_url=ek.get_news_story(df1Id)
link1 = re.search('href="(.*)" data-type', df1_url)
webbrowser.open(link1.group(1))
