Hello,
I'm looking for the syntax to pull all Canadian Preferred Shares using the Search function in RDP. I'm interested in the following fields:
- volume
- shares outstanding
- CFI
- LEI/CUSIP/ISIN
- RIC
This is the code I currently have at the moment that does not pull anything:
filterStr = "RCSCountryLeaf eq 'Canada' and RCSAssetCategoryLeaf xeq 'Preferred Share'"srchfields = "Country, RIC, FullName, CommonName,CompanyName, SeniorityType, NativeIdentifier, DerivedCategory, OriginalIssueCurrency, ParentIndustrySector, CouponCurrency, CouponTypeDescription, CFI"GroupSize = 10000 #max at 10000 data = rdp.search(view=rdp.SearchViews.EquityInstruments, filter=filterStr, top=GroupSize, select=srchfields)
Any help is greatly appreciated, I can't find too much official documentation on this topic
Regards