:: Subscribe to our newsletter
 
Articles / Directory
06/17/2013
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



06/17/2013
Latest version of NeuralCode(v1.3) for
Neural Networks Trading.



06/17/2013
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



06/17/2013
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



02/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.


Training NeuralCode with Stock information for prediction

Next, let’s try to use NeuralCode for Stock Trading.
  • Launch the Predict Stock Prices Worksheet.

  • Click on "NeuralCode" to launch the training and prediction dialog.

  • Click on the "Input Range" text box. Select cells A2 to D11. Make sure you see 'Predict Stock Prices'!$A$2:$D$11 in the text box.

  • Click on the "Target Column" text box. Select column "F" in the text box. We are training the networks with Tomorrow’s Closing price to give it the ability to predict future prices with historical information.

  • Click on the "New Training" button. Wait till you see the message "Training Completed Successfully". This message will appear when the Error Rate falls below the Target Error Rate.

  • Without closing the dialog, click on the "Predict Results" tab. Click on the "Input Attributes" text box. Select cells A12 to D12. Make sure you see 'Predict Stock Prices'!$A$12:$D$12 in the text box. We are predicting tomorrow’s closing price with the historical data from A2 to D11 in the Neural Networks and today's Open, High and Low.



  • Click on the "Output Results" text box. Select column "H".

  • Click on the "Predict" button and you will see the results.

Tip :
Train the Neural Networks with the different Technical Indicators that you are accustomed with.

Setting a smaller Target Error Rate will allow you to have more accurate results. However, more training time will be required.

It is not necessary that you see "Training Completed Successfully" to perform the prediction. You can click on "Stop Training" and proceed to the Prediction. Many industry experts have warned of "over training"/"over fitting" in neural networks and missing the big picture.

Back to NeuralCode - Neural Networks Trading main page


 


Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners