GAP UP, GAP DOWN Explorer? [RESOLVED] - GAP UP, GAP DOWN Explorer? [RESOLVED] Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

fousc		#1 Posted : Tuesday, September 20, 2005 5:49:43 AM(UTC)
Rank: Member Groups: Registered, Registered Users, Subscribers Joined: 7/8/2005(UTC) Posts: 12		Does anyone have a formula or any information on an explorer that would search for gap ups, or down within like the last 5 days or something like this? Regards, Fousc
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your Discussions forum accountor Register a new forum account.

StorkBite		#2 Posted : Tuesday, September 20, 2005 12:46:17 PM(UTC)
Rank: Advanced Member Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995 Was thanked: 14 time(s) in 10 post(s)		ColA: gapup(); {today} ColB: ref(gapup(),-1); {yesterday} ColC: ref(gapup(),-2); {2 days ago} ColD: ref(gapup(),-3); {3 days ago} ColE: ref(gapup(),-4); {4 days ago} ColF: ref(gapup(),-5); {5 days ago} Filter: ColA>0 OR ColB>0 OR ColC>0 OR ColD>0 OR ColE>0 OR ColF>0
User Profile View All Posts by User View Thanks

wabbit		#3 Posted : Tuesday, September 20, 2005 1:01:35 PM(UTC)
Rank: Advanced Member Groups: 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)		Another couple of ways: --8<--------------------------- Col A: BarsSince(GapUp()) Filter: ColA>0 and ColA<5 --8<--------------------------- Filter: Alert(GapUp(),5) Anyone got anymore? wabbit :D
User Profile View All Posts by User View Thanks

StorkBite		#4 Posted : Tuesday, September 20, 2005 1:47:28 PM(UTC)
Rank: Advanced Member Groups: Registered, Registered Users Joined: 3/19/2005(UTC) Posts: 2,995 Was thanked: 14 time(s) in 10 post(s)		Well Wabbit... I'm ashamed now :oops: ... thanks for the lesson in humility! :P j.k. Really, your code rocks! I was trying to come up with something quick... turns out that I failed the test of conciseness. That's what I love about this place.
User Profile View All Posts by User View Thanks

wabbit		#5 Posted : Tuesday, September 20, 2005 1:55:15 PM(UTC)
Rank: Advanced Member Groups: 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)		remember: there's more than one way to skin a wabbit!!! :LOL: wabbit :D
User Profile View All Posts by User View Thanks

fousc		#6 Posted : Tuesday, September 20, 2005 2:07:47 PM(UTC)
Rank: Member Groups: Registered, Registered Users, Subscribers Joined: 7/8/2005(UTC) Posts: 12		thanks for the help guys! -fousc
User Profile View All Posts by User View Thanks

investorretired		#7 Posted : Tuesday, September 20, 2005 6:25:21 PM(UTC)
Rank: Advanced Member Groups: Registered, Registered Users Joined: 6/13/2005(UTC) Posts: 52		fousc wabbit solution one looks at the last 6 days. If you want the last 5 days, elimate all reference to ColF wabbit solution two looks at the last 4 days. If you want the last 5 days change ColA<5 to ColA<6. Great coding by wabbit. Keep up the good work.
User Profile View All Posts by User View Thanks

Users browsing this topic

Guest (Hidden)