The process of evaluating a strategy, theory, or model by applying it to historical data.

learn more… | top users | synonyms (1)

4
votes
1answer
143 views

Getting ETF data from google finance

I hope this is on-topic. I want to set-up a set of investment rules and back-test it on a mix of asset-classes. Thus I thought that using ETFs for the back-test would be a good idea (time series could ...
3
votes
0answers
75 views

How to optimize return in a moving average crossover algorithm

Moving average crossover strategy is a widely used strategy in algo trading. Is there a way to optimize return in a moving average crossover stratergy. I have used this site to backtest MA crossover ...
-1
votes
1answer
30 views

Monthly Return Net of Fees [closed]

How can I calculate the monthly return net of fees if the fee is annual?For example, if every year there is a 20% incentive fee, is there a formula to adjust the return of each month to compensate for ...
1
vote
1answer
32 views

importing columns of returns data into python from excel/csv [closed]

I'm fairly new to the quant finance space, and I was hoping to get some guidance. Say I have a csv/excel file with columns of daily returns data for various asset classes or securities (one column per ...
3
votes
1answer
63 views

Methodology for handling short american options in a back test

Given that an American option can be exercised at any time, how does one handle algorithmically shorting an American option in a back test? I am not sure what the best practice is to simulate the ...
1
vote
1answer
60 views

Limits on Short selling

When back testing an algorithm that relies upon short selling certain stocks, how to limit the short selling so that the back-test results still remain reliable? What kind of controls are generally ...
3
votes
1answer
101 views

Question about historical volatility ranking

I have seen this strategy example, which uses garch in a regime switching context: https://systematicinvestor.wordpress.com/2012/01/06/trading-using-garch-volatility-forecast/ The author classifies ...
6
votes
0answers
160 views

Here is an approach for measuring Data Snooping; is it new?

I came up with an approach for measuring data snooping, or overfitting. My question is whether this approach was published and expanded-on already, or is it new? My approach relies on the observation ...
1
vote
1answer
63 views

Daily or weekly data?

I am trying to test a strategy but do not know if I should use daily or weekly data? I have tried researching this & have found that daily data will bring " too much " noise compared to lower ...
3
votes
1answer
177 views

Backtesting on historical option data

I have downloaded some daily historical option data for a timespan of 10 years and want to perform trading backtests with them. Data are European index options, on ODAX. My question is about realistic ...
1
vote
1answer
96 views

Simulating Stock's close, high and low prices

I am testing a model in which I need to simulate closing, high and low prices (i.e. 3 dimensions of prices) of any given stock. Using the simple Geometric Brownion Motion equation I can easily ...
1
vote
0answers
101 views

Are there any software libraries for backtesting FX algorithms against tick data?

I've read question, however it doesn't appear as if any of those libraries work for FX data. A Google search for python forex backtesting turns up this project, ...
3
votes
1answer
710 views

Learn backtesting using MATLAB

What are some good ressources (books, articles, ...) to learn backtesting of investment strategies using MATLAB ? It can be strategies related to fixed-income, equities, derivatives, ... whatever. ...
0
votes
1answer
82 views

Backtesting software with custom data input

I was considering to develop a custom backtesting platform for myself. However, I see that it would require some significant time and effort, and the result might not be as initially expected. So I ...
1
vote
0answers
52 views

How to compare market values with model values after calibration?

After calibration the G2++ model for interest (with swaption volatilities), I want to statistically test the quality of the calibration by comparing market to model values. What is the best way to ...
1
vote
0answers
66 views

Adjusting for your own orders in future backtests

I was asked this question in an interview and despite thinking about it for a while, I haven't been able to come up with a good answer. Suppose you have a strategy you are running where at certain ...
3
votes
1answer
140 views

Overlapping Value-at-Risk Backtest Data an Issue?

My understanding of VaR model back testing is thus: ~~ t: Calculate daily VaR using look back data over n past days t+1: Compare daily return against VaR, record breach if one occurred, repeat ...
1
vote
1answer
96 views

Calculation of Returns and Risk Metrics for L/S Portfolio

I am trying to build a test for a long/short portfolio. I am aiming for market neutral and have put together a long portfolio as well as a short portfolio (see below). However, I am not sure if I am ...
0
votes
2answers
141 views

Long/Short Backtesting Set up

I am going to be backtesting a Long/Short equity strategy and need some guidance on how best to deal with the short book. I was thinking that for each portfolio I would go long 50 equities and go ...
3
votes
1answer
93 views

How to compute daily compounded backtest returns closer to real-world results?

I often run quick tests of trading strategies in my analytics suites by: multiplying a vector of signal (lagged, {-1,0,1}) with a time series of daily percentage returns doing a cumulative product ...
0
votes
0answers
193 views

How to calculate returns of backtested strategy?

Lets say I have some strategy (long/short) backtested for certain period. Strategy has entries/exits only at the end of the day and may have overnight positions hold. Now I would like to compare ...
1
vote
1answer
239 views

Analog - Pattern Recognition model using KNN

I'm building a pattern recognition model for my master thesis. The idea is to build a framework with some Macro variables (long/short term rates; rates differential; equity; fx; vix) in order to find ...
0
votes
1answer
149 views

What data should be used for regression-based model backtesting?

I ran regressions using historical valuation data and now want to backtest the models I came up with. Are there any issues with using the same historical data set for the backtest that I need to be ...
2
votes
2answers
268 views

How to select optimal betting strategy from backtest?

I have written a model for predicting the winner of UFC fights. My model calculates the probability of each fighter to win a given match. I have back tested the model and found it to be very ...
4
votes
2answers
138 views

Back-testing Value at Risk with a WML investment strategy

I'm currently taking a course in Financial Econometrics and there is a question in the lecture notes regarding back-testing of VaR which I'm have difficulty with. First of all the procedure for ...
1
vote
1answer
426 views

How to fully replicate ADX + DI Indicators in Excel?

For black box testing, I was hoping that I could replicate the ADX + DI+ and DI- indicators that are provided in trading platforms such as ThinkOrSwim, ScottradeElite etc. However, I noticed that ...
4
votes
0answers
157 views

What is the most convenient data structure for backtesting a model of futures options prices?

I have an empirical model for the dynamics of futures prices in a particular market that I have implemented using a long series of the front five contracts. (I account for the roll in my model.) I ...
1
vote
2answers
507 views

Backtesting with Simulated Historical Data?

The trading strategies that are going to backtest well are the ones that pick the winners from the past. For example, if a trading strategy simply bought apple stock it would backtest extremely well. ...
3
votes
1answer
298 views

How to find optimal look back in quant trading models

I'm in the process of building a quantitative trading model, I want to improve on the way in which I decide upon a look back length for the indicators. I understand the different pros/cons for very ...
1
vote
3answers
512 views

Handling Missing values in stocks returns when estimating the co variance matrix

What is the best way to handle missing values when stocks did not exist for the entire historical period?.
1
vote
1answer
173 views

Plot Evolution of portfolio weights over time in R [closed]

Is there any function for plotting the evolution of portfolio weights over time in r?. I have a matrix of portfolio weights from an equal weighting strategy at rebalancing times and want to plot ...
2
votes
1answer
598 views

Backtesting with fundamentals

Recently I've read some books about quantative approach to fundamental investing: - What works on Wall Street - James O'Shaughnessy - Quantitative Value - Wesley Gray, Tobias Carlisle - Quantitative ...
2
votes
2answers
287 views

Backtesting Period

Views on timeframes for backtesting vary considerably. Curious on what timeframe/trade size leads to a statistically significant result. For example, what backtest period is reasonable for a system ...
0
votes
2answers
153 views

Sharpe Ratio and time spent in loss

Is it possible to express, given an annualized Sharpe Ratio value, what is an expected maximum/average time spent in a draw-down or something in this manner? E.g. with SR of 10, you'd expect to spend ...
0
votes
1answer
181 views

How to backtest the VaR model?

I have a sorted historical P&L vector of 250 days and say, I want to calculate the 90% VaR on this distribution. I will look for the 225 element (90% * 250 = 225) and this will be my Value at ...
1
vote
2answers
459 views

Machine Learning on matlab 2010

I am trying to develop a trading model. It uses certain technical and fundamental features and the model learns from the past. I have a 3-class output - bullish, neutral and bearish. On trying neural ...
5
votes
3answers
778 views

Expected Shortfall (CVaR) Backtesting

I am writing my thesis on VaR and ES risk measurements and have encountered some issues with how to best test the accuracy of ES estimates. My understanding of the topic is that backtesting ES ...
1
vote
0answers
248 views

Comparing Backtests of Value-at-Risk and Expected Shortfall

My goal is to test if ES (CVaR) empirically is a better risk measure than VaR for a set of given variables (assumed underlying distribution, confidence level, sample size) for different asset classes. ...
0
votes
1answer
432 views

backtesting with open, close, high and low

I am quite notice at the business of backtesting for an automated strategy. I was wondering, can I/should I use High and Low for this purpose? On one hand, the algorithm will see these prices, but on ...
0
votes
1answer
258 views

adjusted close prices on SP500

When I look at the adjusted close prices of SP500, for example, I notice that the numbers are always significantly below the actual closing. In the explanation of what adjusted prices are, one gets ...
0
votes
1answer
89 views

How do I take an unbiased, sector neutral sample from a stock index?

I am looking to take a cross sector subset of a larger stock index universe. What steps to I take to assure that sector representation is as equal as possible to help smooth out my variance(while ...
4
votes
0answers
554 views

Testing Valuation, Size and Momentum (proprietary factors) from 1988-2013: No evidence of driving cross-sectional returns

I am currently testing whether three proprietary factors - Valuation, Size and Momentum - explain cross-sectional returns. A sample of 3000 securities was tested using Fama-MacBeth two-pass ...
3
votes
1answer
232 views

How to design back-testing (validation) for such modified Vasicek model?

Consider a classical Black Scholes model , $$\frac{dS}{S} = \mu dt + \sigma dW$$ , where $dW$ is a Brownian motion, that $W(t_1) - W(t_0) \sim N(0, t_1 - t_0)$. The back-testing strategy is ...
4
votes
3answers
562 views

Backtesting - can you buy/sell at open and closing prices?

In backtesting (nasdaq stocks), I make the assumption that I have the ability buy/sell each day at the opening and closing prices. Is this realistic?
1
vote
2answers
117 views

how to make a distribution model tolerable of trend?

I'm building an model on different loans' NPL rate. The problem is NPL rates are always affected by the market. When NPL rates move in trend, my model will fail the back-testing. Assuming $x(t)$ is a ...
3
votes
3answers
320 views

How to most optimally perform currency conversions when backtesting on portfolio level?

I am currently expanding my own strategy profiling and testing platform which partly consists of a portfolio backtesting module. The backtest engine processes tick based data (quotes for currencies, ...
-2
votes
2answers
526 views

How to get/estimate ask/bid price for backtesting for OHLC data? [closed]

As you know, most of the EOD data available have only OHLC price. I used to do back-testing using the Close price as both bid and ask. however, in real world, the bid and ask spread is huge and the ...
3
votes
4answers
1k views

IB TWS & API, without IB account?

I'll be starting a MFE grad program in Fall, and some of the classes have a lab that use the IB TWS & API. I'd like to play around with it for fun this summer. Unfortunately, I don't have an IB ...
2
votes
2answers
1k views

backtesting options strategies in R

I would like to backtest an options strategy in R. I require the ability to delta hedge and rebalance to options in the portfolio at different frequencies (daily, monthly,etc.) What packages are the ...
-2
votes
1answer
400 views

How to test the efficiency of Exponential Moving Averages as a trading startegy? [closed]

I would like to know how I can test the efficiency of Exponential Moving Averages when it comes to forex trading. Can i have any papers that point to the efficiency of this strategy? Thank you. :)