see attached detail of the structure of the files.
I believe this is an Excel/VB project. MATLAB might work. So may SQL. Ultimately, all the files will need to be in CSV format to interface with my applications.
Files:
Equities
There are between 175 and 1000 equity files. Each has 7 columns:
Column 1 Date
Column 2 Adjusted Close[C]
Column 3 XAV(C, 64)
Column 4 XAV(C, 32)
Column 5 2*Column 4 – Column 3
Column 6 XAV(Column 5, 8)
Column 7 Diff_Val(Column 6)
XAV(X, N)
If row = 1 then…
