How backtesting works and what software is required?

Discussion in 'Trading Software' started by vk60546, Mar 4, 2016.

  1. vk60546

    vk60546

    sorry for a noob question, but can someone explain how backtesting is done? What would be helpful is any strategy (does not need to be profitable for this example) explained and then back tested.

    Thanks in advance.
     
  2. A fairly inexpensive way to get started is to go here: http://www.amibroker.com/ (has a 30 day free trial too)

    Also, you can use this book to help try out a few systems:

    It helps to have a programming background, but not necessary with some work.

    Good luck.
     
  3. 2rosy

    2rosy

    run you strategy over some data. you can get history from quandl.

    here's a world class winner. if the previous day was up: buy the open sell the close
    Code:
    import pandas as pd
    import numpy as np
    import Quandl
    df=Quandl.Quandl.get('GOOG/NYSE_SPY',authtoken=QUANDLTOKEN,sort_order='desc')
    df['upday']= np.sign(df.Close-df.Open)
    df['prevupday']= df.upday.shift(-1)
    df['range']= df.Close-df.Open
    df[df.prevupday>0].range.cumsum()
    
     
  4. botpro

    botpro

    +1
    There is also an active user group with over 14000 users :
    https://groups.yahoo.com/neo/groups/amibroker/info
    One can also participate without being a yahoo user, by simply subscribing via email (--> mailinglist). See above link for details.
     
  5. botpro

    botpro

    The following MovingAverage Crossover system is maybe one of the simplest systems one can design (it is from the AmiBroker examples that is part of the software):
    Code:
    period = 20; // number of averaging periods
    m = MA( Close, period ); // simple moving average
    Buy = Cross( Close, m ); // buy when close crosses ABOVE moving average
    Sell = Cross( m, Close ); // sell when closes crosses BELOW moving average
    
    And the result one can inspect on the chart (with green arrow signals indicating "buy" and red arrow "sell").
    And one can get the result also in a spreadsheet table with all the details like date, price, action etc...
    And there is a 3rd method of real backtesting with many statistical metrics...
    I would suggest to research the many texts and examples on the web...

    As already was said it has also an evaluation version for trying out.
    But be aware that you have to invest some time in setting up the database of ticker symbols that you are interested in,
    and learning the software, as is normal with any new software... IMHO half a day or so...

    It already has a demo database integrated for quickly trying out all the features...
     
    Last edited: Mar 4, 2016
  6. Sergio77

    Sergio77

    Amibroker is an excellent choice. Try some examples first and ask questions in forums. Backtesting is a tricky subject.
     
  7. Gueco

    Gueco

    quantshare is a better option
     
  8. With all the free demo's available, why back test? Your psychological mind is not in the past, but the present. Forward test and challenge your emotions.

    Na zdrowie,
    Tim
     
  9. Backtesting is applying a trading strategy on a past historical data. Try Stock Predictor software, it has free demo http://www.ashkon.com/sp.html
     
  10. jharmon

    jharmon

    Beware of survivorship bias.
     
    #10     Mar 16, 2016