HELP PLEASE WRITING FORMULA FOR PREVIOUS BAR EXPLORATION

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

Notification

Error

HELP PLEASE WRITING FORMULA FOR PREVIOUS BAR EXPLORATION - HELP PLEASE WRITING FORMULA FOR PREVIOUS BAR EXPLORATION

Options

Previous Topic Next Topic

matt1974		#1 Posted : Friday, September 24, 2010 2:26:56 PM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 9/24/2010(UTC) Posts: 7		Can anyone help me please, I have a formula as follows but want it to filter on the close of the previous bar C>Mov(C,50,S) AND Mov(C,50,S)>Mov(C,100,S) I am using end of day data and want to find the previous weekly completed bar falling within the criteria, obviously the formula currently works off the latest close. Apologies if I sound naive! If anyone could help it would be greatly appreciated (I have tried using PREV but am either using in the wrong context of using the wrong code altogether) Thanks very much...


User Profile View All Posts by User View Thanks


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

johnl		#2 Posted : Friday, September 24, 2010 7:26:32 PM(UTC)
Rank: Advanced Member Groups: Registered, Registered Users Joined: 11/7/2005(UTC) Posts: 602		Will the function REF(formula,-1) work for you?


User Profile View All Posts by User View Thanks

matt1974		#3 Posted : Wednesday, September 29, 2010 4:31:48 AM(UTC)
Rank: Newbie Groups: Registered, Registered Users Joined: 9/24/2010(UTC) Posts: 7		This appears to be working correctly, thank you very much for your help.


User Profile View All Posts by User View Thanks

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.