![bloomberg api vba bloomberg api vba](https://i.stack.imgur.com/qQxs3.png)
If you play with this FLDS for a while, you should become pretty comfortable with this override possibility in Bloomberg. Just for an example, if you select BEST_FPERIOD_OVERRIDE (default value = 1FY) to be 3FY, you can see that the value for BEST_EPS also changes. You should now have a view for all the fields, which can be overriden for this specific field (BEST_EPS). Write best eps into FLDS query input box and press ENTER
![bloomberg api vba bloomberg api vba](https://docplayer.net/docs-images/56/7127934/images/page_10.jpg)
For example, you can test the override in your Bloomberg with the following commands: To implement an override to any field, we need to set up one array for override field names and another for override values. Excellent source for investigating possible override options for a field, is Bloomberg itself and its FLDS function. What is new here, is the override optionality. Needless to say, we still need to give arrays for securities (Bloomberg tickers with yellow key) and fields (Bloomberg field names). Optional ByRef overrideValues As Variant) As Variant Optional ByRef overrideFields As Variant, _ Public Function referenceData( ByRef securities As Variant, _ Now, let us investigate these function interfaces a bit to be able to understand, what has been changed.įor referenceData, the new class interface function has been defined to be the following: I assume that you are familiar of these data query types already. Anyway, to be more specific about the new public function interfaces, we have now three separate public functions for different types of data queries: So, everything is (and hopefully will be) inside one class module.
![bloomberg api vba bloomberg api vba](https://www.thepexcel.com/wp-content/uploads/2015/11/3types.png)
However, I still have not compromised the basic principle which says, that the wrapper is a compact one-module entity, which can be imported easily into your new VBA project. Handling all those different mandatory/optional input parameters for all different types of market data started to be a bit too messy operation to handle and public interface function mutated itself into a scary-looking monster. With this updated version, I have now decided to break the class public interface function (previously getData function) into three separate functions. If you are not familiar with the previous versions, you might want to take a look at these first. If Application.I am finally publishing some updates (hopefully also improvements) to the existing version for Bloomberg BCOM wrapper. This example displays a message indicating whether 10 seconds have passed. WaitTime = TimeSerial(newHour, newMinute, newSecond) This example pauses a running macro for approximately 10 seconds. This example pauses a running macro until 6:23 P.M. The time at which you want the macro to resume, in Microsoft Excel date format. An expression that returns an Application object. However, background processes such as printing and recalculation continue.Įxpression Required. Important The Wait method suspends all Microsoft Excel activity and may prevent you from performing other operations on your computer while Wait is in effect. Returns True if the specified time has arrived. Pauses a running macro until a specified time.