Tag Products

Posts: 2

Calling ATR and a Stop Loss Macro In TraderXL Pro

Yeah, I still use TraderXL Pro for a bunch of my data manipulation and technical analysis stuff. I use it to download data and run macros through it, macros that I design and then use in my trading screen. After my fucked up 2009 trading year, I had to revamp my entire arsenal of macros and screens for a brighter and more profitable future, I hope.]{style="font-size:10.0pt;"}

[Anyway, below is one of the many macros I use in TraderXL Pro for generating an automatic stop loss using and Average True Range ([ATR]{.small-caps}) function. I then suck this data into my trading screen, and through the use of other magical macros. I then determine if I have to move my stop or sit on my hands.]{style="font-size:10.0pt;"}

[Since I love you guys, here’s the macro call for the [ATR]{.small-caps} function and the stop loss. First name your spreadsheet Current_Stock_Holdings.xls (you can change this later) then copy this into the AutoRun Macro box in BulksquoteXL.]{style="font-size:10.0pt;"}


[Macro Call

[I use a 20 day time period for my [ATR]{.small-caps} function, as the image above shows. You’ll have substitute[]{.push-double} [“]{.pull-double}X” in the callout function above for the time period you want. It can be 5, 10, 15, or 50, whatever floats your boat and your needs.]{style="font-size:10.0pt;"}

[Once you’ve done this, then you need to copy and paste in the macro for the stop loss function below. Make sure you save it to your spreadsheet locally. As with the [ATR]{.small-caps} function, you’ll have to edit the [X.X]{style="background:yellow;"} that I highlight below to a multiple that you like. It can be 1.5 or 5.5 times the ATR. This will generate wider or tighter stops based on your individual preferences. The smaller the number you input, the tighter the stop you generate. Conversely the larger the number you input, the looser the stop.]{style="font-size:10.0pt;"}

[You can use the Macro Viewer function in TraderXL to import the macro below if you don’t know how to do it manually. Copy and paste the function between the ++++++++’s into a [TXT]{.small-caps} file and then import it.]{style="font-size:10.0pt;"}


[Sub Stop_loss_ATR()]{style="font-size:10.0pt;"}


[′ Stop_loss_ATR Macro]{style="font-size:10.0pt;"}

[′ Macro recorded 12/15/2009 by neuralmarkettrends]{style="font-size:10.0pt;"}



[    Range(“H1”).Select]{style="font-size:10.0pt;"}

[    ActiveCell.FormulaR1C1 =[]{.push-double} [“]{.pull-double}Stop Loss”]{style="font-size:10.0pt;"}

[    Range(“H21”).Select]{style="font-size:10.0pt;"}

[    ActiveCell.FormulaR1C1 =[]{.push-double} [“]{.pull-double}=(RC[-3]-(RC[-1]*[X.X]{style="background:yellow;"}))”]{style="font-size:10.0pt;"}

[    Range(“H21”).Select]{style="font-size:10.0pt;"}

[    Selection.NumberFormat =[]{.push-double} [“]{.pull-double}0.0000”]{style="font-size:10.0pt;"}

[    Selection.NumberFormat =[]{.push-double} [“]{.pull-double}0.000”]{style="font-size:10.0pt;"}

[    Selection.NumberFormat =[]{.push-double} [“]{.pull-double}0.00”]{style="font-size:10.0pt;"}

[    Selection.Copy]{style="font-size:10.0pt;"}

[    Range(“H22:H253”).Select]{style="font-size:10.0pt;"}

[    ActiveSheet.Paste]{style="font-size:10.0pt;"}

[    Application.CutCopyMode = False]{style="font-size:10.0pt;"}

[End Sub]{style="font-size:10.0pt;"}


[Just a side note, you might be wondering why I call the stockchart function[]{.push-double} [“]{.pull-double}StockChart(“OHLC”,“J1″).” I do that so I can create a nice candlestick chart next to the downloaded data as eye candy.]{style="font-size:10.0pt;"}

[That’s it, there you have it. Now go cause mischief!]{style="font-size:10.0pt;"}


Product Review: Stock NeuroMaster

About a week ago I stumbled across a neat little stock neural net program called, interestingly enough, Stock NeuroMaster. I downloaded it and played around with it during its 14 day trail evaluation and was surprised by how easy it is to use.

Although I'm a heavy duty RapidMiner modeler, and I build intricate custom neural net/genetic algorithm models, Stock NeuroMaster appeals to me for its simplicity and ease of use.

Stock Neuromaster, NasdaqIf you don't care about how neural nets work, don't want to deal with the hassle of finding data and making predictions sets, and just want a system to generate [BUY]{.small-caps} and [SELL]{.small-caps} signals with a click of a button, this is the system for you.

The system, from what I've deduced, uses a standard backpropogation algorithm. It downloads [OHLC]{.small-caps} closing data for your selected stock symbol, then applies a zigzag line to the peaks and valleys of the stock price (this is done to find profits and losses), generates training BUY/SELL signals, then trains the data for maximum profit, and then builds a model.

Stock Neuromaster, PerformanceOnce the model is built, you can update the data by downloading daily/weekly data and then create a prediction with a simple click of a button. The prediction will then automatically generate a BUY/SELL or [HOLD]{.small-caps} signal for the next trading day open. The model will also keep a log of all generated BUY/SELL signals and give you some system statistics on how well the system is performing.

[Pros]{style="text-decoration: underline;"}

  1. Easy to use, no knowledge of neural net algorithms needed
  2. Clean [GUI]{.small-caps}, easy to read clean charts
  3. System Performance, Profit and Loss statement, and Buy/Sell Signal summary
  4. Easy step by step model building and prediction sets
  5. Yahoo, Metastock, and [CSV]{.small-caps} (format) data compatibility and updates
  6. Stop loss and trading strategy settings

[Cons]{style="text-decoration: underline;"}

1. Only a few technical indicators 2. No real time data feed or update, only end of the day data downloads 3. No position sizing

[Bottom line]{style="text-decoration: underline;"}: If you want a neural net program that will generate [BUY]{.small-caps} and [SELL]{.small-caps} signals for stocks, without knowing how the inside guts work, then this is the product for you. Download the Stock NeuroMaster free 14 day trial (zip file) and let me know what you think by leaving me a comment.