Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Handy PCF example formulas to help you learn the syntax of PCFs! Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Craig_S
Posted : Sunday, March 6, 2005 12:15:32 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819

Here are some PCF examples to help everyone learn how the syntax of the easiest formula language in the industry works!

Closing price today
(C )

Yesterday's closing price (one day ago)
(C1)

Closing price one month ago
(C21)

Closing price one week ago (5 trading days)
(C5)

Closing price one year ago (250 trading days)
(C250)

Closing price two years ago (500 trading days)
(C500)

Closing price three years ago (750 trading days)
(C750)

Closing price four years ago (1000 trading days)
(C1000)

Closing price five days ago (5 trading days)
(C5)

Closing price four days ago (4 trading days)
(C4)

Closing price three days ago (3 trading days)
(C3)

Closing price on 1/20/06
C'01/20/06'

Dollar Volume today: today's closing price multiplied by today's volume
(C*V)

Today's high
(H )

Yesterday's high (one day ago)
(H1)

Highest closing price over the last six months (126 trading days)
(MAXC126)

Highest high over the last 5 trading days
(MAXH5)

Today's low price
(L )

Yesterday's low price (one day ago)
(L1)

Lowest closing price over the last six months (126 trading days)
(MinC126)

Lowest low over the last 5 trading days
(MINL5)

Net Change
(C-C1)

Net Change 1 Week
(C-C5)

Net Change 1 Month
(C-C21)

Net Change 1 Year
(C-C250)

Open price today
(O )
Yesterday's open price (one day ago)
(O1)

One week percent change
((C-C5)/C5*100)

One month percent change
((C-C21)/C21*100)

1-year percent change in closing price (250 trading days)
((C-C250)/C250*100)

Percentage change in closing price from yesterday to today
((C-C1)/C1*100)

Percentage change in closing price from two days ago to yesterday
((C1-C2)/C2*100)

Ten day price moving average
(AvgC10)

Value of Price 10 day moving average yesterday (one day ago)
(AvgC10.1)

Two hundred day price moving average
(AvgC200)

Price Moving Average 40 Day Yesterday: forty day price moving average which excludes today's prices
(AvgC40.1)

Spread Today: today's high minus today's low
(H-L)

Spread Yesterday: yesterday's high minus yesterday's low
(H1-L1)

Balance of Power (BOP) value 5 days ago
BOP1.5

Average BOP value over the last 30 days
AVG(BOP,30) *note use of comma

Time Segmented Volume (TSV) with a period of 18 value today
TSV18

TSV18 value 5 days ago
TSV18.5

TSV18 value on 1/20/06
TSV18.'01/20/06'

Average TSV18 value over the last 30 days
AVG(TSV18,30) *note use of comma

Stochastic 12 5: Stochastics calculated using a period of 12 days and a 5 day moving average
(Stoc12.5)

Stochastic 12 & 5 Yesterday: Stochastics calculated using a period of 12 days and a 5 day moving average excluding today's prices
(Stoc12.5.1)

Stochastic 23 & 5: Stochastics calculated using a period of 23 days and a 5 day moving average
(Stoc23.5)

Stochastic 23 & 5 Yesterday: Stochastics calculated using a period of 23 days and a 5 day moving average excluding today's prices
(Stoc23.5.1)

Stochastic 45 & 7: Stochastics calculated using a period of 45 days and a 7 day moving average
(Stoc45.7)

Stochastic 45 & 7 Yesterday: Stochastics calculated using a period of 45 days and a 7 day moving average excluding today's prices
(Stoc45.7.1)

Volume today
(V)

Yesterday's volume
(V1)

Volume one week ago (5 trading days)
(V5)

Volume one month ago (21 trading days)
(V21)

Volume one year ago (250 trading days)
(V250)

5 day moving average of volume
(AvgV5)

3 month (63 day) moving average of volume
(AvgV63)

6 month (126 day) moving average of volume
(AvgV126)

Wilder’s RSI (without Wilder's Smoothing) – 14 day
(RSI14.1)

Wilder’s RSI (without Wilder's Smoothing) – 14 day with 10 day avg period
(RSI14.10)

Wilder’s RSI (without Wilder's Smoothing) – 14 day yesterday
(RSI14.1.1)

Wilder’s RSI (without Wilder's Smoothing) – 14 day with 10 day avg period yesterday
(RSI14.10.1)

You may also wish to review the following:

Personal Criteria Language Function List
PCF Formula Descriptions



- Craig
Here to Help!
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.