Date format change starting April 17th 2019

Hello all,

Starting the April 17th 2019, we will be changing the date format to yyyy-mm-dd which you will see for all files you download such as transactions, historical returns, etc…
If you are running scripts, please plan to adjust to this new format.

Thanks

Thanks for the heads up.

Hi Hem,

Very much appreciated - thank you!

Any chance you could post another message here with 2 example files attached before vs after?
(to be able to test and make sure my code works directly on April 17th)

Thank you in advance,

Jerome

Will this affect inbound dates (i.e., when specifying a date via “asof” in a script)? Will this also affect the display of dates in headers or just in the context of tables?

Thanks for letting us know in advance.
Will existing Exposure List dates all be automatically changed to the new format as well, or do we have to change the dates manually?

This will affect file downloads only. Attached is a random transactions sample file for both before and after the date format change. The format change will not be implemented for any notes in the files at the moment.

Most likely we will implement the change at the end of business day April 17th. I will keep you updated
Thanks


Sample transactions before date format change.txt (23 KB)


Sample transactions after date format change.txt (23.3 KB)

Thank you Hem.

FYI, if I am not mistaken, the sample for “before change” does not exactly reflect an actual transaction file we can download (I just tried):
Date from the attached sample file is e.g.4/9/2019 (no leading zeros and has 20xx)
Date from currently downloadable transaction files = e.g. 04/09/19 (has leading zeros and no 20xx)

Thank you

Jerome

Hi Jerome,

This is an invest transactions strategy download.
Future downloadable files will show leading zeros and complete year (yyyy-mm-dd).

Would you like to see a different file?
Thanks

Thanks Hem,

As long as it sorts properly in Excel—as the download seemed to do when pasted into excel—then good for me.

I am not a programmer (but would like to be and I am slowly learning). You would think this format should sort even if Excel does not recognize it as a date (Excel did not seem to recognize it as a date). It did sort properly. This is stuff you already know about and I know you have already considered it.

Bottom line: it worked.

-Jim

Hi, just asking if there has been any pre-req backend work on dates, that might be affecting new imports.

Getting a “Date may not follow 04/13/19” error with both the old and new date formats


Hello giovannig,

Can you please show us a sample of your imported file? Line 2 would do.
Thanks!

Hi Hem,

Most useful files for me would be the files that one can download from the pages:
→ holdings
→ transactions

I assume that the import transactions space will not change the date format (currently MM/DD/YYYY) as it is not a file!

Many thanks

Jerome

Attached are both formats in a single file.

Here is a list of all affected endpoints:
[][font=courier new]/app/account/trans.csv[/font][][font=courier new]/app/rollingTest/resultsTableDl/[/font][][font=courier new]/app/watchlist/items.csv?v=basic[/font][][font=courier new]/p123/DownloadPortPeriodPerformance[/font][][font=courier new]/p123/DownloadPortTrans[/font][][font=courier new]/p123/DownloadRankings[/font] (header line)[*][font=courier new]/transact_real.jsp?download=[/font]Note that [font=courier new]/p123/DownloadStudyResults[/font] will not be affected.


P123_SimTran_SP500MarketTimedHedge.csv (1.1 KB)

Thank you Aaron

Was certainly getting this error on the 13th/14th. Went away on Monday the 15th.

Sorry to have hijacked.