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

Notification

Icon
Error

Options
Go to last post Go to first unread
MuratErdogan  
#1 Posted : Wednesday, January 13, 2016 2:44:46 AM(UTC)
MuratErdogan

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/9/2015(UTC)
Posts: 25

Thanks: 9 times

Opening of the closing of today and before yesterday is greater than the trend change.


How can I write ?

i try this;

If(C>O AND C-O>Ref(C,-1)-Ref(O,-1) AND C-O>Ref(C,-2)-Ref(O,-2) AND C-O>Ref(C,-3)-Ref(O,-3)
,
O>C AND O-C>Ref(O,-1)-Ref(C,-1) AND O-C>Ref(O,-2)-Ref(C,-2)AND O-C>Ref(O,-3)-Ref(C,-3)
,1)

but not working.


regards,

Murat Erdogan
MuratErdogan  
#2 Posted : Friday, January 15, 2016 10:00:28 AM(UTC)
MuratErdogan

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/9/2015(UTC)
Posts: 25

Thanks: 9 times

here is the all combination :

http://i.hizliresim.com/W1G1GQ.jpg

so i try this for start beginning but not good one:

If(O>C, O-C>Ref(O,-1)-Ref(C,-1)AND O-C>Ref(O,-2)-Ref(C,-2) AND O-C>Ref(O,-3)-Ref(C,-3), 0)

such shows :

http://i.hizliresim.com/rZJZyz.jpg

where I make mistakes ?

can you help me ?

MuratErdogan

MuratErdogan  
#3 Posted : Friday, January 15, 2016 11:51:59 AM(UTC)
MuratErdogan

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/9/2015(UTC)
Posts: 25

Thanks: 9 times

i think i found the problem.

We need to be able to write this in the formula/code :

down day and up day...

But how ?

Murat Erdogan

Edited by user Friday, January 15, 2016 11:55:08 AM(UTC)  | Reason: Not specified

MS Support  
#4 Posted : Friday, January 15, 2016 3:36:52 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Hi MuratErdogan, I would need to see the conditions more clearly defined, i.e. "Trend Change" can be measured in a variety of ways. A down day or up day to me simply means the Close is less than the Open (down day) or the Close is greater than the Open (up day) but different people could define that differently, perhaps measuring from yesterday's close to today's close.
thanks 1 user thanked MS Support for this useful post.
MuratErdogan on 1/15/2016(UTC)
MuratErdogan  
#5 Posted : Friday, January 15, 2016 5:44:15 PM(UTC)
MuratErdogan

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/9/2015(UTC)
Posts: 25

Thanks: 9 times
Hi Ms Support,

First of all, thank you for your swift reply.

Since my english is not enough, I could not precisely explain what I meant.

The question is this ;


Whether today's closing is up or down, 

or whether yesterday's closing is up or down,

If today's (closing - opening) is higher than yesterday's (closing - opening) then ENTER.


i try this one but not good;
If(O>C, O-C > Ref(O,-1)-Ref(C,-1) AND O-C > Ref(O,-2)-Ref(C,-2) AND O-C>Ref(O,-3)-Ref(C,-3),0)

Thank you for your time,

Kindest Regards,

Murat Erdogan

Edited by user Friday, January 15, 2016 8:31:36 PM(UTC)  | Reason: color

MS Support  
#6 Posted : Friday, January 15, 2016 8:39:42 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Do you need both yesterday and today to be Up days, you mention today being up or down or yesterday being up or down so I am a bit confused. Today being up would simply be: C > O Yesterday being up would simply be: Ref(C > O,-1) Today's C-O being greater than yesterday's C-O would simply be: C-O > Ref(C-O,-1) But I am not entirely sure how you want to use Boolean operators to combine all of this.
thanks 1 user thanked MS Support for this useful post.
MuratErdogan on 1/15/2016(UTC)
MS Support  
#7 Posted : Friday, January 15, 2016 8:56:50 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
It is best to simply state the formula you want by what is required. When you phrase the question as "whether today's closing is up or down" it is unclear to me what you want the actual entry criteria to be. If the entry criteria is simply when today's closing is up, that is all we would need to know, the addition of "or down" makes it a bit more confusing. Assuming you are looking for 2 up days and a larger open/close range than the previous day, you would write it like this: C > O AND Ref(C > O,-1) AND C - O > Ref(C - O,-1) IF should not be required for the above formula although it could be written similarly using the IF statement.
thanks 1 user thanked MS Support for this useful post.
MuratErdogan on 1/15/2016(UTC)
MuratErdogan  
#8 Posted : Friday, January 15, 2016 9:29:27 PM(UTC)
MuratErdogan

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/9/2015(UTC)
Posts: 25

Thanks: 9 times
Dear MS Support,

this is good.. i mean this one..

C > O AND Ref(C > O,-1) AND C - O > Ref(C - O,-1)

The final question;
if today up 
yesterday down

how can i write this combination ?

sory for my english..

Murat
MS Support  
#9 Posted : Friday, January 15, 2016 9:31:53 PM(UTC)
MS Support

Rank: Advanced Member

Groups: Moderators, Registered, Registered Users, Subscribers
Joined: 10/8/2010(UTC)
Posts: 1,929

Thanks: 85 times
Was thanked: 154 time(s) in 150 post(s)
Hi MuratErdogan,

No problem regarding your English, just wanted to give some tips so we might be able to help more easily. In regards to your slightly modified formula:

 

You would just switch the Greater Than to a Less Than in the formula and change the end to O - C to keep the value positive (could also use ABS to get the absolute value):

C > O AND Ref(C < O,-1) AND C - O > Ref(O - C,-1)

Edited by user Friday, January 15, 2016 9:33:25 PM(UTC)  | Reason: Not specified

thanks 1 user thanked MS Support for this useful post.
MuratErdogan on 1/15/2016(UTC)
MuratErdogan  
#10 Posted : Friday, January 15, 2016 9:46:23 PM(UTC)
MuratErdogan

Rank: Member

Groups: Registered Users, Subscribers, Unverified Users
Joined: 12/9/2015(UTC)
Posts: 25

Thanks: 9 times

Dear MS Support,

Thank you very much for everything.

Regards,

Murat

Users browsing this topic
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.