Different result between =TR in excel (which matches get_data using TR.Revenue), vs get_data usin...

barry.chapman

...g TR.F.Revenue

Hi,

I get the same result using

=@TR("CGC.AX","TR.TotalAssets(Scale=6)","SDate=2020-01-01 EDate=2019-01-01,Frq=FY")

and

ek.get_data("CGC.AX", 'TR.TotAssets(Scale=6)', {'SDate': '2020-01-01', 'EDate': '2019-01-01', 'FRQ': 'FY'})[0]

Instrument Total Assets

0 CGC.AX 936.959

but, a different result using TR.F.TotAssets

ek.get_data("CGC.AX", 'TR.F.TotAssets(Scale=6)', {'SDate': '2020-01-01', 'EDate': '2019-01-01', 'FRQ': 'FY'})[0]

Instrument Total Assets

0 CGC.AX <NA>

Should I be using TR.F.TotAssets or TR.TotAssets, I see that your examples use the former.

Jirapongse

@barry.chapman

Yes, the data of TR.F.TotAssets is <NA> on 2018-12-30.

The data is available for the TR.TotAssets field.

It could be a content issue. Please contact the content support team directly via MyRefinitiv to verify the data.