Re: Importing *.csv file

[ Q3 01 - Q1 03 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Importing *.csv file posted by Tony on May 23, 2002 at 11:57:07:

: Dear All

: I have a question about the CSV file.
: I have read the HELP file but I don't understand the sample

: "HWP","09/27/96",47.625,0.625,47.75,48.5,47.25,2115700," "

: I don't know the value 0.625 and 47.75 used for ?
: I tried it several time but I cound't find the these two value after I imported

: "SYMB","MM/DD/YY",NAV,??,??,HH,LL,VV Is it right ?

: Can I import Open-price with *.csv file ?

: Thanks for your kindly help !!!

Hi Tony,

CSV files can come in a variety of formats, the name CSV just means
that the fields are delimited by a comma, but what fields, and their
order can be anything.

In the example above the two fields in question are change from prior
and 'open' I believe, so you would import this with the generic import
string:

"SYMB","MM/DD/YY",NAV,XX,OO,HH,LL,VV,XX

the change field won't be imported, it is skipped, but the open field will
if you use the above format. You can see the imported data using "Edit/
All Data..." with the "Prices" data type selected.

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
/XP

Replies: