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 Mark on April 25, 2004 at 11:03:43:

: : 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

Replies:

• Re: DJIA historical import problem Mark 19:13:27 04/26/04 (1)
  • Re: DJIA historical import problem Peter Eigler 15:25:47 04/27/04 (0)