Printable View
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
Attachment 31099
is a little bit fuzzy. What didn't work?Quote:
but it did not work ......
Also is your 'End Sub' in the wrong place?
Code:' 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?
Attachment 31100
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
Attachment 31101
Go to Debug, Compile and fix any errors that it finds