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'])
screenshot 1.png
