Re: DJIA historical import problem

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: DJIA historical import problem posted by Peter Eigler on April 26, 2004 at 16:29:23:

: : : Hi Mark
: : : just tried to import DJIA for a period 1927 to today and the import mixed up completely, as FM reads the dates 1929 to 1949 as 2029 to 2049. Any ideas as to import DJIA historical old dates?
: : : Thanks
: : : Peter

: : Hi Peter,

: : If the import format contains a 2 digit year, this will happen. When FM
: : imports data and the year is a 2 digit year, it must convert that to a full
: : 4 digit year. It assumes anything less than 50 is 20XX, and >= 50 is 19XX.

: : The way to work around this is to convert the year figures to 4 digits before
: : importing. Are you importing, or retrieving?

: : Thanks,
: : Mark
: : --
: : Mark Beiley
: :
: : Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP
: :

: Hi Mark. I am retrieving djia historical prices from Yahoo. How shall I convert to four digits? All by hand working around since 1927?
: Oh no.

: Thanks
: Peter

Hi Peter,

If you go to Yahoo's web site, you can visit the page where they offer
historical prices. As an example, see:

http://finance.yahoo.com/q/hp?s=^DJI

At the bottom of the page there is a link to "Download to Spreadsheet".
If you download this file, you can read it into Excel or any other
spreadsheet. Select the date column, and choose "Format / Cells..." in
Excel. Choose "Number / Date / mm/dd/yyyy" to format those cells. Then,
re-save the file as a .csv file. Then, you can import this into Fund
Manager with the generic price import.

Here is a sample line from the re-saved .csv file:

4/26/2004,10472.91,10540.26,10396.75,10444.73,12906000,10444.73

You would import this in Fund Manager with the import string of:

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

and you would need to "Specify" the symbol.

Thanks,
Mark
--
Mark Beiley

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

Replies:

• Re: DJIA historical import problem Peter Eigler 15:25:47 04/27/04 (0)