Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Profile: fgaston
About
User Name: fgaston
Groups: Gold User, Member, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Gender:
Statistics
Joined: Thursday, June 19, 2014
Last Visit: Monday, July 9, 2018 12:50:59 PM
Number of Posts: 40
[0.01% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: Display date condition triggered in column?
Posted: Tuesday, July 3, 2018 2:07:20 PM

Bruce:

I often miss buy & sell signals that I have setup in columns. Can I display the date the condition triggered, OR would the better way to approach it be to alter the condition formula to ask if the condition was met within the last couple of trading days, or to just rely on alerts?  Thanks, Fred

Topic: DI Spread Formula
Posted: Monday, January 22, 2018 3:53:42 PM

Thank you Bruce.  Can you tell me the formula to show VolZoneOsc 14 is in a positive uptrend?

Topic: DI Spread Formula
Posted: Saturday, January 20, 2018 12:55:28 PM

To add to my post above, my aim to to look for breakout using DI, so I would want the spread to occur after a positive XO.  Would introducing ADX into formual be valuable to indicate the strength of the trend?

Topic: DI Spread Formula
Posted: Saturday, January 20, 2018 12:33:17 PM

Hi-I am looking for help with a formula using Directional Movement where the green line is above the red line and the spread between them is greater than 3 and VolZoneOsc 14 value is above 0.

Thanks, Fred

Topic: Price Change vs. Price Growth
Posted: Monday, January 8, 2018 5:02:09 PM

Hi:

What is the difference please between Price Change and Price Growth?

Also, what are the formulas please for Price Change-1 Yr and Avg Price Change-3 Yr

Thanks, Fred

 

Topic: Weighted Alpha
Posted: Friday, February 24, 2017 8:30:24 AM

Hi:

I ran into a term/measurement I hadn't seen before called positive weighted alpha (that Zacks uses), and read the definition is: The exact formula for weighted alpha can be modified based on the preferences or objectives of the individual analyst. One version of weighted alpha might apply a weight of 1.5 to all activity within the past three months and a factor of 0.5 to all activity between nine and 12 months ago. Others may apply a gradually declining weight to all price movements as they stretch further back in time.

I don't see anything in the forums on in v17.  Is this anything you could help me take a crack at it, or are there equivalent formulas that are predictive at continued gains-momentum?
 
Thanks, Fred
 
Topic: Convert a Buy Signal to a Sell Signal
Posted: Wednesday, November 30, 2016 12:45:50 PM

Hi:
This produces a signal when the price goes below the bottom Bollinger Band and then is followed by the next green candle.  I've used it successfully as a buy signal & need help making it now do the opposite (price goes above top Bollinger Band followed by next red candle).  Thanks, Fred

C > O AND ((L1 <= AVGC20.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND L2 > AVGC20.2 - 2 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)) OR (C1 <= O1 AND L2 <= AVGC20.2 - 2 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20) AND L3 > AVGC20.3 - 2 * SQR(ABS(C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 - 20 * AVGC20.3 ^ 2) / 20)) OR (C1 <= O1 AND C2 <= O2 AND L3 <= AVGC20.3 - 2 * SQR(ABS(C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 - 20 * AVGC20.3 ^ 2) / 20) AND L4 > AVGC20.4 - 2 * SQR(ABS(C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 - 20 * AVGC20.4 ^ 2) / 20)))

Topic: Formula for price drop
Posted: Thursday, October 6, 2016 4:27:56 PM

Bruce:

I took out CMF just to simplify & it&#39;s working well with the C <= .93 *C10 so I think it must be in the CMF formula...still need to work that in.

Topic: Formula for price drop
Posted: Thursday, October 6, 2016 4:23:03 PM

Getting inaccurate results in plot as soon as I add the C <= .93 *C10 (I&#39;m plotting vs. using EasyScan)

Also don&#39;t know how to program And clarifying CMF, want it be either be under 50 or have been under 50 within the last 3-4 closes.

Topic: Formula for price drop
Posted: Thursday, October 6, 2016 4:19:53 PM

And clarifying CMF, want it be either be under 50 or have been under 50 within the last 3-4 closes.  Thx