Stock Meeting Place Last active: Never
Not logged in [Login - Register]
Go To Bottom

Printable Version
Subscribe | Add to Favourites

Post new thread Poll:
Author: Subject: Adjusted volume formula for pesky volume spikes
colster
Junior Member
**




Posts: 7
Registered: 24-8-2008
Member Is Offline


posted on 4-8-2009 at 10:41 AM Edit Post Reply With Quote
Adjusted volume formula for pesky volume spikes



Hi, in Leon Wilson's trading books he talks about how he overcomes the problem of volume spikes dwarfing the volume histogram making it difficult to analyse (until the spike passes from the screen) by "lopping" off the top of these spikes. On p.114 "The Next Step to Share Trading Success" he gives a formula which I cant get to work because the following error message comes:

A leading quote (") for a text constant expected. (e.g. "ABC")

The formula he gives looks like this (and i have triple checked my typing), can anyone help me to get it working? Many thanks, Colin...


MovAveA:=Input('Short Term Moving Average on Volume',3,34,5); MovAveB:=Input('Long Term Moving Average on Volume',35,250,50); MaxVal:=Input('Maximum Allowable Volume',0.1,5,2);

MaxVol:=MaxVal*(Mov(VOLUME,MovAveB,E));Adjustment:=VOLUME-(VOLUME-MaxVol);

If(VOLUME>MaxVol,Adjustment,If(VOLUME<MaxVol,VOLUME,VOLUME));Mov(If(VOLUME>MaxVol,Adjustment,If(VOLUME<MaxVol,VOLUME,VOLUME)),MovAveA,E);M ov(If(VOLUME>MaxVol,Adjustment,If(VOLUME<MaxVol,VOLUME,VOLUME)),MovAveB,E);
View User's Profile View All Posts By User U2U Member
henry1224
Junior Member
**




Posts: 4
Registered: 1-9-2004
Member Is Offline


posted on 8-8-2010 at 03:52 PM Edit Post Reply With Quote


MovAveA:=Input("Short Term Moving Average on Volume",3,34,5); MovAveB:=Input("Long Term Moving Average on Volume",35,250,50); MaxVal:=Input("Maximum Allowable Volume",0.1,5,2);

MaxVol:=MaxVal*(Mov(VOLUME,MovAveB,E));
Adjustment:=VOLUME-(VOLUME-MaxVol);

If(VOLUME>MaxVol,Adjustment,If(VOLUME<MaxVol,VOLUME,VOLUME));Mov(If(VOLUME>MaxVol,Adjustment,If(VOLUME<MaxVol,VOLUME,VOLUME)),MovAveA,E);< br /> Mov(If(VOLUME>MaxVol,Adjustment,If(VOLUME<MaxVol,VOLUME,VOLUME)),MovAveB,E);
View User's Profile View All Posts By User U2U Member
Post new thread Poll:


Go To Top


Powered by XMB 1.9.1 RC2 Nexus (RC2)
Developed By Aventure Media & The XMB Group © 2002-2004



[PHP: 79.0% - SQL: 21.0%]