Page 1 of 1

USDJPY Pivot Study

Posted: Sat Nov 29, 2008 8:26 pm
by razorboy
Here is a little two week study i did of USDJPY prices using pivot points as your entry and various sorts of exits as listed below. The spread sheet has over 3000 5 minute periods in it

This involves taking every trade on every candle, rules are explained below and I have included the spread sheet, please review it. I am not a good excel programmer (I am not even a bad programmer, that is how bad i am). I have broken the trades out into shorts and longs. please go thru the sheet and pick out any errors you think there are.

1 is a long trade, 2 is a short trade

Profits
Without Stop Loss or commissions
Long Trades Long on open if open price is above pivot of previous period, cover on close 8036.6 pips
Short Trades Short on open if open price is below pivot of previous period, cover on close 7874.6 pips
total 15911.2
Profits
Without stop loss but a 4 pip commission
Long Trades Long on open if open price is above pivot of previous period, cover on close 1332.6 pips
Short Trades Short on open if open price is below pivot of previous period, cover on close 870.6
total 2203.2 pips





Profits
With Stop loss and commission
Stop loss = mid point of previous candle

Long Trades Long on open if open price is above pivot of previous period cover on close or stop loss -5373.3 pips
Short Trades Short on open if open price is below pivot of previous period, cover on close or stop loss -6285.2 pips
total -11658.5 pips