Author Topic: Formula Editor Examples  (Read 15043 times)

braddoubleu

  • Administrator
  • Sr. Member
  • *****
  • Posts: 453
  • Karma: +8/-1
    • Trade-Ideas
Formula Editor Examples
« 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.

« Last Edit: March 28, 2012, 09:43:29 pm by TradeIdeas_DA »

Barrie Einarson

  • Administrator
  • Hero Member
  • *****
  • Posts: 610
  • Karma: +20/-1
Re: Formula Editor Examples
« Reply #1 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.

braddoubleu

  • Administrator
  • Sr. Member
  • *****
  • Posts: 453
  • Karma: +8/-1
    • Trade-Ideas
Re: Formula Editor Examples
« Reply #2 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.

Barrie Einarson

  • Administrator
  • Hero Member
  • *****
  • Posts: 610
  • Karma: +20/-1
Re: Formula Editor Examples
« Reply #3 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.

youngamerican68

  • Jr. Member
  • **
  • Posts: 65
  • Karma: +0/-0
Re: Formula Editor Examples
« Reply #4 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

braddoubleu

  • Administrator
  • Sr. Member
  • *****
  • Posts: 453
  • Karma: +8/-1
    • Trade-Ideas
Re: Formula Editor Examples
« Reply #5 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.

TradeIdeas_DA

  • Administrator
  • Hero Member
  • *****
  • Posts: 729
  • Karma: +9/-2
    • Trade Ideas LLC
Re: Formula Editor Examples
« Reply #6 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

Follow me on Twitter: http://twitter.com/TradeIdeas

TradeIdeas_DA

  • Administrator
  • Hero Member
  • *****
  • Posts: 729
  • Karma: +9/-2
    • Trade Ideas LLC
Re: Formula Editor Examples
« Reply #7 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
Follow me on Twitter: http://twitter.com/TradeIdeas

Belks

  • Newbie
  • *
  • Posts: 2
  • Karma: +1/-0
Re: Formula Editor Examples
« Reply #8 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!

braddoubleu

  • Administrator
  • Sr. Member
  • *****
  • Posts: 453
  • Karma: +8/-1
    • Trade-Ideas
Re: Formula Editor Examples
« Reply #9 on: October 14, 2015, 09:59:47 am »
No, you can only get the relative volume value for today.

Bonpara

  • Newbie
  • *
  • Posts: 17
  • Karma: +0/-0
Re: Formula Editor Examples
« Reply #10 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