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
}
