Is it possible to set the parameters so that it only returns the data available?

nathan.n.nastili

I am interested in pulling the entire history for financial metric(s) for several companies.

For example, suppose I am interested in pulling the total revenue for AGFEED Industries.

I see that the data is available from 2010 to 2005 and I am interested in pulling the entire history

I am able to pull the history using the code below by setting the EDate = -20.

TR = ["TR.TotalRevenue.Date","TR.TotalRevenue"]
id = ['0001331427']

df, err = ek.get_data(id, TR, {'Scale': 6, 'SDate': 0, 'EDate': -20, 'FRQ': 'FY', 'ReportingState':'Orig'
df

Unfortunately, it will return more records than I want. I would only the first 5 records in this example.

Is it possible to set the parameters so that it only returns the data available?

I have provided one company in the example above, however, I would ultimately like to provide a list of company.

Thank you in advance

chavalit-jintamalit

Hi @nathan.n.nastili

There is no such parameter for TR.TotalRevenue field.

You can use dropna() function from dataframe.

df.dropna()