[smf_addin] Digest Number 3530

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3530

1a

Re: Last and Next Earnings Report Date by "Kermit W. Prather" kermitpra

1b

Re: Last and Next Earnings Report Date by "Randy Harmelink" rharmelink

2a

is the yahoo group working? by kermitpra

2b

Re: is the yahoo group working? by "Randy Harmelink" rharmelink

Messages

1a

Re: Last and Next Earnings Report Date

Tue Oct 6, 2015 2:37 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks for this information. Any chance you might place the workbook on http://ogres-crypt.com/SMF

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, October 02, 2015 1:57 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Last and Next Earnings Report Date


On Fri, Oct 2, 2015 at 10:29 AM, rjemery@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

1) I entered JPM in the yellow box and nothing happened, even after hitting ENTER. How does one make use of this template?

You should copy the formulas you need. This is what I see for the first few lines if I put in JPM:

JPM
<=== Enter Ticker Symbol here






Reported Date
Reported Time
Fiscal Quarter
Reported EPS
Estimated EPS
$ Surprise
% Surprise

10/13/2015
After Close
9/2015
$0.00
$1.40
--
--

7/14/2015
Before Open
6/2015
$1.54
$1.44
$0.10
6.94%

4/14/2015
Before Open
3/2015
$1.45
$1.39
$0.06
4.32%

1/14/2015
Before Open
12/2014
$1.19
$1.30
-$0.11
-8.46%

Those first two reported dates are formulas:

=RCHGetElementNumber(Ticker,1290)
=RCHGetElementNumber(Ticker,1295)


2) Actually, I wish to have commands (akin to RCHGetQuotes) that retrieve the previous and next earnings report date for a number of symbols I have in a worksheet. Does your command set support that?

RCHGetYahooQuotes() is limited to fields offered by Yahoo's CSV file interface. Neither of those fields is available on the Yahoo feed.

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1b

Re: Last and Next Earnings Report Date

Tue Oct 6, 2015 2:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Tue, Oct 6, 2015 at 2:37 PM, 'Kermit W. Prather' kermitp@tampabay.rr.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
> Thanks for this information. Any chance you might place the workbook on
> http://ogres-crypt.com/SMF
>
>
>

Already there. It was mentioned earlier in the thread:

On Fri, Oct 2, 2015 at 8:30 AM, Randy Harmelink <rharmelink@gmail.com>
wrote:

> Take a look at the Zacks earnings announcements template:
>
> SMF-Template-Zacks-Earnings-Annoucements.xls
> <http://ogres-crypt.com/SMF/Templates/SMF-Template-Zacks-Earnings-Annoucements.xls>
>
> On Fri, Oct 2, 2015 at 8:22 AM, rjemery@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> What command would I use to obtain the last and next earnings report
>> dates?
>>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

2a

is the yahoo group working?

Tue Oct 6, 2015 2:43 pm (PDT) . Posted by:

kermitpra

Unusal for us to go 3 days with no posting

Just wondering if it is still working.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: is the yahoo group working?

Tue Oct 6, 2015 2:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Appears to be working... :)

On Tue, Oct 6, 2015 at 2:43 PM, kermitp@... wrote:

>
> Unusal for us to go 3 days with no posting
>
>
> Just wondering if it is still working.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 20

• Privacy • Unsubscribe • Terms of Use