Importing security prices

AlanK's Avatar

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

    AlanK's Avatar

    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?

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

    -Kevin N.'s Avatar

    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

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

29 May, 2024 07:01 AM
29 May, 2024 06:26 AM
29 May, 2024 04:47 AM
29 May, 2024 02:38 AM
29 May, 2024 12:43 AM