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 26, 2004 at 19:13:27:

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

Hi Mark,
That worked.
Many thanks
Peter

Replies: