Register    Login    Forum    Search    FAQ

Board index » Spread Betting » Money management





Post new topic Reply to topic  [ 13 posts ]  Go to page Previous  1, 2
Author Message
 Post subject: Re: Optimising the stoploss
 Post Posted: Mon Mar 07, 2011 11:26 pm 
Offline

Joined: Fri Nov 05, 2010 8:31 am
Posts: 72
I have now simplified my EXCEL spreadsheet sufficiently to load it into google docs .
see:
https://spreadsheets.google.com/ccc?key ... 7KAL#gid=0

the way to read the spread sheet is :
Columns a to d contain 2010 data columns f to i contain 2011 data. Other columns as annotated.
The Bins columns specify the AVTR offset from the median, the median was estimated at -0.39 AVTR below the close
The probability sum column gives the probability that the stoploss is hit, since it is the sum of all the probabilities that tomorrows low is less than the stoploss.
The 2010 data was used to optimise the figures, and so to check the system works, the same figures are used on the 2011 data, the errors seem quite reasonable. However since I have only tested on one "out of range" sample this could be just down to luck.
I realised I made a typo on my last post which was kind of important since I left out a minus sign!!
it should read:
My probability data shows that the probability of hitting a stop loss set (-0.39 + K) AVTR(25) for three values of k is as follows:
K= -0.16 Probability 33%
K=-0.24 Probabilty 24%
K= -0.4 Probabilty 12.5%
Just to clarify what these final results would mean,
Set the stoploss (0.39+0.16) i.e.0.55 Avtr below close gives 33% chance of being hit the next day
Set the Stoploss at (0.39+0.24) i.e 0.63 Avtr below close gives 24% chance of being hit the next day
Set the Stoploss at (0.39+0.4) i.e 0.79 Avtr below close gives 12.5% chance of being hit the next day
Set the Stoploss at (0.39+0.96) i.e 1.35 Avtr below close gives 1% chance of being hit the next day
These values for the stoploss will seem fairly low, this is because I am only checking if the stop loss is hit tomorrow, nothing is said about the future.
All data is FTSE350 stocks EOD data from Yahoo. For real TA nerds, the AVTR function I am using doesn't use the Welles Wilder average calculation, just a plain simple Moving average.


Top 
 Profile  
 
 Post subject: Re: Optimising the stoploss
 Post Posted: Tue Mar 08, 2011 10:02 pm 
Offline

Joined: Fri Nov 19, 2010 7:24 pm
Posts: 91
OTL, another good post and that google docs is interesting stuff. I guessed that the data would be from an isolated daily viewpoint with the 1.35 ATR figure. I was going to suggest the next stage may be to investigate optimal stops on weekly and monthly data but on second thoughts would it just churn out the same 1.35 figure but on a weekly ATR?
Now knowing the 1% chance factor means we can optimise our stops even more which gives us yet another edge when establishing new positions.
My post may not make much sense, its been a long day again! But thanks OTL for all this food for thought!

_________________
Spread Betting Trader
http://spreadbettingtrader.blogspot.com/


Top 
 Profile  
 
 Post subject: Re: Optimising the stoploss
 Post Posted: Wed Mar 09, 2011 5:47 pm 
Offline
Site Admin
User avatar

Joined: Wed Nov 03, 2010 9:10 pm
Posts: 147
I just wanted to appologise that I haven't been involved in this topic so far. I read the first post, most of it went over my head and I haven't had chance to re-read it yet. I'm going to try and make some time to read everything and then make some constructive comments, If I understand it all.

Keep up the good work.

_________________
May the markets be with you!

Harry,
The Spread betting beginner


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 13 posts ]  Go to page Previous  1, 2

Board index » Spread Betting » Money management


Who is online

Users browsing this forum: No registered users and 1 guest

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Web Analytics