I am instructed to post a following question here by Helpdesk. Hope someone can take care of it.
I am looking for an efficient way of checking the latest revisions of (1) sell side analysts’ earnings estimates of individual company and (2) economists’ forecasts of macroeconomic variables (such as GDP QoQ). For (1), ideally, when I run some code specifying a universe (e.g., SP500), then it gives me back a list of sell sides’ revised earnings estimates of constituents of the index within a day or a week. (not aggregate, but individual firm level) Similarly, for (2), when I throw an inquiry, hopefully it returns a list of revised economists’ forecasts. To clarify, I am not looking for consensus figures, but individual analysts’ or economists’ forecasts. I would like to do this on Excel API or Python API. If you have any idea how to implement it, could you share it with me? Thank you!