StockFetcher Forums · Filter Exchange · translating from TC2000<< >>Post Follow-up
sylvano
2 posts
msg #33044
Ignore sylvano
8/29/2004 1:27:37 AM

Here is a script written for TC2000, can someone help me translate it for stockfetcher?
*Spring on Current Bar
V > V1 AND (H - L) / V < (H1 - L1) / V1

*Spring on Previous Bar
V1 > V2 AND (H1 - L1) / V1 < (H2 - L2) / V2

*Stocks 15 - 25%…Long
AVGC20 >= (H * 1.15) and AVGC20 <= (H * 1.25)

*Stocks > 25%…Long
AVGC20 > (H * 1.25)

*Stocks 15 - 25%…Short
AVGC20 * 1.18 <= L AND AVGC20 * 1.33 >= L

*Stocks >25%…Short
AVGC20 * 1.33 < L

*Long Reversal Bar
H < H1 AND L < L1 AND C > ((H + L) / 2)

*Short Reversal Bar
H > H1 AND L > L1 AND ((H + L) / 2) > C
Thanks and by the way, those formulas are very profitable.


yepher
359 posts
msg #33048
Ignore yepher
8/29/2004 8:51:49 PM

I am not really that familiar with TC200 Syntax but here is an attempt at porting a formula to SF syntax.

Have a look at this formula to get your started:

V > V1 AND (H - L) / V < (H1 - L1) / V1
Fetcher[
set {hMinusLow, high - low}
set {volRatio, hMinusLow/Volume}

Volume > volume 1 day ago
AND volRatio < volRatio 1 day ago
]


I think all the formulas you posted can be ported fairly easily. I would suggest reading through the Stockfetcher manual and you can also use: http://yepher.com/~yepher/stockfetcher/command.html as a quick cheat sheet.

The commands you will probably use are:
CMA - Custom Moving Average
Average - another way the average price or Volume
Days ago - allows you to offset the measure in time
High, low, open, close - price
Volume - volume

set - is a command that can be a little tricky at first so read up on it too.

If you try and port the others and post your progress I am sure there are many here who will be more than willing to help you get it exactly right.


robdavis
69 posts
msg #33050
Ignore robdavis
8/29/2004 9:20:24 PM

Sylvano,

Great stuff! Thanks for bringing TC2000 and their scripts to our attention!


FIRST TC2000 SCRIPT:
"Spring on Current Bar"
V > V1 AND (H - L) / V < (H1 - L1) / V1


TRANSLATION FOR SF USERS:
Fetcher[/*FIRST TC2000 SCRIPT*/
Show stocks where
set{HL,high - low}
and set{HLV,HL / volume}
and set{HL1,high 1 day ago - low 1 day ago}
and set{HLV1,HL1 / volume 1 day ago}
and HLV1 is greater than HLV
and volume is greater than volume 1 day ago
and close is between 1 and 250
and average volume(90) is above 50000
and volume 30 day low is greater than 50000
]



SECOND TC2000 SCRIPT
Spring on Previous Bar
V1 > V2 AND (H1 - L1) / V1 < (H2 - L2) / V2


TRANSLATION FOR SF USERS:
Fetcher[/*2ND TC2000 SCRIPT*/
Show stocks where
set{HL1,high 1 day ago - low 1 day ago}
and set{HLV1,HL1 / volume 1 day ago}
and set{HL2,high 2 days ago - low 2 days ago}
and set{HLV2,HL2 / volume 2 days ago}
and HLV2 is greater than HLV1
and volume 1 day ago is greater than volume 2 days ago
and close is between 1 and 250
and average volume(90) is above 50000
and volume 30 day low is greater than 50000
]



COMBINATION OF FIRST AND SECOND TC2000 SCRIPTS
Spring on Current Bar
V > V1 AND (H - L) / V < (H1 - L1) / V1
Spring on Previous Bar
V1 > V2 AND (H1 - L1) / V1 < (H2 - L2) / V2


TRANSLATION FOR SF USERS:
Fetcher[/*1ST AND 2ND TC2000 SCRIPTS*/
Show stocks where
set{HL,high - low}
and set{HLV,HL / volume}
and set{HL1,high 1 day ago - low 1 day ago}
and set{HLV1,HL1 / volume 1 day ago}
and HLV1 is greater than HLV
and set{HL2,high 2 days ago - low 2 days ago}
and set{HLV2,HL2 / volume 2 days ago}
and HLV2 is greater than HLV1
and volume is greater than volume 1 day ago
and volume 1 day ago is greater than volume 2 days ago
and close is between 1 and 250
and average volume(90) is above 50000
and volume 30 day low is greater than 50000
]



I hope this helps.


Rob


robdavis
69 posts
msg #33063
Ignore robdavis
8/30/2004 12:32:00 PM

Sylvano,

Assuming that we want to use the (same) global filter of
Fetcher[
Show stocks where
close is between 1 and 250
and average volume(90) is above 50000
and volume 30 day low is greater than 50000
]

...the 3rd TC2000 script (i.e. "Stocks 15 - 25%…Long; AVGC20 >= (H * 1.15) and AVGC20 <= (H * 1.25)" for SF users is as follows:

Fetcher[/*3RD TC2000 SCRIPT*/
set{Higher,high * 1.15}
and set{x,count(MA(20) is greater than Higher,1)}
and set{y,count(MA(20) equals Higher,1)}
and set{z,x+y}
and set{Highest,high * 1.25}
and set{p,count(Highest is greater than MA(20),1)}
and set{q,count(Highest equals MA(20),1)}
and set{r,p+q}
and z is greater than 0
and r is greater than 0
and draw MA(20,1)
and show stocks where
close is between 10 and 99
and average volume(90) is above 50000
and volume 30 day low is greater than 50000
]


I hope this helps.

Rob


StockFetcher Forums · Filter Exchange · translating from TC2000<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.