Bloomberg Data Override using getdata for interval avg

28 次查看（过去 30 天）
Robertson Reid
Robertson Reid 2017-8-31
编辑： Victor Carmi 2017-12-1
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
  3 个评论
显示 1更早的评论
Robertson Reid
Robertson Reid 2017-9-8
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
Victor Carmi 2017-12-1
编辑：Victor Carmi 2017-12-1
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

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Amy
Amy 2017-9-8
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.

类别

在 Help Center 和 File Exchange 中查找有关 Bloomberg Desktop 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by