Data error Bloomberg data feed of historic data

조회 수: 2 (최근 30일)
Christian
Christian 2014년 12월 29일
편집: Christian 2015년 1월 6일
I am using the history command to retrieve data from Bloomberg. The command looks as follows
[MarketData1 ord] = history( connect, Tickers, {'Last_Price','EQY_Turnover', 'Volume'},'8/31/95', '11/30/15', {'daily', 'active_days_only'} );
The data looks mostly (for most securities and most dates) ok. But for Crude (CL1 Comdty) I get strange results around Thanksgiving of 1996.
Concretely I get the following prices for PX_LAST 26.11.1996 23.62 27.11.1996 23.75 29.11.1996 24943 (which more look like a volume)
I see similar outliers a other points in the data series. Any idea what is going wrong?
Thanks, Christian
  댓글 수: 3
Christian
Christian 2014년 12월 29일
No. I spent some time with Bloomberg Help Desk, Excel and API Demo. There the problem does not arise. However, it seems that the 24943 is a volume number. Because when I access the data via HP on the Terminal that is the volume number on the 29th (see attached screenshot). Why there is no price but volume and on the 27 there is price but no volume is a different matter that i am currently trying to figure out with help of their Help Desk. But it seems that Matlab puts the volume of 29th into PX_Last of 29th.
Christian
Christian 2015년 1월 6일
편집: Christian 2015년 1월 6일
Here are some another features of that error. 1) The same problem occurs for the down load of S&P (SPX Index) data on 911. Bloomberg does not report a price but there was trading volume (see attached screenshot). 2) If I only ask fro PX_Last data, i.e. if I modify my function to
connect = blp;
[MarketData ord] = history(connect, Tickers, {'Last_Price'},'8/31/95', '11/30/15', {'daily','active_days_only'});
The error does not occurs.
It seems to me that Matlab messes up data coming back from Bloomberg in cases where there is no price but volume.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Bloomberg Desktop에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by