Importing Prices

[GoogleCodeExporter]

The date formats need to work with 2-digit years as that is what Excel defaults 
to for setting a date format.  4-digit years require a custom format that is 
lost when reloading a CSV file.  Likewise for the date and month, if applicable.

Add an option to or just simply ignore invalid US trade dates.  Who has the 
time to delete such a multitude of rows identified by MPI in a 9,000+ line file 
of gold prices?

Original issue reported on code.google.com by MachineG...@gmail.com on 5 Jun 2011 at 12:52

[GoogleCodeExporter]

Thanks for the feedback, I will incorporate this in the next minor release.

Original comment by mypersonalindex@gmail.com on 5 Jun 2011 at 1:39

[GoogleCodeExporter]

I added the option to discard rows with invalid dates for v3.2.

However, the 2 digit year is not something I want to add.  This can lead to a 
lot of confusion when dealing with the 1900s or 2000s.  See 
http://office.microsoft.com/en-us/excel-help/change-the-default-date-format-HP00
5285937.aspx for changing Excel to use 4 digits date by default.

Original comment by mypersonalindex@gmail.com on 10 Dec 2011 at 10:54

[GoogleCodeExporter]

Original comment by mypersonalindex@gmail.com on 11 Mar 2012 at 5:08

• Changed state: Started

[GoogleCodeExporter]

Original comment by mypersonalindex@gmail.com on 11 Mar 2012 at 5:08

• Changed state: Fixed