Preschool>= Lesson Status ?
Kindergarten>= Lesson Status ?
Elementary>= Lesson Status ?
Grade 1 Support and Resistance Levels
Grade 2 Japanese Candlesticks
Grade 3 Fibonacci
Grade 4 Moving Averages
Grade 5 Common Chart Indicators
Middle School>= Lesson Status ?
Grade 7 Important Chart Patterns
Grade 8 Pivot Points
Summer School>= Lesson Status ?
High School>= Lesson Status ?
Grade 9 Trading Divergences
Grade 10 Market Environment
Grade 11 Trading Breakouts and Fakeouts
Grade 12 Fundamental Analysis
Grade 13 Currency Crosses
- What is a Currency Cross Pair?
- Crosses Present More Trading Opportunities
- Cleaner Trends and Ranges
- Taking Advantage of Interest Rate Differential
- Obscure Crosses
- Planning Around News and Fundamentals
- Creating Synthetic Pairs
- Euro and Yen Crosses
- How to Use Crosses to Trade the Majors
- How Cross Currency Pairs Affect Dollar Pairs
- Summary: Currency Crosses
Grade 14 Multiple Time Frame Analysis
Undergraduate>= Lesson Status ?
- Why Keep a Trade Journal?
- Benefits of Keeping a Journal
- What Should You Record in Your Journal?
- Potential Trading Area
- Entry Trigger
- Position Sizing
- Trade Management Rules
- Trade Retrospective
- Trading Journal Statistics
- Reviewing Your Trading Journal
- Difficulties of Keeping a Trade Journal
- Summary: Keeping a Trade Journal
Graduation>= Lesson Status ?
- Which Trading Style is Best for You?
- Which Currencies Should You Trade?
- What is Your Level of Trading Experience?
- Should You Be a Discretionary, Mechanical, or Hybrid Trader?
- What Kind of Mechanical System Suits Your Personality?
- What is Your Attitude Towards Risk?
- What Kind of Stop Suits Your Trading Style?
DIY - Calculating Currency Correlations using Excel
As you've read, correlations will shift and change over time. So keeping on top of current coefficient strengths and direction becomes even more important.
Lucky for you, currency correlations can be calculated in the comfort of your own home, just you and your most favorite spreadsheet application.
For our explanation, we're using Microsoft Excel, but any software that utilizes a correlation formula will work.
- We're assuming that you won't be magically creating the daily price data out of thin air, but rather, will be getting it somewhere online. So, Step 1, do that! Obtain your data, say, for the last 6 months. Remember, you want data containing daily closing prices.
- Open Excel.
- Copy and paste your data to an empty spreadsheet or open the exported data file from Step 1. Get the last 6 months!
- Now arrange your data to look like the following or something similar. Colors and fonts are up to you! Have fun with this. Yellow might not be the best option though!
- It's time to decide on a time frame. Do you want last week's correlation? Last month? Last year? The amount of price data you have will dictate this, but you can always get more data. For this example, we're using the last month.
- In the first empty cell below your first comparison pair (I'm correlating EUR/USD to the other pairs, so I'm starting with EUR/USD and USD/JPY), type: =correl(
- Next, select the range of cells for EUR/USD's price data, followed by a comma. You'll be surrounding this range with a box.
- After the comma, select USD/JPY's price data range just like you did for EUR/USD.
- Click the Enter key on your keyboard to calculate the correlation coefficient for EUR/USD and USD/JPY.
- Repeat Steps 5-9 for the other pairs and for other time frames. When you're done, you can take your new data and create a cool looking table just like this. Man, that's pro-status!
The one-week, one-month, three-month, six-month, and one-year trailing periods provides the most complete view of the correlations between currency pairs. But it's up to you to decide which or how many time periods you want wish to analyze.
While it might be overkill to update your numbers every single day, unless you're a currency correlation addict, updating them at least every other week should be enough.
If you find yourself manually updating your correlation tables every hour on Excel, you might need to get out more and pick up a hobby.
While you are logged into your account,
you can save your progress in the School of Pipsology!
- What is Currency Correlation?
- How to Read Currency Correlation Tables
- Always Know Your Risk Exposure
- How to Use Currency Correlation in Your Trading
- Know that Currency Correlations Change
- DIY - Calculating Currency Correlations using Excel
- Summary: Currency Correlations