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

I

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?

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.
 
You must log in or register to reply here.
Back
Top