I have two problems:
1. sometimes when I run the below code chunk, I get an empty data frame, and sometimes I do not.
2. when I don't get an empty data frame, the dates are reported erroneously, as in not in a proper date-time format. (note that I am trying to get the data into a csv file with dates in a specific format)
Here is my code and a screenshot of the output showing the erroenous date-time format.
import refinitiv.data as rd rd.open_session() syntax = "SCREEN(U(IN(Equity(active,public,primary))), IN(TR.TRBCIndustryCode,54102030,54101010,54101020),CURN=USD)" TSfields = ["TR.F.PeriodEndDate(IncludeSpl=Yes)","TR.F.TotAssets(IncludeSpl=Yes)"] df2 = rd.get_data( universe = syntax, fields = TSfields, parameters = {'Scale': 0, 'SDate': "1989-01-01",'EDate': "2022-06-05", 'FRQ': 'FY', 'Curn': 'USD'}, ) df2.rename(columns = {'Instrument':'#'}, inplace = True) df2.loc[-1] = df2.columns.to_list() df2 = df2.sort_index().reset_index(drop=True) df2.columns = ["ticker","PEDate","assets"] print(df2) df2.to_csv("tob_shutoff_TSraw.csv", date_format='%Y-%m-%d', index=False) print(df2['PEDate'])