backtesting

  1. C

    Stop Loss Backtesting Formula

    Hi, I’m trying to figure out a formula that I’m finding a bit tricky. I’m backtesting a trading strategy and currently focusing on optimising a stop loss percentage. I have 8.5 years worth of data and I want to be able to tweak a Stop Loss percentage number to see what would have given optimum...
  2. T

    Help With Backtesting Spreadsheet

    Hi Folks, I have a problem to solve. I have a spreadsheet that selects two funds based upon an algorithm that is applied to a basket of funds. At the close of the last trading day of the month, the new fund selections are made (sometimes they change, sometimes they remain the same...
  3. O

    Strategy backtesting: automating signals and calculating returns

    Hey guys, I am currently backtesting a volatility strategy in Excel 2007 and have stumbled upon some problems automating things. Seems hard to post a snapshot so I'm just gonna describe my sheet and problem... Column 1: 20 day moving average of volatility Column 2: 50 day moving average of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top