Technical analysis software add-ins for Microsoft Excel.
Home|Products|Order|Downloads|Support
Task 2: Neural Net>>Make predictions

Task: Make predictions, based on historical data and Cutler's RSI indicator values.

<< Previous  |  Next >>
  1. Switch to MSFT worksheet.
  2. Select H1 cell and enter string "Predictions".
  3. Select item under the PredictorXL menu:
  4. Click Bulk Predictions button:
  5. Click button near Inputs input-box, select 20 rows of data range that includes RSI's values and hit Enter or click button:
  6. Click button near Outputs input-box, select 20 rows of Close range (prediction will be made for this range) and hit Enter or click button:
  7. Click Align button to align Ranges:
  8. Set parameters as shown on the picture:
  9. Click button near Prediction Output input-box, select single cell "H25" in the column H and hit Enter or click button:
  10. Click Show process button to view the process of training.
  11. Click New button to create new net.
  12. Click Start training button:
  13. When prediction process will be complete (you will receive notification), switch to INTC worksheet and repeat all steps.

Task Results

  • Predictions ranges will be created.
<< Previous  |  Next >>
Home|Products|Order|Downloads|Support