Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.
Jimmy2shoes
-
Content Count
1 -
Joined
-
Last visited
-
My first idea (known technical buy signal) is 3 days with consecutive highs and closes, also known as 'Three White Soldiers'. You probably know it, but i would love to know how you backtest this ideas, in excel formula.... Can u make formula, for backtesting any strategy? I have a few ideas and would love to know your thoughts!?
James
-
I would love to have a chat about your excel spreadsheet, 'Backtesting Higher Close Smaller' ... I have a few strategies/portfolio ideas that i would like to implement, i have an automated excel spreadsheet to give me the buy and sell signals(Based on Technical Analysis Signals). I would love to be able to backtest their strength. Using various Oscillating Indicators, i would like to test their strengths/weaknesses. But, i dont know how to use these signals to make a trade at close price(Buy next day), sell after my moving average follows an equation(Parabolic SAR)-Changes accordingly, unable to test them in excel systematically. Perhaps we could exchange ideas, formulas, strategies... you get the jist. Anyways i see u do intra day trading. Im much more a position holder using fundamentals/technicals based upon certain characteristics.
-
I am trying to create a cell, that uses a reference from another cell that says "BUY". I need the cell to say that once this cell says "BUY", literally/theoretically, Buy one share, at price listed in Cell G21. i would continue and hold this until the cell in question says "SELL" then obviously it Sells. However, In the next cell i would need it to calculate the running profit/loss. I would also need the cell to then change the system around so that once the long contract has been sold a short contract now comes into play, and visa versa. I have a Moving Average cross-over system already in place and would love to be able to simply back test it. If anyone would offer any help it would be much appreciated. Also the cross overs have different lengths i.e. 10v20, 20v50,50v100 etc. So would it be possible to weight them so that when the 10v20 cross over(10 above the 20) i buy say 5 shares say. When the 20 goes above the 50 i buy 20 shares and if the 50v100 does the same i buy 100 shares. Any help would be much appreciated thanks.