The BDS function provided by the Bloomberg Excel plugin produces multiple cells. For example, =BDS("VOD LN Equity", "TICK_SIZE_TABLE") fills three columns and 19 rows of data. The third column contains tick sizes from 0.0001 to 10. How can I extract just the largest value, i.e. 10? I would like the result to take up only one cell. Many thanks.
3
-
$\begingroup$ Probably best to use the helpdesk for this kind of question $\endgroup$– oronimbusCommented Apr 2, 2021 at 19:08
-
$\begingroup$ I already tried with a related question. Their approach was to ignore it. When I suggested they might like to get back to me, they said "we will let you know if there is an answer". In fairness, I have also had better experiences with them, but asking what to do after their API returns a result probably will not work. $\endgroup$– Jeremy BloggsCommented Apr 2, 2021 at 19:58
-
$\begingroup$ This seems like an Excel formula question? Use MAX function to find the largest value in 3rd column, then MATCH to get its row number, then INDEX to get the value in this row and column 2. However instead of BDS, you should use BQL. Then you can perform all this logic within BQL call. $\endgroup$– Dimitri VulisCommented Apr 2, 2021 at 21:30
Add a comment
|
1 Answer
$\begingroup$
$\endgroup$
3
The function builder makes it possible to figure out an answer. If someone knows where in the documentation I could have found this, it would be helpful to know for the next time.
=BDS("VOD LN Equity", "TICK_TABLE_SIZE", "Aggregate", "Y", "SortDesc", "3", "StartCol", "3", "EndRow", "1")
-
-
$\begingroup$ @Dmitri Vulis That seems even harder to get to work. If you (or anyone) posts an answer explaining how, I will gladly accept it. $\endgroup$ Commented Apr 3, 2021 at 6:59
-
$\begingroup$ HELP DAPI - Constructing Formulas > if you do not find it there, it almost certainly does not exist. It is part of the standard BDS syntax explanation - {LPHP DAPI:0:1 2754307 <GO>} for a direct link (within BBG). Not sure how stable this link is in the long run to be honest. I do not think BQL is showing this field. $\endgroup$– AKdemyCommented May 8, 2021 at 21:27