Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Worden Discussion Forum » Customer Training & Support » PCFs, EasyScan and Custom Indicators » Average of 5 different stocks

Average of 5 different stocks

Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

Siddharth

Posted : Monday, November 25, 2013 6:23:23 PM

Registered User
Joined: 10/7/2004
Posts: 9

Hi Bruce, is it possible to create an indicator that would give me an average closing price or average High of a portfolio consisting of 5 stocks? For example if i wanted an average closing price of MSFT, INTC, IBM, GE and WMT, how can i write a PCF for this? Thank you in advance,

-sid

Bruce_L

Posted : Tuesday, November 26, 2013 9:31:47 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There is no syntax in the Personal Criteria Formula Language for referencing other symbols. For this reason, I cannot think of a practical automated method of creating an Indicator Formula for this. You may wish to review the following for a semi-automated technique for utilizing other symbols in a PCF:

Indexes in PCF's
RSMA PCFs

While there isn't a practical way to do this in TC2000, StockFinder has a Custom Market Indicator feature which would allow you to average the closing prices of all of the symbols in a WatchList.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Siddharth

Posted : Friday, November 29, 2013 11:23:29 AM

Registered User
Joined: 10/7/2004
Posts: 9

Thank you Bruce. Appreciate it.

-sid

Bruce_L

Posted : Friday, November 29, 2013 11:43:46 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Users browsing this topic

Guest-1

Forum Jump

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.