Selasa, 13 Agustus 2013

[smf_addin] Digest Number 2732

9 New Messages

Digest #2732
1a
Problems with the functions by "sgschollaert" sgschollaert
1b
Re: Problems with the functions by "Randy Harmelink" rharmelink
3a
Option Symbol by "john.kalkanis" john.kalkanis
3b
Re: Option Symbol by "Randy Harmelink" rharmelink
3c
Earnings.com by "Jason Strauss" g3m1n1980
3d
Re: Earnings.com by "Jason" g3m1n1980
3e
Re: Earnings.com by "Randy Harmelink" rharmelink

Messages

Mon Aug 12, 2013 7:08 am (PDT) . Posted by:

"sgschollaert" sgschollaert

Randy

I am trying to re-start this application.

I use
= Windows 7 Enterprise
= Office Excel Professional Plus 2010

I used the SMF_addin extensively before, but getting #Name? message in all the cells.

Any ideas?

Thanks

Steve Schollaert

Mon Aug 12, 2013 8:04 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

#NAME? usually means one of two things:

1. The add-in is no longer properly activated via the add-in manager.
2. The workbook you're opening had the add-in in a different location
than you currently do.

For issue (2), see the "Location Errors" item in the LINKS area of the
group.

On Mon, Aug 12, 2013 at 7:08 AM, sgschollaert <usrepat@hotmail.com> wrote:

>
> I am trying to re-start this application.
>
> I use
> = Windows 7 Enterprise
> = Office Excel Professional Plus 2010
>
> I used the SMF_addin extensively before, but getting #Name? message in all
> the cells.
>
> Any ideas?
>

Mon Aug 12, 2013 9:32 am (PDT) . Posted by:

"john.kalkanis" john.kalkanis

HI, I am wondering how you can also get the "confirmed&quot; or "not confirmed" info related to the earnings release date from earningswhispers...
john

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You just need to tell it to go to the next row of the table to pick it up.
> For example:
>
> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol=nq",1,"Release
> Date:",,,,1)
>
> On Wed, Mar 6, 2013 at 6:52 AM, christine.vankuik <
> christine.vankuik@...> wrote:
>
> >
> > I use the following command to get the date (which works) but I can not
> > get the after or before data (because of the string before is empty, so I
> > can not refer to, any thoughts how to get the after/before info)
> >
> > RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol=~~~~~",1,"Release
> > Date:")
> >
> > here an example of stock NQ weblink to take a look:
> >
> > http://www.earningswhispers.com/stocks.asp?symbol=nq
> >
> >
>

Mon Aug 12, 2013 9:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just use a 0 instead of a 1 in the formula, then you'll need to extract it
from that string.

On Mon, Aug 12, 2013 at 8:55 AM, john.kalkanis
<john.kalkanis@...<john.kalkanis@yahoo.com>
> wrote:

> HI, I am wondering how you can also get the "confirmed&quot; or "not confirmed"
> info related to the earnings release date from earningswhispers...
> john
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > You just need to tell it to go to the next row of the table to pick it
> up.
> > For example:
> >
> > =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol=nq
> ",1,"Release
> > Date:",,,,1)
> >
> > On Wed, Mar 6, 2013 at 6:52 AM, christine.vankuik <
> > christine.vankuik@...> wrote:
> >
> > >
> > > I use the following command to get the date (which works) but I can not
> > > get the after or before data (because of the string before is empty,
> so I
> > > can not refer to, any thoughts how to get the after/before info)
> > >
> > > RCHGetTableCell("
> http://www.earningswhispers.com/stocks.asp?symbol=~~~~~",1,"Release
> > > Date:")
> > >
> > > here an example of stock NQ weblink to take a look:
> > >
> > > http://www.earningswhispers.com/stocks.asp?symbol=nq
>

Mon Aug 12, 2013 10:15 am (PDT) . Posted by:

"john.kalkanis" john.kalkanis

Hi. Is there a function to generate the ticker to be used in smfGetOptionQuotes, knowing the symbol, expiry and date?

I tried smfGetOptionStrikes and smfGetOptionExpirations but they generate strikes (in the first case) or expiry (in the second). while I have both and just need to generate the ticker.

Thanks
John

Mon Aug 12, 2013 12:49 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There is a parameter in both of those functions to have it generate the
ticker symbols. The documentation for each has an example of doing so.

Otherwise, given:

D2: ="SPY"
E2: =DATE(2013,8,17)
F2: $170
G2: ="Call"

Then:

H2: =D2&TEXT(E2," m/dd yyyy ")&TEXT(F2,"$0.00 ")&G2
I2: =smfGetOptionQuotes(H2,"b")

On Mon, Aug 12, 2013 at 10:15 AM, john.kalkanis <john.kalkanis@yahoo.com>wrote:

> Hi. Is there a function to generate the ticker to be used in
> smfGetOptionQuotes, knowing the symbol, expiry and date?
>
> I tried smfGetOptionStrikes and smfGetOptionExpirations but they generate
> strikes (in the first case) or expiry (in the second). while I have both
> and just need to generate the ticker.
>

Mon Aug 12, 2013 12:56 pm (PDT) . Posted by:

"Jason Strauss" g3m1n1980

Randy,

Who are you using for past earnings reports now? I think the old site - earnings.com defaults to Reuters now and they don't give it.

Please advise

Mon Aug 12, 2013 1:41 pm (PDT) . Posted by:

"Jason" g3m1n1980

Nevermind, I checked the group site and seems to be a terporary issue.

--- In smf_addin@yahoogroups.com, Jason Strauss <xxjaysonxx@...> wrote:
>
> Randy,
>
> Who are you using for past earnings reports now? I think the old site - earnings.com defaults to Reuters now and they don't give it.
>
> Please advise
>

Mon Aug 12, 2013 2:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not aware of any possible replacement for the earnings report data...

On Mon, Aug 12, 2013 at 12:56 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:

> Randy,
>
> Who are you using for past earnings reports now? I think the old site -
> earnings.com defaults to Reuters now and they don't give it.
>
> Please advise
>
Diposting oleh EXCEL FEED LEARNING di 00.54

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)