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? Thanks!!
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.