Getting Estimated Earnings TTM, FTM, MRQ values?

Author: hmg2020

Creation Date: 8/28/2009 3:02 PM

Wealth Lab » WealthScript (.NET) » Getting Estimated Earnings TTM, FTM, MRQ values?

hmg2020

8/28/2009 3:02 PM

How can I get TTM, MRQ and FTM values of estimated earnings?

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.

hmg2020

8/31/2009 9:25 AM

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

Cone

8/31/2009 11:24 AM

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

CODE:
Please log in to see this code.

hmg2020

8/31/2009 1:19 PM

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...

Cone

8/31/2009 4:08 PM

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.

hmg2020

8/31/2009 6:47 PM

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.

Cone

9/1/2009 3:15 AM

CODE:
Please log in to see this code.

tedclimo

7/24/2011 10:50 AM

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.

Cone

#10

7/25/2011 9:31 AM

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

CODE:
Please log in to see this code.

tedclimo

#11

7/29/2011 10:57 AM

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

Cone

#12

7/29/2011 5:48 PM

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.

Eugene

#13

7/30/2011 12:18 AM

Ted,

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

tedclimo

#14

7/30/2011 1:59 PM

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!!!