Question for a programmer who knows about statistics | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

The man that knows something knows nothing at all 95 replies

Statistics-related question about breakouts 3 replies

I am looking for a programmer who knows how to program MT4 code. 2 replies

Trader Statistics and Broker Statistics 0 replies

Anyone Knows 0 replies

Question for a programmer who knows about statistics

  • #1
  • First Post: Edited 5:13pm May 31, 2016 3:02pm | Edited 5:13pm
Hello,
I was making some historic calculations and I used "Standardize" en Excel.
I looked up to see if there was a function in MT4 but I only see NormalizeDouble(), and it doesn't seem to do what I'm trying to do.
Does anyone know if there's a function that I can use or how to calculate it?
Thanks in advance.


Description
Returns a normalized value from a distribution characterized by mean and standard_dev.
Syntax
STANDARDIZE(x, mean, standard_dev)
The STANDARDIZE function syntax has the following arguments:

  1. X Required. The value you want to normalize.
  2. Mean Required. The arithmetic mean of the distribution.
  3. Standard_dev Required. The standard deviation of the distribution.

Hard work and patience.
  • #2
  • May 31, 2016 4:26pm May 31, 2016 4:26pm
Quoting Q4x
Hello, I was making some historic calculations and I used "Standarize" en Excel. I looked up to see if there was a function in MT4 but I only see NormalizeDouble(), and it doesn't seem to do what I'm trying to do. Does anyone know if there's a function that I can use or how to calculate it? Thanks in advance. Description Returns a normalized value from a distribution characterized by mean and standard_dev. Syntax STANDARDIZE(x, mean, standard_dev) The STANDARDIZE function syntax has the...

iStdDev in MQL4

https://en.wikipedia.org/wiki/Standard_deviation - in "Basic examples" you have the formula
"Talk is cheap. Show me the code." Linus Torvalds
  • #3
  • May 31, 2016 5:05pm May 31, 2016 5:05pm
Quoting Suntelius
{quote} iStdDev in MQL4 https://en.wikipedia.org/wiki/Standard_deviation - in "Basic examples" you have the formula
Thanks Suntelius.
But the standard deviation (iStdDev) is one of the parameters used by the "Standarize" function.
"Standarize" uses three values: the value I want to normalize, the mean, and the StdDev.
I'm looking for the function for "Standarize" (https://support.office.com/en-us/art...3-6437108ee775)
Thanks anyway
Hard work and patience.
  • #4
  • May 31, 2016 6:16pm May 31, 2016 6:16pm
I couldn't find the function you want, but it's just 1-2 lines of code, so... Code it yourself? XD
  • #5
  • Jun 1, 2016 2:44am Jun 1, 2016 2:44am
Quoting Q4x
{quote} Thanks Suntelius. But the standard deviation (iStdDev) is one of the parameters used by the "Standarize" function. "Standarize" uses three values: the value I want to normalize, the mean, and the StdDev. I'm looking for the function for "Standarize" (https://support.office.com/en-us/art...3-6437108ee775) Thanks anyway

Your link it's your answer, you have formula.

X = [Value]

m = [mean (average)]

S = Standart deviation

soo,


Standarize = (X - m) / S
"Talk is cheap. Show me the code." Linus Torvalds
  • #6
  • Last Post: Jun 1, 2016 10:25am Jun 1, 2016 10:25am
Unfortunately that doesn't work.
The formula is this: https://support.content.office.net/e...4aa0827cb1.gif
The problem is how to do it in MT4.
0 traders viewing now