Author Topic: Gained more than 10% over the last 2 days  (Read 3086 times)

jcrb2007

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Gained more than 10% over the last 2 days
« on: December 11, 2015, 10:04:45 am »
I'm using the following code but it's not working [U2DP]. I copied that from the Change in 5 Days template.

Is it possible to create a custom formula to look for Change in 2 Days?

I'm looking to create a custom scan that looks for stocks that have gained more than 10% over the last 2 days.

Thx



Barrie Einarson

  • Administrator
  • Hero Member
  • *****
  • Posts: 610
  • Karma: +20/-1
Re: Gained more than 10% over the last 2 days
« Reply #1 on: December 11, 2015, 05:18:54 pm »
Hi .. I believe this Custom Filter gives you what you are looking for:

((most_recent_close/close_p)-1)*100

Most Recent Close is today's close

Close_p is the close 2 days ago.

Using numbers, let's say the close today was $12 and 2 days ago it was $10.

So (12/10) = 1.20 and then subtracting 1 from that and multiplying by 100 converts that to 20%.

To create that formula:

http://www.trade-ideas.com/AccountManagement/List.html

Click on Create New and paste the formula in the Source box , give it a name that makes sense because you can search on it - it will start with the letter U and will be added to your list of filters.

You could put 10 in the min box and that should find stocks that are up at least 10% from 2 days ago.

Cheers

Barrie Einarson
info@trade-ideas.com
Trade Ideas Trading Room Moderator
https://tradeideas.omnovia.com/