Hi, I am suspecting you are using older version of psConfig.txt file. Latest version (v3, last few years) should have a section where you specify your PortfolioSlicer-Source.xlsx location:
I accidentally over wrote it a few days ago that is why I am asking. It seems that the downloads on the download page do not have this line in them. Can you verify the correct script download?
First, in Source file review ReportCurrency worksheet - make sure Excel table ends with last record and there are no empty rows in that table.
But likely your problem is in CurrencyConv file. First, go to CurrExchIntraDay folder and if there is a file in there, confirm that all records have currency from and to specified.
Then go to CurrExch folder and review all files in there - likely one of the file has incorrect record (like empty currency "to") and you will need to delete these records and re-run extract scripts.
Comments
I am suspecting you are using older version of psConfig.txt file. Latest version (v3, last few years) should have a section where you specify your PortfolioSlicer-Source.xlsx location:
Please check your psConfig.txt file.
But likely your problem is in CurrencyConv file.
First, go to CurrExchIntraDay folder and if there is a file in there, confirm that all records have currency from and to specified.
Then go to CurrExch folder and review all files in there - likely one of the file has incorrect record (like empty currency "to") and you will need to delete these records and re-run extract scripts.