Reuters News headline by Eikon API

Midori.Miyata1

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

}

Jirapongse

@Midori.Miyata1

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.

The Workspace results are:

Please check the query, date_from, and date_to parameters.