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

Notification

Icon
Error

Options
Go to last post Go to first unread
kanellop  
#1 Posted : Thursday, December 1, 2005 2:11:03 AM(UTC)
kanellop

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose, In the past you had publish a Formula which i had moderate it a little, from my Side. This Formula is: { Date-cutoff - excludes inactive codes whose last active date was before 30/November/2005 } day:=30; { 1~31 Day of month cutoff } mth:=11; { 1~12 Month cutoff } y:=2005; { Year cutoff } { ***************************************** } { Date cutoff } cutoff:=Year()>y OR (Year()=y AND (Month()>mth OR Month()=mth AND DayOfMonth()>=day)); { Exploration filter } cutoff AND V>0 AND C > 7 This Formula i use it, when i want it to found the Stocks that traded it, in the most recent day. But Today i decide it to choose also to make the Exploration without nothing in the Filter of the Exploration. The Result was that only 45 Stocks was discard with this Method. With the above, yours Exploration, about 35% of the Stocks that i used to make the Exploration was discard. After all that i want to ask you to explain me the Thought of your Formula! Kind Regards, George Kanellopoulos.
StorkBite  
#2 Posted : Thursday, December 1, 2005 3:57:53 AM(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)
George, please use PM for private messages to Jose. Thanks!
Jose  
#3 Posted : Thursday, December 1, 2005 6:32:02 AM(UTC)
Jose

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 1/19/2005(UTC)
Posts: 1,065
Location: Koh Pha-Ngan, Earth

Was thanked: 2 time(s) in 2 post(s)
Thanks, George S. I actually would like to discourage Private Messages unless they are related to custom work. Anyway, there is always something to learn from other's problems, so it's good to air them here. George K. - look at the price filter condition that you've introduced (AND C > 7), and you'll find your answer there. Unfortunately I'm not clever enough to prevent errors introduced somewhere between the keyboard and seat. ;) jose '-)
kanellop  
#4 Posted : Thursday, December 1, 2005 12:08:57 PM(UTC)
kanellop

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 181

Dear Jose, Thank you for the answer. They are Times that My Mind Mire. Especially in late Night Hours. My Message to you, i wrote it, in the Middle of the Night with my Local Time! Now, i understand. Yes the C > 7 is the answer for my Problem. Be well Dear Jose! Also i want to say a Hello to G_Stockman and Texas, USA! For the History i likes me to send Public Messages! Until now i have not send any Private Message to anyone from this Site! I think that must to send to Patrick for to change his Avatar that makes me to be extremely Scary! :( George Kanellopoulos.
StorkBite  
#5 Posted : Thursday, December 1, 2005 1:52:33 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)
Ok... I'm hearing it... my own PM box is full! Still, the point is this: PLEASE don't start a thread addressed to an individual. However, don't be shy in saying thanks to an individual that may have helped with your original thread. It's a fine point of etiquette... and my job. Thanks for understanding.
Patrick  
#6 Posted : Thursday, December 1, 2005 6:12:24 PM(UTC)
Patrick

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266

Was thanked: 1 time(s) in 1 post(s)
Let me backup my favorite moderator here :D 1) If I see a title in CAPS it bugs me and I don't want to answer it. 2) If I see a post addressed to someone else, if I know the answer I won't answer it. 3) If I see a post addressed to someone else, if I don't know the answer I won't bother trying to find it ... Patrick :mrgreen:
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.