henryk napisał(a):Witam,
moze mi ktos podpowiedziec jak napisac furmule eksploracji do meta stocka ktora wyszuka mi akcje ktore osiagnely dzisiaj all time high?
i formule ktora wyszuka akcji ktore w jakims przedziale np 100 sesji notowane sa dzisiaj na najwyzszym poziomie?
dziekuje za pomoc
henryk
Jest cos co moze Ci pomoc, ale musisz sobie to sam dopasowac, bo nie jestem expertem od exploracji:
52 Week Hi-Lo Exploration
ColA:
{Close}C;
ColB:
{52-week High} HighestSince(1, (DayOfMonth()=08 AND Month()=05 AND Year()=1998), H);
ColC:
{52-week Low} LowestSince(1, (DayOfMonth()=08 AND Month()=05 AND Year()=1998), L);
{Choose one of these filters}
Filter 1:
ColA >= (0.9*(ColB))
Filter 2:
ColB >= 2*ColC
Uwagi do powyzszej formuly:
"If you want both the conditions to be satisfied in the same query, just join the two filters by the AND operator:
Filter: (ColA >= (0.9*(ColB)) AND ColB >= ColC)
One problem with the 52-wk High and 52-wk Low formula--every day you've got to change the values for dayofmonth(), Month() and Year() functions. The formula given above assumes that you would be running the query on May 07, 1998. Change the values of the above functions accordingly."
Albo to:
Stocks Closing Above 60 Day High
ColA:
{Close) C
ColB:
{Previous 60-day High} Ref(HHV(H,60), -1)
ColC:
{Current 60-day High} HHV(H,60)
ColD:
{Volume} V
Filter:
(colA>colB) AND (Ref(C,-1)<Ref(HHV(H,60), -1)) AND (H=HHV(H,60))
"To find the securities that have closed above their high today (the last trading day in the database) for the first time. This formula does two things:
1) It lists only those securities which have met the required conditions only on the last trading day.
2) The new 60-day high must have taken place only on the last trading day."
Pozdrawiam... Olaf
"Trade What You See, Not What You Think"
"When the facts change, I change my mind - what do you do, sir?"