Search results

Hey guys , has any one on here seen/developed a stock screener using Exel?

Hey db, The past backtests selling strategy was an indicator. What I am doing now is using the same "entry" signal as the backtest, but changing the "sell" signal , from what was an indicator previously , to the 3:1 reward/risk ratio. Aiming for many small wins often , risking $1 to...

Hey all thanks for the helpful replys! The back tests exit was not based on a r:r ratio, instead it was based on an indicator eg. Sell when price closes through indicator XYZ, which meant the exit was always different. This was a trend following backtest but i noticed the entrys where...

Hey BigFunky, Yes I realise that, but it was the entries I was more focused on. The exit strategy I have, and the exit strategy with the back test are different due to me being unable to quantify the exit side of my strategy. So in the end the Annualised return and max DD , MAR ratio...

Hey toolazy, Forward testing is underway. I certainly agree with you about splitting my capital into 10 (or there about, Splitting the 10% into to chunks of 5%,5% (Or whatever % of capital I use, I will split into 2 equal sizes.) Will suit me more. Putting first 5% on a trade, once...

Hey guys, I ran a few backtests a while ago (but with limited flexibility in terms of parameters), and was able to find a strategy with a pretty high W/L % (based over 10 years od DOW data) Now, do you guys think its possible to use the strategy which gave the W/L % and apply a...

The one and only jack hershey, it is an honour! Yes since i first posted and started this thread i have been making up excel spreadsheets , of historical data from certain stocks, calculating the true range, then calculating the ATR over "X" time frame , and multiplying the ATR x 1.5, to...

Anyone here use VBA via Excel to test trading strategies/backtest/calculate probabilities etc Just wondering before I dive head first into it! xxoxoxoxooxxooxoxxo

Hey guys just a quick question, How different from doing a "finance degree" is an "Applied Finance" degree? What are the differences ? Is one more beneficial for a career in finance than the other? Cheers guys, just the the community college in my area only has applied finance papers.

The commissions are set to $15 per trade each way, which is the brokerage fee here in Australia which is found in the bottom right corner of the results I uploaded. I cant adjust the slippage nor the interest % :(

Wow, thanks for the info! Im still working away , I am able to achieve a calmar ratio of .5 which is a lot better then the .14 I achieved in my first backtest posting. I am beginning to think I need better software to back test more "specific" details rather than [Buy when Close price...

What are yours guys thoughts on some good software to backtest strategies on? Cheers xxoxxo Gossip Girl

Hey guys , currently back testing strategies and my win% are high , but I really want to get my max drawn downs lower but I cant seem to get any lower than 45%? Anyone been stuck at this also? The only indicators I can test at the moment are MA/EMA/BB

Getting better

Or ....

Automate my system and lets move to the BVI!

Heres the graph

Slowly getting the max DD % down while upping the total returns! Also included an equity curve

Thank you d08... you are very helpful... lets get married and go on a honeymoon to Antartica

How can i visually/interpret an equity curve with data provided in my excel spreadsheet. I hate to say it but i don't even know what an equity curve is... :( #feelingashamed