=BQL("AAPL US Equity","rolling(avg(dropna(px_volume(dates=range(-30d,0d)))),iterationdates=range(-1y,0d))")
Excel will not accept it. Can anyone spot the error?
Excel will not accept it. Can anyone spot the error?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Bloomberg BQL - can anyone spot the error
- Thread starter Maverick2608
- Start date
I found the error. "," should be substituted with ";" apparently.
I want to change this formula so it returns just one figure = average 30 day volume for at specific date.
How should the formula look like to achieve that?
How should the formula look like to achieve that?
I found out. Just needed to use the right date format.
Thanks for the support ;-)
Thanks for the support ;-)
Yes, unfortunately Bloomberg confirmed that they are not historically available (even though the 30 day average is indicated as being historically available), so I have to program it.Don't you make this way too complicated? Bbg has already metrics it updates on its servers for 21d and I think even 30d avg volume. Just search within the api wizard for average volume and you will find it.
Hmm, strange, I thought to remember they offer at the very least the historical 21d one... Oh well...
Yes, unfortunately Bloomberg confirmed that they are not historically available (even though the 30 day average is indicated as being historically available), so I have to program it.
I will check the 21D again. Thanks.Hmm, strange, I thought to remember they offer at the very least the historical 21d one... Oh well...
No, "VOLUME_AVG_20D" is not historical either.Hmm, strange, I thought to remember they offer at the very least the historical 21d one... Oh well...