We're going do just the draws starting from 2000-01-01 to present.
Index |
Year |
Month |
Day |
A |
B |
C |
1 |
2000 |
1 |
1 |
5 |
3 |
0 |
2 |
2000 |
1 |
2 |
6 |
9 |
7 |
3 |
2000 |
1 |
3 |
4 |
9 |
6 |
4 |
2000 |
1 |
4 |
3 |
1 |
0 |
5 |
2000 |
1 |
5 |
7 |
5 |
7 |
6 |
2000 |
1 |
6 |
2 |
9 |
2 |
7 |
2000 |
1 |
7 |
2 |
2 |
7 |
8 |
2000 |
1 |
8 |
6 |
5 |
8 |
9 |
2000 |
1 |
9 |
4 |
0 |
3 |
10 |
2000 |
1 |
10 |
1 |
3 |
7 |
… |
… |
… |
… |
… |
… |
… |
4801 |
2013 |
2 |
21 |
3 |
0 |
0 |
4802 |
2013 |
2 |
22 |
2 |
9 |
1 |
4803 |
2013 |
2 |
23 |
7 |
5 |
6 |
4804 |
2013 |
2 |
24 |
0 |
7 |
8 |
4805 |
2013 |
2 |
25 |
9 |
2 |
3 |
4806 |
2013 |
2 |
26 |
6 |
5 |
8 |
4807 |
2013 |
2 |
27 |
5 |
6 |
8 |
4808 |
2013 |
2 |
28 |
9 |
1 |
0 |
4809 |
2013 |
3 |
1 |
4 |
3 |
1 |
We will analyze Column B for this example.
The setting for the analysis are as follows:
Newer Values at -
- Bottom of Sheet
---- Wave Matrix Settings
Regression - Linear
Waves - 8
BMA Iterations - 8
---- Wave Find Algorithm
Amplitude and Frequency
---- Algorithrm Settings
Percision of BMA Degree - 0.001
Wave to BMA RMS Ratio - 0.50
Amplitude to Frequency Ratio - 0.50
---- Ultimate Wave Predictor Settings
Quantum
Depth - 25
Level - 25
Everything else default.
When the Generate Wave Matrix button in the Analyze And Predict ribbon section is pressed, a Wave Matrix table and graph is created in a new sheet.
Below is the shortened table; you should be able to create the same output if you have the JADEXCODE addin installed and working in Excel.
|
Type = |
Linear |
BMA Degree 1 |
BMA Degree 2 |
BMA Degree 3 |
BMA Degree 4 |
BMA Degree 5 |
BMA Degree 6 |
BMA Degree 7 |
BMA Degree 8 |
Algorithm |
Predictor |
|
A = |
4.42422875 |
-1.019 |
-1.171 |
-1.108 |
-1.028 |
-1.024 |
-1.003 |
-0.981 |
-0.975 |
Wave / BMA = 0.50 |
Depth = 25 |
|
B = |
2.41131E-05 |
|
|
|
|
|
|
|
|
Amp / Freq = 0.50 |
Level = 25 |
|
Index |
Regression |
Wave 1 |
Wave 2 |
Wave 3 |
Wave 4 |
Wave 5 |
Wave 6 |
Wave 7 |
Wave 8 |
Remainder |
Data |
|
1 |
4.424252863 |
0.02065733 |
0.011125731 |
0.032315571 |
0.04100567 |
0.02118177 |
0.02126645 |
0.020582701 |
0.015140556 |
-1.607528642 |
3 |
|
2 |
4.424276976 |
0.015326489 |
0.009841715 |
0.030671635 |
0.038794694 |
0.019428526 |
0.019595307 |
0.018972558 |
0.013764332 |
4.409327768 |
9 |
|
3 |
4.424301089 |
0.008624798 |
0.008265779 |
0.02863233 |
0.036010233 |
0.017210792 |
0.01746498 |
0.016901908 |
0.011980038 |
4.430608052 |
9 |
|
4 |
4.424325202 |
0.000633215 |
0.006421243 |
0.026227577 |
0.032688998 |
0.014553921 |
0.014893482 |
0.014380464 |
0.00978721 |
-3.543911312 |
1 |
|
5 |
4.424349315 |
-0.00851875 |
0.004346501 |
0.023510441 |
0.028906419 |
0.011521306 |
0.011941196 |
0.011465385 |
0.007233309 |
0.485244878 |
5 |
|
6 |
4.424373428 |
-0.018677894 |
0.002086992 |
0.020544528 |
0.024754519 |
0.008191895 |
0.008685038 |
0.008231492 |
0.00438295 |
4.517427051 |
9 |
|
7 |
4.424397541 |
-0.029656011 |
-0.000300522 |
0.017410707 |
0.02035374 |
0.004672856 |
0.005233454 |
0.004788949 |
0.001336807 |
-2.448237522 |
2 |
|
8 |
4.424421655 |
-0.041223838 |
-0.002745517 |
0.014210988 |
0.015859913 |
0.001107258 |
0.001735691 |
0.001294427 |
-0.001756254 |
0.587095677 |
5 |
|
9 |
4.424445768 |
-0.053150124 |
-0.005176767 |
0.011048122 |
0.011428973 |
-0.002361907 |
-0.001659398 |
-0.002096211 |
-0.004748112 |
-4.377730343 |
0 |
|
10 |
4.424469881 |
-0.0651958 |
-0.007519886 |
0.008029397 |
0.007223733 |
-0.005584253 |
-0.004794305 |
-0.005217009 |
-0.007479537 |
-1.34393222 |
3 |
|
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
… |
|
4801 |
4.539995904 |
-0.335539221 |
-0.041293204 |
0.006901579 |
0.016443406 |
0.009127483 |
0.007765404 |
0.005503697 |
0.002536573 |
-4.211441622 |
0 |
|
4802 |
4.540020017 |
-0.365412601 |
-0.055593693 |
-0.005581289 |
0.00489903 |
-7.59133E-05 |
0.000399222 |
-0.000201105 |
-0.001700996 |
4.883247328 |
9 |
|
4803 |
4.54004413 |
-0.394572134 |
-0.069757722 |
-0.018026053 |
-0.006603165 |
-0.009224227 |
-0.0069 |
-0.005828873 |
-0.005855687 |
0.976723731 |
5 |
|
4804 |
4.540068244 |
-0.422562589 |
-0.083521407 |
-0.030194435 |
-0.017877337 |
-0.018194895 |
-0.014071937 |
-0.011380675 |
-0.009973093 |
3.067708123 |
7 |
|
4805 |
4.540092357 |
-0.448910101 |
-0.096618509 |
-0.041839092 |
-0.028713025 |
-0.026837954 |
-0.021021214 |
-0.016813492 |
-0.014050849 |
-1.84528812 |
2 |
|
4806 |
4.54011647 |
-0.473112211 |
-0.108778884 |
-0.052697661 |
-0.038860447 |
-0.034959251 |
-0.027596444 |
-0.022014738 |
-0.018011163 |
1.235914329 |
5 |
|
4807 |
4.540140583 |
-0.494671237 |
-0.119741586 |
-0.062510027 |
-0.048056638 |
-0.042345969 |
-0.03361833 |
-0.026833742 |
-0.021732907 |
2.309369853 |
6 |
|
4808 |
4.540164696 |
-0.513103612 |
-0.129259266 |
-0.071022468 |
-0.05602945 |
-0.048769409 |
-0.038881656 |
-0.031083125 |
-0.025052369 |
-2.62696334 |
1 |
Quantum |
4809 |
4.540188809 |
-0.527961819 |
-0.137106594 |
-0.077998524 |
-0.062513841 |
-0.054000634 |
-0.043172343 |
-0.034557795 |
-0.027782494 |
-0.575094764 |
3 |
Projection -> |
4810 |
4.540212922 |
-0.534467762 |
-0.140597023 |
-0.081084833 |
-0.06536278 |
-0.056299313 |
-0.04505597 |
-0.036082676 |
-0.028982339 |
3.912954379 |
7.465234605 |
We'll post the graph in a bit.
The parts of the table that you should be interested in are the 'Type =', "A =", "B =" Cells; Regression , Waves, Remainder, and Data columns.
The other information is related to how the wave were created using the 'Bidirection Mean Averaging' process.
It's not necessary to know how the Wave Matrix was created, it is necessary to understand how use it.
continues...