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

Notification

Icon
Error

Options
Go to last post Go to first unread
bluewhale  
#1 Posted : Friday, November 18, 2011 5:59:28 PM(UTC)
bluewhale

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 5/20/2005(UTC)
Posts: 6

I'm trying to get the reference function to work, am following examples in the the help section, but it simply does not work. Using this formula to determine the close 5 days in the future: Ref(C,+5) I do an exploration on a date months ago, have current data downloaded, yet the column just shows up as "N/A". It works to display a historical date. I'm literally going crazy here trying to sort this out, anyone have suggestions?
mstt  
#2 Posted : Friday, November 18, 2011 7:09:28 PM(UTC)
mstt

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042

Was thanked: 57 time(s) in 54 post(s)
Hi BW

If you plot a forward-referenced value on a chart, Ref(C,+5) for example, then you will notice that the plot stops 5 bars before the righmost data bar. In other words the rightmost bar and the 4 bars preceding it will return N/A for the forward-referenced CLOSE. This is exactly the effect that you are getting with the Explorer. MetaStock cannot plot indicators or whatever beyond the last bar of data, and for every bar that you project into the future MetaStock will generate an N/A result. If the Explorer cannot return a valid value for the last bar explored then it has to return an N/A (just as a chart for the above example returns an N/A for the last bar).

Rather than trying to force Metastock to do what it cannot and will not do, you need to think about what result you require and then make sure that that result is accessable as at the last bar of data. If you can figure that out on a chart (a valid result on the last data bar) then the code should generate the same result when used in the Explorer. Be aware, however, that you might need to tell the explorer to load more data. Using the Minimum Records option will cause problems - don't assume that because your charts show 1000 bars that the Explorer will load the same amount of data. Minimum Records is not your primary problem here but it could be adding in a confusion factor that tends to mask the real problem.

Roy


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.