Login Page - Create Account

Support Board


Date/Time: Fri, 27 Dec 2024 11:28:27 +0000



Post From: Relative Volume Index

[2014-07-05 10:13:43]
Shaharabin - Posts: 28
Hi buddy,

This sounds quite simple indicator to build by yourself using a spreadsheet study.

Do this:

1. Add a spreadsheet study to your chart
edit the study's "K" sub graph to show the display type you want it to (bar, line, etc.)

- Now we're going to edit the "k" column in the spread sheet so it will show the relative volume

- Cumulative volume is simply the volume for a specific day (as i understand from you), so you've got that already on column "F" in the spreadsheet

2. - Right click on the chart and choose - "chart settings" - under "session times" make sure the times are the day's opening and day's closing times - now the volume will show the correct volume during those times. (most chances it's already set up correctly)

3. Let's add the Average volume data - add another study to the chart - "Moving average - simple"
in the study settings choose the input data - "Volume" and "Length" to the number of days you wish to average.
also - tick the "Hide Study" so it wont show on the chart.

now you got another column in the spreadsheet representing your Average Cumulative Volume, great.

4. final step is to locate the column representing the Average Cumulative Volume on the spreadsheet, lets say it's
column 'AA'.
Go to cell 'K3' and write this: "=AA3-F3" . which means "K" is now showing the "Average Volume - Volume"

That's it!

P.S.
To make it look better, go to the spreadsheet settings - subgraphs - choose the "k" - Auto coloring - Based on +/- .