I am raising query on behalf of client that data is getting misaligned and they are using rdp platform session
client issue:
When I query the ID 4295900704 with the fields ["TR.F.StatementDate", "TR.F.PeriodEndDate", "TR.F.CashCashEquivTot", "TR.F.CashCashEquivTot.date"] and for the last 10 years (using SDATE and EDATE) it seems like TR.F.CashCashEquivTot has additional data for 2017-05-31 which I don’t get as a TR.F.PeriodEndDate/TR.F.StatementDate.
So until then the dates are equal but from then on they are one period off. I need a set of around 15 financial fields but would like to get them in a single API call.
As sometimes one or another value are missing I can’t just use TR.F.CashCashEquivTot.date for all of them. I also want to avoid to do 15 API calls for each company.
Is there any way to achieve that query without misalignment of periods/dates?
client Issue is highlighted in yellow where date and period end date is not matching with last column.
replication done from our end.
Upon reviewing the data using our get History and fundamental Reference, we are seeing correct results. For May 2017, the data appears as NA, which is expected due to unavailability.
However, on client this adjusted to columns without displaying NA and giving wrong data.NA is being filled up by adjusting the other rows
code we used:
import lseg.data as ld
from lseg.data.content import fundamental_and_referenceld.open_session()
df = fundamental_and_reference.Definition(universe = '4295900704',
fields = ["TR.F.StatementDate", "TR.F.PeriodEndDate", "TR.F.CashCashEquivTot", "TR.F.CashCashEquivTot.date"],
parameters = {'Sdate' : '-50',
'Edate' : '0',
'FRQ' : 'FI',
'Period':'FI0'
}
).get_data()
df.data.df
Code:
import lseg.data as ld
from lseg.data.content import fundamental_and_referenceld.open_session()
df = fundamental_and_reference.Definition(universe = '4295900704',
fields = ["TR.F.StatementDate", "TR.F.PeriodEndDate", "TR.F.CashCashEquivTot", "TR.F.CashCashEquivTot.date"],
parameters = {'Sdate' : '-50',
'Edate' : '0',
'FRQ' : 'FI',
'Period':'FI0'
}
).get_data()
df.data.df
I have raised the issue with product team already, but they routed to dev community team.
could you please advise on this, what is the issue here?
