help with detrended fluctuatin analysis

[anne durande]

Hi
I an a new vba'user , and I tried to caculate DFA (detrended fluctutation analysis) on time series
I put a white noise in a column, and I developed a VBA code, but it did not work ......
hopefully , someone could help me
Thanks
You will find excel files and article method in pdf (https://libstore.ugent.be/fulltxt/RU...19_0001_AC.pdf)

Anne

donnees (2).xlsm

[Paul_Hossler]

but it did not work ......

is a little bit fuzzy. What didn't work?

Also is your 'End Sub' in the wrong place?

   ' Calculer la série temporelle y_i = ?(a_i - moyenne(a))
    For i = 1 To n
        ' Calculer la série y_i en utilisant la somme cumulative des différences
        If i = 1 Then
            newY(i) = diff(i)
        Else
            newY(i) = newY(i - 1) + diff(i)
        End If
        ' Afficher la série temporelle y_i dans la colonne C de la feuille Excel
        ws.Cells(i + 1, 3).Value = newY(i)
    Next i
End Sub   ' <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<


' Définir les tailles des boîtes
boiteTailles = Array(250, 500, 1000, 1500)

Do you want the formulas in this section only?

Capture.JPG

[anne durande]

Hi,
The macro does not execute when I run it.
All the formulas in the paper, you show, are in the vbamacro
Now I want to run it to see whether it works, and the potential problem, I know what I should obtain, I just need to control
Anne

[Paul_Hossler]

Capture.JPG

Go to Debug, Compile and fix any errors that it finds