This is a trading item or a component that was created using QuantShare by one of our members.
This item can be downloaded and used by QuantShare Trading Software.
Trading items are of different types. There are data downloaders, trading indicators, trading systems, watchlists, composites/indices...
You can use this item and hundreds of others for free by downloading QuantShare.
Top Reasons Why You Should Use QuantShare:
Works with US and international markets (stock, forex, options, futures, ETF...)
Offers you the tools that will help you become a profitable trader
Allows you to implement any trading ideas
Exchange items and ideas with other QuantShare users
Our support team is very responsive and will answer any of your questions
We will implement any features you suggest
Very low price and much more features than the majority of other trading software
For Free - No Credit Card Required
Historical Earnings Surprise, EPS and Consensus Data
An earnings surprise is when a company reports an earnings number that is not expected by analysts. In other words, an earnings surprise occurs when the earnings per share (EPS) is not in-line with the consensus estimates. The earnings may exceed, be in-line or below the consensus estimates. Usually, an earnings surprise cause the stock price to move quickly in either direction depending on whether that surprise was positive or negative and also on how high or low the surprise is (the difference between the reported earnings and the consensus forecast).
The higher the earnings surprise is the more likely the stock will go up and the lower the earnings surprise is (negative) the more likely the stock will go down.
This download item gets historical EPS, Consensus EPS and earnings surprise in percentage. It retrieves the reported earnings per share, consensus EPS and surprise numbers for U.S. and International stocks. The data is stored in the database "earnings_cal", the same database I have used in (Historical Earnings Calendar for Major Stock Exchanges), an item that downloads earnings release time (After Market Close, Before Market Close or Time Not Supplied). You can use both items to save the release time in addition to the EPS, consensus EPS and earnings surprise.
The different fields created and filled by this trading object are:
EPS: This field gets the earnings per share.
Consensus: This field gets the consensus EPS. The analyst's expectation of what will be the EPS.
Surprise: The Earnings surprise. This fundamental item is expressed in percentage and it is calculated by taking the percentage value of the division of EPS by the Analysts Consensus.
Earnings history for selected symbols:
To display historical earnings for the selected symbol, select "Tools" then "Database Data". Next to "Database", select "earnings_cal". At the bottom of the control (next to "Filters"), select whether you want to show earnings history for the selected chart, all charts or all stocks in your database.
Access data programmatically from the earnings history database:
Use the "GetData" function to get earnings surprise data for U.S. stocks. Here is an example that shows you how to plot historical earnings surprises on a chart (Right click on chart then select "Edit Formula"):