Question about Excel: how to show Signals on a chart?

Discussion in 'Automated Trading' started by imbetbm, Jul 14, 2009.

  1. imbetbm


    I just finished backtesing my idea using Excel 2007 and the results look pretty satisfactory, but I want to show those buy/sell signals on a chart so that I can better visualize if I have correctly captured the price actions that I intended to, and do future analysis.

    I have googled around for a while, but no solution found.

    Can somebody help me with this?

  2. Price Buy Sell
    45 0 0
    46 46 0
    47 0 0
    46.5 0 0
    48 0 0
    47.5 0 47.5
    46 0 0

    Supposed you bought @ 46 and raised stop to 47.5.
    Plot price in black with a continuous line, buy with blue dotted lines (show dot but not line) and sell with red dotted lines.