Registered User
Joined: 3/23/2005
Posts: 7
|
I understand that stocks are more likely to gap up over night than gap down. Can you help to construct a scan, that would short list potentially bullish buy candidates, that could be bought just before the close, with view to selling next day if profitable.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
We can't help you write Personal Criteria Formulas or EasyScans for "bullish buy candidates" or "stocks that will gap up overnight" without more information from you. If you have some idea of specific conditions or criteria to include in such scans, we will do our best to help you create them.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
 Platinum Customer
Joined: 11/21/2005
Posts: 45
|
On a similar idea - how about finding stocks that statistically have a tendency to gap up / down & ranking them by probability & gap size & usual direction.
Maybe likely gap direction can be found in correlation / divergence with an index ??
i.e. I note that some issues gap almost every morning with a frequency of m around 2 gaps down to 3 gaps up (from observation rather than stats). Now I would like to identify & quantify the likely outcomes from a statistical point of view.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
mbbcat,
The following formula would count the number of Gap Ups during the last 100-Trading Days (using Low versus previous High):
ABS((L > H1) + (L1 > H2) + (L2 > H3) + (L3 > H4) + (L4 > H5) + (L5 > H6) + (L6 > H7) + (L7 > H8) + (L8 > H9) + (L9 > H10) + (L10 > H11) + (L11 > H12) + (L12 > H13) + (L13 > H14) + (L14 > H15) + (L15 > H16) + (L16 > H17) + (L17 > H18) + (L18 > H19) + (L19 > H20) + (L20 > H21) + (L21 > H22) + (L22 > H23) + (L23 > H24) + (L24 > H25) + (L25 > H26) + (L26 > H27) + (L27 > H28) + (L28 > H29) + (L29 > H30) + (L30 > H31) + (L31 > H32) + (L32 > H33) + (L33 > H34) + (L34 > H35) + (L35 > H36) + (L36 > H37) + (L37 > H38) + (L38 > H39) + (L39 > H40) + (L40 > H41) + (L41 > H42) + (L42 > H43) + (L43 > H44) + (L44 > H45) + (L45 > H46) + (L46 > H47) + (L47 > H48) + (L48 > H49) + (L49 > H50) + (L50 > H51) + (L51 > H52) + (L52 > H53) + (L53 > H54) + (L54 > H55) + (L55 > H56) + (L56 > H57) + (L57 > H58) + (L58 > H59) + (L59 > H60) + (L60 > H61) + (L61 > H62) + (L62 > H63) + (L63 > H64) + (L64 > H65) + (L65 > H66) + (L66 > H67) + (L67 > H68) + (L68 > H69) + (L69 > H70) + (L70 > H71) + (L71 > H72) + (L72 > H73) + (L73 > H74) + (L74 > H75) + (L75 > H76) + (L76 > H77) + (L77 > H78) + (L78 > H79) + (L79 > H80) + (L80 > H81) + (L81 > H82) + (L82 > H83) + (L83 > H84) + (L84 > H85) + (L85 > H86) + (L86 > H87) + (L87 > H88) + (L88 > H89) + (L89 > H90) + (L90 > H91) + (L91 > H92) + (L92 > H93) + (L93 > H94) + (L94 > H95) + (L95 > H96) + (L96 > H97) + (L97 > H98) + (L98 > H99) + (L99 > H100))
This formula would count the number of Gap Downs (using High versus previous Low):
ABS((H < L1) + (H1 < L2) + (H2 < L3) + (H3 < L4) + (H4 < L5) + (H5 < L6) + (H6 < L7) + (H7 < L8) + (H8 < L9) + (H9 < L10) + (H10 < L11) + (H11 < L12) + (H12 < L13) + (H13 < L14) + (H14 < L15) + (H15 < L16) + (H16 < L17) + (H17 < L18) + (H18 < L19) + (H19 < L20) + (H20 < L21) + (H21 < L22) + (H22 < L23) + (H23 < L24) + (H24 < L25) + (H25 < L26) + (H26 < L27) + (H27 < L28) + (H28 < L29) + (H29 < L30) + (H30 < L31) + (H31 < L32) + (H32 < L33) + (H33 < L34) + (H34 < L35) + (H35 < L36) + (H36 < L37) + (H37 < L38) + (H38 < L39) + (H39 < L40) + (H40 < L41) + (H41 < L42) + (H42 < L43) + (H43 < L44) + (H44 < L45) + (H45 < L46) + (H46 < L47) + (H47 < L48) + (H48 < L49) + (H49 < L50) + (H50 < L51) + (H51 < L52) + (H52 < L53) + (H53 < L54) + (H54 < L55) + (H55 < L56) + (H56 < L57) + (H57 < L58) + (H58 < L59) + (H59 < L60) + (H60 < L61) + (H61 < L62) + (H62 < L63) + (H63 < L64) + (H64 < L65) + (H65 < L66) + (H66 < L67) + (H67 < L68) + (H68 < L69) + (H69 < L70) + (H70 < L71) + (H71 < L72) + (H72 < L73) + (H73 < L74) + (H74 < L75) + (H75 < L76) + (H76 < L77) + (H77 < L78) + (H78 < L79) + (H79 < L80) + (H80 < L81) + (H81 < L82) + (H82 < L83) + (H83 < L84) + (H84 < L85) + (H85 < L86) + (H86 < L87) + (H87 < L88) + (H88 < L89) + (H89 < L90) + (H90 < L91) + (H91 < L92) + (H92 < L93) + (H93 < L94) + (H94 < L95) + (H95 < L96) + (H96 < L97) + (H97 < L98) + (H98 < L99) + (H99 < L100))
This would be 100 * the ratio of Gap Ups to Gap Downs (using Low versus previous High or High versus previous Low):
100 * ABS((L > H1) + (L1 > H2) + (L2 > H3) + (L3 > H4) + (L4 > H5) + (L5 > H6) + (L6 > H7) + (L7 > H8) + (L8 > H9) + (L9 > H10) + (L10 > H11) + (L11 > H12) + (L12 > H13) + (L13 > H14) + (L14 > H15) + (L15 > H16) + (L16 > H17) + (L17 > H18) + (L18 > H19) + (L19 > H20) + (L20 > H21) + (L21 > H22) + (L22 > H23) + (L23 > H24) + (L24 > H25) + (L25 > H26) + (L26 > H27) + (L27 > H28) + (L28 > H29) + (L29 > H30) + (L30 > H31) + (L31 > H32) + (L32 > H33) + (L33 > H34) + (L34 > H35) + (L35 > H36) + (L36 > H37) + (L37 > H38) + (L38 > H39) + (L39 > H40) + (L40 > H41) + (L41 > H42) + (L42 > H43) + (L43 > H44) + (L44 > H45) + (L45 > H46) + (L46 > H47) + (L47 > H48) + (L48 > H49) + (L49 > H50) + (L50 > H51) + (L51 > H52) + (L52 > H53) + (L53 > H54) + (L54 > H55) + (L55 > H56) + (L56 > H57) + (L57 > H58) + (L58 > H59) + (L59 > H60) + (L60 > H61) + (L61 > H62) + (L62 > H63) + (L63 > H64) + (L64 > H65) + (L65 > H66) + (L66 > H67) + (L67 > H68) + (L68 > H69) + (L69 > H70) + (L70 > H71) + (L71 > H72) + (L72 > H73) + (L73 > H74) + (L74 > H75) + (L75 > H76) + (L76 > H77) + (L77 > H78) + (L78 > H79) + (L79 > H80) + (L80 > H81) + (L81 > H82) + (L82 > H83) + (L83 > H84) + (L84 > H85) + (L85 > H86) + (L86 > H87) + (L87 > H88) + (L88 > H89) + (L89 > H90) + (L90 > H91) + (L91 > H92) + (L92 > H93) + (L93 > H94) + (L94 > H95) + (L95 > H96) + (L96 > H97) + (L97 > H98) + (L98 > H99) + (L99 > H100)) / ABS((H < L1) + (H1 < L2) + (H2 < L3) + (H3 < L4) + (H4 < L5) + (H5 < L6) + (H6 < L7) + (H7 < L8) + (H8 < L9) + (H9 < L10) + (H10 < L11) + (H11 < L12) + (H12 < L13) + (H13 < L14) + (H14 < L15) + (H15 < L16) + (H16 < L17) + (H17 < L18) + (H18 < L19) + (H19 < L20) + (H20 < L21) + (H21 < L22) + (H22 < L23) + (H23 < L24) + (H24 < L25) + (H25 < L26) + (H26 < L27) + (H27 < L28) + (H28 < L29) + (H29 < L30) + (H30 < L31) + (H31 < L32) + (H32 < L33) + (H33 < L34) + (H34 < L35) + (H35 < L36) + (H36 < L37) + (H37 < L38) + (H38 < L39) + (H39 < L40) + (H40 < L41) + (H41 < L42) + (H42 < L43) + (H43 < L44) + (H44 < L45) + (H45 < L46) + (H46 < L47) + (H47 < L48) + (H48 < L49) + (H49 < L50) + (H50 < L51) + (H51 < L52) + (H52 < L53) + (H53 < L54) + (H54 < L55) + (H55 < L56) + (H56 < L57) + (H57 < L58) + (H58 < L59) + (H59 < L60) + (H60 < L61) + (H61 < L62) + (H62 < L63) + (H63 < L64) + (H64 < L65) + (H65 < L66) + (H66 < L67) + (H67 < L68) + (H68 < L69) + (H69 < L70) + (H70 < L71) + (H71 < L72) + (H72 < L73) + (H73 < L74) + (H74 < L75) + (H75 < L76) + (H76 < L77) + (H77 < L78) + (H78 < L79) + (H79 < L80) + (H80 < L81) + (H81 < L82) + (H82 < L83) + (H83 < L84) + (H84 < L85) + (H85 < L86) + (H86 < L87) + (H87 < L88) + (H88 < L89) + (H89 < L90) + (H90 < L91) + (H91 < L92) + (H92 < L93) + (H93 < L94) + (H94 < L95) + (H95 < L96) + (H96 < L97) + (H97 < L98) + (H98 < L99) + (H99 < L100) + .00001)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/23/2005
Posts: 7
|
mbbcat & Bruce,
I note your valuable contributions with interest. Thank you for that. I was trying to develop a scan that would identify likely candidates that would gap up the next day or at a minimum overlap todays close to the upside. A very experienced trader/instructor on the web, buys (one of his scan candidates) just before the close, and sells the next day for a profit (not day trading). I was trying to develop such a scan. I think he used to select a high beta condition, high average volume, high average day range, and optionable stock. All the best!
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Bruce,
Because of the statement:
QUOTE (mbbcat) i.e. I note that some issues gap almost every morning with a frequency of m around 2 gaps down to 3 gaps up (from observation rather than stats). Now I would like to identify and quantify the likely outcomes from a statistical point of view.
it appears to me that mbbcat is referring to up openings and down openings rather than gaps on a daily chart.
In addition, those divide by zero's are going to cause problems.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
bustermu,
Thank you for the feedback. The replace function is a wonderful thing:
The following formula would count the number of Gap Ups during the last 100-Trading Days (using Open versus previous High):
ABS((O > H1) + (O1 > H2) + (O2 > H3) + (O3 > H4) + (O4 > H5) + (O5 > H6) + (O6 > H7) + (O7 > H8) + (O8 > H9) + (O9 > H10) + (O10 > H11) + (O11 > H12) + (O12 > H13) + (O13 > H14) + (O14 > H15) + (O15 > H16) + (O16 > H17) + (O17 > H18) + (O18 > H19) + (O19 > H20) + (O20 > H21) + (O21 > H22) + (O22 > H23) + (O23 > H24) + (O24 > H25) + (O25 > H26) + (O26 > H27) + (O27 > H28) + (O28 > H29) + (O29 > H30) + (O30 > H31) + (O31 > H32) + (O32 > H33) + (O33 > H34) + (O34 > H35) + (O35 > H36) + (O36 > H37) + (O37 > H38) + (O38 > H39) + (O39 > H40) + (O40 > H41) + (O41 > H42) + (O42 > H43) + (O43 > H44) + (O44 > H45) + (O45 > H46) + (O46 > H47) + (O47 > H48) + (O48 > H49) + (O49 > H50) + (O50 > H51) + (O51 > H52) + (O52 > H53) + (O53 > H54) + (O54 > H55) + (O55 > H56) + (O56 > H57) + (O57 > H58) + (O58 > H59) + (O59 > H60) + (O60 > H61) + (O61 > H62) + (O62 > H63) + (O63 > H64) + (O64 > H65) + (O65 > H66) + (O66 > H67) + (O67 > H68) + (O68 > H69) + (O69 > H70) + (O70 > H71) + (O71 > H72) + (O72 > H73) + (O73 > H74) + (O74 > H75) + (O75 > H76) + (O76 > H77) + (O77 > H78) + (O78 > H79) + (O79 > H80) + (O80 > H81) + (O81 > H82) + (O82 > H83) + (O83 > H84) + (O84 > H85) + (O85 > H86) + (O86 > H87) + (O87 > H88) + (O88 > H89) + (O89 > H90) + (O90 > H91) + (O91 > H92) + (O92 > H93) + (O93 > H94) + (O94 > H95) + (O95 > H96) + (O96 > H97) + (O97 > H98) + (O98 > H99) + (O99 > H100))
This formula would count the number of Gap Downs (using Open versus previous Low):
ABS((O < L1) + (O1 < L2) + (O2 < L3) + (O3 < L4) + (O4 < L5) + (O5 < L6) + (O6 < L7) + (O7 < L8) + (O8 < L9) + (O9 < L10) + (O10 < L11) + (O11 < L12) + (O12 < L13) + (O13 < L14) + (O14 < L15) + (O15 < L16) + (O16 < L17) + (O17 < L18) + (O18 < L19) + (O19 < L20) + (O20 < L21) + (O21 < L22) + (O22 < L23) + (O23 < L24) + (O24 < L25) + (O25 < L26) + (O26 < L27) + (O27 < L28) + (O28 < L29) + (O29 < L30) + (O30 < L31) + (O31 < L32) + (O32 < L33) + (O33 < L34) + (O34 < L35) + (O35 < L36) + (O36 < L37) + (O37 < L38) + (O38 < L39) + (O39 < L40) + (O40 < L41) + (O41 < L42) + (O42 < L43) + (O43 < L44) + (O44 < L45) + (O45 < L46) + (O46 < L47) + (O47 < L48) + (O48 < L49) + (O49 < L50) + (O50 < L51) + (O51 < L52) + (O52 < L53) + (O53 < L54) + (O54 < L55) + (O55 < L56) + (O56 < L57) + (O57 < L58) + (O58 < L59) + (O59 < L60) + (O60 < L61) + (O61 < L62) + (O62 < L63) + (O63 < L64) + (O64 < L65) + (O65 < L66) + (O66 < L67) + (O67 < L68) + (O68 < L69) + (O69 < L70) + (O70 < L71) + (O71 < L72) + (O72 < L73) + (O73 < L74) + (O74 < L75) + (O75 < L76) + (O76 < L77) + (O77 < L78) + (O78 < L79) + (O79 < L80) + (O80 < L81) + (O81 < L82) + (O82 < L83) + (O83 < L84) + (O84 < L85) + (O85 < L86) + (O86 < L87) + (O87 < L88) + (O88 < L89) + (O89 < L90) + (O90 < L91) + (O91 < L92) + (O92 < L93) + (O93 < L94) + (O94 < L95) + (O95 < L96) + (O96 < L97) + (O97 < L98) + (O98 < L99) + (O99 < L100))
This would be 100 * the ratio of Gap Ups to Gap Downs (using Open versus previous High or Low):
100 * ABS((O > H1) + (O1 > H2) + (O2 > H3) + (O3 > H4) + (O4 > H5) + (O5 > H6) + (O6 > H7) + (O7 > H8) + (O8 > H9) + (O9 > H10) + (O10 > H11) + (O11 > H12) + (O12 > H13) + (O13 > H14) + (O14 > H15) + (O15 > H16) + (O16 > H17) + (O17 > H18) + (O18 > H19) + (O19 > H20) + (O20 > H21) + (O21 > H22) + (O22 > H23) + (O23 > H24) + (O24 > H25) + (O25 > H26) + (O26 > H27) + (O27 > H28) + (O28 > H29) + (O29 > H30) + (O30 > H31) + (O31 > H32) + (O32 > H33) + (O33 > H34) + (O34 > H35) + (O35 > H36) + (O36 > H37) + (O37 > H38) + (O38 > H39) + (O39 > H40) + (O40 > H41) + (O41 > H42) + (O42 > H43) + (O43 > H44) + (O44 > H45) + (O45 > H46) + (O46 > H47) + (O47 > H48) + (O48 > H49) + (O49 > H50) + (O50 > H51) + (O51 > H52) + (O52 > H53) + (O53 > H54) + (O54 > H55) + (O55 > H56) + (O56 > H57) + (O57 > H58) + (O58 > H59) + (O59 > H60) + (O60 > H61) + (O61 > H62) + (O62 > H63) + (O63 > H64) + (O64 > H65) + (O65 > H66) + (O66 > H67) + (O67 > H68) + (O68 > H69) + (O69 > H70) + (O70 > H71) + (O71 > H72) + (O72 > H73) + (O73 > H74) + (O74 > H75) + (O75 > H76) + (O76 > H77) + (O77 > H78) + (O78 > H79) + (O79 > H80) + (O80 > H81) + (O81 > H82) + (O82 > H83) + (O83 > H84) + (O84 > H85) + (O85 > H86) + (O86 > H87) + (O87 > H88) + (O88 > H89) + (O89 > H90) + (O90 > H91) + (O91 > H92) + (O92 > H93) + (O93 > H94) + (O94 > H95) + (O95 > H96) + (O96 > H97) + (O97 > H98) + (O98 > H99) + (O99 > H100)) / ABS((O < L1) + (O1 < L2) + (O2 < L3) + (O3 < L4) + (O4 < L5) + (O5 < L6) + (O6 < L7) + (O7 < L8) + (O8 < L9) + (O9 < L10) + (O10 < L11) + (O11 < L12) + (O12 < L13) + (O13 < L14) + (O14 < L15) + (O15 < L16) + (O16 < L17) + (O17 < L18) + (O18 < L19) + (O19 < L20) + (O20 < L21) + (O21 < L22) + (O22 < L23) + (O23 < L24) + (O24 < L25) + (O25 < L26) + (O26 < L27) + (O27 < L28) + (O28 < L29) + (O29 < L30) + (O30 < L31) + (O31 < L32) + (O32 < L33) + (O33 < L34) + (O34 < L35) + (O35 < L36) + (O36 < L37) + (O37 < L38) + (O38 < L39) + (O39 < L40) + (O40 < L41) + (O41 < L42) + (O42 < L43) + (O43 < L44) + (O44 < L45) + (O45 < L46) + (O46 < L47) + (O47 < L48) + (O48 < L49) + (O49 < L50) + (O50 < L51) + (O51 < L52) + (O52 < L53) + (O53 < L54) + (O54 < L55) + (O55 < L56) + (O56 < L57) + (O57 < L58) + (O58 < L59) + (O59 < L60) + (O60 < L61) + (O61 < L62) + (O62 < L63) + (O63 < L64) + (O64 < L65) + (O65 < L66) + (O66 < L67) + (O67 < L68) + (O68 < L69) + (O69 < L70) + (O70 < L71) + (O71 < L72) + (O72 < L73) + (O73 < L74) + (O74 < L75) + (O75 < L76) + (O76 < L77) + (O77 < L78) + (O78 < L79) + (O79 < L80) + (O80 < L81) + (O81 < L82) + (O82 < L83) + (O83 < L84) + (O84 < L85) + (O85 < L86) + (O86 < L87) + (O87 < L88) + (O88 < L89) + (O89 < L90) + (O90 < L91) + (O91 < L92) + (O92 < L93) + (O93 < L94) + (O94 < L95) + (O95 < L96) + (O96 < L97) + (O97 < L98) + (O98 < L99) + (O99 < L100) + .00001)
The following formula would count the number of Gap Ups during the last 100-Trading Days (using Open versus previous Close):
ABS((O > C1) + (O1 > C2) + (O2 > C3) + (O3 > C4) + (O4 > C5) + (O5 > C6) + (O6 > C7) + (O7 > C8) + (O8 > C9) + (O9 > C10) + (O10 > C11) + (O11 > C12) + (O12 > C13) + (O13 > C14) + (O14 > C15) + (O15 > C16) + (O16 > C17) + (O17 > C18) + (O18 > C19) + (O19 > C20) + (O20 > C21) + (O21 > C22) + (O22 > C23) + (O23 > C24) + (O24 > C25) + (O25 > C26) + (O26 > C27) + (O27 > C28) + (O28 > C29) + (O29 > C30) + (O30 > C31) + (O31 > C32) + (O32 > C33) + (O33 > C34) + (O34 > C35) + (O35 > C36) + (O36 > C37) + (O37 > C38) + (O38 > C39) + (O39 > C40) + (O40 > C41) + (O41 > C42) + (O42 > C43) + (O43 > C44) + (O44 > C45) + (O45 > C46) + (O46 > C47) + (O47 > C48) + (O48 > C49) + (O49 > C50) + (O50 > C51) + (O51 > C52) + (O52 > C53) + (O53 > C54) + (O54 > C55) + (O55 > C56) + (O56 > C57) + (O57 > C58) + (O58 > C59) + (O59 > C60) + (O60 > C61) + (O61 > C62) + (O62 > C63) + (O63 > C64) + (O64 > C65) + (O65 > C66) + (O66 > C67) + (O67 > C68) + (O68 > C69) + (O69 > C70) + (O70 > C71) + (O71 > C72) + (O72 > C73) + (O73 > C74) + (O74 > C75) + (O75 > C76) + (O76 > C77) + (O77 > C78) + (O78 > C79) + (O79 > C80) + (O80 > C81) + (O81 > C82) + (O82 > C83) + (O83 > C84) + (O84 > C85) + (O85 > C86) + (O86 > C87) + (O87 > C88) + (O88 > C89) + (O89 > C90) + (O90 > C91) + (O91 > C92) + (O92 > C93) + (O93 > C94) + (O94 > C95) + (O95 > C96) + (O96 > C97) + (O97 > C98) + (O98 > C99) + (O99 > C100))
This formula would count the number of Gap Downs (using Open versus previous Close):
ABS((O < C1) + (O1 < C2) + (O2 < C3) + (O3 < C4) + (O4 < C5) + (O5 < C6) + (O6 < C7) + (O7 < C8) + (O8 < C9) + (O9 < C10) + (O10 < C11) + (O11 < C12) + (O12 < C13) + (O13 < C14) + (O14 < C15) + (O15 < C16) + (O16 < C17) + (O17 < C18) + (O18 < C19) + (O19 < C20) + (O20 < C21) + (O21 < C22) + (O22 < C23) + (O23 < C24) + (O24 < C25) + (O25 < C26) + (O26 < C27) + (O27 < C28) + (O28 < C29) + (O29 < C30) + (O30 < C31) + (O31 < C32) + (O32 < C33) + (O33 < C34) + (O34 < C35) + (O35 < C36) + (O36 < C37) + (O37 < C38) + (O38 < C39) + (O39 < C40) + (O40 < C41) + (O41 < C42) + (O42 < C43) + (O43 < C44) + (O44 < C45) + (O45 < C46) + (O46 < C47) + (O47 < C48) + (O48 < C49) + (O49 < C50) + (O50 < C51) + (O51 < C52) + (O52 < C53) + (O53 < C54) + (O54 < C55) + (O55 < C56) + (O56 < C57) + (O57 < C58) + (O58 < C59) + (O59 < C60) + (O60 < C61) + (O61 < C62) + (O62 < C63) + (O63 < C64) + (O64 < C65) + (O65 < C66) + (O66 < C67) + (O67 < C68) + (O68 < C69) + (O69 < C70) + (O70 < C71) + (O71 < C72) + (O72 < C73) + (O73 < C74) + (O74 < C75) + (O75 < C76) + (O76 < C77) + (O77 < C78) + (O78 < C79) + (O79 < C80) + (O80 < C81) + (O81 < C82) + (O82 < C83) + (O83 < C84) + (O84 < C85) + (O85 < C86) + (O86 < C87) + (O87 < C88) + (O88 < C89) + (O89 < C90) + (O90 < C91) + (O91 < C92) + (O92 < C93) + (O93 < C94) + (O94 < C95) + (O95 < C96) + (O96 < C97) + (O97 < C98) + (O98 < C99) + (O99 < C100))
This would be 100 * the ratio of Gap Ups to Gap Downs (using Open versus previous Close):
100 * ABS((O > C1) + (O1 > C2) + (O2 > C3) + (O3 > C4) + (O4 > C5) + (O5 > C6) + (O6 > C7) + (O7 > C8) + (O8 > C9) + (O9 > C10) + (O10 > C11) + (O11 > C12) + (O12 > C13) + (O13 > C14) + (O14 > C15) + (O15 > C16) + (O16 > C17) + (O17 > C18) + (O18 > C19) + (O19 > C20) + (O20 > C21) + (O21 > C22) + (O22 > C23) + (O23 > C24) + (O24 > C25) + (O25 > C26) + (O26 > C27) + (O27 > C28) + (O28 > C29) + (O29 > C30) + (O30 > C31) + (O31 > C32) + (O32 > C33) + (O33 > C34) + (O34 > C35) + (O35 > C36) + (O36 > C37) + (O37 > C38) + (O38 > C39) + (O39 > C40) + (O40 > C41) + (O41 > C42) + (O42 > C43) + (O43 > C44) + (O44 > C45) + (O45 > C46) + (O46 > C47) + (O47 > C48) + (O48 > C49) + (O49 > C50) + (O50 > C51) + (O51 > C52) + (O52 > C53) + (O53 > C54) + (O54 > C55) + (O55 > C56) + (O56 > C57) + (O57 > C58) + (O58 > C59) + (O59 > C60) + (O60 > C61) + (O61 > C62) + (O62 > C63) + (O63 > C64) + (O64 > C65) + (O65 > C66) + (O66 > C67) + (O67 > C68) + (O68 > C69) + (O69 > C70) + (O70 > C71) + (O71 > C72) + (O72 > C73) + (O73 > C74) + (O74 > C75) + (O75 > C76) + (O76 > C77) + (O77 > C78) + (O78 > C79) + (O79 > C80) + (O80 > C81) + (O81 > C82) + (O82 > C83) + (O83 > C84) + (O84 > C85) + (O85 > C86) + (O86 > C87) + (O87 > C88) + (O88 > C89) + (O89 > C90) + (O90 > C91) + (O91 > C92) + (O92 > C93) + (O93 > C94) + (O94 > C95) + (O95 > C96) + (O96 > C97) + (O97 > C98) + (O98 > C99) + (O99 > C100)) / ABS((O < C1) + (O1 < C2) + (O2 < C3) + (O3 < C4) + (O4 < C5) + (O5 < C6) + (O6 < C7) + (O7 < C8) + (O8 < C9) + (O9 < C10) + (O10 < C11) + (O11 < C12) + (O12 < C13) + (O13 < C14) + (O14 < C15) + (O15 < C16) + (O16 < C17) + (O17 < C18) + (O18 < C19) + (O19 < C20) + (O20 < C21) + (O21 < C22) + (O22 < C23) + (O23 < C24) + (O24 < C25) + (O25 < C26) + (O26 < C27) + (O27 < C28) + (O28 < C29) + (O29 < C30) + (O30 < C31) + (O31 < C32) + (O32 < C33) + (O33 < C34) + (O34 < C35) + (O35 < C36) + (O36 < C37) + (O37 < C38) + (O38 < C39) + (O39 < C40) + (O40 < C41) + (O41 < C42) + (O42 < C43) + (O43 < C44) + (O44 < C45) + (O45 < C46) + (O46 < C47) + (O47 < C48) + (O48 < C49) + (O49 < C50) + (O50 < C51) + (O51 < C52) + (O52 < C53) + (O53 < C54) + (O54 < C55) + (O55 < C56) + (O56 < C57) + (O57 < C58) + (O58 < C59) + (O59 < C60) + (O60 < C61) + (O61 < C62) + (O62 < C63) + (O63 < C64) + (O64 < C65) + (O65 < C66) + (O66 < C67) + (O67 < C68) + (O68 < C69) + (O69 < C70) + (O70 < C71) + (O71 < C72) + (O72 < C73) + (O73 < C74) + (O74 < C75) + (O75 < C76) + (O76 < C77) + (O77 < C78) + (O78 < C79) + (O79 < C80) + (O80 < C81) + (O81 < C82) + (O82 < C83) + (O83 < C84) + (O84 < C85) + (O85 < C86) + (O86 < C87) + (O87 < C88) + (O88 < C89) + (O89 < C90) + (O90 < C91) + (O91 < C92) + (O92 < C93) + (O93 < C94) + (O94 < C95) + (O95 < C96) + (O96 < C97) + (O97 < C98) + (O98 < C99) + (O99 < C100) + .00001)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Platinum Customer
Joined: 11/21/2005
Posts: 45
|
Many Thanks for that,
Indeed I am looking to find issues that trade within a range but habitually open with a gap - strategy would be to buy at close & sell at open - OR if the data could be finessed even more find what times of day they habitually make their HOD /LOD & aim for that. ( not sure if the TC platform will accept programming for its intraday data ?? ))
Risk control would be partially in the form of a time stop - ie one can not expect to get this right every day & hard stops would probably get murdered, but if the issue is ranging there is a fair amount of probability that where it does not go today it may go in the next few days - additionally a few strategically placed options spreads would perhaps help
Alternatively - If data could be found for the times of day that the issues volatility peaked & troughed maybe that would be an alternative play, not yet found a source for that tho ?? any ideas welcome ;)
now the next
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (mbbcat) ...OR if the data could be finessed even more find what times of day they habitually make their HOD /LOD & aim for that. ( not sure if the TC platform will accept programming for its intraday data ?? )) ... Alternatively - If data could be found for the times of day that the issues volatility peaked & troughed maybe that would be an alternative play, not yet found a source for that tho ?? any ideas welcome ;)
This will not be done using Personal Criteria Formulas. PCFs work exclusively with daily data.
I can't comment much on the rest of your post. The trainers cannot give settings, interpretation or investment advice.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Platinum Customer
Joined: 11/21/2005
Posts: 45
|
>> Personal Criteria Formulas. PCFs work exclusively with daily data.
So is there another way to access the realtime / intraday data ? visual basic for instance or does the sdk only access the daily data also ?
>> The trainers cannot give settings, interpretation or investment advice.
Of course, none expected, Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
mbbcat,
The Real Time data is only accessible from within TeleChart. This is true even when using the TeleChart Developers Kit (TCDK). You could export the data at fixed intervals and use a third party program such as Excel to analyze the data.
The only real possibility using just TeleChart would be to use Custom Indicators and Custom Percent True Indicators with Real Time Indicator Sorting. That said, the formulas would need to be carefully written and/or their calculation carefully timed to obtain the desired results. This is further complicated by the 200 item limit on Real Time Indicator Sorting. I doubt the process would be practical for isolating times where spikes are most likely.
You may wish to review the following:
Exporting data to text format - comma, space or tab delimited
Real time indicator sorting (available at the Platinum level)
Plotting Custom Indicators with Examples
Visually Backtesting Specific Symbols
opening range indicator
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Platinum Customer
Joined: 11/21/2005
Posts: 45
|
Thanks,
>>The Real Time data is only accessible from within TeleChart. This is true even when using the TeleChart Developers Kit (TCDK).
What about historical intra-day data?
>>You could export the data at fixed intervals and use a third party program such as Excel to analyze the data.
Could not interrupt the trading day to do this as an update & export takes serious time, but if there was a means of getting say 5, 10 & 15 min data out after hours, then that may be an option
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
mbbcat,
Anything that is true of TeleChart's Real Time Data is also true of its Intra-Day Data as the Intra-Day Data is only available as part of the Real Time Data Stream. If you cannot take the time to export the data during the day, I cannot think of a way to do this currently using TeleChart.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/21/2005
Posts: 566
|
Bruce, are there any plans in the work to export data to excel in a pre-formatted excel template? My understanding is that one can export telechart data to excel now but it wont be formatted, such that if you already had an excel sheet designed in a specific manner you would not be able to designate specific cells in which you wanted the telechart data to be pasted.
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
jcfla7,
Worden Brothers does not normally discuss or comment on future features, services or products until they are actually released or officially announced.
It is possible to create a spreadsheet that references other sheets or workspaces. It is also possible to replace the contents of the referenced sheet with data exported from TeleChart and imported using the Excel's Wizard on a daily basis. Explaining how to do this in detail would be a spreadsheet tutorial and is not something the trainers can or will do.
If you have programming experience, another option might be to create something using the TeleChart Developers Kit (TCDK).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/21/2005
Posts: 566
|
of fair enough, are there any other resources you can point me to to learn as much as I can about telechart's ability to export to excel? Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
jcfla7,
You would need to use Export to Text and then use Excel's Import Wizard to bring them into Excel. You are limited to the Available Data Fields in Export to Text when using this method. You may wish to review the following:
Exporting data to text format - comma, space or tab delimited
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |