Click here to Login








Historical Earnings Surprise, EPS and Consensus Data

by Patrick Fonce, 232 days ago
Share |






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"):

a = GetData("earnings_cal", "surprise", Zero); // Returns earnings surprise in percentage
plot(a, "", colorRed, ChartLine, StyleOwnScale); // Plots historical EPS surprise numbers

To get consensus EPS, simply type:
a = GetData("earnings_cal", "consensus", Zero); // Returns historical EPS consensus

Sample Data:
http://biz.yahoo.com/z/20120703.html


Share This ->
Share |


You have to log in to bookmark this object
What is this?




Type: Download Script

Object ID: 832


Country:
United States

Market: Stock Market

Style:
Fundamental Analysis

Reviews
You must log in first

Join now
and get instant access for free to the trading software, the Sharing server and the Social network website.
Click here


Related objects
Show All
Historical Stock Market Data (by QuantShare, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 3466 Notes Report an item
Intraday Quotes for Major Stock Exchanges (by QuantShare, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1203 Notes Report an item
Morningstar Historical Fundamentals (by Stefan Kroscen, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 124 Notes Report an item
U.S. Stock Market (by QuantShare, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 1516 Notes Report an item
History of dividend payment for stocks in the US stock market (by The trader, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 65 Notes Report an item
Historical Earnings Calendar for Major Stock Exchanges (by Patrick Fonce, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 109 Notes Report an item
Yahoo EOD historical quotes (by QuantShare, uploaded several months ago)
No notes

Rate an item Rate an item Rate an item Rate an item Rate an item Number of downloads 741 Notes Report an item
Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object

Technical Analysis


Fundamental Analysis



Random Blog Posts

QuantShare Version 2.1.0 - Trading Software

How to create a ratio indicator using QS Trading Software

Screening with the composite indicators

Synchronize Buy/Sell List of Rules in the Trading System Optimizer

QS Trading Software: Global Script

New Ranking and Percentile Composite Functions

QS Trading Software: Database Optimization

Stock Market Prediction with QuantShare

Show All

Number of reviews
Click to add a review
Average rate
Click to rate this item
Number of times this object was downloaded
Number of rates the current object received
Report an object
if you can't run it for example or if it contains errors
Click to report this object






QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright 2012 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.