This has turned into a nitemare. There is no easy way to do this. Sigh. Too bad. Any other suggestions?
Is this a programming issue? If so I recommend help from the PHP forums at http://www.codingforums.com You can use file_get_contents to pull any info you need from a web page and insert it into a database for future use. You start with the code below and build on it. PHP: $contents = @file_get_contents("http://www.elitetrader.com/vb/"); Give them the URL and the info you want and they will post a solution.
I wish it were a programming problem. No, the problem is that the website gives earnings for not only the company, but for every company that it has bought. So for example, ORCL will give earnings for not just ORCL, but for Sun Micro. The problem is that there is no simple way to tell when the earnings is fro ORCL or another company that it has bought. For example, scroll down to the earnings section and look at the columns: http://www.fulldisclosure.com/company.asp?client=cb&ticker=orcl
heh..nitro..i told you that long time ago.. http://www.elitetrader.com/vb/showthread.php?s=&postid=3242708&highlight=purposely#post3242708 why yahoo and many other sources are posting tickers,news and useless data from all over the world? http://biz.yahoo.com/ic/330.html i don't give a fuck about indian or any asian or euro companies. wtf? this yahoo site belongs to what country? yahoo and the f**g rest ... please LIST and post about US companies only. i don't give a f**ck about tata motors..not just yet... each country have their own yahoo finance and everything is in it..no need to post ot in US. unless the goal is to create an appearance of some sort of activity... any activity. cause there is ain't any..same shit like exchanges do..every month i see 20-50 US companies are delisted.. to keep up and maintain the numbers exchanges are coming up with all sort of tricks. we have hundreds of ETF's ,ETN's and even ETF's build on portions of other ETF's. how messed up this is? only to maintain the numbers. some bs chineese companies,canadian..they do whatever to keep the overall numbers from falling..only f**kg retard can't see that US businesses are dying at ridiculously fast rate..couple more years and at this pace i will have no US stocks to trade.. what is this shit? http://www.fulldisclosure.com/dividend.asp?date=20110601&client=cb 3000+ entries for day..from all over the world. probably 10 traded on US markets..what for? i believe-to purposely f**ck you up. and that shit is everywhere. feel free to call me sick or paranoid..
You want just the ORCL earning dates in green? If so the PHP example I posted earlier will accomplish that task.
Bob, Here is what I did, and it is not easy, but it is not terrible. In Sql Server Management Studio (I am using Sql Server 2008 R2), I did a "Edit All Rows" on the database table that contains the data that I screen scraped (have to set the value to 0 in Tools->Options->Sql Server Object Explorer->Value For Edit...). I then right clicked on the result grid with pane with all the rows, which gives me a popup menu, then Pane->Sql. That gave me the sql source in a split pane with the results in the pane below. The sql looks like this: SELECT Id, Symbol, Period, Event, EPSEstimate, EPSActual, EPSPrevYearActual, Date FROM EarningStat I then added a statement, WHERE (Symbol = 'AMGN') AND (NOT (Event LIKE '%Amgen%')) Event is a table column that contains the event description from the site you gave me. That gives me all the (unwanted) entries that are AMGN companies earnings that were taken over by AMGN. Select all the rows and then right click on all the hi-lighted rows and delete. Presto, what is left is just the actual AMGN earnings. You can change the WHERE statement to do the same for Oracle, Microsoft, etc. Tedious if you have lots of symbols, but ok for a few. Thanks again for your help.