Hi.
I did historical backtesting of a financial instrument and would like to plot the results in a meaningful way. The data looks like that:
lzPJd77QQtyDeFc4yNcLyQ.png
Without going into details, I calculated the profit for every combination of a so-called BUY-LEVEL from 0.1% to 10% (0.1% steps) and SELL-LEVEL from 0.6% to 10% (0.1% steps).
Basically, I would like to have a graph that emphasizes/gives a hint which combinations are the most profitable.
Does anybody know of a good plot in Excel that can visualize what I would like to have?
My first idea (paper&pen) was BUYLEVEL on x-axis, SELLLEVEL on y-axis and profit on a 2nd y-axis on the right side. However it would be misleading and not plotted correctly, since SELL-LEVEL&Profit are not independent events.
I am very thankful for any hint (also on theory/examples of financial plotting, or similiar)
Cheers
Bookmarks