StreetInsider earnings data provider error: reverse date and month order
Author: adrian50697
Creation Date: 11/7/2015 7:57 PM
profile picture

adrian50697

#1
I have an issue with the StreetInsider earnings release data where it displays the month and day in reverse on my charts. For example if the correct earnings date is 10 January 2015 it will incorrectly show up as 1 October 2015. Essentially it's getting confused with DD-MM-YYYY and MM-DD-YYYY date formats. It may have something to do with the fact I'm in Australia where default date format is DD-MM-YYYY.
profile picture

Eugene

#2
That's pretty strange. The default date format on my end is similar to Australia but despite that and the presense/absense of mother language in browser's settings, SI always returns dates in the fixed M/d/yyyy format:



Are you saying that when you open AAPL's earnings in Internet Explorer (this matters for the provider) the day precedes the month?

Apple (AAPL) Earnings
profile picture

Eugene

#3
Well, I just changed the regional settings to English (Australia) myself and can NOT reproduce this. Wealth-Lab has adjusted to show d/M/yyyy and the earnings dates for AAPL fall on the right dates:



IE (the engine behind .NET's web page processing) also shows the page in the fixed format.
profile picture

Eugene

#4
AAPL was easy so let's take the opposite example where almost all dates can be treated as d-M and M-d: NVDA. The Nov 5 earnings is correctly shown as 5/11/15 and not in May.



Are you sure you're not confusing something? The issue positively can not be reproduced with Australian regional settings.
profile picture

adrian50697

#5
So interestingly I have no earnings data at all for AAPL and initially couldn't figure out why, then realised all the DD range from 20-27 and when incorrectly used as MM obviously there is no such month and the data doesn't appear.

Attached is what I see for NVDA. The month and day are in reverse.



profile picture

Eugene

#6
I'm going to commit a change to a future release of the library that is supposed to fix this issue. Note that Wealth-Lab 6.8+ will be required to install/update (it's time to drop 6.6 support as 6.9 is at the door). Once it's released, please let me know if it helps or not.
profile picture

adrian50697

#7
Ok thanks any idea when the new release will be available? Also is there a workaround that can be used in the mean time?
profile picture

Eugene

#8
1 - Possibly next month.

2 - Although I was unable to reproduce this with Australian settings applied, from a logical standpoint a workaround could be to temporarily switch to U.S. regional settings.

NOTE: what to do if Wealth-Lab crashes on start after changing regional settings.
profile picture

Eugene

#9
Hey Adrian,

Check out the latest update of the library. Has it fixed the issue?
profile picture

adrian50697

#10
Yes it's working now! Thanks Eugene.
profile picture

Eugene

#11
We did it! Glad to help.