Bloomberg Data Override using getdata for interval avg

Am trying to get the average volume for a stock by using override. For example this is how I could do it in excel:

=BDP("AAPL US Equity", "Interval AVG", "Market Data Override=PX Volume", G1:H1, G2:H2)

Where G1:H1 are text of 'START_DATE_OVERRIDE' and 'END_DATE_OVERRIDE' G2:H2 are the dates in the format of '20110101' and '20110331' ie 'yyymmdd'

Have tried getting the same data using the getdata function and override fields using the datafeed toolbox, but to no avail...any help would be appreciated

R

[Amy]

Hi - could you share the code you are trying to do this with in MATLAB currently? What exactly is not working? Are you receiving an error, or is the output not what you expect?

Have you already referred to the documentation page for getdata? If not, it has a few examples of requesting data with override fields and date overrides.

[Robertson Reid]

I have tried various permutations, such as:

getdata(c,'AAPL US Equity','Interval AVG','{'START_DATE_OVERRIDE','END_DATE_OVERRIDE'},{'20110101','20110331'});

Have tried chopping and changing the dates to different formats, 01-Jan-2011, moving the various elements around such that Market Data Override = PX Volume is a name and value pair at the end, etc. Basically no luck so far.

In terms of the output it comes up blank the majority of the time, when there isnt an error from the various permutation

[Victor Carmi]

I have the same problem, but with ECO_RELEASE_DT_LIST. I try to change the default timeframe using START_DT and END_DT, but they are completely ignored. Moreover you can put anything like '%#$*(745' in the override value and it won't give an error. It's simply ignored.

This is the code: data = getdata(c, 'IP YOY Index',{'ECO_RELEASE_DT_LIST'},'START_DT','%#$*(745'); that won't give an error. And what I'm trying to do is: data = getdata(c, 'IP YOY Index',{'ECO_RELEASE_DT_LIST'},'START_DT','20130101');

Thanks

Answer 1

[Amy]

Instead of using the field name 'Interval AVG', try using the field mnemonic instead.

Also, note that the "getdata" function does not provide override functionality directly, but rather is limited by the Bloomberg server. To make sure you are providing valid override fields for a given query field, type the following at the Bloomberg terminal (replace 'FIELD_MNEMONIC' with the mnemonic for the field you are querying):

FLDS FIELD_MNEMONIC <GO>

YYYYMMDD is the correct date format. Instead of 'START_DATE_OVERRIDE' and 'END_DATE_OVERRIDE', have you tried 'START_DT' and 'END_DT'?

Let me know if there is anything else I can clarify.