Can't use ISIN to retreive datapoints
I'm currently building a program in Pycharm and want to use the Eikon API to retreive 2 fields: CF_Last and TR.priceclose (SDate=-1M). However, when i give up ISIN codes as instrument names, i get an error, while RICs do seem to work. Is there any way to do this based on ISIN?
import tkinter as tk
from tkinter import filedialog
import pandas as pd
import eikon as ek
# API Key
ek.set_app_key('')
# Define the list of instrument codes and fields to retrieve
instrument_codes = ['BE0974293251', 'NL0010273215']
fields = ['CF_LAST', 'TR.PriceClose(SDate=-1M)']
# Retrieve the data using the Eikon API
data, err = ek.get_data(instrument_codes, fields)
# Check for errors
if err:
raise ValueError(err)
# Print the resulting DataFrame
print(data)
Tagged:
0
Best Answer
-
Meanwhile, i've solved the issue and it turns out you can use ISIN to retreive datapoints. Snippet below works just fine.
# API Key
ek.set_app_key('api key')
# Define base dataframe
client_df = pd.DataFrame()
# get the current working directory
current_directory = os.getcwd()
# set the path to the database file
database_file_path = r'C:\Users\List.xlsx'
# Define function to retrieve stock data from Eikon API
def get_stock_data(isin_list):
# Define the fields to request from the Eikon API
fields = ['TR.Isin', 'TR.PriceClose(SDate=0;Curn=EUR)', 'TR.PriceClose(SDate=-30D;Curn=EUR)']
# Request the data from the Eikon API
data, err = ek.get_data(isin_list, fields)
# If there was an error, raise an exception
if err:
raise Exception(f"Error getting data: {err}")
# If the data is empty, raise an exception
if data.empty:
raise Exception("No data available")
# Rename the columns to be more descriptive
data.columns = ['Stock', 'Isin', 'Price', 'Price -1 mth']
# Round the Price column down to 2 decimal places
data['Price'] = data['Price'].astype(float).round(2)
data['Price -1 mth'] = data['Price -1 mth'].astype(float).round(2)
# Return only the Price and 1 month price change columns
return data[['Price', 'Price -1 mth']]0
Answers
-
Hi @christophe01 ,
Than you for your question, unfortunately you can't use ISIN directly in ek.get_data, however you may convert ISINs to RIC via ek.get_symbology function and use the RICs for the ek.get_data. Please see below:
ek.get_symbology(
['BE0974293251', 'NL0010273215'],
from_symbol_type='ISIN',
to_symbol_type='RIC')Hope this helps!
Best regards,
Haykaz
0 -
Hi @christophe01 , thank you for coming back to us and posting your solution. Apparently, you can get TR fields with ISIN, however you will not be able to get fields such as CF_LAST with ISIN.
Best regards,
Haykaz
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛