Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Metastock 6.0 for Window -- Ignore unavailable to you. Want to Upgrade?

To: Sean W. Smith who wrote (1562)	2/5/1998 11:54:00 PM
From: Theodore Johnson	Read Replies (1) \| Respond to of 4056

Hi all, Im glad I read about the Q+ only updating 255 stocks at a time. In an attempt to establish a 5 year database from the metastock files I ve been going crazy!!! The As alone have 900 stocks. I can see where running scans and then transferring to metastock is useful but what a pain to have to delete every day. Why cant you establish a file for the scans and also put those files into the automatically update file for Q+. Then each day the scanned files would be updated. Still learning. I hear when Q+ 2.0 comes out it will have 6 years of data. Hopefully we will be able to transfer more than 255 files at a time.

To: Sean W. Smith who wrote (1562)	2/6/1998 11:41:00 AM
From: John Sacz	Read Replies (1) \| Respond to of 4056

Sean; Thanks for your suggestions. I also could see no way to use the canned, stdev(data array,prds), function. I achieved what I needed with the following formula. This gives me the standard deviation of 5 different MA's at the same point in time. 1stprd:=Input("Enter 1st prd",3,15,5); 2ndprd:=Input("Enter 2nd prd",6,30,13); 3rdprd:=Input("Enter 3rd prd",13,60,22); 4thprd:=Input("Enter 4th prd",22,120,50); 5thprd:=Input("Enter 5th prd",50,240,100); MAavg:=((Mov(C,1stprd,E)+Mov(C,2ndprd,E)+Mov(C,3rdprd,E) +Mov(C,4thprd,E)+Mov(C,5thprd,E))/5); Sqrt((Power(Mov(C,1stprd,E)-MAavg,2)+Power(Mov(C,2ndprd,E)-MAavg,2) +Power(Mov(C,3rdprd,E)-MAavg,2)+Power(Mov(C,4thprd,E)-MAavg,2) +Power(Mov(C,5thprd,E)-MAavg,2))/5) Thanks again, John (Red print not significant. Don't know how to remove.)

To: Sean W. Smith who wrote (1562)	2/7/1998 1:40:00 PM
From: Chandler H. Everett	Read Replies (1) \| Respond to of 4056

To Sean and John......I've played around with the formulas you've been discussing and find the following interesting results: Fml("4SMA") = Mov(C,4,S) Fml("4SD") = Sqrt(Var(C,4)) Fml("4") = Fml( "4SMA" ) - Fml( "4SD" ) Fml("44") = Fml( "4SMA" ) + 1.5*(Fml( "4SD" )) Fml("4") and Fml("44") become tight bands around price. I put the multiplier in Fml("44") because the SMA is trailing (Richard Estes believes that the top band of any band set should have a higher variance). What seems to occur is that when the closing price moves in a day either above the upper band in a Down trend, or below the lower band in an Up trend, THE TREND CHANGES. These trends may well be very short or very long, but you guys may have come up with a great way to set Stops. See what you think. BW Chan