In this video you will learn the new Bloomberg BQL function to use directly in Excel to extract financial data. BQL stands for Bloomberg Query Language and it’ s a new API that allows us to download information directly into Excel. The advantage of BQL with respect to formulas such as BDP or BDH is that with just one query we can populate many cells and gather data for multiple securities and across many different fields all at the same time
Chapters
0:00 Intro: What is BQL?
0:33 How the BQL Builder works
2:26 The advantage of BQL
2:43 Download Cross-sectional Data
3:28 Download Time Series Data
5:18 Download Panel Data
6:00 Data cleaning in BQL
#bloombergterminal #bql #downloadbloombergdata