Home → Problems →

Importing security prices

• Edit

AlanK

02 Jun, 2011 01:12 AM

Hi:

I've created a .csv file, a sample of which is posted below. When I asked MD to import from this file, I receive a message that 53 items were imported, but that 53 of them were skipped due to errors. Any idea what errors?

AlanK

Date,Open,High,Low,Close,Volume,Adj Close
1/2/2009,64.09,64.09,64.09,64.09,0,64.09
1/9/2009,61.28,61.28,61.28,61.28,0,61.28
1/16/2009,59.9,59.9,59.9,59.9,0,59.9
1/23/2009,57.28,57.28,57.28,57.28,0,57.28
1/30/2009,60.2,60.2,60.2,60.2,0,60.2
2/6/2009,57.36,57.36,57.36,57.36,0,57.36
2/13/2009,57.06,57.06,57.06,57.06,0,57.06

1. 1 Posted by AlanK on 02 Jun, 2011 02:31 PM

   

   Well, as my Firefox browser sometimes reports - "this is embarrassing".

   The security in question was merged into another, so its price history, which simply stopped at a point in the past, as obtained from finance.google as it was not available from yahoo. I tried filling up the file with zeros up through today to see if that would help and it did not.

   Here's the issue: I have MD set to use the date format YYYY.MM.DD (the ISO standard). Once I converted my dates to that format in the .csv file, the prices imported just fine. Apparently, yahoo prices come in that format (or perhaps the "quotes and exchange rates" extension is able to convert them on download?

   • Edit

2. 2 Posted by -Kevin N. on 02 Jun, 2011 03:16 PM

   

   Hi AlanK,

   When I asked MD to import from this file, I receive a message that 53 items were imported, but that 53 of them were skipped due to errors. Any idea what errors?

   Another user had a similar problem, I sugested that he add the leading zero to the dates and that resolved his problem.
   01/02/2009 instead of 1/2/2009
   HTH -Kevin N

   • Edit

3. System closed this discussion on 31 Mar, 2015 03:34 PM.