"The Profit Magic of Stock Transaction Timing" by Hurst J.M. - Spectral Analysis
Here is an excel spreadsheet to calculate the spectral analysis approximation of a price time series. The approximation is one by Fourier as explained in "The Profit Magic of Stock Transaction Timing" by Hurst J.M. Download and open it with Microsoft Excel, it uses macros.
If anybody is interested in i will give more explanations in the comments.
Excel - Spectral Analysis
If anybody is interested in i will give more explanations in the comments.
Excel - Spectral Analysis
KINDLY EXPLAIN
ReplyDeleteThank you for your interest.
DeleteInto the posted excel there are many unusefull sheets. The only you need are the sheets named Commands and the sheet in which you put your time series to analyze. Into the example the input time series is into the sheet named Fiat. You set the command options on the commands sheet, then click the analyze Button. A new output sheet will appear, named as the input one, with suffix _pp (for example Fiat_pp). Then to view the graphs click the View Approx button and a new sheet will appear named Fiat_gr. On the legend you can read the more important cycles present into the analyzed time series, used to represent the approximation. The graph shows the original time series with overlapped the approximation, the approximation is shown overlapped both on the input data and on the data to forecast.