Firstly, you'll need to ensure :

1- you're on the min version of Analyse 5.5.3 and + to run automated scripts.

2.  you have a topline clone (e.g. C:\ProgramData\Askia\Clones\TPforScripts.xml)

 A/ Test your script

Go to the top menu, 'Automation' and create a new script:

Copy and paste the following script:

Save it and add it in your Script directory

B/ Create a portfolio (by command line)

To create the portfolio automatically , you can run a  batch file  from the command line using the /"automate:" parameter e.g. 

1. Analyse.exe  "c:\Qes\ex.qes" /"automate:c:\Scripts\CloneScript.txt"

C/ Create  the corresponding  excel export (by command line)

Add the following command line to your batch file:

1.Analyse.exe "c:\Qes\ex.qes" /"automate:c:\Scripts\CloneScript_tag.txt"
2.Analyse.exe "C:\Qes\ex.qes" /exportexcel /"portfolio:C:\Qes\Tp.xml" /"output:C:\Qes\result.xls" /"logfile:C:\Qes\Log.txt"

 Enjoy