Hi all once again. I have been able to create the indicator I was after with one issue, which maybe somebody with better math skills than me could help me with [:)] . Basically it is a variation on a standard formula already in the library and does the following:
The code below works for sub 15 minute charts, and will show volume in 15 minute segments. 1. It plots current volume over the average volume for a specific 15 minute timeframe. 2. If plots standard deviation bands above and below the average volume in order to put the current volume relative to the average volume in better context. My problem is with the standard deviation : It shows something close, but not the same, as the standard deviation I calculate manually in Excel. Like the average volume, the standard deviation is also per 15 minute timeperiod. Below is the code. Can anybody spot anything wrong with the standard deviation calculation?? eToke. TimeFrame = 900; //15 minute n = (3600*6.5)/timeframe;// number of bars in day TimeFrameSet(timeframe); Avgvol=0; StdDev=0; d = 5; barnum = BarsSince(Day()!=Ref(Day(),-1)); //bar number from start of the day for (i=0; i<n; i++) { VarSet("vol"+i,IIf(i==barnum,V,0)); } for (i=0; i<n; i++) { Avgvol=IIf(barnum==i,Sum(VarGet("vol"+i),n*d)/d,Avgvol); VarSet("AvgVol"+i,IIf(i==barnum,Avgvol,0)); } for (i=0; i<n; i++) { StdDev=IIf(barnum==i,sqrt(Sum((VarGet("vol"+i)-VarGet("AvgVol"+i))*VarGe\ t("vol"+i)-VarGet("AvgVol"+i)),n*d)/d),StdDev); } CurrentVolume = Ref(V,1); AvgVol = Ref(AvgVol,1); VolStdDev = Ref(StdDev,1); TimeFrameRestore(); AvgVol = TimeFrameExpand(AvgVol,timeframe); VolStdDev = TimeFrameExpand(VolStdDev,timeframe); CurrentVolume = TimeFrameExpand(CurrentVolume,timeframe); Plot(CurrentVolume,"Volume",colorGreen,styleHistogram); Plot(Avgvol-VolStdDev,"Lower",colorDarkRed,styleHistogram|styleThick); Plot(Avgvol,"Avg Vol",colorRed,styleHistogram|styleThick); Plot(Avgvol+VolStdDev,"Upper",colorPink,styleHistogram|styleThick); Plot(0,"ZeroLine",colorBlack,styleNoTitle|styleNoLabel); --- In amibroker@yahoogroups.com, "etoketrader" <etoke...@...> wrote: > > Hi everybody, > > I am trying to create a relative volume indicator which would plot a volume bar relative to it's moving average by timeframe. > > If this is done across all timeframes, then the code would be very simple.. for example : > > RelativeVol = V - MA(V,20) > > However what I am looking for is to be able to compare the current volume with the MA of the equivalent bar of the same time, so for example the Volume of the 9:30 bar is compared to the moving average of the 9:30 bars of the previous 20 days. > > Is there a straightforward method of coding this? > > thanks! > etoke >