Friday, February 14, 2025

Bloomberg BQL

 BQL is not part of daily limit. So we can use those to get the data even when limit is hit:


=@BQL.QUERY("get(" & TEXTJOIN(",", TRUE, B1:E1) & ") for(members('RAY Index'))","cols=7;rows=5919")


where cells B1 to E1 have fields as follows:

market_cap px_volume 30_day_average_volume_at_time factor_expected_daily_volume


No comments:

Post a Comment