Hello Everyone.
With regards top my post for a "Triple Colour Coded Volume indicator."

I'm very sorry but I seem to have been very bland in my post, not being specific in exactly what I would like to be able to achieve and also where my knowledge of formulas is practically above zero I have been a little confused myself.
If I'm confused, then how is anyone able to help if I don't know exactly what I'm looking to do ! :-)

So here goes,
I think I can clarify the situation.

Firstly, I've dug deep into the forum and some other websites.
I found here ;

http://forum.equis.com/forums/thread/23864.aspx
Different colours for volume bars

An excellent post/threads regarding volume.
I really like Henry1224 formula

Up:=If(C>Ref(C,-1),V,0);
dn:=If(C<Ref(C,-1),v,0);
Neutral:=If(C=Ref(C,-1),v,0);
up;Dn;Neutral;

As this plotted all 3 colours within an inner window in 1 go

I also liked Wabbit's suggestion here;
http://forum.equis.com/viewtopic.php?t=3913
to synchronise coloured volume to price volume colour.

Regarding above threads, these are all great but I notice they are always looking to colour the volume (I think) relating to the previous days close

What I am looking to construct is a triple coloured volume indicator that mirrors the price regarding the same day open and close relationship.

I'll explain further.

Here is what I would like to achieve;

1. If today's close is higher than today's open then volume colour would be green.
2. If today's close is lower than its open the volume colour would be red.
3. If today's close is the same as it's opening price the volume colour would be blue.

So the volume colour only relates to it's open and closing price , not to the previous days close.

I'm just not sure how to write this.
Looking at henry's formula;

Up:=If(C>Ref(C,-1),V,0);
dn:=If(C<Ref(C,-1),v,0);
Neutral:=If(C=Ref(C,-1),v,0);
up;Dn;Neutral;



I thought it might be something like this;

Up:=If(C>open,V,green);
dn:=If(C<open,v,red);
Neutral:=If(C=open),v,blue);
up;Dn;Neutral;

As you can see,,, Not a clue.
I'm determined to try a bit harder and crack this,,, (4am,, now 7.50am:-(
After looking in metastock help (Index,, Reference Function helped me a lot),, trial and error and trying to think a bit logically, I've come up with this,,
Seems to work, I think,,
I had to change things around abit,, Plotted as histogram

Up:=If(OPEN<Ref(CLOSE,-0),V,0);
dn:=If(OPEN>Ref(CLOSE,-0),V,0);
Neutral:=If(OPEN=Ref(CLOSE,-0),V,0);
up;Dn;Neutral;


So now it will pick up neutral volume (Harami),,, and colour is coded to price Open / Close relationships.

Please, if there are any good coders reading this,, if you could just confirm if I have written this correctly.
Tried my best. I think it's ok, but not sure.

I hope this might be of some use to people out there if it is ok.
I couldn't have written it without analysing some of the other posts on this forum.
Thank you all.[:)]

Many many thanks for your reply Wabbit.
sorry for my late reply,, (I hate 12 hour night shifts:-)).

I've tried both your suggestions, and both do the trick, many thanks.

As to how/ why they are written differently, and if 1 is written better (wrong word:better, but not sure how else to describe it) than the other.

I have recently purchased Metastock Pro, and next mth should have a live data feed through quote center.


I'm trying to understand how you have written them.
I'm new to language /formulas etc.
(I did visit your website and see that you have a degree in Mathematics/bachelor of Science etc,,, so this coding must be second nature to you now) :-)
I know how to use a caculator :-)
I'm look at the manual page 418,, to try and understand the formulas you wrote.
* = Multiple
V= Volume
If (Page 422)= Kind of if then xyz =abc, then true (I think)

So 1st formula
up:=If(CLOSE>OPEN,V,0);
Means;
I think;
If the close is greater than the open today, volume is up
dn:=If(CLOSE<OPEN,V,0);
If the close is less than the open today, volume is down
neutral:=If(CLOSE=OPEN,V,0);
If close is same as the open, todays volume will be neutral
PROBLEM: I don't understand the next bit Wabbit, why you mention
{plot}
up; {green}
dn; {red}
neutral; {blue}

Have you added that just so as to tell me Wabbit that they should be coloured that way? As If I create a new indicator the information, or as 3 seperate indicators for up, down, neutral in indicator builder, then just import into a new inner window; it always imports/shows as a red line,, and I colour them myself,, (and do as you suggested,, save as tempate when finished.)

Didn't know what the {} meant,,
Wiki'd it as trouble in Index finding out,
http://en.wikipedia.org/wiki/Table_of_mathematical_symbols
Seems to just be brackets! :-) Example:{a,b,c} means the set consisting of a, b, and c.
If I plot
second Formula
up:=V*(CLOSE>OPEN);
Means; close if greater than open, multiply by volume, and will be up
dn:=V*(CLOSE<OPEN);
Means;
Means; close if less than open, multiply by volume, and will be down
neutral:=V*(CLOSE=OPEN);
Means; close equals the open, multiply by volume, and will be neutral.
=================================================
To sum up,, have plotted the indicator fine, saved as template fine.
1. Just not sure what this means/ is included for;
{plot}
up; {green}
dn; {red}
neutral; {blue}

2. These are written for EOD data,, but would they work on intra day data, as I think they would need to be written slightly differently, I think?

Example
Formula now for up bar
up:=If(CLOSE>OPEN,V,0);

But because intra day bars, say a 1 minute bar couldn't just use the word CLOSE, would have to be something like PRICE NOW is Greater than its OPEN?
Would it be somthing like;
"If todays price (Example 1 minute bar) is above its opening price then its volume will be up colour ,,green,, if todays price bar (Example 1 minute) has fallen and is now below or crossed below its open then todays volume bar will be red,, and if it closes same as open it will be blue.

Just a thought.

Again, many many thanks for your reply Wabbit.
Regards
TheGhost

Wabbit,

This Boolean comparison done by MS in the bracket without If function is another thing i have learnt from you ,Thks once again .

Asish

Use: * code * (without the spaces) to define the start of the code segment.
Use: * /code * (without the spaces) to define the end of the code segment.


See http://forum.equis.com/forums/thread/19928.aspx(CLOSE=OPEN);
{plot}
Mov(VOLUME,5,E);
up; {green}
dn; {red}
neutral; {blue}
[/code]


Hope this helps.

wabbit [:D]

P.S. I think you'd benefit from attempting the exercises in the free Quis Formula Primer; see the downloads section.