[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

A popular formula



PureBytes Links

Trading Reference Links


Are you informed about the new fashion in 
StockMarkets?
The last value of Close may be the lowest value and 
if the
condition is false today, it may be true 
tomorrow.
 
/*A Popular Formula for everyday 
use*/COND=C==LOWEST(C);FILTER=1;NUMCOLUMNS=4;COLUMN0=CLOSE;COLUMN1=LOWEST(C);COLUMN2=VALUEWHEN(COND,datenum()%1000000);COLUMN0NAME="LAST 
CLOSE";
COLUMN1NAME="LOWEST CLOSE";COLUMN2NAME="WHEN 
?";
<FONT face=Arial 
size=2>COLUMN2FORMAT=1.0;COLUMN3=BARSSINCE(COND);
<FONT face=Arial 
size=2>COLUMN3FORMAT=1.0;COLUMN3NAME="BARSSINCE";BUY=CUM(1)==LASTVALUE(CUM(1))-LASTVALUE(COLUMN3);
 
Column2 informs you when the lowest close occurred 
and 
column3 how many days ago.
Click on "barssince" label and you will collect the 
champions.
Stocks with "barssince" 0 had the lowest close 
today.
(I counted 239/384 for Sept 21 in Athens SE with 
data from Jan 2000 ... )
Double click on Result and a single green arrow 
will show the lowest close
day.
(I found this idea to get the inverse of exrem. I 
need the last buy signal.
If there is another, more elegant way, please let 
me know.)
Dimitris Tsokakis