Advertisement
Guest User

Untitled

a guest
Apr 30th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. =RSearch("EQUITY",A2:B5,"NBROWS:2000",,C2)
  2. RCSIssuerCountryGenealogy 'M:A9/G:6J'
  3. PriceClose >5.00
  4. GicsName 'Financials'
  5. IsPrimaryRIC Yes
  6. Row 1262
  7.  
  8. =TR(OFFSET($C2,0,0,B6,1),"TR.GICSSector; TR.GICSSectorCode;
  9. TR.GICSIndustryGroup; TR.GICSIndustryGroupCode; TR.GICSIndustry;
  10. TR.GICSIndustryCode; TR.GICSSubIndustry; TR.GICSSubIndustryCode
  11. ","CH=Fd RH=IN",E1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement