Hi Howard - You should see a RevEps object
This is from vba in Excel: Dim qp_Revs As New QuotesPlus.RevEps You can always go to vba from excel to see what functions are being called. Best regards Gary ----- Original Message ----- From: Howard Hansen To: [email protected] Sent: Saturday, March 29, 2008 5:23 PM Subject: Re: [quotes-plus] Scan Function -> COM interface? As far as I can tell the Quotes Plus COM interface doesn't have a function for getting quarterly earnings from the Quotes Plus database. I used the object browser to search the classes exposed by the COM interface but couldn't find a method that returned the quarterly earnings for a stock. Very strange because the Excel interface includes a function for getting quarterly earnings from the Quotes Plus database. Howard ly0y wrote: > > I have been trying to reproduce a scan I run as a console VB.NET > application. I used as my base the QP_EX_Closes program (thanks to > whomever wrote that). > > I have much of it working. The thing I'm fighting right now is > reproducing the QPSCAN function QTREPS(quarter#). > > I've tried to grab the same data from the RevEPS class, which seems > logical, but I don't see a matching function. I tried the > EarningsEstimates class function QtrYPAEPS but when I pass quarter# == > -1 I get garbage back. The CompanyInfo class has a TTMEPS function but > it doesn't take a quarter parameter. > > I know it's something stupid I'm overlooking. Can anyone please point > me in the right direction? > > Eric > >
