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

Notification

Icon
Error

Options
Go to last post Go to first unread
devrishi81  
#1 Posted : Saturday, July 25, 2009 6:51:15 AM(UTC)
devrishi81

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/25/2009(UTC)
Posts: 3

Can you please guide me with a formula for metastock exploration ...exponential moving average of 5 and 13 days(signal) ....on closing basis.... which gives buy signal if exponential  moving average of 5 days crosses exponential moving average of 13 days ....and sell signal if mov avg of 13 days crosses moving average 5 days on a particular day? buy: MA5:=Mov(C,5,E); MA13:=Mov(C,13,E); Cross(MA5,MA13) sell: MA5:=Mov(C,5,E); MA13:=Mov(C,13,E); Cross(MA13,MA5) My problem is that the exploration report shows buy or sell (signal) after 1 or 2 days after crossing , please guide me .....if i need to do some changes...PLz PLz PLz Help

VOBiX  
#2 Posted : Saturday, July 25, 2009 3:06:32 PM(UTC)
VOBiX

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 12/18/2008(UTC)
Posts: 7

Befrore starting system test check the
New Simulation>Next(Select Systems Screen)>Next(Selct Securities Screen)
Stop in System Testing Options and click More and go to the Trade Execution tab and check the Delay Order Opening part. If you make it 1 it will give the signal after crossing.
devrishi81  
#3 Posted : Saturday, July 25, 2009 3:58:43 PM(UTC)
devrishi81

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/25/2009(UTC)
Posts: 3

thnk u so much for ur quick reply...as i am new with meta stock...i thought if i cud correct the formula frm the explorer as the formula is in explorer..or .. do i have to make the changes frm the system tester ,cud u plz explain me in details...
wabbit  
#4 Posted : Saturday, July 25, 2009 8:34:12 PM(UTC)
wabbit

Rank: Advanced Member

Groups ready for retrieval: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Read the manual.

wabbit [:D]

devrishi81  
#5 Posted : Sunday, July 26, 2009 3:27:23 AM(UTC)
devrishi81

Rank: Newbie

Groups: Registered, Registered Users
Joined: 7/25/2009(UTC)
Posts: 3

thx wabbit...i have gone through the manual and i hv tried every thing i cud & ended with no result....so i am here to get some guidence frm u all experts ......i want the accurate date of buy crossing signal and sell crossing signal wen i filter through exploration. thx dev
wabbit  
#6 Posted : Monday, July 27, 2009 8:44:13 AM(UTC)
wabbit

Rank: Advanced Member

Groups ready for retrieval: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Do you want to run an exploration or a system test?

If you want to run an exploration and have the date of the crossover returned in the exploration results, you'll need to combine the ValueWhen(), Cross() and date functions, e.g.

Code:
dd:=ValueWhen(1,Cross(ma1,ma2),DayOfMonth());



wabbit [:D]

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.