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

question

Upvotes
Accepted
8 2 1 2

Reuters News headline by Eikon API

Eikon user asked to check script to pull Reuters news headlines. He can see full Reuters news headlines but it shows only Alert news when pull them by Eikon API.

The script is below. Screenshot of Eikon news monitor and Result by Eikon API are as attached. Would you please advise if there is something wrong with the script?

[python script]

{

"cells": [

{

"cell_type": "code",

"execution_count": null,

"id": "5b24321b",

"metadata": {},

"outputs": [],

"source": [

"import datetime\n",

"from pathlib import Path\n",

"import pandas as pd\n",

"import eikon as ek\n",

"ek.set_app_key('**********')"

]

},

{

"cell_type": "code",

"execution_count": null,

"id": "027103a8",

"metadata": {},

"outputs": [],

"source": [

"code = '7203'\n",

"#JST\n",

"dtfrom = datetime.datetime(2022,3,1)\n",

"dtto = datetime.datetime(2022,4,30)\n",

"\n",

"#========================\n",

"#news data from EIKON\n",

"#========================\n",

"max_newsnum = 100\n",

"\n",

"#UTC\n",

"stdt = dtfrom.strftime('%Y-%m-%dT00:00:00+09:00')\n",

"eddt = dtto.strftime('%Y-%m-%dT23:59:59+09:00')\n",

"\n",

"query = f'R:{code}.T and Topic:RTRS and Language:LJA'\n",

"\n",

"headlines = ek.get_news_headlines(\n",

" query,\n",

" count=max_newsnum,\n",

" date_from=stdt,\n",

" date_to=eddt)\n",

"\n",

"# ループ処理\n",

"rp_flag = len(headlines)\n",

"rp_count = 0\n",

"\n",

"while rp_flag == 100 :\n",

" headlines_roop = ek.get_news_headlines(\n",

" query,\n",

" count=max_newsnum,\n",

" date_from=stdt,\n",

" date_to=headlines.iloc[-1]['versionCreated'].strftime('%Y-%m-%dT23:59:59+09:00'))\n",

" headlines = pd.concat([headlines, headlines_roop])\n",

" rp_flag = len(headlines_roop)\n",

" rp_count += 1\n",

"print(rp_count)\n",

"\n",

"headlines['versionCreated'] = headlines['versionCreated'].apply(lambda x: x.astimezone('Asia/Tokyo').strftime('%Y-%m-%d %H:%M:%S.%f'))\n",

"headlines[['versionCreated','sourceCode','text']].to_csv(f\"{code}.csv\", encoding='utf_8_sig', index=False)\n",

"len(headlines)\n"

]

},

{

"cell_type": "code",

"execution_count": null,

"id": "956b30da",

"metadata": {},

"outputs": [],

"source": []

}

],

"metadata": {

"kernelspec": {

"display_name": "Python 3 (ipykernel)",

"language": "python",

"name": "python3"

},

"language_info": {

"codemirror_mode": {

"name": "ipython",

"version": 3

},

"file_extension": ".py",

"mimetype": "text/x-python",

"name": "python",

"nbconvert_exporter": "python",

"pygments_lexer": "ipython3",

"version": "3.8.8"

}

},

"nbformat": 4,

"nbformat_minor": 5

}


eikon-news.jpg


eikon-api-result.jpg

eikon-data-apinews
eikon-news.jpg (260.8 KiB)
eikon-api-result.jpg (100.2 KiB)
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
76.7k 238 52 72

@midori.miyata

Please try this code:

headlines = ek.get_news_headlines(
 'R:7203.T and Topic:RTRS and Language:LJA',
 count=100)
headlines

The output is similar to Workspace.

1663653987429.png

The Workspace results are:

1663654041980.png

Please check the query, date_from, and date_to parameters.


1663653987429.png (99.2 KiB)
1663654041980.png (115.9 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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