How to backtest if you do not know how to code

Is it possible to backtest without knowing how to code

  • Yes

    Votes: 13 65.0%
  • No

    Votes: 5 25.0%
  • I don't know

    Votes: 2 10.0%

  • Total voters
    20
I'm a little confused as to why your looking for? You say your manually backtesting already so what's the issue?

A programmed backtester simply takes an input logic and iterates the data looking for a buy or sell signal and that is it. Gets more complicated in the portfolio side.

So if you want to manually backtest.... Just scroll the chart revealing a bar until a buy / sell signal occurs.

What exactly are you looking for in an answer.

Where did I say that I am manually backtesting already
 
Ok, great!

Can you give us an example/sample rule, not your exact rule if you want to keep your secret sauce hidden? I'll try to demonstrate how to convert your rules into spreadsheet formulas.

Using the examples, you should be able to customize them for your exact rules.

So far, it seems this will be eligible for 'instant' backtesting...rather than 'row-by-row.'

EDIT: I'll also need to know what instrument to use...something I can download from Google would be nice.


I hope you realize I dont have OHLC values on my excel, and that I simply record the entry and exit prices based on what I have visualized on my actual chart..

@userque
 
I hope you realize I dont have OHLC values on my excel, and that I simply record the entry and exit prices based on what I have visualized on my actual chart..

Ok. Once I see sample rules similar to your actual rules, I'll be able to determine whether I can represent those rules using only OHLC data. I would need rules, not your entry and exit logs. :)
 
Ok. Once I see sample rules similar to your actual rules, I'll be able to determine whether I can represent those rules using only OHLC data. I would need rules, not your entry and exit logs. :)

ok but I dont have data on my excel sheet get it?

the sheet is just a log of trades which I recorded after looking at the chart essentially

@userque
 
Ok. Once I see sample rules similar to your actual rules, I'll be able to determine whether I can represent those rules using only OHLC data. I would need rules, not your entry and exit logs. :)


I would appreciate if I could pm you the rules...


@userque
 
ok but I dont have data on my excel sheet get it?

the sheet is just a log of trades which I recorded after looking at the chart essentially

Ok. Forget about spreadsheets for a minute. I'm just asking for you to post your rules. Vary them a bit if you want to keep them secret. They don't have to be in a spreadsheet. If you can articulate your rules in plain English, I can possibly port them into a spreadsheet myself. :)

Just so we are on the same page:

I have exact rules for going long, exact rules on calculating my stop, exact rules for calculating my target.
 
Back
Top