import refinitiv.data as rd
from refinitiv.data.content import historical_pricing
from refinitiv.data.content.historical_pricing import Intervals
from refinitiv.data.content.historical_pricing import Adjustments
from refinitiv.data.content.historical_pricing import MarketSession
import datetime




rd.open_session(app_key='XX')


universe=["002887AC1=","00206RFS6=","00037BAC6="]


response = historical_pricing.summaries.Definition(universe, interval = Intervals.MONTHLY, start="2016-01-01", end="2022-01-01").get_data()
df=response.data.df


dataframe=response.data.df["INITIALRIC="]
dataframe.insert(2,"RIC","INITIALRIC=" )


dataframe=response.data.df[universe[0]]
dataframe.insert(2,"RIC",universe[0] )


for row in instruments[0:len(universe)]:
    r=response.data.df[row]
    if len(r.columns)>1:
        r.insert(2,"RIC",row )
        dataframe=dataframe.append(r)

dataframe