Re: Importing Historical Prices From CSV File

[ Q2 00 - Q2 01 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Importing Historical Prices From CSV File posted by Clive on January 02, 2001 at 12:20:58:

: Hi Mark;

: I've recently set up investment index files for the Dow, TSE300, S&P 500 and Nasdaq using the historical data sources. I use these as benchmarks to compare my fund performances. I'd like to do the same for some of the more popular international indices.

: I've been looking for a source of historical price data for several of the Morgan Stanley international indices, specifically MSCI World, MSCI Europe and MSCI EAFE. I found a data source at http://www.uk-invest.com/msciscrape.html that gives historical prices for these indices in a downloadable *.csv data file.

: Each data file has the following line format: 29-Dec-2000,1221.253

: Is there any way that Fund Manager can import this historical price data into a *.dat file?

: Thanks,
: Clive

Hi Clive,
Yes, this can be easily imported into an investment (*.dat) file with
the "File/Import/Prices/Generic..." command. You would "Specify" the
symbol, but not the date, and use the format string of:

DD-MM-YY,NAV

If you choose the "Help" button from within this dialog box you can read
detailed instructions on using this command.

Thanks,
Mark
--
Mark Beiley

Fund Manager for Windows 3.1x/95/98/NT

Replies: