0
$\begingroup$

I have this BQL query to grab a list of Russell 3000 members and get the firm names. Is there any way I can grab other data with the company names such as industry/sector name, total assets, EPS, etc...? If so what is the structure/syntax to do that? I am not new to Excel or modeling just new to Bloomberg. I have a couple years experience in VBA.

=BQL.Query("get(name()) for(members(('RAY Index')))","showheaders=false")

Thanks

$\endgroup$
1
  • 1
    $\begingroup$ I would suggest reaching out to the help desk. They have product specialists who will be more than happy to help you out. $\endgroup$ – Kch Mar 2 at 16:44
0
$\begingroup$

Can't you just pass comma-delimited lists of fields to get, as well as filters, like

=BQL("Filter(Members('RAY Index'),GICS_SECTOR_NAME=='Fishmongers')", "PX_LAST*100/PX_VOLUME,RIGHT(NAME,10),EXCH_CODE")

(This is just an example GICS_SECTOR)

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.