No data by 99wallstreet provider
Author: bobydesi123
Creation Date: 8/5/2014 10:59 PM
profile picture

bobydesi123

#1
Eugene,
"It's not good for the forum to mix unrelated issues in one thread. Since this "one more thing" is not related to this thread anyhow, please find an existing discussion thread on 99wallstreet and repost there"

First of all sorry for mixing up the topics, i thought it would some thing be quick.

When i look at my WLP DATA folder:
There is a folder named WS99FundamentalProvider.
When i do a data update I get message like these:

e.g.
Updating DataSet 06juneTrades ...
Symbols already up to date: JKS,NX,SCS,SEAC,TITN
Updating Provider 99wallstreet.com earnings releases ...
JKS 0 fundamental items updated
NX 0 fundamental items updated
SCS 0 fundamental items updated
SEAC 0 fundamental items updated
TITN 0 fundamental items updated
Provider update complete for 99wallstreet.com earnings releases
----------------

Update completed (3.76 sec)

1. However, when i look at the chart for any of the above symbol there are no 'green' arrows of 99wallstreet. Even though the message says data is 'upto date',
2. when i open the WLP's extention manger and look at the say SEAC, SEAC.WLF file it contains only 25 bytes! So there doesn't seem to be any data loaded from 99wallst!
2. When i look at the WLP's extention manger and then the list of provider, I do see
MS123 Extra fundamental/news provider.

So why don't i se 99wallst data on the charts above?
How do i remove and reload/update MS123 Extra fundamental/news provider?
sorry for silly question but its benn a while when i dealt with these as every thing was remove smoothly.

P.S. Cloned my old 80gb SSD to 540ggb SSD every thing s seems to work fine, can this have caused problem?
profile picture

Eugene

#2
When something like that happens, i.e. a provider suddenly stops working in this manner, it's usually a sign of an unexpected change on their website. In particular, this is exactly the case with 99wallstreet. From a technical standpoint, they've changed the web page design and also the URL, breaking the data provider.

Fortunately, legacy URL is still working if redirection is prohibited (you can't do that in browsers). As adapting to the new page layout would take some time due to complexity added by data pagination (notice that the site no longer lists all earnings releases on one page), I decided to simply prohibit redirection and release a quick fix which is already available in the Extension Manager (v2014.08) > "Other extensions" / Updates. On how to install updates, refer to the User Guide > Extension Manager.

The updated provider should keep working until the 99wallstreet guys decide to take the legacy version down completely. When that happens, give me a heads-up here.
profile picture

bobydesi123

#3
Eugene,
Eureka! Your suggestion worked.
Once again, i can't thank you and Cone enough for your quick resolution for any of the question/problems (some them r silly, like i ask sometimes :)).
Thanks.
P.S. I will keep you posted about the 99wallst server when they shut down the old URL.
profile picture

Eugene

#4
Glad to have helped.
profile picture

Eugene

#5
As reported bdsl2004, the provider has again broken - this time because 99wallst has taken down the legacy URL. Stay tuned for a fix (ETA late October - early November).
profile picture

Eugene

#6
Fixed in latest version 2014.11. Please update the extension using the Extension Manager.
profile picture

ruediger78

#7
Eugene,
Provider stopped working again. I have got the latest version of the extension (installed this morning), but dont receive any data for any stock. Could you plese have a look at this error?
profile picture

Eugene

#8
Thanks for the heads-up Ruediger. Indeed, there are 3 changes at the website. Some of them (URL change and a HTML change) can be handled but one is a showstopper. For example, open this page and note the Date column:

http://99wallstreet.com/earnings/stock/AAPL/

It lacks the year. This is where we end: the provider can not continue. Please contact the data vendor and tell them their data has a major flaw.
profile picture

ruediger78

#9
Contacted them via facebook. Lets see what happens.
profile picture

Eugene

#10
Ruediger,

Have you had any response from them?
profile picture

Eugene

#11
In a duplicate thread, WEALTHPRO25 asked:

i updated the fundamental data for 99wallstreet.com, restarted wealthlab and i am still not getting earnings data for individual stock when i run the extension trading method for the long haul, i also updated ms 123 extra fundamental/news providers
profile picture

Eugene

#12
See replies #7 and #8 in this very thread.

P.S. Try searching the forum before posting. Usually an answer can be found quickly thanks to our search-as-you-type system.
profile picture

WEALTHPRO25

#13
thanks
profile picture

Eugene

#14
I completely forgot that I've developed another data provider for earnings surprises :)

It's Zacks Earnings Surprises data through Quandl data provider.

Unfortunately, Zacks data is costly: a single-user subscription to Zacks Earnings Surprises costs $100 a month. Therefore I appreciate pointers to free alternatives of historical earnings surprise data.
profile picture

Eugene

#15
Good news. I was able to find an alternative source of historical earnings including estimates and surprises - StreetInsider. I am going to develop a new fundamental data provider which essentially will be a drop-in replacement for 99WallStreet. Look for the new provider early next month as part of MS123 Fundamental/News provider library.
profile picture

Eugene

#16
ATTENTION

New provider StreetInsider should bring back quality and free earnings data. Look for it in MS123 Fundamental/News provider library v2015.07.

Paid alternative: Zacks data through Quandl provider
profile picture

Eugene

#17
ATTENTION

Good news! 99WallStreet have fixed their major data flaw and we're releasing a new provider build that supports their revamped website. Please update the MS123 Fundamental/News Providers library to its latest version 2016.09 and the earnings data by 99WallStreet will work again.
profile picture

akar

#18
I downloaded the new provider and tried the following script below. However it's only printing the data till 2014 in Debug. Although in the chart it's showing the data till the last earning, of this year.

Please let me know how to fix this.
profile picture

Eugene

#19
Everything works. If you review the Debug log again you'll notice that the data for 2016 is there. The list is not sorted by date which might have confused you.
profile picture

akar

#20
I'm getting data from 2010-2014 in the Debug. Can you please attach the code that you are using ?
profile picture

Eugene

#21
If the data is charted, you should see it in the Debug log.

Using the code from the Wiki on AAPL, how does your Debug output look like? Try updating the DataSet (not in "Pricing" mode) a couple of times to overwrite the data and notice if that was a temporary glitch.
profile picture

akar

#22
I've attached 3 files

1. Chart Screenshot of running the script
2. Debug output and output from the "Update Data" window in a text file
3. The WLP file from WealthLabPro\1.0.0.0\Data\WS99FundamentalProvider\A\AAPL.WLF
profile picture

Eugene

#23
I have nothing to add to what I've already told so I'm just duplicating my reply here:

If you review the Debug log again you'll notice that the data for 2016 is there. The list is not sorted by date which might have confused you.

AAPL Item Count: 31
7/22/2014 1.28 Apple, Inc. 1.23 4.07 37400.0 37990.0 -1.55
10/20/2014 1.42 Apple 1.31 8.40 42120.0 39850.0 5.70
1/27/2015 3.06 Apple 2.6 17.69 74600.0 67690.0 10.21
4/27/2015 2.33 Apple 2.16 7.87 58000.0 56060.0 3.46
7/21/2015 1.85 Apple 1.81 2.21 49600.0 49310.0 0.59
10/27/2015 1.96 Apple 1.88 4.26 51500.0 51120.0 0.74
1/26/2016 3.28 Apple 3.23 1.55 75900.0 76590.0 -0.90
4/26/2016 1.9 Apple 2.0 -5.00 50600.0 51970.0 -2.64
7/26/2016 1.42 Apple 1.38 2.90 42400.0 42090.0 0.74
10/25/2016 1.67 Apple 1.65 1.21 46900.0 46890.0 0.02
1/24/2012 13.87 Apple, Inc. 10.08 37.60 46330.0 38850.0 19.25
4/24/2012 12.3 Apple, Inc. 10.06 22.27 39200.0 36810.0 6.49
7/24/2012 9.32 Apple, Inc. 10.36 -10.04 35000.0 37180.0 -5.86
10/25/2012 8.67 Apple, Inc. 8.75 -0.91 36000.0 35800.0 0.56
1/23/2013 13.81 Apple, Inc. 13.44 2.75 54510.0 54730.0 -0.40
4/23/2013 10.09 Apple, Inc. 10.07 0.20 43600.0 42590.0 2.37
7/23/2013 7.47 Apple, Inc. 7.32 2.05 35300.0 35010.0 0.83
10/28/2013 8.26 Apple, Inc. 7.92 4.29 37500.0 36840.0 1.79
1/27/2014 14.5 Apple, Inc. 14.09 2.91 57600.0 57460.0 0.24
4/23/2014 11.62 Apple, Inc. 10.18 14.15 45600.0 43530.0 4.76
7/20/2010 3.51 Apple 3.11 12.86
10/18/2010 4.64 Apple 4.08 13.73
1/18/2011 6.43 Apple 5.39 19.29
4/20/2011 6.4 Apple 5.35 19.63 24670.0 23270.0 6.02
7/19/2011 7.79 Apple, Inc. 5.8 34.31 28600.0 24920.0 14.77
10/18/2011 7.05 Apple, Inc. 7.28 -3.16 28300.0 29450.0 -3.90
4/22/2009 1.33 Apple 1.09 22.02
7/21/2009 1.35 Apple 1.17 15.38
10/19/2009 1.82 Apple 1.42 28.17
1/25/2010 3.67 Apple 2.07 77.29
4/20/2010 3.33 Apple 2.45 35.92
profile picture

akar

#24
You are correct. After a rerun I see the data there. Thanks for your help