Re: Generic Import

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on November 20, 2006 at 18:51:03:

In Reply to: Generic Import posted by Bjarne Hedegaard on November 20, 2006 at 18:34:39:

: I am trying to import some historical prices.

: It has the following data line in an investment specified with key as USCI-ABS

: 10,5;20,5;1;1;2000

: I have written in the input format as:

: NAV;XX;DD;MM;YYYY

: I am getting an error message "Specified Input Format is illegal".

: What am I doing wrong?

Hi Bjarne,

The problem is the year key is 'YY', and not 'YYYY'. If you use:

NAV;XX;DD;MM;YY

that should solve the problem.

Also, since you are using a comma as the decimal point, you must set "Options / Preferences... / Display / Number Format" to "1.000,00" in order for this to import properly.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: