logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Ztrader  
#1 Posted : Friday, July 12, 2013 9:50:31 AM(UTC)
Ztrader

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/12/2013(UTC)
Posts: 9

Hi, I want to scan stocks for a specific criterion. I need the formula for this. let me explain it to you on a chart.
31 may-5 july highest C price<5 july-today highest C price BUT 31 may-5 july highest value>5 july-today highest value
additionally is it possible to scan for more than one date range like the date range I gave you ? Thanks
henry1224  
#2 Posted : Friday, July 12, 2013 1:57:20 PM(UTC)
henry1224

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT

Was thanked: 2 time(s) in 2 post(s)
even after your explaination, I'm still confused!

You need to use the valuewhen function in any case!
Ztrader  
#3 Posted : Tuesday, July 16, 2013 3:04:46 AM(UTC)
Ztrader

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/12/2013(UTC)
Posts: 9

Let's say our timeline is February 15th - May 31th. There are two points we need to consider: the highest closing price the highest price between that range (not closing price)
For example: YCRW (YRC Worldwide nc.-NASDAQ)stock made the highest closed price at 23.05 in that timeline. But the highest price is 25. The way I take while analysing a stock is: If any of those prices has been breached above then it will go on higher.Let's take YRCW for an example. Since May 31th, it closed higher than 23.05 for the first time in June 18th (closed at 23.25). BUT since May 31th to that date, the price was never higher than 25. Because it went higher than 23.05, it means the price will pass the 25 point, too. That's my green light. And in June 20th it goes above that point (25) and the highest point is 25.50. Now I want to scan the stocks by these two criteria. When I scan the stocks, I want it to be able to list the stocks that closed higher than the highest closing price or the stocks that the highest point in that time range (February 15th - May 31th) was breached above. Only one of these factors should be materialized.
Users browsing this topic
Guest (Hidden)
Similar Topics
Please help me write this formula (Formula Assistance)
by alsaad_1122 6/27/2021 5:28:13 PM(UTC)
Please help me convert this equation from Amy Brooker format to Metastock (Formula Assistance)
by alsaad_1122 6/27/2021 5:16:25 PM(UTC)
Please help me make a profit line (Formula Assistance)
by Crossover521 12/8/2020 9:45:33 AM(UTC)
Please help me to deploy Demark Indicator on Metastock (Advanced Coding Techniques)
by nopadol 11/8/2014 7:27:05 AM(UTC)
Please Help me ! for ATR trailing stop in indicator builder convert for expert advisor or system tester (Formula Assistance)
by petouchbaby 3/13/2013 2:28:34 AM(UTC)
help! please help me write a Three day explorer formula (MetaStock)
by Alpha 9/10/2011 5:25:09 AM(UTC)
please help me about metastock & windows 7 (MetaStock)
by Ahmad 3/23/2011 11:55:30 AM(UTC)
please help me (Formula Assistance)
by verna 3/10/2011 7:08:50 PM(UTC)
Please help me find a way to fix this code ;) (Basic Coding Techniques)
by Arash 7/7/2009 2:18:52 AM(UTC)
Please help me with formulas... (Formula Assistance)
by Futuromaniak 4/9/2008 2:59:27 AM(UTC)
Please help me for selling at highest price (with figure..) (Formula Assistance)
by dmd4689 10/3/2007 5:46:29 AM(UTC)
please help me! (Data Related Questions)
by alex256 1/17/2007 3:46:19 PM(UTC)
Can you please help me reading this chart (MetaStock)
by note_al 6/23/2005 3:20:10 PM(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.