|
PureBytes Links
Trading Reference Links
|
Hi
thx i didnt think of this posibility, it remains
the problem that the equal ticks wold be treated all as positive, but this
manner is better
Bye
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
<A title=dusant@xxxxxxxxxxxxxxxxxx
href="">Dusant
To: <A
title=Metastockusers@xxxxxxxxxxxxxxx
href="">Metastockusers@xxxxxxxxxxxxxxx
Sent: Thursday, February 12, 2004 3:13
AM
Subject: Re: [Metastockusers] Re: volume
formula help
Pablo,
No need to apologise for not knowing
English. English is also not my native language. :)
It however, provides us a universal
medium to communicate.
From what I understand, is that you
want is the advancing declining volumes.
The advancing and declining volumes
work in this manner.
ALL the tickers which are traded during
the day on your exchange are tested whether they have closed higher or lower.
Those tickers which have closed higher their volumes are totalled and those
which have closed lower are totalled separately.
This will give you the advancing
declining volumes separately.
This information is normally published
by the exchange. However, if your exchange does not publish this
information, then you would need to run an exploration.
In MS you would need to the
exploration everyday. In different columns you would have to place the
conditions.
Advancing: if(c > ref(c,-1), v,
0)
Declining : if(c < ref(c,-1),
v, 0)
Unchanged : if(c = ref(c,-1), v,
0)
In the filter, you would have to
specify the date, month and year for which you are evaluating. The MS syntax
for that is dayofmonth(), month() and year().
Then you would have to import the
exploration everyday in excel and total the advancing, declining and unchanged
issues.
That is the only way I can think of. If
someone else has a better idea, let us have it.
DusantChief
Architect<FONT
face="MS Sans Serif">http://www.candlestrength.com/
<BLOCKQUOTE dir=ltr
>
----- Original Message -----
<DIV
>From:
Pablo
Paolucci
To: <A
title=Metastockusers@xxxxxxxxxxxxxxx
href="">Metastockusers@xxxxxxxxxxxxxxx
Sent: Wednesday, February 11, 2004
11:22 PM
Subject: Re: [Metastockusers] Re:
volume formula help
Dusant,
sometimes my english is really
crappy.
In excell the formulas work correctly to my
ends
what the indicator does its to campare every
single tick with the previous, then if there is an up tick the volume is
considered positive, all following tick that are bigger or equal are
considered positive as well.
if there is a negative tick the volume is
considered negative and all following ticks lower or equal to the
negative.
the first tick is compared to the previous
close, to evaluate the volume
the the sum of all positive volume and the sum
of all negative are added, giving a positive or negative value that states
the true caracter of the volume for the day
Its specifically designed for markets like
buenos aires, that are heavily manipulated
Bye
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
To visit your group on the web, go to:http://groups.yahoo.com/group/Metastockusers/
To unsubscribe from this group, send an email to:Metastockusers-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
|