Batch Macro to update p/d/q values in ARIMA tool not working as imagined

[Inactive User]

Hey all! 

I tried to run an ARIMA model in a batch macro so that i could test all the different cimbinations for p, d, q, S_P, S_D, S_Q and drift values. In general, i thought that this wouldn't be too complicated but i can't seem to get it running correctly.

 

I tested it with two rows of Macro input and it correctly itterated two times. But it never updated the values as instructed by the Macro Control Input.

I've attached the workflows with sample data that i created so i can share it with you. It behaves the same as with the real data.

There's probably a minor thing i've overlooked but i can't figure out what and i'd be greatful for any input.

Thanks

[davidskaife]

Hi @Inactive User 

The test data isn't included I'm afraid. Could you package it up - go to Options-Export Workflow and then share that? It will then include the csv file and the macro all in one package :)

[Inactive User]

Hey! :)

Thanks for the hint, I exported both workflows and attached them here as i didnt knew if the data in the macro is included if i only export the "executing" workflow.

[Inactive User · Accepted solution]

Okay, i just got it running. To everyone having the same issue, the problem was the AMP Engine. As soon as i deactivated it, the macro ran perfectly.

Also thanks to @DavidSkaife for taking on my problem. :)

[davidskaife]

Nice one @Inactive User! Glad to have (kinda) helped 😀