Question about getting bid ask of Isincodes by Codebook.

Akira0426

I want to obtain bid ask data by Code book. The code attached below is about getting bid ask from the input data; Isincode. Could you tell me why the code does not work.

import pandas as pd
import refinitiv.data as rd
from refinitiv.data.content import symbol_conversion as sc # ← v1.6 ではこちら

1. セッション開始（Workspace/CodeBook なら引数不要）

rd.open_session()

2. 変換したい ISIN 一覧

isin_list = ["US0378331005", "JP3436100006"] # 例：AAPL, SONY

3. ISIN → RIC_PRIMARY_EXCHANGE へ一括変換

resp = sc.Definition(
symbols = isin_list,
from_symbol_type = sc.SymbolTypes.ISIN,
to_symbol_types = [sc.SymbolTypes.RIC_PRIMARY_EXCHANGE] # 代表 RIC
).get_data()

4. 戻り値は DataFrameWithMetadata

df_conv = resp.data.df.copy()

（もし行数 0 なら権限不足か ISIN 不正）

if df_conv.empty:
print("変換結果が 0 行です。権限または ISIN を確認してください。")
else:
# v1.6 の列名: FROM_SYMBOL / TO_SYMBOL_VALUE
df_conv = (df_conv
.rename(columns={"FROM_SYMBOL": "ISIN",
"TO_SYMBOL_VALUE": "RIC"})
[["ISIN", "RIC"]])
print(df_conv)

rd.close_session()

Jirapongse

@Akira0426

Thank you for reaching out to us.

I uses the LSEG Data Library for Python instead. The code looks like this:

import lseg.data as ld

from lseg.data.content import symbol_conversion

ld.open_session()

isin_list = ["US0378331005", "JP3436100006"]

resp = symbol_conversion.Definition(

    symbols = isin_list,

    from_symbol_type = symbol_conversion.SymbolTypes.ISIN,

    to_symbol_types = [symbol_conversion.SymbolTypes.RIC] 

).get_data()

display(resp.data.df)

ld.get_data(

    universe = resp.data.df["RIC"].tolist(),

    fields = ["BID","ASK"])

Akira0426

Hi Jirapongse-san

Thanks a lot!
The code you attached is working!