question

Upvotes
Accepted
1 0 0 0

rdp.get_data() returns N/A for Canadian symbols

Below get_data function works fine for LSEG and AAPL but returns <NA> for BMO.TO. I wonder if there are no "Revenue" and "GrossProfit" feeds for Canadian stocks.


import refinitiv.dataplatform as rdp

rdp.get_data(

universe=["LSEG.L", "BMO.TO","AAPL.O"],

fields=["TR.Revenue", "TR.GrossProfit"]

)

rdprefinitiv-dataplatform-libraries
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
47.2k 110 44 60

I would like to share a resolution from the content support team.

BMO.TO (Bank of Montreal) or other banks or financial institutions would not have any records for fields TR.Revenue and TR.GrossProfit since they don't sell goods or services.

In order to pull the same information, we need to use the fields TR.InterestIncomeBank and TR.NetInterestIncome.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
5k 8 5 8

hi @yzhou ,

according to this answer from my colleague

If the same code is working for many other RICs and not yielding data for certain RICs, then this is most likely a content issue.

I would recommend you create a content query ticket on MyRefinitiv to discuss your requirements. They may be able to advise if the required data is available in a different field for those particular RICs. For this case, case number 11341856 was raised on your behalf and the support team is going to contact you directly to assist on this.

Whilst we do try to normalise our data, we carry 80million RICs from 10,000+ sources - and sometimes there can be differences based on the source of data/asset class etc.


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.