[smf_addin] Digest Number 3417

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3417

1a

Element Definitions mismatch by adelgado2367

1b

Re: Element Definitions mismatch by "Randy Harmelink" rharmelink

1c

How do I retrieve data from website excel spreadsheet by "Joe" jtassielli2003

1d

Re: How do I retrieve data from website excel spreadsheet by "Randy Harmelink" rharmelink

Messages

1a

Element Definitions mismatch

Wed May 27, 2015 9:52 am (PDT) . Posted by:

adelgado2367

Hi, Randy!

I am using the RCHGetElementNumber-ElementDefinitions file from "Works in Progress", dated 2015-04-20, and it seems that the names for elements 4734 to 4767 do not match the definitions in smf-elements-4.txt


Regards
Antonio

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

1b

Re: Element Definitions mismatch

Wed May 27, 2015 10:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. I've corrected descriptions of elements 4734 thru
4763 and reuploaded the file.

On Wed, May 27, 2015 at 9:52 AM, adelgado2367@... wrote:

> Hi, Randy!
>
>
> I am using the RCHGetElementNumber-ElementDefinitions file from "Works in
> Progress", dated 2015-04-20, and it seems that the names for elements 4734
> to 4767 do not match the definitions in smf-elements-4.txt
>
>

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

1c

How do I retrieve data from website excel spreadsheet

Wed May 27, 2015 10:30 am (PDT) . Posted by:

"Joe" jtassielli2003

Hi Randy, web page:http://us.spindices.com/indices/equity/sp-500,  then click "additonal info", then "earnings". You retrieve a excel spreadsheet.  I wish to use something like the rchgettablecell function to automatically extract data when changed into my own spreadsheet. thanks Joe   
  From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, May 27, 2015 1:18 PM
Subject: Re: [smf_addin] Element Definitions mismatch

  Thanks for the heads up. I've corrected descriptions of elements 4734 thru 4763 and reuploaded the file.

On Wed, May 27, 2015 at 9:52 AM, adelgado2367@... wrote:

Hi, Randy!
I  am using the RCHGetElementNumber-ElementDefinitions file from "Works in Progress", dated 2015-04-20, and it seems that the names for elements 4734 to 4767 do not match the definitions in smf-elements-4.txt

#yiv8471679724 #yiv8471679724 -- #yiv8471679724ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8471679724 #yiv8471679724ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8471679724 #yiv8471679724ygrp-mkp #yiv8471679724hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8471679724 #yiv8471679724ygrp-mkp #yiv8471679724ads {margin-bottom:10px;}#yiv8471679724 #yiv8471679724ygrp-mkp .yiv8471679724ad {padding:0 0;}#yiv8471679724 #yiv8471679724ygrp-mkp .yiv8471679724ad p {margin:0;}#yiv8471679724 #yiv8471679724ygrp-mkp .yiv8471679724ad a {color:#0000ff;text-decoration:none;}#yiv8471679724 #yiv8471679724ygrp-sponsor #yiv8471679724ygrp-lc {font-family:Arial;}#yiv8471679724 #yiv8471679724ygrp-sponsor #yiv8471679724ygrp-lc #yiv8471679724hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8471679724 #yiv8471679724ygrp-sponsor #yiv8471679724ygrp-lc .yiv8471679724ad {margin-bottom:10px;padding:0 0;}#yiv8471679724 #yiv8471679724actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8471679724 #yiv8471679724activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8471679724 #yiv8471679724activity span {font-weight:700;}#yiv8471679724 #yiv8471679724activity span:first-child {text-transform:uppercase;}#yiv8471679724 #yiv8471679724activity span a {color:#5085b6;text-decoration:none;}#yiv8471679724 #yiv8471679724activity span span {color:#ff7900;}#yiv8471679724 #yiv8471679724activity span .yiv8471679724underline {text-decoration:underline;}#yiv8471679724 .yiv8471679724attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8471679724 .yiv8471679724attach div a {text-decoration:none;}#yiv8471679724 .yiv8471679724attach img {border:none;padding-right:5px;}#yiv8471679724 .yiv8471679724attach label {display:block;margin-bottom:5px;}#yiv8471679724 .yiv8471679724attach label a {text-decoration:none;}#yiv8471679724 blockquote {margin:0 0 0 4px;}#yiv8471679724 .yiv8471679724bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8471679724 .yiv8471679724bold a {text-decoration:none;}#yiv8471679724 dd.yiv8471679724last p a {font-family:Verdana;font-weight:700;}#yiv8471679724 dd.yiv8471679724last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8471679724 dd.yiv8471679724last p span.yiv8471679724yshortcuts {margin-right:0;}#yiv8471679724 div.yiv8471679724attach-table div div a {text-decoration:none;}#yiv8471679724 div.yiv8471679724attach-table {width:400px;}#yiv8471679724 div.yiv8471679724file-title a, #yiv8471679724 div.yiv8471679724file-title a:active, #yiv8471679724 div.yiv8471679724file-title a:hover, #yiv8471679724 div.yiv8471679724file-title a:visited {text-decoration:none;}#yiv8471679724 div.yiv8471679724photo-title a, #yiv8471679724 div.yiv8471679724photo-title a:active, #yiv8471679724 div.yiv8471679724photo-title a:hover, #yiv8471679724 div.yiv8471679724photo-title a:visited {text-decoration:none;}#yiv8471679724 div#yiv8471679724ygrp-mlmsg #yiv8471679724ygrp-msg p a span.yiv8471679724yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8471679724 .yiv8471679724green {color:#628c2a;}#yiv8471679724 .yiv8471679724MsoNormal {margin:0 0 0 0;}#yiv8471679724 o {font-size:0;}#yiv8471679724 #yiv8471679724photos div {float:left;width:72px;}#yiv8471679724 #yiv8471679724photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8471679724 #yiv8471679724photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8471679724 #yiv8471679724reco-category {font-size:77%;}#yiv8471679724 #yiv8471679724reco-desc {font-size:77%;}#yiv8471679724 .yiv8471679724replbq {margin:4px;}#yiv8471679724 #yiv8471679724ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8471679724 #yiv8471679724ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8471679724 #yiv8471679724ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8471679724 #yiv8471679724ygrp-mlmsg select, #yiv8471679724 input, #yiv8471679724 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8471679724 #yiv8471679724ygrp-mlmsg pre, #yiv8471679724 code {font:115% monospace;}#yiv8471679724 #yiv8471679724ygrp-mlmsg * {line-height:1.22em;}#yiv8471679724 #yiv8471679724ygrp-mlmsg #yiv8471679724logo {padding-bottom:10px;}#yiv8471679724 #yiv8471679724ygrp-msg p a {font-family:Verdana;}#yiv8471679724 #yiv8471679724ygrp-msg p#yiv8471679724attach-count span {color:#1E66AE;font-weight:700;}#yiv8471679724 #yiv8471679724ygrp-reco #yiv8471679724reco-head {color:#ff7900;font-weight:700;}#yiv8471679724 #yiv8471679724ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8471679724 #yiv8471679724ygrp-sponsor #yiv8471679724ov li a {font-size:130%;text-decoration:none;}#yiv8471679724 #yiv8471679724ygrp-sponsor #yiv8471679724ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8471679724 #yiv8471679724ygrp-sponsor #yiv8471679724ov ul {margin:0;padding:0 0 0 8px;}#yiv8471679724 #yiv8471679724ygrp-text {font-family:Georgia;}#yiv8471679724 #yiv8471679724ygrp-text p {margin:0 0 1em 0;}#yiv8471679724 #yiv8471679724ygrp-text tt {font-size:120%;}#yiv8471679724 #yiv8471679724ygrp-vital ul li:last-child {border-right:none !important;}#yiv8471679724

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

1d

Re: How do I retrieve data from website excel spreadsheet

Wed May 27, 2015 10:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Since it's an EXCEL workbook that resides on their servers, you'd just use
normal EXCEL processing to refer to the worksheet. You don't need the
add-in for that. For example:

='
http://us.spindices.com/documents/additional-material/[sp-500-eps-est.xlsx]ESTIMATES&PEs'!$A$4

...or you could even array-enter and bring in a range:

=IF(LEN('
http://us.spindices.com/documents/additional-material/[sp-500-eps-est.xlsx]ESTIMATES&PEs'!A23:M36)=0,
"",'
http://us.spindices.com/documents/additional-material/[sp-500-eps-est.xlsx]ESTIMATES&PEs'!A23:M36
)

On Wed, May 27, 2015 at 10:30 AM, Joe jtassielli2003@... wrote:

>
> web page:http://us.spindices.com/indices/equity/sp-500,
>
> then click "additonal info", then "earnings";.
>
> You retrieve a excel spreadsheet. I wish to use something like the
> rchgettablecell function to automatically extract
> data when changed into my own spreadsheet.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . 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