Can I one ownload historical stock price data using API for a list of ISINs contain in a CSV file?

@barbara.petracci

I have a CSV file with the following data.

RIC
IBM.N
PTT.BK
BDMS.BK
GOOG.O
BAC.N
AAL.L
AV.L
JD.L
AVV.L
LSE.L
VOD.L

I have used the RDP library to retrieve the interday summary data.

First, I connect to the RDP by using the application key, user name, and password. Then I use the pd.read_csv function to read the CSV file. Next, I iterate to all items in the RIC column and call the rdp.HistoricalPricing.get_summaries function for each item.

import refinitiv.dataplatform as rdp
import pandas as pd
import time
rdp.open_platform_session(
    "APP_KEY", 
    rdp.GrantPassword(
        username = "username", 
        password = "password"
    )
)
rics = pd.read_csv("ricsdata.csv")
for item in rics["RIC"]:
    print(item)
    response = rdp.HistoricalPricing.get_summaries(item)
    print(response.data.df)
    time.sleep(1)

For more information, please refer to the following links:

1. Getting Started with Python

2. Python RDP Library examples

3. RDP API Docs Please search for historical-pricing.