coding Pascal Willain effective volume

#1
Hello,

What I need to do is to write some of Pascal Willain's indicators, like the Effective Volume. If you are not familiar with these, I will get right to the problem.
I use intraday (1 minute) data. Based on the intraday data, I need to calculate the average exchanged volume for that day. Then I will have a formula that compares the volume exchanged at the current minute with the average volume for that day and based on the result of this comparison, will plot something. I can't seem to figure out how to calculate the average just using the Metastock Formula Language. Do i need the MDK for this simple operation?

Any help is appreciated.

Regards
 
#2
Since it seems I wasn't clear enough in my previous post, let me put it like this:

I have 1-min data and a formula that looks at the volume of shares traded every minute. I compare the volume traded on a certain MINUTE to something called average effective volume.

Average effective volume is an arithmetic average of volumes traded this current DAY. It takes into account only those minutes where there is a price inflection. So, to compute this average:
1. I look at every minute since the day started until the day ended (from 9:30 a.m. to 4 p.m.! NOT last n minutes, NOT all minutes until now, BUT ALL minutes of today).
2. I see if the closing price is different than the close of the previous minute
3. if the close is different, I include this volume in the computation of the average.

I need a way to compute this average so that I can use it inside my formula.

In Metastock language I only saw moving averages computing an average of the last n values of a vector. I found nothing that would be even close to what I described above.

Please if anyone thinks I am not clear enough let me know. I find it very strange that from all the people that use Metastock and frequent this forum and from 900 viewers...nobody knows how to solve this problem, which in other programming languages is something that you do in a 'Hello world' program :)
 
#3
Hi, you can try to look at http://www.metastocktools.com/#metastock by Jose Silva, maybe there you can find something useful for what you're trying to do... there's a formula called signal (value) accumulator that says... "[...] accumulates OBV or Volume (or any other signal) between & including two user-input dates or signals [...]

try also at http://forum.equis.com/ searching for "volume between 2 dates (events)" or something like that

good luck

gabibbo
 

Similar threads