Rank: Newbie
Groups: Registered, Registered Users, Unverified Users
Joined: 12/22/2013(UTC)
Posts: 8
|
I am using Metastock Professional 10.1 and having the following condition in a column.
CROSS(ValueWhen(1,(Hour()=9 AND Minute()=44),V) , Sum(Ref(ValueWhen(1,(Hour()=9 AND Minute()=44),V),-1),3))
When the exploration is run and Reports are seen, N/A appears in the respective column value. But, on inspecting the values, the column value is shown properly as 0 or 1 based on the security data.
Am I missing something here? Any particular reason for seeing N/A in the Report column?
Regards, sdg
|
|
|
|
|
|
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)
|
what time frame are you working in? What are you trying to find? A Volume breakout?
CROSS(ValueWhen(1,(Hour()=9 AND Minute()=44),V) , Sum(Ref(ValueWhen(1,(Hour()=9 AND Minute()=44),V),-1),3))
What you are looking for never occurs.
The cross function is looking for a cross of 2 values {that part is correct} The valuewhen function returns the volume at 9:44 your error is the Ref( data array,-1) function and the Sum(data array,3) function
You will need to specify 4 different Volume values
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Unverified Users
Joined: 12/22/2013(UTC)
Posts: 8
|
I am working in Hour time frame. I am trying to find out Volume Breakout at first hour of trading for the day by comparing 'First hour volume of the day' with Sum of First hour Volumes of the previous 3 days.
The formula works fine, which is confirmed by inspecting the values of the exploration for a particular security. It clearly mentions 1 or 0 based on Volume breakout. It is just that it displays N/A in the Explorer Report Column.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,960
Thanks: 92 times
Was thanked: 155 time(s) in 150 post(s)
|
Might need to know a bit more on the symbol in question, how much data is loaded into the explorer, assuming you are using 1-min data in the scan, etc.
Typically N/A would appear if the condition never occurred within the data set for a particular security. I believe you will also see it early on in the inspect where there has not yet been enough data to calculate the formula. Symbols displaying an N/A should not display 1's or 0's, unless perhaps you were running the exploration on a specific date instead of most recent date.
You may also want to try deleting the "EXPLORE" folder. This will delete all previous exploration reports. This is typically found in C:\Program Files (x86)\Equis\MetaStock.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Unverified Users
Joined: 12/22/2013(UTC)
Posts: 8
|
I would like to know how to post snapshot image to the reply. I am not getting any option to choose a jpeg image to attach to the reply.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
