Scribd Logo
Upload

Welcome to Scribd!

  • 134 views

    Money Management Calculator 2.0: 1. Float Details 2. Trade Details

    Uploaded by

    Pierre van Wyk
    The document provides details on using a spreadsheet to manage money and trades, including sections for float details, trade details, stop loss analysis, and trade analysis and logs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Money Management Calculator 2.0: 1. Float Details 2. Trade Details

    Uploaded by

    Pierre van Wyk
    134 views8 pages
    The document provides details on using a spreadsheet to manage money and trades, including sections for float details, trade details, stop loss analysis, and trade analysis and logs.

    Original Description:

    Money Management calculation

    Original Title

    Mm Spreadsheet

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides details on using a spreadsheet to manage money and trades, including sections for float details, trade details, stop loss analysis, and trade analysis and logs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    134 views8 pages

    Money Management Calculator 2.0: 1. Float Details 2. Trade Details

    Uploaded by

    Pierre van Wyk
    The document provides details on using a spreadsheet to manage money and trades, including sections for float details, trade details, stop loss analysis, and trade analysis and logs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 8

    Money Management Calculator 2.

    0
    1. Float Details Float % Risk Max $ Risk $102,319 2.5% $2,558 2. Trade Details Units $ Entry Brokerage Total Cost 3. Stop Loss Analysis ATR Value ATR Multiple Initial Stop % Max Loss $ Max Loss $0.05 3.0 $3.350 -4.64% -$2,557.97 % Return $ Profit 8.76% $4,830.34 4. Trade Analysis $ Exit Risk/Reward 1: 1.89 $3.82 15720 $3.50 $100.00 $55,119.35

    Important: Edit only the blue cells. The black & red cells are automatically calculated.

    How To Use This Spreadsheet:

    1. Float Details Set your trading float size (Float) and how much you are willing to risk on a trade (% Risk). 2. Trade Details Set your entry price ($ Entry) and brokerage rate (Brokerage). 3. Stop Loss Analysis Enter the value of the trades' ATR and the multiple of that ATR (ATR Multiple). If you're not using the ATR method simply enter y 4. Trade Analysis Enter your exit point ($ Exit). Advanced Users: This spreadsheet has not been 'locked' so you are free to tailor it to your own needs. Copyright 2009
    www.trading-secrets-revealed

    ou're not using the ATR method simply enter your initial stop manually into 'Initial Stop'.

    Trade Log
    www.trading-secrets-revealed.com

    No. Wins: No. Losses: Avg Result: Avg Profit: Avg Loss: Win/Loss Ratio:

    2 1 $440.00 $1,565.00 $1,810.00 2

    66.7% Number of Trades: 33.3% Avg Trade Size: Avg Trade (days): No. Trading Days: Avg No. Per Week: Open Positions:

    3 $12,196.67 35.3 1391 0.02 $0

    Initial Capital: Additional Capital: Subtracted Capital: Total Cash Input: Current Worth: Profit/Loss: Net Profit:

    BUY
    Code
    XXX YYY ZZZ

    SELL
    Brokerage
    $30.00 $30.00 $30.00

    Date
    1/9/2009 15/9/2009 1/10/2009

    Quantity
    2,000 3,500 5,000

    Price
    $5.000 $4.000 $2.500

    Taxes

    Total
    $10,030.00 $14,030.00 $12,530.00

    Date
    2/10/2009 25/9/2009 5/12/2009

    Price
    $6.00 $3.500 $2.750

    ade Log
    Initial Capital: Additional Capital: Subtracted Capital: Total Cash Input: Current Worth: Profit/Loss: $100,000 $0 $0 $100,000 $101,320 $1,320.00 1.32% Profit: Loss: Brokerage: Taxes: $3,130.00 $1,810.00 $180.00 $0.00

    secrets-revealed.com

    SELL
    Brokerage
    $30.00 $30.00 $30.00

    Taxes

    Total
    $11,970.00 $12,220.00 $13,720.00

    Profit/Loss
    $1,940.00 ($1,810.00) $1,190.00

    Percent
    19.34% -12.90% 9.50%

    Days
    31 10 65

    You might also like