Need Assistance in building a classification model

[EvanTan]

Hi designers,

I need assistance in building a classification model to predict the stock price movement. I need a model that can predict the variable "next day return predicted value". I am facing issues with generating a model that contains a confusion matrix-false positive and negative. 

[caltang]

The Data School has some blog posts about this:

• https://www.thedataschool.co.uk/louisa-obrien/building-classifier-models-in-alteryx/
• https://www.thedataschool.co.uk/andrew-lehm/alteryx-stats-tools-for-beginners-part-4-classification/

Of course, you need to validate the models too:

• https://community.alteryx.com/t5/Data-Science/Metric-Matters-Part-1-Evaluating-Classification-Models... 
• https://community.alteryx.com/t5/Data-Science/How-Do-You-Know-if-Your-Classification-Model-Is-Any-Go... 

On the Confusion Matrix part, here's some good articles:

• https://community.alteryx.com/t5/Data-Science/What-is-a-Confusion-Matrix/ba-p/537567 
• https://community.alteryx.com/t5/Data-Science/De-Confusing-the-Matrix/ba-p/651382 
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-make-confusion-Matrix-s... 

Beyond that, since you're building something like that, it's important to preface by saying that this is not something that can held against anyone should the workflow be wrong.

[gawa]

@EvanTan 

Predicting the future stock price would be usually "Time Series Prediction", and not a classification problem.

You can go with these tool set.

[EvanTan]

if that's the case how do you utilise the time series tools to predict the stock movement, i have tried the time series forecast tool but it prompted a r project file requried

[gawa]

You have to install Predictive Tools in addition to Designer.

https://help.alteryx.com/current/en/designer/tools/predictive-analytics.html#idm46162922229584