Sabtu, 03 Oktober 2015

[smf_addin] Digest Number 3528

5 Messages

Digest #3528

Messages

Fri Oct 2, 2015 8:22 am (PDT) . Posted by:

rjemery7

What command would I use to obtain the last and next earnings report dates?


Fri Oct 2, 2015 8:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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?
>

Fri Oct 2, 2015 10:29 am (PDT) . Posted by:

rjemery7

Randy,

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

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?

Fri Oct 2, 2015 10:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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.

Fri Oct 2, 2015 9:52 am (PDT) . Posted by:

rr76012

Hello Ron Spruell,


Did you post a copy of your moving average spreadsheet? If so, what is the name of your spreadsheet.


thanks,


rr76012

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

Tidak ada komentar:

Poskan Komentar