Getting Estimated Earnings TTM, FTM, MRQ values?
Author: hmg2020
Creation Date: 8/28/2009 3:02 PM
profile picture

hmg2020

#1
How can I get TTM, MRQ and FTM values of estimated earnings?
profile picture

Cone

#2
See for TTM and MRQ, see FundamentalDataSeries in the QuickRef (F11). For FTM, you'll have to work for it yourself by accessing and manipulatin g the EPS data directly using FundamentalDataItems. You won't be able to plot future values, but you can work with them programmatically for forecasting.
profile picture

hmg2020

#3
OK...I know MRQ estimated earnings are obtained this way.
CODE:
Please log in to see this code.


But for TTM, Is it adding the previous quarters the only way?
or is there another name for them in the series like "estimated earnings (TTM)"?
profile picture

Cone

#4
No, you have to aggregate the raw data, it's just as easy.

CODE:
Please log in to see this code.

profile picture

hmg2020

#5
Thanks and forgive my lack C# understanding.
I wish I knew how the FTM value is calculated to get it like it is displayed in the charts...
profile picture

Cone

#6
FTM is "Forward 12 Months", right?
As I said previously, you cannot display these data in a Wealth-Lab chart because the future bars don't exist to plot on.
profile picture

hmg2020

#7
I understand. I just want do display them as text rather than having to move my mouse cursor to the estimated earnings icon where the value is already calculated.

For instance, this is what I can see for BIG when I move my mouse cursor over the last estimated earning.

Q2:2009
Est EPS: $0.303
Sum TTM Mean: $1.787
Sum FTM Mean: $2.045

So I don't want to move the mouse all the time to see these figures and FTM is the only one I need now.

profile picture

Cone

#8
CODE:
Please log in to see this code.
profile picture

tedclimo

#9
The code below is my attempt at creating a historical DataSeries from ratio of Future Estimated EPS / TTM EPS.
Yes it compiles, but No it does not provide a historical ratio.... only the current ratio which is flatlined back through entire stock lifespan.
what am I doing wrong???
CODE:
Please log in to see this code.

Thanks in advance.
profile picture

Cone

#10
Here's a little re-arrangement without really checking what you're doing -

CODE:
Please log in to see this code.
profile picture

tedclimo

#11
Cone,
I tried your code on all 30 stocks in the DOW30(Fidelity Data).
Each one gives me the same error msg:
QUOTE:
Runtime error: Object reference not set to an instance of an object. at WealthLab.Strategies.MyStrategy.Execute()

What am I missing?

Ted
profile picture

Cone

#12
I don't know because I can't see what you've done. I copied the code from here, compiled, and it runs fine for me.
profile picture

Eugene

#13
Ted,

Have you double-checked that "estimated earnings" exist for all the Dow 30 (Fidelity) symbols?
profile picture

tedclimo

#14
Cone & Eugene,

Solution identified. Estimated EPS only has 4.5 years of history (at least on my PC). Whereas, EPS has 5.5 years of history.
Once I set TimeFrame to view last 4 yrs only, Cone's script worked on all Dow 30 components && "Runtime Error" vanished.
Thank you for your wisdom.

All the best to you & yours!!!