I'm stuck and perplexed. And could really use some help...
I have a program in EViews 12 Enterprise Edition wherein I import quarterly earnings data from Bloomberg using this:
dbopen(type=bloom, server=localhost:8194) None
FETCH BLOOM::"SBUX US EQUITY IS_COMP_EPS_ADJUSTED"
When I look at the earnings series on my Bloomberg terminal, it is perfectly complete with numbers each quarter.
However, when I look at the series in EViews, there are several missing datapoints with NAs displayed instead. I can run the fetch over and over, and get the same results.
I'm attaching a picture that shows what I'm seeing on both EViews and Bloomberg.
I'm hoping that I've done something wrong in opening Bloomberg or in the fetch command.
But, if this is an unfixable bug of some sort, is there a way for EViews to give me the average of the datapoints before and after the missing data rather than throwing an "NA?" That would be a second best solution to the issue.
Many thanks!
Kevin
Bloomberg Missing Data
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
Bloomberg Missing Data
- Attachments
-
- missing_data.png (184.49 KiB) Viewed 18662 times
-
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: Bloomberg Missing Data
We are investigating the issue. We will report back what we find.
Re: Bloomberg Missing Data
I just checked several other stocks and other figures (other than EPS) and find similar results.
Re: Bloomberg Missing Data
Although it's true that the chart in Bloomberg shows all the quarterly data points, when retrieving the data in Excel via BDH there are missing points. Below is what I get and it is consistent with the quarters missed by Eviews. This suggests that it is a Bloomberg problem or that BDH is not the best way to capture this data and I think this is what the Eviews fetch uses.
IS_COMP_EPS_ADJUSTED
SBUX US EQUITY
31/03/2013 0.24
30/06/2013 0.275
29/09/2013 0.2997
30/03/2014 0.28
28/09/2014 0.37
28/12/2014 0.4
29/03/2015 0.33
28/06/2015 0.42
27/09/2015 0.43
27/12/2015 0.46
27/03/2016 0.39
26/06/2016 0.49
02/10/2016 0.56
01/01/2017 0.52
02/04/2017 0.45
02/07/2017 0.55
01/10/2017 0.55
31/12/2017 0.58
01/04/2018 0.53
01/07/2018 0.62
30/09/2018 0.62
30/12/2018 0.75
31/03/2019 0.6
30/06/2019 0.78
29/09/2019 0.7
29/12/2019 0.79
29/03/2020 0.32
28/06/2020 -0.46
27/09/2020 0.51
27/12/2020 0.61
IS_COMP_EPS_ADJUSTED
SBUX US EQUITY
31/03/2013 0.24
30/06/2013 0.275
29/09/2013 0.2997
30/03/2014 0.28
28/09/2014 0.37
28/12/2014 0.4
29/03/2015 0.33
28/06/2015 0.42
27/09/2015 0.43
27/12/2015 0.46
27/03/2016 0.39
26/06/2016 0.49
02/10/2016 0.56
01/01/2017 0.52
02/04/2017 0.45
02/07/2017 0.55
01/10/2017 0.55
31/12/2017 0.58
01/04/2018 0.53
01/07/2018 0.62
30/09/2018 0.62
30/12/2018 0.75
31/03/2019 0.6
30/06/2019 0.78
29/09/2019 0.7
29/12/2019 0.79
29/03/2020 0.32
28/06/2020 -0.46
27/09/2020 0.51
27/12/2020 0.61
Re: Bloomberg Missing Data
Eureka! And thank you to javiersan... Getting closer to solving this issue...
I spoke with Bloomberg and showed them an Excel spreadsheet with my code as follows:
=BDH("SBUX US EQUITY", "IS_COMP_EPS_ADJUSTED", "12/31/2008", "12/31/2020")
This results in dates returned that don't square with conventional quarter-end dates. For example, the Bloomberg reporting date might be 10/2/2016 for 2016Q3 results. I think this "confuses" EViews (as it should) since 10/2 is actually in the fourth quarter.
In my chat with Bloomberg, I found that the addition of a "PER=AQ" override code seems to fix the issue in Excel.
In Excel, the code should be as follows:
=BDH("SBUX US EQUITY", "IS_COMP_EPS_ADJUSTED", "12/31/2008", "12/31/2020","PER=AQ")
However...
When I try to use that Override code in EViews, Eviews chokes on it.
When I try to find that Override code in the "Select Overrides" Bloomberg Database Dialog box, it is not available (see picture).
And when I try to insert it directly in code, EViews doesn't recognize it either...
In order for me to make this work, I think I need EViews to be fixed to allow the PER=AQ Override Code...
Unless, of course, it can be used, but I'm just not entering it correctly in my code.
EViews Code: "SBUX US Equity IS_COMP_EPS_ADJUSTED PER=AQ"
Many, many thanks for all your help with this!!!
Kevin
I spoke with Bloomberg and showed them an Excel spreadsheet with my code as follows:
=BDH("SBUX US EQUITY", "IS_COMP_EPS_ADJUSTED", "12/31/2008", "12/31/2020")
This results in dates returned that don't square with conventional quarter-end dates. For example, the Bloomberg reporting date might be 10/2/2016 for 2016Q3 results. I think this "confuses" EViews (as it should) since 10/2 is actually in the fourth quarter.
In my chat with Bloomberg, I found that the addition of a "PER=AQ" override code seems to fix the issue in Excel.
In Excel, the code should be as follows:
=BDH("SBUX US EQUITY", "IS_COMP_EPS_ADJUSTED", "12/31/2008", "12/31/2020","PER=AQ")
However...
When I try to use that Override code in EViews, Eviews chokes on it.
When I try to find that Override code in the "Select Overrides" Bloomberg Database Dialog box, it is not available (see picture).
And when I try to insert it directly in code, EViews doesn't recognize it either...
In order for me to make this work, I think I need EViews to be fixed to allow the PER=AQ Override Code...
Unless, of course, it can be used, but I'm just not entering it correctly in my code.
EViews Code: "SBUX US Equity IS_COMP_EPS_ADJUSTED PER=AQ"
Many, many thanks for all your help with this!!!
Kevin
- Attachments
-
- Capture.PNG (35.07 KiB) Viewed 18437 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Bloomberg Missing Data
We're still waiting on support from Bloomberg, but this will certainly help speed things along once Bloomberg help arrives.
Follow us on Twitter @IHSEViews
Re: Bloomberg Missing Data
Just following up on this...
I just tried all the other Bloomberg Overrides available on EViews to see if any of those might produce the same result as Bloomberg's help desk's recommended "PER=AQ" override when using Bloomberg BDH codes in excel.
Beyond the "override" availability issue, I'm noting that the data isn't landing in the right quarters when imported into EViews from Bloomberg. I'm not sure if this is a related or separate issue though...
I'm attaching another image which shows the EViews data right alongside what I see on my Bloomberg screen. Notice that the data isn't landing in the right periods once fetched into EViews.
Sorry for being so persistent about this, but I'm really stuck and am desperate to make this work for a major project.
Many thanks for all your help!
Kevin
I just tried all the other Bloomberg Overrides available on EViews to see if any of those might produce the same result as Bloomberg's help desk's recommended "PER=AQ" override when using Bloomberg BDH codes in excel.
Beyond the "override" availability issue, I'm noting that the data isn't landing in the right quarters when imported into EViews from Bloomberg. I'm not sure if this is a related or separate issue though...
I'm attaching another image which shows the EViews data right alongside what I see on my Bloomberg screen. Notice that the data isn't landing in the right periods once fetched into EViews.
Sorry for being so persistent about this, but I'm really stuck and am desperate to make this work for a major project.
Many thanks for all your help!
Kevin
- Attachments
-
- Untitled.png (1 MiB) Viewed 18353 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
-
- EViews Developer
- Posts: 870
- Joined: Tue Sep 16, 2008 3:50 pm
Re: Bloomberg Missing Data
A new EViews 12 patch was made available last night which fixes the reported issue. All reported issues are resolved when using the PER=AQ attribute/ override as mentioned by kcaron (thank you for determining the correct option).
To specify the "Per=" attribute you will need to use a syntax similar the Bloomberg - Excel syntax. In Excel, the code would look like:
The equivalent in EViews is:
or similarly
I should note the start and end dates are not passed on to Bloomberg and therefore ignored for reasons I have not yet determined. As a second side note the above EViews code will execute without error in older versions of EViews as well but it is only in the latest patch where the PER=AQ attribute is not ignored.
To specify the "Per=" attribute you will need to use a syntax similar the Bloomberg - Excel syntax. In Excel, the code would look like:
Code: Select all
=BDH("SBUX US EQUITY", "IS_COMP_EPS_ADJUSTED", "12/31/2008", "12/31/2020","PER=AQ")
The equivalent in EViews is:
Code: Select all
fetch @BDH(SBUX US EQUITY, IS_COMP_EPS_ADJUSTED, 12/31/2008, 12/31/2020,PER=AQ)
or similarly
Code: Select all
fetch bloomberg::@BDH(SBUX US EQUITY, IS_COMP_EPS_ADJUSTED, 12/31/2008, 12/31/2020,PER=AQ)
I should note the start and end dates are not passed on to Bloomberg and therefore ignored for reasons I have not yet determined. As a second side note the above EViews code will execute without error in older versions of EViews as well but it is only in the latest patch where the PER=AQ attribute is not ignored.
Re: Bloomberg Missing Data
Thank you!
This fix solved the issue 100%.
Data flowing into EViews now perfectly matches what I see on my Bloomberg screen.
Kevin
This fix solved the issue 100%.
Data flowing into EViews now perfectly matches what I see on my Bloomberg screen.
Kevin
Who is online
Users browsing this forum: No registered users and 9 guests