Senin, 18 April 2016

[smf_addin] Digest Number 3678

6 Messages

Digest #3678
1a
Re: Next Earnings Date by "Chuck Grablewski" cgrablew
1b
Re: Next Earnings Date by "Randy Harmelink" rharmelink
1c
Re: Next Earnings Date by "Chuck Grablewski" cgrablew
1d
Re: Next Earnings Date by "Randy Harmelink" rharmelink
2b
Re: Corporate Governance by "Randy Harmelink" rharmelink

Messages

Sun Apr 17, 2016 9:32 am (PDT) . Posted by:

"Chuck Grablewski" cgrablew

Randy,

I updated my definitions and rchgettablecell works as you
thought.....Thanks...One point of clarification - If I used
rchgetelementnumber on element 1290 (this is the one I was previously
using) I get an error. Based on your response, it looks like you think it
works. Is there anything else I should have updated other than element
definition spreadsheet? Maybe the txt files?

Thanks,

Chuck Grablewski

On Sat, Apr 16, 2016 at 6:06 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> You probably just need to update your element definitions. CIEN works fine
> for me, returning:
>
> Jun 2 - Jun 6 (Est.)
>
> The element was last updated on 2016-01-07:
>
> http://ogres-crypt.com/SMF/Elements/
>
> P.S. -- I'm assuming you meant element #1285, if from Yahoo. #1290 is from
> Zacks, and returns:
>
> 6/2/2016
>
> On Sat, Apr 16, 2016 at 4:31 PM, cgrablew@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>> It doesn't look like field 1290, Next Earning Date, is out there any
>> longer. Is there another place I can get this information? I've tried
>> using RCHGetTableCell("https://finance.yahoo.com/q?s="&"~~~~~"&"&ql=1",1,"
>> Earnings Date") but it doesn't always return the information. If the field
>> being returned is a date, then it works. But if the field is a range like
>> Jan 2 - Jan 6 the function returns an "Error". If you search Yahoo finance
>> for stock symbol CIEN you'll see the data in the website (looks like 2
>> rows). Is there anyway I get use the RCHGetTableCell function to return all
>> the data?
>>
>>
>
>

Sun Apr 17, 2016 10:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's the *.txt files that contain the actual element definitions. The XLS
file just contains documentation.

On Sun, Apr 17, 2016 at 9:32 AM, Chuck Grablewski cgrablew@... wrote:

>
> I updated my definitions and rchgettablecell works as you
> thought.....Thanks...One point of clarification - If I used
> rchgetelementnumber on element 1290 (this is the one I was previously
> using) I get an error. Based on your response, it looks like you think it
> works. Is there anything else I should have updated other than element
> definition spreadsheet? Maybe the txt files?
>
>
>

Sun Apr 17, 2016 2:53 pm (PDT) . Posted by:

"Chuck Grablewski" cgrablew

Randy,

I just replaced all the txt files & the xla file with the most current
version of the addin. With the new xla file the Table Load macro doesn't
work.I used to hit CTL+SHIFT+J to invoke the 2 dimensional table load. If
I put back the old xla file, then it works. Any ideas of what is going on?

Thanks,

Chuck Grablewski

On Sun, Apr 17, 2016 at 11:36 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> It's the *.txt files that contain the actual element definitions. The XLS
> file just contains documentation.
>
> On Sun, Apr 17, 2016 at 9:32 AM, Chuck Grablewski cgrablew@... wrote:
>
>>
>> I updated my definitions and rchgettablecell works as you
>> thought.....Thanks...One point of clarification - If I used
>> rchgetelementnumber on element 1290 (this is the one I was previously
>> using) I get an error. Based on your response, it looks like you think it
>> works. Is there anything else I should have updated other than element
>> definition spreadsheet? Maybe the txt files?
>>
>>
>>
>
>

Sun Apr 17, 2016 4:21 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The keyboard shortcut probably disappeared because I don't use it any
longer. But you can just reassign that keyboard shortcut to the macro.

I have the macros assigned to toolbar buttons.

Also, if you bring up the context menu with a right mouse click, there is
an "SMF" section there. One of the options there links to the
smfUpdateDownloadTable macro.

On Sun, Apr 17, 2016 at 2:53 PM, Chuck Grablewski cgrablew@... wrote:

>
> I just replaced all the txt files & the xla file with the most current
> version of the addin. With the new xla file the Table Load macro doesn't
> work.I used to hit CTL+SHIFT+J to invoke the 2 dimensional table load. If
> I put back the old xla file, then it works. Any ideas of what is going on?
>
>
>

Mon Apr 18, 2016 1:13 am (PDT) . Posted by:

nkfmn

Yahoo finance in Company/Profile section describes and rate this unique issue for most of the traded companies - is there a way to bring this paragraph into an excel using SMF function ?


Nehemiah K.

Mon Apr 18, 2016 1:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://finance.yahoo.com/q/pr?s=MMM","td",-2,"
http://issgovernance.com")

These should get the individual scores:

=smfConvertData(smfStrExtr(smfGetTagContent("
http://finance.yahoo.com/q/pr?s=MMM","td",-2,"http://issgovernance.com
"),"Audit:",";"))

=smfConvertData(smfStrExtr(smfGetTagContent("
http://finance.yahoo.com/q/pr?s=MMM","td",-2,"http://issgovernance.com
"),"Board:",";"))

=smfConvertData(smfStrExtr(smfGetTagContent("
http://finance.yahoo.com/q/pr?s=MMM","td",-2,"http://issgovernance.com
"),"Rights:",";"))

=smfConvertData(smfStrExtr(smfGetTagContent("
http://finance.yahoo.com/q/pr?s=MMM","td",-2,"http://issgovernance.com
"),"Compensation:","."))

On Mon, Apr 18, 2016 at 1:13 AM, nehemiak@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Yahoo finance in Company/Profile section describes and rate this unique
> issue for most of the traded companies - is there a way to bring this
> paragraph into an excel using SMF function ?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar