## New version 17 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 Next Earnings Date Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
danielbender
 Posted : Tuesday, April 27, 2010 4:52:20 PM
Platinum Customer

Joined: 1/14/2006
Posts: 410

I am trying to create an indicator that will generate the next anticipated earnings date for a stock, in terms of days in the future, and display it in a watchlist column.  I think I have a workable approach, but I need some programming help.

The starting point is the Earnings 1-yr indicator on a weekly graph (note, using a weekly chart is important, it wont work on a daily chart).   Then create a 1 period "rate of change (net)" child indicator.   Then generate a combined condition with 1) rate of change moving up, or 2) rate of change moving down.  This creates a spike graph, with a spike every 13 weeks or so.  That part is easy.

Now I need some help to take the latest spike (most recent Earnings Event), find its date, add 13 weeks to that date to generate the next anticipated Earnings Event,  then find the difference between the current date and the next Earnings Event in days, and then display that as an integer in a watchlist column.  If the number is small, I know the next EE is pending.  If the number is near 90, I know the next EE will be several months away.

If someone can figure out a simpler or more accurate method, that would be fine as well.

Thank you

Bruce_L
 Posted : Wednesday, April 28, 2010 9:53:28 AM

Worden Trainer

Joined: 10/7/2004
Posts: 59,601
'|******************************************************************
'|*** StockFinder RealCode Indicator - Version 5.0 www.worden.com
'|*** Copy and paste this header and code into StockFinder *********
'|*** Indicator:Next Earnings Date
'|******************************************************************
'# Earnings = indicator.Library.Earnings 1-Yr
'# Cumulative
Static CountDown As Single
If isFirstBar Then
CountDown = Single.NaN
Else If Earnings.Value <> Earnings.Value(1) AndAlso _
Price.DateValue = Earnings.DateValue Then
CountDown = 63
Else
CountDown -= 1
End If
Plot = CountDown

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
danielbender
 Posted : Wednesday, April 28, 2010 1:36:55 PM
Platinum Customer

Joined: 1/14/2006
Posts: 410
Bruce - Thanks, that worked pretty well.
jmeisen
 Posted : Monday, October 10, 2011 5:34:03 PM
Registered User
Joined: 6/5/2010
Posts: 27

Bruce,
I have applied this to my charts, and the indicator portion appears to work well, but when used as a watchlist column, the values are not the same as what is given in the indicator window.

Any suggestions?

jm

jmeisen
 Posted : Monday, October 10, 2011 7:16:44 PM
Registered User
Joined: 6/5/2010
Posts: 27

Bruce, please disregard the above post; I have found and now have included

'# Cumulative

Now the watch-list lists correctly.

Thanks,

jm

Bruce_L
 Posted : Tuesday, October 11, 2011 8:34:29 AM

Worden Trainer

Joined: 10/7/2004
Posts: 59,601
I am happy to read you were able to figure it out on your own.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
caution
 Posted : Thursday, January 19, 2017 12:05:49 PM
Platinum Customer

Joined: 5/5/2010
Posts: 178

Bruce,

Does the above code still works or is there a better way to have upcoming earnings included in the watchlist?

Bruce_L
 Posted : Thursday, January 19, 2017 12:54:06 PM

Worden Trainer

Joined: 10/7/2004
Posts: 59,601

The above code still works. I do not know of any other way to add earnings dates or upcoming earnings as a WatchList Column in StockFinder (it was added to TC2000 after SF stopped development).

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/17 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 17 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos You cannot post new topics in this forum. You cannot reply to topics in this forum. You cannot delete your posts in this forum. You cannot edit your posts in this forum. You cannot create polls in this forum. You cannot vote in polls in this forum.