Open to Buy Formula by zfv15721

VIEWS: 100 PAGES: 14

More Info
									Code    Day         Date -Time         Pair   Buy / Sell      b/s        Stop   limit Lot    Open
au01    Mo    - DD/MM/YYY HH:MM      AUDUSD Buy limit                1   0.7485 0.795   1    0.75263
eu01    Tue   - DD/MM/YYY HH:MM      EURUSD Buy                      1   1.4225   1.45  2     1.4255
gu01    Tue   - DD/MM/YYY HH:MM      GBPUSD Buy                      1     1.64 1.6755  5      1.648
nu01    Mo    - DD/MM/YYY HH:MM      NZDUSD Buy stop                 1   0.6524 0.6842  3      0.667
uca01   Tue   - DD/MM/YYY HH:MM      USDCAD Sell                    -1   1.1542 1.0987  2     1.1488
uch01   Tue   - N/A                  USDCHF Sell                    -1    1.098   1.05  1    1.08074
uj01    Tue   - N/A                  USDJPY Sell                    -1    96.45     92  1      95.54
                                            Sell; Sell
Trade Day - N/A                      EURUSD limit; Sell     Sell = - Stop     Limit   #lot Open rate




              Pips PnL                 415.40    Pips       Automatic
              Amount invested        1,500,000   $          Automatic
              Total risk             ########    $          Automatic
              Total gain             4,154.00    $          Automatic
              First day                12,501    $          To set up at spread sheet creation
              Last day                 16,655    $          Automatic
              Worst loss in pips      -437.10    Pips       Automatic
              Best Profit in pips      350.00    Pips       Automatic
              Lot size                100,000    $          To set up
              Pip value                  10      $          To set up

              Note                   The data are fake in this spread sheet. This is just to let you know how to
                                     The comments here are only examples. Every trade should have one.
                                     For inaccurate results, check if the formula in the concerned cell overlaps




              Author: Henri
              Mail: kh4y3m "write the at" gmail <dot>com


                                                                            Enjoy
                      Close    Pips PnL Total risk   Expected pips    Risk     Actua    Time Statu
                        0.7764 237.70     -41.30        423.70        10.26     5.76   MT - st 1
                        1.4255   0.00     -59.40        490.00        8.25      0.00   MT - st 1
                         1.655 350.00    -400.00       1,375.00       3.44      0.88   MT - st 1
                      0.65243 -437.10    -437.10        516.00        1.18      1.00   LT - st 1
                          1.14 176.00    -108.00       1,002.00       9.28      1.63   ST - st 1
                         1.098 -172.60   -172.60        307.40        1.78      1.00   ST - mt 1
                        92.926 261.40     -91.00        354.00        3.89      2.87   ST - st 1

                    Close rate   #VALUE! #VALUE!       #VALUE!       #######   ##### ST / MT -1 or
                                                         0.00        #DIV/0!   #####
                                                         0.00        #DIV/0!   #####
                                                         0.00        #DIV/0!   #####




is just to let you know how to
ry trade should have one.
in the concerned cell overlaps
          Comment             Trade


I win less than I agreed to           0
                                      4
Code    Day         Date -Time         Pair   Buy / Sell      b/s        Stop   limit Lot    Open
au01    Mo    - DD/MM/YYY HH:MM      AUDUSD Buy limit                1   0.7485 0.795   1    0.75263
eu01    Tue   - DD/MM/YYY HH:MM      EURUSD Buy                      1   1.4225   1.45  2     1.4255
gu01    Tue   - DD/MM/YYY HH:MM      GBPUSD Buy                      1     1.64 1.6755  5      1.648
nu01    Mo    - DD/MM/YYY HH:MM      NZDUSD Buy stop                 1   0.6524 0.6842  3      0.667
uca01   Tue   - DD/MM/YYY HH:MM      USDCAD Sell                    -1   1.1542 1.0987  2     1.1488
uch01   Tue   - N/A                  USDCHF Sell                    -1    1.098   1.05  1    1.08074
uj01    Tue   - N/A                  USDJPY Sell                    -1    96.45     92  1      95.54
                                            Sell; Sell
Trade Day - N/A                      EURUSD limit; Sell     Sell = - Stop     Limit   #lot Open rate




              Pips PnL                 415.40    Pips       Automatic
              Amount invested        1,500,000   $          Automatic
              Total risk             ########    $          Automatic
              Total gain             4,154.00    $          Automatic
              First day                12,501    $          To set up at spread sheet creation
              Last day                 16,655    $          Automatic
              Worst loss in pips      -437.10    Pips       Automatic
              Best Profit in pips      350.00    Pips       Automatic
              Lot size                100,000    $          To set up
              Pip value                  10      $          To set up

              Note                   The data are fake in this spread sheet. This is just to let you know how to
                                     The comments here are only examples. Every trade should have one.
                                     For inaccurate results, check if the formula in the concerned cell overlaps




              Author: Henri
              Mail: kh4y3m "write the at" gmail <dot>com


                                                                            Enjoy
                      Close    Pips PnL Total risk   Expected pips    Risk     Actua    Time Statu
                        0.7764 237.70     -41.30        423.70        10.26     5.76   MT - st 1
                        1.4255   0.00     -59.40        490.00        8.25      0.00   MT - st 1
                         1.655 350.00    -400.00       1,375.00       3.44      0.88   MT - st 1
                      0.65243 -437.10    -437.10        516.00        1.18      1.00   LT - st 1
                          1.14 176.00    -108.00       1,002.00       9.28      1.63   ST - st 1
                         1.098 -172.60   -172.60        307.40        1.78      1.00   ST - mt 1
                        92.926 261.40     -91.00        354.00        3.89      2.87   ST - st 1

                    Close rate   #VALUE! #VALUE!       #VALUE!       #######   ##### ST / MT -1 or
                                                         0.00        #DIV/0!   #####
                                                         0.00        #DIV/0!   #####
                                                         0.00        #DIV/0!   #####




is just to let you know how to
ry trade should have one.
in the concerned cell overlaps
          Comment             Trade


I win less than I agreed to           0
                                      4
                                                      b/                      Lot     Open
              Date -Time
Code Day - 29/07/2009 19:59       Pair     Buy / Sell s     Stop     limit     s      Price         Close
         - 30/07/2009 11:33
uj01 Thu - 31/07/2009 15:30     USDJPY Sell            -1   96.42      94.7     1          95.7          94.7




          Pips PnL               100.00 Pips          Automatic
          Amount invested          1    K$            Automatic

          Total risk            -720.00 $             Automatic

          Total gain            1,000.00 $            Automatic

          First day              45,300 $             To set up at spread sheet creation

          Last day               46,300 $             Automatic

          Worst loss in pips     100.00 Pips          Automatic

          Best Profit in pips    100.00 Pips          Automatic

          Lot size              100,000 $             To set up

          Pip value                10      $          To set up




                                                                               Specification of all co
             Column name                                                                                                    Description

                                Write a two or three letter code, with letters of the pair you trade. eu01 for the first trade on eurusd
          Code                  code eu001. This will let you sort you trades per pair.

          Day                   Writing the first three digits of the day the trade opend may be usefull.
                                Write the date and time for the three events, when: the order has been set up, the first dash; the o
          Date -Time            position is closed out, this is the last dash.

          Pair                  Write the currency pair involved in the position. As usual: EURUSD, or USDJPY

          Buy / Sell            Write Sell; Sell limit; Sell stop; Buy; Buy limit; Buy stop and set up a conditionnal color which matc

          b/s                   If long (buy or b) write 1, if short, write -1. This will let the formulas give actual results.

          Stop                  Rate of the stop order.

          limit                 Rate of the limit order.
Lot(s)              Number of lots for the position.

Open Price          Rate of the position, which should be equal to the rate of the order or trade.

Close               Write the close rate when the position is closed out. Don't forget to write the date - Time the positi

Pips PnL            This cell gives the PnL in Pips.

Total risk Pips     This cells displays the total risk you took for all the trades in the spread sheet.
Expected pips pnl   This is the PnL you expect for the position, regarding open rate and limit rate.
Risk Reward         This number displays a coefficient. This is a ratio beetween what you expect to win and what you
Actual Risk         This the risk reward of this closed out position let you know if you close the trade too early regardi
Time frame          Two indication are given in this cell. the first one is how long you expected staying in position, and
Status              The status is meant by one number: -1, the ordre is not yet triggered; 0, the position is opened; 1,
Comment             Living a comment about a trade is usefull. Why the trade, which strategy, and every thing else to l
Trade rating        Check a scale, from 1 to 5 or 1000 and rate your trades to analyse why you won, and why you los

         How to     - IT IS VERY IMPORTANT TO CHECK THAT THE CONSTANT NUMBER IN THE PNL FORMULA IS 100 F
                                                                         Actua
                                Total risk     Expected pips       Risk l Risk        Time    Statu
                       Pips PnL   Pips             pnl            Reward Rewa        frame      s               Comment

                        100.00      -72.00         100.00           1.39     1.39     MT        0     Posted on twitter.




pecification of all columns
                                   Description

 pair you trade. eu01 for the first trade on eurusd. If you plan having more than 100 position on one pair a month, just write the
pair.

pend may be usefull.
n: the order has been set up, the first dash; the order has been triggered and so the position is open, this is the second dash; the



s usual: EURUSD, or USDJPY

 stop and set up a conditionnal color which match with your feelings about what color is a sell or a buy.

 let the formulas give actual results.
 rate of the order or trade.

ut. Don't forget to write the date - Time the position closed.




e trades in the spread sheet.
 ing open rate and limit rate.
beetween what you expect to win and what you could loose. so, this is explaining you you can win regarding what you can loose.
you know if you close the trade too early regarding what you expected or if you let the limit be triggered. In a second way, you can
s how long you expected staying in position, and the second one, what really happend. So for instance, If you write LT - st, this
is not yet triggered; 0, the position is opened; 1, the position is closed. So, you can sort you trades to gather those which are in
e trade, which strategy, and every thing else to let you save data about your trades.
 rades to analyse why you won, and why you lost.

NSTANT NUMBER IN THE PNL FORMULA IS 100 FOR THE USDJPY AND 10000 FOR ALL OTHER PAIRS.
    Trade
    rating

     3/5/2009




    Auto /
    Manual


m

m

m

m

m

m

m

m
m

m

m

a

a
a
a
a
m
m
m
m

								
To top