IBES -count of analysts
Posted: 30 March 2014 12:50 PM   [ Ignore ]
Newbie
Rank
Total Posts:  22
Joined  2013-01-15

Dear all,
Do you have a sample code to count the number of analysts following a firm each year? I am not sure if I need to apply filters regarding FPI indicator and how we convert FPEDATS to fiscal year ? I ask this because I saw another post discussing the following:

FPI = 1 - the forecasts are made for the fiscal year and are reported in the year before the publication of the annual report.
FPI = 2 - the forecasts are made for the fiscal year and are reported in the year before FPI = 1, etc.
FPI = 6 - the forecasts are made for the quarterly figures and are reported in the quarter before the publication of the quarterly report.
FPI = 7 - the forecasts are made for the quarterly figures and are reported in the quarter before FPI = 6, etc.
FPI = 0 - the long term growth (if you choose this date you can’t select Forecast Period End Date at step 1, because there is no Period End for long term growth).


so would I convert FPEDATS to fiscal year differently depending on FPI code?

thanks,

-R

Profile
 
 
Posted: 30 March 2014 01:37 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Rochelle,

I added a macro that appends the number of analysts following, see: http://www.wrds.us/index.php/repository/view/35

I am using the last month of the fiscal year as the measuring point (#analysts can vary over the year), and I am taking the forecasts for the current year (FPI: 1). This should be easy to tweak if needed.

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 02 April 2014 01:33 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  22
Joined  2013-01-15

Thanks very much, Joost.

Profile
 
 
Posted: 02 April 2014 07:55 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

You’re welcome! smile

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 03 April 2014 05:08 PM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  6
Joined  2012-06-15

Hi, Joost,

Do you have any macro to calculate forecast characteristics, accuracy, dispersion ect? Many thanks!

Profile
 
 
Posted: 04 April 2014 10:46 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

What macro would be most helpful at this point?

best,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile