Aah bukak Chapter 6 page 78
extract dari buku tu
CALCULATING CORRELATIONS YOURSELF
Because correlations have a tendency to shift over time, the best way to
keep current on the direction and strength of your pairings is to calculate them yourself. Although it might seem like a tricky concept, the actual process can be made quite easy.
The simplest way to calculate the numbers is to use Microsoft Excel. In Excel, you can take the currency pairs that you want to derive a correlation from over a specific time period and just use the correlation function. Taking the one-year, six-month, three-month, and one-month trailing readings gives the most comprehensive view of the similarities and differences between pairs; however, you can decide which or how many of these readings you want to analyze.
Breaking down the process step-by-step, we’ll find the correlation between the USD/GBP and the USD/CHF.
First you’ll need to get the pricing data for the two pairings. To keep
organized, label one column GBP and the other CHF and then put in the
weekly values of these currencies using the last price and pairing them
with the USD for whatever time period you want to use. At the bottom
of the two columns, go to an empty slot and type in =CORREL.
Highlight all of the data in one of the pricing columns, type in a comma, and then do the same thing for the other currency; the number produced is your correlation. Although it is not necessary to update your numbers every day, updating them once every couple of weeks or at the very least once a month is generally a good idea.