Trade-Ideas Support Forum

General Category => Formula Editor => Topic started by: braddoubleu on June 24, 2011, 10:33:18 pm

Title: Formula Editor Examples
Post by: braddoubleu on June 24, 2011, 10:33:18 pm
From the My Account section of our website, click on the bottom link - Custom Formulas http://www.trade-ideas.com/FormulaEditor/List.html.

v_up_1/v_up_5*5
This formula will look to the last 1 minute volume and compare it to the last 1 minute average of the last 5 minutes.  Entering a MIN value of 2 will ensure the last 1 minute volume is twice the average of the last 5 minutes, thus showing increasing volume relative to itself.

seconds_after_open/60/60
This neat little formula will allow you to define a time period in hours where your alert window is active.  Maybe I only want to see stocks pulling back off their highs during the last hour of trading.  Entering a MIN value of 4.5 and a MAX of 5.5 will only show signals during the hour preceding the final trading hour.

abs(open_p-last_price)/(high_p-low_p)*100
This filter when the MAX is set to 0, this filter will only show stocks that exhibited a doji candle the previous day. 

quality
You are already familiar with Quality from the Description column.  Quality refers to the alert specific filters that can be applied to specific alerts (it's the field next to the alert in the Configure Alerts window).  For instance in the new high and new low alerts, it details how many new day high or low it is.  If a stock is making a year high, the value for the quality will be at least 365.  But what if, for example, you only want to see three day highs and not four day highs?  Now with a custom quality field, you can specify 2.99 as the MIN value and 3.01 as the MAX.

(expected_open-t_low)/(t_high-t_low)*100
This formula ensures the open price is within a certain percentage of today's low relative to the current day range (high-low).

(expected_open-t_low)/t_low*100.0
This formula is slightly different.  Instead of looking to a percentage of the day range, it looks to the opening price and ensures the low is within a certain percentage of the price.

if(seconds_after_open<300,[PV],[RV])
This custom volume filter uses an if/then statement where during the first 5 minutes of the trading day, this filter will return the Percent Volume and after will display the Relative Volume.

Remember, you can always add the custom filter as a column to see the value of the data.

Title: Re: Formula Editor Examples
Post by: Barrie Einarson on June 25, 2011, 03:08:45 pm
The second one: seconds_after_open/60/60 - am I right in thinking that if I set the min max to 5.5 and 6.5 and then I set an alert for "New High" - it will only show me new highs relative to 3:00PM?  If so, that opens up many Power Hour Strategies.
Title: Re: Formula Editor Examples
Post by: braddoubleu on June 26, 2011, 03:14:33 am
Not relative to 3:00.  It will only allow values into the window during that time period.
Title: Re: Formula Editor Examples
Post by: Barrie Einarson on June 26, 2011, 03:30:46 am
I see you changed your response - I'll have to think about what that means now lol.
Title: Re: Formula Editor Examples
Post by: youngamerican68 on June 26, 2011, 05:46:23 pm
If I sort by (expected_open-t_low)/t_low*100.0 with largest on top, will this show me the stocks with largest % distance from the open to the low at that time?

Thanks
Title: Re: Formula Editor Examples
Post by: braddoubleu on June 28, 2011, 11:37:48 am
I believe sorting in descending order on this custom filter will give you stocks that have the greatest distance from the open to today's low in percent.
Title: Re: Formula Editor Examples
Post by: TradeIdeas_DA on March 24, 2012, 05:58:56 pm
I'm posting here a fine example of the custom formula editor in action.  Great example using ATR as a %:

http://forums.trade-ideas.com/index.php?topic=741.0

Title: Re: Formula Editor Examples
Post by: TradeIdeas_DA on October 17, 2012, 11:35:28 am
I'm posting another fine example of the custom formula editor in action:  Compare yesterday's close to yesterday's range.
Where yesterday's CLOSE is near to yesterday's LOW or HIGH.

http://forums.trade-ideas.com/index.php?topic=837.msg3118#msg3118
Title: Re: Formula Editor Examples
Post by: Belks on October 14, 2015, 07:46:26 am
Can I get the value of [RV] on yesterday or for the last 3-5 days? Thanks!
Title: Re: Formula Editor Examples
Post by: braddoubleu on October 14, 2015, 09:59:47 am
No, you can only get the relative volume value for today.
Title: Re: Formula Editor Examples
Post by: Bonpara on October 17, 2015, 02:00:11 pm
These are awesome and more powerful then I think we give them creidt for.

For the time value one. is there a custom formula you could write to ask to ingore the lunch time trading only? Just incase you were auto trading a strat like I do it is not optimal to run at lunch but good for the end and start of day.

Thanks