Hi,
example :
01/25/2016 19.0500 19.4000 18.3500 18.4000
01/27/2016 18.7500 18.7500 18.0000 18.1500
01/28/2016 18.2500 19.0000 18.1500 18.8500
01/29/2016 18.9500 20.5000 18.8500 20.3000
02/01/2016 20.5000 20.7000 18.5000 18.6000
Above are a sample, I need to know the difference between High and Low. I have 100 EOD symbol in Metastock. I want to know the sum of difference between High and low for all the 100 symbols group by symbols for a given start and end date.
What is the best formula. Also dont need it as indicator, i want to run a system test.
hope i made you understand.
thanks
ML
example :
01/25/2016 19.0500 19.4000 18.3500 18.4000
01/27/2016 18.7500 18.7500 18.0000 18.1500
01/28/2016 18.2500 19.0000 18.1500 18.8500
01/29/2016 18.9500 20.5000 18.8500 20.3000
02/01/2016 20.5000 20.7000 18.5000 18.6000
Above are a sample, I need to know the difference between High and Low. I have 100 EOD symbol in Metastock. I want to know the sum of difference between High and low for all the 100 symbols group by symbols for a given start and end date.
What is the best formula. Also dont need it as indicator, i want to run a system test.
hope i made you understand.
thanks
ML