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

Notification

Icon
Error

Options
Go to last post Go to first unread
WmWaster  
#1 Posted : Wednesday, May 10, 2006 3:44:09 PM(UTC)
WmWaster

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/20/2006(UTC)
Posts: 53

Test data on different time frames Hi. How can I do an exploration test which search for 2-day, 5,-day, weekly & monthly data? Thank you.
henry1224  
#2 Posted : Wednesday, May 10, 2006 4:47:16 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)
Depending on the formula? A basic formula for a daily exploration, run exploration, save results, go back and under edit/options change the periodocity to the time frame you want, run another exploration,save results. Now for the headache! a "daily exploration" C>mov(C,5,S) = Close is greater than 5 bar "Daily data" moving average a "weekly exploration" C>mov(C,5,S) = Close is greater than 5 bar "weekly data" moving average = 25 bar "daily"moving average To get around these type's of problems, you have to create Weekly formulas of the daily formulas Check out Roy's site, Jose's site for time frame indicators or if you have PowerPivot+ add-on you can then use that to create Multi Time frame formulas
WmWaster  
#3 Posted : Wednesday, May 10, 2006 5:25:07 PM(UTC)
WmWaster

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 3/20/2006(UTC)
Posts: 53

henry1224 wrote:
Depending on the formula? A basic formula for a daily exploration, run exploration, save results, go back and under edit/options change the periodocity to the time frame you want, run another exploration,save results.
But it seems there's no option for, like, 2-day or 5-day formulas. How to do?
Quote:
Now for the headache! a "daily exploration" C>mov(C,5,S) = Close is greater than 5 bar "Daily data" moving average a "weekly exploration" C>mov(C,5,S) = Close is greater than 5 bar "weekly data" moving average = 25 bar "daily"moving average To get around these type's of problems, you have to create Weekly formulas of the daily formulas Check out Roy's site, Jose's site for time frame indicators or if you have PowerPivot+ add-on you can then use that to create Multi Time frame formulas
Where are their websites? (I have googled them in vain) I do not have PowerPivot+.
mstt  
#4 Posted : Wednesday, May 10, 2006 7:41:37 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)
WmWaster This link will take you to my web site. MetaStock Tips & Tools This link will take you to Jose's site. MetaStock Tools There are inherent problems with forming EOD data into timeframes other than conventional weeks and months etc. Weeks and months have known start and end points which do not change, but this is not the case with two and five day timeframes. Non-standard timeframes usually bcome rolling frames that keep changing as you add new data. Therefore they are useless for most purposes, and especially so for back-testing of systems. The problem is that while these frames can be "anchored" to either the first or last data bar, the first and last bars themselves change as more data is added. Yes, I did say that the first bar changes. Suppose that you open 1000 bars for each chart but you have 2000 bars of history. Each time a new data bar is added a 1000-bar chart will open with a new starting bar. The same situation applies to explorations that do not use ALL history. Conclusion: there is no reliable anchor or reference point for 2 or 5 day timeframes so any tools based on them should be used with extreme caution. Roy
StorkBite  
#5 Posted : Wednesday, May 10, 2006 7:56:43 PM(UTC)
StorkBite

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995

Was thanked: 14 time(s) in 10 post(s)
Look no further, the addresses are available right here on the forum index: http://forum.equis.com/index.php Jose's Corner www.metastocktools.com Roy's Arena www.metastocktips.com
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.