StockFetcher Forums · Filter Exchange · Day Point Range<< >>Post Follow-up
stan22
11 posts
msg #40271
Ignore stan22
1/14/2006 1:53:42 AM

Hello,

Could someone please tell me how to change this filter to use the open and close instead of the high and low of the day.

Thank You

The day point range is the actual price difference between the high and low of the day. The day point range is not converted to a percent.


alf44
2,025 posts
msg #40275
Ignore alf44
1/14/2006 12:21:15 PM

stan22,

If I understand you correctly...you are trying to use the Open to Close Range as a selection criteria...instead of the High to Low Range (which is what StockFetcher uses in their "Day Point Range" measure).

Try this :

-------------------

Fetcher[set{ClOpRng, abs(Close minus Open)}

Show stocks where the ClOpRng is above 1.00
Price is above 10.00
Average Volume(65) is above 500000

add column ClOpRng

sort Column 5 descending
]



---------------------

The ClOpRng column will show you the actual Range between the Open and Close !

Also, The ClOpRng column has been sorted in descending order so the stocks with the largest Close to Open Range will be at the top !

Is that what you had in mind ?


Regards,

alf44






nikoschopen
2,824 posts
msg #40281
Ignore nikoschopen
1/14/2006 5:19:34 PM

There already exists a OPCL indicator. Check out the following URL:

http://www.stockfetcher.com/stockdb/fetcher?p=forum&sub=view&fid=1003&tid=26674&mid=26721&efstext=b3BjbA#26721

OR

http://yepher.com/stockfetcher/command-cmddoc.html#Absolute Open to Close Change
_________________

Here's a rundown...


Fetcher[show stocks where the opcl is above 0]


Fetcher[show stocks where the opcl% is below -2.5%]


Fetcher[show stocks where the aopcl is above 2.0]


Fetcher[show stocks where the aopcl% is above 5.0%]



In summary:

opcl = Open to close change
opcl% = Open to close Change Percent
aopcl = Absolute Open to Close Change
aopcl% = Absolute Open to Close Change Percent




alf44
2,025 posts
msg #40282
Ignore alf44
1/14/2006 6:16:22 PM

WOW...

...I did not know that !

My "offering" from my previous post is a part of a larger scan I wrote where the Open to Close Range is used.

Oh well...





rtucker
318 posts
msg #40283
Ignore rtucker
1/14/2006 7:00:47 PM

Nice. Thanx for pointing this method out!


stan22
11 posts
msg #40287
Ignore stan22
1/14/2006 8:34:52 PM

alf44 and nikoschopen,

This is exactly what i was looking for, thank you both for your help, very much appreciated.


alf44
2,025 posts
msg #40289
Ignore alf44
1/14/2006 9:29:30 PM

...no prob !


Good Luck,

alf44




StockFetcher Forums · Filter Exchange · Day Point Range<< >>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.