Registered User Joined: 9/7/2014 Posts: 36
|
Looking to create a PCF with the following formula
QStick = SMA (Period, (Close - Open))
where SMA = 3
Period = 10
Close - closing price of last 10 days
Open - opening price the last 10 days.
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
I don't understand the extra SMA parameter.
Qstick is calculated by taking an 'n' period moving average of the difference between the open and closing prices.
In the next version of TC2000 which should be out soon, you can write this as follows:
AVG(C-O,10)
The current version doesn't allow for functions inside AVG( ).
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
You can download version 17 here http://www.tc2000.com/download
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am really not sure I understand. There appear to be two periods but only one place to apply the period. If the period of the simple moving average is 3:
AVGC3 - AVGO3
But if the period of the simple moving average is 10:
AVGC10 - AVGO10
I guess it could be a 3 period simple moving average where the open is the open of the most recent 10 days period and the close is the close of the most recent 10 day period.
AVGC3 - AVGO3.9
-Bruce Personal Criteria Formulas TC2000 Support Articles
|