CurrencyConv Throws Exception

Musing

I've been trying to update my workbook but I keep on getting a message that says:

"We couldn't refresh the table 'CurrencyConv' from connection 'CurrencyConv'. Here is the error message we got:

External component has thrown an exception."

I've tried downloading the newest spreadsheet and scripts, but I still get the same problem. Any ideas what is causing the problem.

Thanks,
Musing

VidasMatelis

Hi,

Please double check in psConfig.txt parameter PSDataFolder value. For majority of users this should be C:\PortfolioSlicer\PSData
If that is OK, then make sure that parmater ColumnSeparator (same psConfig.txt file) is set to TAB.

Musing

From reading some other threads I had already checked those items, but I just double checked and they are as you indicated.

VidasMatelis

Can you please send me all files from c:\PortfolioSlicer\PSData folder. My email address is posted on this page: http://portfolioslicer.com/contact.html

VidasMatelis

You PSData files looks OK. I will need your Excel file to investigate further. It is likely that one of the Excel tables has data with some problems and you are getting an error on currency conversion file just because this is the first file loaded. So please send me your Excel file.
Or as alternative - you can download latest Excel file and scripts, run scripts without changing psConfig.txt so you have no data specific to you. If your refresh succeeds, then this would confirm that issue is with one of your data tables (Symbol/Allocation/Account, etc). If refresh fails, then there is an issue with the environment - maybe Excel version not right, or something else.