Re: Help to import historical data

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on August 22, 2006 at 14:09:32:

In Reply to: Help to import historical data posted by Troy on August 22, 2006 at 13:48:19:

: Hello everyone

: For some reason, I just can not work out how to import historical data.

: I work in the IT industry, so am no stranger to data transfers, but I just can not work this out

: I want to import price history into my portfolio

: My CSV file looks like this when opened in notepad
: DGE.L,17.65,08/20/2005

: Being Symbol as defined on the symbol field of the share
: Price
: Date MM/DD/YYYY

: Then followed menu path to import
: File Import Prices Generic and used the following mask
: "SYMB",NAV,"MM/DD/YY"

: And then I receive error
: The specified import format did not match any lines in the imported file

: What am I doing wrong?

: Thanks
: Troy

Hi Troy,

Since your data looks like this:

DGE.L,17.65,08/20/2005

you would use "File / Import / Prices / Generic..." and use these settings:

Specify Date: OFF
Specify Symbol: OFF
Input Format: SYMB,NAV,MM/DD/YY

It looks like you were very close, but since your data doesn't have double quotes, you don't want them in your format string either.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: