Bloomberg BQL | Bloomberg Query Language (Explained)

[@BrainyFinance]

Good Afternoon! This video is about the new BQL API to download data to Excel. Many professionals prefer this to BDH and BDP formulas as it's faster and more intuitive. On a separate note, apologies for my voice, spring has come to London and hay fever has been tough on me this year 😃

[@fatcapital88]

thank you for the video... I've been using BDP and BDH and just doing the rest manually for a long time now, putting off learning BQL, but it looks so easy I feel like kind of dumb for not embracing it sooner.

[@yiqian1793]

Thank you for your video~ I have a question on how to open the excel with the Bloomberg icon on top? My excel just until "HELP", and no "Bloomberg".

[@joshua10000]

Thanks for the intro😊 I’m using Bloomberg to download data as well using bdp and found that would be costly because Bloomberg telling me they gonna charge me per data point… so I’m curious if BQL function can bypass the data download bill 😅

[@srivastav1ankit]

Great video ! Thanks

[@taijenseng]

Great video !

[@abidjahangir8067]

Hi. Found your videos very helpful. I really appreciate how elegantly you explainnthe topic. However, I am facing an issue with BQL and i was hoping you could b able to understand the reasons for the problem

[@geo86421]

Thank you very much 😊👏 May I ask you the following things: I tried to extract information for a list of companies which I only have the ISIN for instead of the tickers. How do I proceed then? In the BQL Builder I selected the range of companies respectively ISIN Furthermore, I need the ISS Quality Score for the companies at specific points in time/or the time series. But in the fields I cannot find the score. Should I proceed differently? For example with the functions you explained in the other video? Thanks in advance for your help!

[@twtw785]

Hello, can you do some video no how to use the xbbg to download historical data (both daily and intraday) into python ? thanks

[@ExcelTutorials1]

Thanks for this video, it is super helpful!!

[@BrainyFinance]

As it is your feedback :)

[@gayatrimullick4911]

hello how can i import live delivery data of stocks from Bloomberg

[@yingyeungsin8634]

thank you. you are a life saver

[@BrainyFinance]

Thank you for leaving me a comment, it means a lot to me. Welcome to the channel :)

[@TheGuzyGroup]

Do you do freelance BQL work?

[@mujomujo3567]

More Bloomberg tutorials please

[@jaewonlee4480]

Thank you for your video!! I have a question regarding your video. 1. is it free or how much do we have to pay to bloomberg? 2. Do you also use any other language to analyse and clean the data? (like Python) Thank you so much!!

[@BrainyFinance]

Thank you for your comment! 1. Bloomberg is an expensive software, 24k for a yearly license 😬 despite its cost is the most used data vendor in financial services so learning the basics can open many doors 2. In investment management we still use VBA and Excel to manipulate data but NumPy and Python is definitely getting traction, I am just an amateur but I can imagine using more of that in the future :)

[@444Yielding]

Thank you!!!!

[@sbj6654]

I followed every steps but got error.how can I know what's the proplem

[@LexKlaudius]

Thanks for this video Regarding BQL, I still have doubts about some functions that should be basic. For example, how do I select my own list of tickers for a given query? I have not found any manual that indicates it.

[@BrainyFinance]

Thank you for your comment and your support! This is something I am investigating myself, will get back to you here once I know more :)

[@BrainyFinance]

I found it! If you have your tickers in cells A2:A20 use this: =BQL(""&BQL.List(A2:A20)&"","PX_LAST()") Let me know if it works for you :)

[@LexKlaudius]

@@BrainyFinance Thanks a lot :) It actually works. Also, I tried to use it as a parameter in a BQL.Query and apparently the transformation is not direct.

[@rickypeters9608]

That’s not what EBITDA stands for, you forgot the DA part

[@KevinHernandez-n8g]

Valentine Brook

[@AndreGowans-f9e]

Hilpert Ways

[@長谷川雄太-b6e]

Jones Scott Lewis Dorothy Thomas Brian