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?
DailyVolume on intraday study
-
- Posts: 60
- Joined: 03 Mar 2011
- Has thanked: 9 times
- Been thanked: 2 times
- TJ
- Posts: 7742
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2222 times
Re: DailyVolume on intraday study
the following are 2 different things: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?
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?
-
- Posts: 60
- Joined: 03 Mar 2011
- Has thanked: 9 times
- Been thanked: 2 times
Re: DailyVolume on intraday study
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.
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.
- TJ
- Posts: 7742
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2222 times
Re: DailyVolume on intraday study
if you want 100 days' of analysis, you cannot avoid loading 100 days of data.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.
see post #4 for ideas:
Multiple time frame, Multi-Data Analysis
viewtopic.php?f=16&t=6929
-
- Posts: 60
- Joined: 03 Mar 2011
- Has thanked: 9 times
- Been thanked: 2 times
Re: DailyVolume on intraday study
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
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