StockFetcher Forums · Filter Exchange · Composing this syntax into stockfetcher terms<< >>Post Follow-up
AdamW328
84 posts
msg #55848
Ignore AdamW328
10/19/2007 4:25:37 PM

Can someone compose this syntax, which I found from another site, into the syntax that would work for stockfetcher. Thanks!

dwiggains
391 posts
msg #55857
Ignore dwiggains
10/20/2007 10:52:36 AM

?????

AdamW328
84 posts
msg #55876
Ignore AdamW328
10/21/2007 6:05:41 PM

Sorry....forgot to post the syntax....lol

here it is:

SELECT Name, PriceA, PriceB, PriceC, PriceD, Price_1 AS PriceE, Price AS PriceF
FROM FILTER {Price >= Price_1 AND Price <= PriceA}
(FILTER{Price <= 1.1*PriceB} (
SELECT Name, PriceA, PriceB, PriceC, Price_1 AS PriceD, Price
FROM
FILTER{Price >= 0.9*PriceB} (
SELECT Name, PriceA, PriceB, Price_1 AS PriceC, Price
FROM
FILTER{Price >= 0.9*PriceA AND Price <= 1.1*PriceA} (
SELECT Name, PriceA, Price_1 AS PriceB, Price
FROM
FILTER{Price >= 1.2*PriceA} (
SELECT Name, Price_1 AS PriceA, Price
FROM
FILTER {Price < Price_1}
(SELECT Name, Price FROM Stock NEXT {$1.Name=$2.Name} Stock)
FOLD {$1.Name = $2.Name, $2.Price >= $.Price,} Stock)
FOLD {$1.Name = $2.Name, $2.Price <= $.Price,} Stock)
FOLD {$1.Name = $2.Name, $2.Price >= $.Price,} Stock)
FOLD {$1.Name = $2.Name, $2.Price <= $.Price,} Stock)
NEXT {$1.Name = $2.Name}
Stock)

jrbikes
624 posts
msg #55922
Ignore jrbikes
10/22/2007 8:41:00 PM

What is this?

Youall guys are crazy!

StockFetcher Forums · Filter Exchange · Composing this syntax into stockfetcher terms<< >>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 2016 - 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