wahidsaleemi
commented
5 years ago -
The https://stocksearning.com does not have an API. We are just using Invoke-WebRequest and the Internet Explorer rendering engine to browse the site via PowerShell. This is why this script requires Windows (Internet Explorer) and why there could be errors. An API would provide very predictable return information. Instead of "browsing" a web page and getting back HTML, you would get back json-formatted or xml-formatted fields. You would know exactly which field has the stock symbol, earnings date, and other information. For example, try this: Invoke-RestMethod -Uri https://api.earningscalendar.net/?date=20181205
-
For www.earningswhispers.com, it doesn't look like there is an API we can access so it would still be parsing HTML. I'm not sure if it would be any easier. You could add a -Source parameter so users of the script can choose between the two sites. If you look at the page source, you'll see some javascript that is being used to retrieve the earnings date, you would need to replicate that functionality in PowerShell.
-
I didn't look into TWS API for earnings data because of the cost and don't know if it would even be possible to access that information from TWS' API.
-
For qmatrix or any of the paid data sources, I can help you write a script against it if you've subscribed. Most API's actually do require registration and getting a token, so that's very common. A couple of the paid ones: -- http://www.zacksdata.com/data/calendar-events-revisions/ -- quandl's API is free but the earnings data comes from Zacks: https://docs.quandl.com/v1.0/docs/data-organization -- earningscalendar.net tells you which companies announced earnings on a specific date but not when upcoming earnings are, for that - it's $50/month. -- intrinio is $100/month: https://intrinio.com/data-tag/next_earnings_date?
You can search for "earnings data API" and sift through many more. If you find one that's relatively inexpensive, that might be worthwhile to code against.
SCCMAdmin
edouardswiac
tmxwshmt
@wahidsaleemi in Issue #1 you mentioned... "It would be better to find a web API so we don't need to parse HTML. There are several non-free ones but I haven't found one that's free: https://stackoverflow.com/questions/4945626/free-api-or-similar-to-get-next-earnings-date-for-stocks"
Regarding a web API or TWS API:
How do you know https://stocksearning.com has an API we are accessing? I couldn't find it advertised. For me to learn that's all. Also I found these are estimated earnings dates in the example of DAL it is 10 Jan.
How do we know if https://www.earningswhispers.com has an API we can access? Hard to find anything advertised openly. Sample symbol DAL which was removed from output CSV has BMO 17 Jan earnings on this site. Different to the estimate at https://stocksearning.com. I think using https://www.earningswhispers.com in future if possible, could improve the data we are relying on.
I know TWS has an API. Do you know how to get earnings to appear in TWS (even at a subscription cost)? (you made a note about Stan in the past perhaps we should investigate. Maybe it's called Wall Street Horizon. I'll ask him on FB if you don't know)
I use a piece of software called XLQ (Excel add-in) which makes use of various free and paid data sources by moving downloaded data into Excel. See https://qmatix.com/ and scroll down on main page for data sources list. I know Tiingo was added as a free source after you register and grab a token. However after a look around the API they have is $10/month, but most importantly, I can't see they offer earnings data. I could ask them if need be. So yeah, need to find some earnings data sources as a starting point.
You said you know several at cost earnings data sources. What are they if you care to share?