Page 1 of 1

DailyVolume on intraday study

Posted: Mar 03 2011
by AntiMatter
My study is on 1 minute data. However, I would like to know the average volume of the last 100 days, as a filter (e.g. to avoid trading those stocks with too low a volume).

The function DailyVolume (so that I could average DailyVolume[0....100]) would appear to help, but seems to return only "0".

The other alternative would be to load 100 days of 1min data, but that seems excessive! Surely there is a more elegant solution?

Re: DailyVolume on intraday study

Posted: Mar 03 2011
by TJ
My study is on 1 minute data. However, I would like to know the average volume of the last 100 days, as a filter (e.g. to avoid trading those stocks with too low a volume).

The function DailyVolume (so that I could average DailyVolume[0....100]) would appear to help, but seems to return only "0".

The other alternative would be to load 100 days of 1min data, but that seems excessive! Surely there is a more elegant solution?
the following are 2 different things:

1) the average of 100 days of 1 min volume
2) the average of 100 days of daily volume

which do you have in mind?

Re: DailyVolume on intraday study

Posted: Mar 03 2011
by AntiMatter
Good point,

What I really want is 2) the average of 100 days of daily volume.

However, failing that, I could probably "make do" with the other option.

Re: DailyVolume on intraday study

Posted: Mar 03 2011
by TJ
Good point,

What I really want is 2) the average of 100 days of daily volume.

However, failing that, I could probably "make do" with the other option.
if you want 100 days' of analysis, you cannot avoid loading 100 days of data.

see post #4 for ideas:
Multiple time frame, Multi-Data Analysis
viewtopic.php?f=16&t=6929

Re: DailyVolume on intraday study

Posted: Mar 03 2011
by AntiMatter
Thanks for the useful links.

If I am looking at a graph, and insert a study, then I can have data1(intraday) and data2(daily) and get the daily average volume.

However, I want to insert the study into my RealTimeMarketScanner (which has a long list of stocks, at a resolution of 5 minutes). Basically I want to have data from both 5 minutes and daily in the RealTimeMarketScanner....

Hmmn, looks like I have to go the route of GV/ADE then....? Was hoping to avoid that, for now ;-)