| chato |
|
Gold User, Member, TeleChart
|
| Registered User |
|
|
|
|
| Unsure |
|
| Monday, August 4, 2008 |
| Sunday, March 27, 2011 6:56:11 PM |
12
[0.00% of all post / 0.00 posts per day] |
|
|
Bruce, I just noted a typo on Post 11. The last comment on NOG in the last paragraph should read less that 1.0340 not 1.0258 because it is a 1.0340 scan..
|
Thank you Bruce, we seem to be comming to different conclusions. I suggest that I review what I want and the formula with you to see if we are on the same page.
I want a scan that shows all stocks that go up at least 1.034 times the open price during the day trading session for successive days, 2 , 3, 4, etc. depending on the PCF. If a stock opens at $5.00 it must reach at least 5.17 to qualify (5.00 times 1.034) and it must do this on the number of last consecutive days that the the PCF calls for. The same would apply for a 1.0258 scan. So the first question is - do the formulas noted in my 7/3 post give these results?
If the formulas are correct then we have to address the differences in results. To check past results I go to the historical tables found on my E trade, Google or Yahoo sites. For the 1.0340 scan all three sites show RDCM on 7/01 opening at 5.02 with a high of 5.05 and SRTY on 6/30 opening at 58.66 with a high of 60.57. Neither of these highs are 1.0340 times the open price so they should be eliminated form the results.
On the 1.0258 scan, PLA is listed on 7/1 with a 4.24 open and a high of 4.25 and CYD on 7/2 with an open of 16.43 and a high of 16.79 neither are 1.0258 times their open.
Tonight, 7/13 I did a 3 day 1.034 scan resulting in FBP.E - GOK - NOG - PSUN - and SNBC. NOG on 7/12 is listed as opening at 13.57 with a high of 13.97 which is less that the open times 1.0340.
Your comments please -
|
QUOTE (Bruce_L) chato,
I get the following symbols when updated through July 2, 2010 Market Close for All Items in System (which you call a 3-Day formula but which I would consider a 4-Day formula):
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200
$TICKA, DRV, FAZ, IDT, RDCM, SMN, SQQQ, SRTY, SSG & TYP
The formula would not be applicable to a symbol such as $TICKA which crosses through zero, but all of the other symbols were up more than 3.4% above the Open during the most recent 4-Market Days at that time (which is what the formula specifies).
When you originally asked about these formulas you seemed to understand that using multiplication was the correct thing to do for percent changes (even though there is some confusion as to what you should be using for particular percent changes).
Cusstom Scan
PCF
Syntax Errors
You now seem to want something where the price is at least $1.034 above the Open during the day. If that is the case, you need to use addition instead of multiplication:
H >= O + 1.034 AND H1 >= O1 + 1.034 AND H2 >= O2 + 1.034 AND H3 >= O3 + 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200
Your "2-Day" formula (which I would consider a 3-Day formula):
H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND AVGV5 > 800 AND C > 3.6 AND C < 200
Is testing for Price to have been more than 2.58% above the Open at some point during the day for the most recent 3-Trading Days. When updated through July 2, 2010 Market Close, I get the following symbols (which I typed by hand, so there could be a typo):
$AMXA, $TICKA, AGYS, AHC, APC, BGZ, BZQ, CCRT, CF, CRZO, CYD, DAC, DRV, DTO, DWSN, ERY, FAZ, FDML, GAP, IDT, IO, JASO, KITD, LDK, LTBR, MAPP, MTRX, MWN, NANO, NR, PDFS, PGNX, PLA, PRS, PWRD, QID, RDCM, RLRN, SCO, SDD, SDOW, SGMO, SKF, SMN, SOL, SPWRA, SQQQ, SRS, SRTY, SSG, STP, TSL, TYP, TZA, UNIS, UPI, VHC, YGE & ZINC
All of these symbols seem to fit the criteria (keeping in mind that percentages are not applicable to symbols that can cross through zero). If you want to change it to being at least $1.0258 above the Open, you would need to use addition instead of multiplication:
H >= O + 1.0258 AND H1 >= O1 + 1.0258 AND H2 >= O2 + 1.0258 AND AVGV5 > 800 AND C > 3.6 AND C < 200
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
|
Thanks for the note- as of 7/3/10, the historicals show that , PLA got up 1.034 (not closed) over the open for one day only (Friday), Cyd was up 0 days, RDCM was up one day and again Crzo never reached 1.034 over the open price either Thursday or Friday.
As a result none of the four stocks should have come up true as they did not satisfy the conditions for either the 3 day or 2 day scan.
Why are my scans not working? Do I have to re-write the formulas? I certainly would appreciate some insight on this - CHATO
|
I am having trouble with my PCFs picking up non-conforming stocks. Today my 3 day 1.034 PCF listed 8 stocks including RDCM and SRTY which did not go up 1.034 over the open for the last 3 days. Also my 2 day 1.034 PCF listed about 24 stocks and about 12 stocks should not be there. GYRO CIZN HOOK CBPO JGBO CBPO SYPR MXC PLA CYD TLF CRZO ECHO RDCM - do not fit the PCF. Am I doing something wrong?
3 day 1.034 PCF
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200
2 day 1.034
H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND AVGV5 > 800 AND C > 3.6 AND C < 200
Thanks - Chato
|
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND H4 > O4 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200
I have been using this PCF to scan for stocks that go up 1.034 from their respective open prices during the trading day, the close is not part of the formula.
It is working but it is also picking up some stocks which have not gone up 1.0340 for the last three days.
Does the formula have to be changed to avoid these errors?
Thank you,
Chato
|
|
Many thanks Bruce, I am finally getting the hang of it - Chato
|
The following PCF seems to be formulated correctly and gives correct results,
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND H4 > O4 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200
I try to use the same format and change both the % (up over the open) and number of days. This new PCF triggers Syntax Error. Can you explain what I am doing wrong?
H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND H3 > O3 * 1.0258 AND H4 > O4 * 1.0258 AND H5 > O5 * 1.0258 AND H6 > O6 * 1.0258 AND H7 > O7 * 1.0258 AND H8 > O8 * 1.0258 AND H9 > O9 * 1.0258 AND H10 > O10 * ANDH11> O11 * 1.0258 AND H12 > O12 * 1.0258 AND AVGV5 > 800 AND C > 3.5 AND C < 200
Thanks - Chato
|
|
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND H4 > O4 * 1.034 AND H5 > O5 * 1.034 AND H6 > O6 * 1.034 AND AVGV5 > 800 AND C > 3.5 AND C < 200
I am using the above PCF and the scan results are not correct. I assume that there is a mistake in the formula. I run this and the scan shows one stock (MTG) and it should show something like 10 stocks such as CBG,CTRN,BBND,HSNI,MWR, etc. which all qualify.
I want a scan of all stocks for the last six sessions that have gone up at least 1.0340 % over their open price sometime during the trading day. I am not interested in the close. The volume criteria is a average min, volume of 80.000 share for the last 5 days and the price range is $3.50 to $200.00 Can you suggest something?
Thank you, chato
|
|
I am brand new to Worden and would like to start with a PCF, but am not sure how to set up the conditions. Below is the model of a scan that I use with another firm that I would like to duplicate with your protocol.
The first and basic condition is a modified white candlestick scan. I want a nightly scan of “all stocks” that have gone up a prescribed minimum percentage (in this case .0340) from its opening price sometime during the trading day. I am not interested in the close.
The stock price limits are $3.60 to $200.00 and the minimum daily average volume for say the last 5 days would be 80,000 shares, regardless of price.
I will duplicate the scan changing the percent and number of days, which I should be able to handle once I have the correct format.
I would like to get this behind me and look forward to moving on with some of your interesting programs.
Many thanks – Lionel Giliotti
output = "sevenday.0340list";
if high(0) > open(0) * 1.0340
and high(-1) > open(-1) * 1.0340
and high(-2) > open(-2) * 1.0340
and high(-3) > open(-3) * 1.0340
and high(-4) > open(-4) * 1.0340
and high(-5) > open(-5) * 1.0340
and high(-6) > open(-6) * 1.0340
and AvgVol( 0 , -29 ) >80000
and close(0) > 3.60
and close(0) < 200
then
println symbol;
endif;
|
|