Forex Market Analysis Spreadsheet

This is our official forex market analysis spreadsheet that we use during our Monday night webinars.  This forex market analysis spreadsheet can be filled out manually fairly quickly for one group of currency pairs. For example you can analyze the USD pairs quickly with this spreadsheet (USD/JPY, USD/CHF, USD/CAD, etc.) Then you can repeat the process on any currency using the same simple procedures. The spreadsheet combines multiple time frame analysis with individual currencies to get a total handle on the current market conditions. It is truly the most thorough method of forex market analysis, and far superior to any forex technical analysis. The spreadsheet simplifies the market analysis process and  works for  8 currencies across 28 pairs.

Download The Spreadsheet

The analysis spreadsheet is a Macro Enabled Excel sheet for use with Microsoft Office version 2007 or newer. Microsoft Excel is not forex market analysis software, it is spreadsheet software that we have adapted for our market analysis method. Click on the link and the analysis spreadsheet will open and load into your browser. Then if you click on it, it will display on the screen in any browser, you can then save it to your hard drive if you wish.

How To Fill Out The Spreadsheet

First of all make sure you have downloaded the metatrader platform and set up the  free trend indicators that we provide.  To fill out the spreadsheet, print a hard copy, then arrange the 28 currency pairs in the order of listed on the sheet.  For example, start with the EUR/USD, then the GBP/USD etc. Once you have all 28 pairs set up you can open up the spreadsheet with Microsoft excel.  The first time you open the document you will have to enable Macros.  This is usually a button near the top of the sheet that’s says “enable content”. You are now going to list the trend direction on the H4, D1, and W1 timeframes for each currency pair.  Under each timeframe you will be given 3 simple options:

1) UP = Uptrend 2) Down = Downtrend 3) NO trend.

Forex Analysis

Forex Market Analysis

Once you fill out the 3 time frames for each currency pair. Look at the graphs on the right and see if they match up with the examples. If they completely line up on a specific time frame, then it represents the individual currency is completely strong or completely weak and trending on that specific time frame.  That would encourage you to do a more though analysis on that currency to see if what pairs can be part of your daily trading plans.

Spreadsheet Overview

The sheet is broken into 2 areas.  The first area on the left is a list of 28 pairs with the 3 major time frames listed.  There are drop down boxes in each time frame that allow you to identify the trends.  You simply identify the trends for 3 major time frames in all 28 pairs.

Forex Market Analysis Spreadsheet

Forex Market Analysis Spreadsheet

This information auto populates the second area on the (right side).  This area consists of grids that represent individual currencies. There is a guide on the far right of these grids which you use to compare to see if there is consistent individual currency strength or weakness.  These individual currency grids and guides are set up to look like The Forex Heatmap®.  This will aid in the visual recognition of the alignment of the individual currency strength and weakness at analysis and allow accelerated mastery at trade entry of the Forex Heatmap®. We use The Forex Heatmap® for our trade entry management. By analyzing the forex market this way, the analytical method matches the entry method we use, so everything in our trading system is consistent.

Forex Market Analysis

Forex Market Analysis Spreadsheet

Practicing Market Analysis

Every Monday night we show you how to use the spreadsheet and practice analyzing the market on one currency in our live forex webinars. Any forex trader can join us for these webinars to see how we analyze the market daily to prepare our daily trading plans. These webinars are video recorded and archived.

Individual Currencies Versus Pairs

Every currency pair consists of two separate currencies, each currency has different properties.  For example the EUR/USD has the EUR is an individual currency and the USD is an individual currency. You trade the pair but you must analyze the two currencies separately before trading.  Most traders look at the pair but do not separate the currencies for analysis.  You must separate them in order to find the individual currency strength or weakness, to give you the best possible currency market analysis, and pair analysis.  To analyze the EUR individual currency you must find all seven major currency pairs with the EUR on the left.  When you look at all the seven pairs containing the EUR and analyze them based on just the EUR you can discover whether the EUR individual currency is strong, weak, neutral or mixed.  This can become a little challenging to keep track of when you are new to parallel and inverse analysis.  That is where the spreadsheet becomes very handy.  Just by providing the Trends on the 28 pairs on 3 time frames, it will automatically “Separate” the currency Pairs information into the Individual currencies and provide a simple visual map of the forex that looks just like The Forex Heatmap®.

The spreadsheet simplifies parallel and inverse analysis for any level forex trader, and provides an easy to use visual guide for individual currency strength and weakness via inspection of the major trends. All you have to do is identify the 3 large trends, or lack of trend on all 28 currency pairs. This tool will easily allow you to analyze the major trends of currency pairs and have it automatically split that information into the individual currencies and show you the Individual currency strength and weakness. You quickly can compare the results to the visual guide examples in the sheet.  This simple sheet it will make l feel like a parallel and inverse veteran and you will know whether the individual currencies strong weak or mixed?  You will have more information than 95% of all forex traders do, plus you create a consistent approach in your forex analysis today, tomorrow and every day. After you are finished filling our the spreadsheet you can easily figure out what pairs have a higher probability of continuing their trends, and you can write a trading plan for that pair accordingly.

Avatar for Mark Mc Donnell
About Mark Mc Donnell
Mark Mc Donnell is the founder of Forexearlywarning, we provide spot forex trading plans and signals across 28 currency pairs.

Comments are closed.