[smf_addin] Digest Number 3902

EXCEL Stock Market Functions Add-in Group

8 Messages

Digest #3902

1a

Re: Add-in problem with small numbers by indinvestor111

1b

Re: Add-in problem with small numbers by indinvestor111

1c

Re: Add-in problem with small numbers by "Randy Harmelink" rharmelink

2a

rchcreatecomment and custom stockchart member chart by jhfrazer@ymail.com

2b

Re: rchcreatecomment and custom stockchart member chart by "Randy Harmelink" rharmelink

2c

Re: rchcreatecomment and custom stockchart member chart by

2d

Re: rchcreatecomment and custom stockchart member chart by

3a

Re: Last and Next Earnings Report Date by lutherkinchen

Messages

1a

Re: Add-in problem with small numbers

Sat Jan 28, 2017 8:10 am (PST) . Posted by:

indinvestor111

Well, I don't have any programming skills, so can't give specific recommendations regarding the code. However, I did notice the "K" in your code is capitalized. The "k" on the site is lowercase. Does that matter? Yahoo uses uppercase for its "M" and "B", but for some reason not for "k".

Again, appreciate the time spent on this.


Feel better!!!

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

1b

Re: Add-in problem with small numbers

Sat Jan 28, 2017 8:18 am (PST) . Posted by:

indinvestor111

Also, wouldn't it make sense to multiply the first line by 1 if you're multiplying the "M" by 1000?

Case UCase(Right(s2, 1)) = "K": s2 = Left(s2, Len(s2) - 1): nMult = 1000
Case UCase(Right(s2, 1)) = "M": s2 = Left(s2, Len(s2) - 1): nMult = 1000



Or does that introduce problems with other sites?

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

1c

Re: Add-in problem with small numbers

Sat Jan 28, 2017 9:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

In the context
​where "K" came up, it only meant actual thousands.

The problem is that some financial statements line items are in thousand of
dollars, or millions of dollars. In those cases, there's really no easy way
to interpret the suffix, so the general usage was applied.

On Sat, Jan 28, 2017 at 9:18 AM, elandry@
​...wrote:

>
> Also, wouldn't it make sense to multiply the first line by 1 if you're
> multiplying the "M" by 1000?
>
> Case UCase(Right(s2, 1)) = "K": s2 = Left(s2, Len(s2) - 1): nMult = 1000
> Case UCase(Right(s2, 1)) = "M": s2 = Left(s2, Len(s2) - 1): nMult = 1000
>
> Or does that introduce problems with other sites?
>

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

2a

rchcreatecomment and custom stockchart member chart

Sat Jan 28, 2017 9:19 am (PST) . Posted by:

jhfrazer@ymail.com

Welcome back Randy,


I am trying as best I can to use your rchcreatecomment function to access my default stockchart style. I am a member of stockcharts and would like to see this chart for the stocks i have listed in an excel spreadsheet when i mouse over the cells in which your function is listed. (Assume the stock symbols are in Column A, Company Name in Column B and your function is attached to Column C.)The link which stockcharts provides to the chart below for example is;
http://stockcharts.com/h-sc/ui?s=AAPL&p=D&yr=3&mn=0&dy=0&id=p78116736167 http://stockcharts.com/h-sc/ui?s=AAPL&p=D&yr=3&mn=0&dy=0&id=p78116736167



however when i replace aapl with another symbol, or a cell reference fo nflx for example I still get an apple chart. Is there a way to use your function in such a way that I might reach my desired result?


Thank you and I hope you are recovering comfortably,


John

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

2b

Re: rchcreatecomment and custom stockchart member chart

Sat Jan 28, 2017 9:35 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. I used this formula:

=RCHCreateComment("http://stockcharts.com/c-sc/sc?s=
"&D28&"&p=D&yr=3&mn=0&dy=0&i=p78116736167&r=1485624147024",99,,,1)

When I change the ticker symbol in cell D28, the chart changes.

On Sat, Jan 28, 2017 at 10:19 AM, jhfrazer@
​...wrote:

> I am trying as best I can to use your rchcreatecomment function to access
> my default stockchart style. I am a member of stockcharts and would like
> to see this chart for the stocks i have listed in an excel spreadsheet when
> i mouse over the cells in which your function is listed. (Assume the stock
> symbols are in Column A, Company Name in Column B and your function is
> attached to Column C.)The link which stockcharts provides to the chart
> below for example is;
>
> http://stockcharts.com/h-sc/ui?s=AAPL&p=D&yr=3&mn=0&dy=0&id=p78116736167
>
>
> however when i replace aapl with another symbol, or a cell reference fo
> nflx for example I still get an apple chart. Is there a way to use your
> function in such a way that I might reach my desired result?
>
>
> Thank you and I hope you are recovering comfortably,
>
>
> John
>
>
>
>
>
>

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

2c

Re: rchcreatecomment and custom stockchart member chart

Sat Jan 28, 2017 12:58 pm (PST) . Posted by:

--------------------------------------------
On Sat, 1/28/17, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] rchcreatecomment and custom stockchart member chart
To: smf_addin@yahoogroups.com
Date: Saturday, January 28, 2017, 7:27 PM


 









Not sure what to tell you. I used
this formula:

=RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&D28&"&p=D&yr=3&mn=0&dy=0&i=p78116736167&r=1485624147024",99,,,1)

When I change the ticker symbol in
cell D28, the chart changes.

On Sat, Jan 28, 2017 at
10:19 AM, jhfrazer@​...wrote:


















I am trying as best I can to use your rchcreatecomment
function to access my default stockchart style.  I am a
member of stockcharts and would like to see this chart for
the stocks i have listed in an excel spreadsheet when i
mouse over the cells in which your function is listed.
(Assume the stock symbols are in Column A, Company Name in
Column B and your function is attached to Column C.)The link
which stockcharts provides to the chart below for example
is;http://stockcharts.com/h-sc/
ui?s=AAPL&p=D&yr=3&mn=0&dy=0&
id=p78116736167 

however when i replace aapl
with another symbol, or a cell reference fo nflx for example
I still get an apple chart.  Is there a way to use your
function in such a way that I might reach my desired result?
 
Thank you and I hope you are
recovering comfortably,
John















#yiv7609842581 #yiv7609842581 --
#yiv7609842581ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv7609842581 #yiv7609842581ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7609842581 #yiv7609842581ygrp-mkp #yiv7609842581hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7609842581 #yiv7609842581ygrp-mkp #yiv7609842581ads {
margin-bottom:10px;}

#yiv7609842581 #yiv7609842581ygrp-mkp .yiv7609842581ad {
padding:0 0;}

#yiv7609842581 #yiv7609842581ygrp-mkp .yiv7609842581ad p {
margin:0;}

#yiv7609842581 #yiv7609842581ygrp-mkp .yiv7609842581ad a {
color:#0000ff;text-decoration:none;}
#yiv7609842581 #yiv7609842581ygrp-sponsor
#yiv7609842581ygrp-lc {
font-family:Arial;}

#yiv7609842581 #yiv7609842581ygrp-sponsor
#yiv7609842581ygrp-lc #yiv7609842581hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7609842581 #yiv7609842581ygrp-sponsor
#yiv7609842581ygrp-lc .yiv7609842581ad {
margin-bottom:10px;padding:0 0;}

#yiv7609842581 #yiv7609842581actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv7609842581 #yiv7609842581activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv7609842581 #yiv7609842581activity span {
font-weight:700;}

#yiv7609842581 #yiv7609842581activity span:first-child {
text-transform:uppercase;}

#yiv7609842581 #yiv7609842581activity span a {
color:#5085b6;text-decoration:none;}

#yiv7609842581 #yiv7609842581activity span span {
color:#ff7900;}

#yiv7609842581 #yiv7609842581activity span
.yiv7609842581underline {
text-decoration:underline;}

#yiv7609842581 .yiv7609842581attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv7609842581 .yiv7609842581attach div a {
text-decoration:none;}

#yiv7609842581 .yiv7609842581attach img {
border:none;padding-right:5px;}

#yiv7609842581 .yiv7609842581attach label {
display:block;margin-bottom:5px;}

#yiv7609842581 .yiv7609842581attach label a {
text-decoration:none;}

#yiv7609842581 blockquote {
margin:0 0 0 4px;}

#yiv7609842581 .yiv7609842581bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7609842581 .yiv7609842581bold a {
text-decoration:none;}

#yiv7609842581 dd.yiv7609842581last p a {
font-family:Verdana;font-weight:700;}

#yiv7609842581 dd.yiv7609842581last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv7609842581 dd.yiv7609842581last p
span.yiv7609842581yshortcuts {
margin-right:0;}

#yiv7609842581 div.yiv7609842581attach-table div div a {
text-decoration:none;}

#yiv7609842581 div.yiv7609842581attach-table {
width:400px;}

#yiv7609842581 div.yiv7609842581file-title a, #yiv7609842581
div.yiv7609842581file-title a:active, #yiv7609842581
div.yiv7609842581file-title a:hover, #yiv7609842581
div.yiv7609842581file-title a:visited {
text-decoration:none;}

#yiv7609842581 div.yiv7609842581photo-title a,
#yiv7609842581 div.yiv7609842581photo-title a:active,
#yiv7609842581 div.yiv7609842581photo-title a:hover,
#yiv7609842581 div.yiv7609842581photo-title a:visited {
text-decoration:none;}

#yiv7609842581 div#yiv7609842581ygrp-mlmsg
#yiv7609842581ygrp-msg p a span.yiv7609842581yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7609842581 .yiv7609842581green {
color:#628c2a;}

#yiv7609842581 .yiv7609842581MsoNormal {
margin:0 0 0 0;}

#yiv7609842581 o {
font-size:0;}

#yiv7609842581 #yiv7609842581photos div {
float:left;width:72px;}

#yiv7609842581 #yiv7609842581photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv7609842581 #yiv7609842581photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv7609842581 #yiv7609842581reco-category {
font-size:77%;}

#yiv7609842581 #yiv7609842581reco-desc {
font-size:77%;}

#yiv7609842581 .yiv7609842581replbq {
margin:4px;}

#yiv7609842581 #yiv7609842581ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv7609842581 #yiv7609842581ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv7609842581 #yiv7609842581ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv7609842581 #yiv7609842581ygrp-mlmsg select,
#yiv7609842581 input, #yiv7609842581 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv7609842581 #yiv7609842581ygrp-mlmsg pre, #yiv7609842581
code {
font:115% monospace;}

#yiv7609842581 #yiv7609842581ygrp-mlmsg * {
line-height:1.22em;}

#yiv7609842581 #yiv7609842581ygrp-mlmsg #yiv7609842581logo {
padding-bottom:10px;}


#yiv7609842581 #yiv7609842581ygrp-msg p a {
font-family:Verdana;}

#yiv7609842581 #yiv7609842581ygrp-msg
p#yiv7609842581attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7609842581 #yiv7609842581ygrp-reco
#yiv7609842581reco-head {
color:#ff7900;font-weight:700;}

#yiv7609842581 #yiv7609842581ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7609842581 #yiv7609842581ygrp-sponsor #yiv7609842581ov
li a {
font-size:130%;text-decoration:none;}

#yiv7609842581 #yiv7609842581ygrp-sponsor #yiv7609842581ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7609842581 #yiv7609842581ygrp-sponsor #yiv7609842581ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7609842581 #yiv7609842581ygrp-text {
font-family:Georgia;}

#yiv7609842581 #yiv7609842581ygrp-text p {
margin:0 0 1em 0;}

#yiv7609842581 #yiv7609842581ygrp-text tt {
font-size:120%;}

#yiv7609842581 #yiv7609842581ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7609842581
-a format un cerc al carui scop tinde la deschiderea de scoli romanesti in Basarabia predarea limbii romanesti dezvoltarea gustului pentru literatura romaneasca intr-un cuvant s-a facut primul pas care fatal va duce la antagonism si desigur majoritatea va prefera sa invete in limba materna in cea romaneasca Deci instrainarea de Rusia e inevitabila

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

2d

Re: rchcreatecomment and custom stockchart member chart

Sat Jan 28, 2017 3:43 pm (PST) . Posted by:

--------------------------------------------
On Sat, 1/28/17, charlespineda@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] rchcreatecomment and custom stockchart member chart
To: smf_addin@yahoogroups.com
Date: Saturday, January 28, 2017, 10:55 PM


 











--------------------------------------------

On Sat, 1/28/17, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:



Subject: Re: [smf_addin] rchcreatecomment and custom
stockchart member chart

To: smf_addin@yahoogroups.com

Date: Saturday, January 28, 2017, 7:27 PM





 



















Not sure what to tell you. I used

this formula:



=RCHCreateComment("http://stockcharts.com/c-sc/sc?s="&D28&"&p=D&yr=3&mn=0&dy=0&i=p78116736167&r=1485624147024",99,,,1)



When I change the ticker symbol in

cell D28, the chart changes.



On Sat, Jan 28, 2017 at

10:19 AM, jhfrazer@​...wrote:





































I am trying as best I can to use your rchcreatecomment

function to access my default stockchart style.  I am a

member of stockcharts and would like to see this chart
for

the stocks i have listed in an excel spreadsheet when i

mouse over the cells in which your function is listed.

(Assume the stock symbols are in Column A, Company Name
in

Column B and your function is attached to Column C.)The
link

which stockcharts provides to the chart below for
example

is;http://stockcharts.com/h-sc/

ui?s=AAPL&p=D&yr=3&mn=0&dy=0&

id=p78116736167 



however when i replace aapl

with another symbol, or a cell reference fo nflx for
example

I still get an apple chart.  Is there a way to use your

function in such a way that I might reach my desired
result?

 

Thank you and I hope you are

recovering comfortably,

John































#yiv7609842581 #yiv7609842581 --

#yiv7609842581ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}



#yiv7609842581 #yiv7609842581ygrp-mkp hr {

border:1px solid #d8d8d8;}



#yiv7609842581 #yiv7609842581ygrp-mkp #yiv7609842581hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}



#yiv7609842581 #yiv7609842581ygrp-mkp #yiv7609842581ads
{

margin-bottom:10px;}



#yiv7609842581 #yiv7609842581ygrp-mkp .yiv7609842581ad {

padding:0 0;}



#yiv7609842581 #yiv7609842581ygrp-mkp .yiv7609842581ad p
{

margin:0;}



#yiv7609842581 #yiv7609842581ygrp-mkp .yiv7609842581ad a
{

color:#0000ff;text-decoration:none;}

#yiv7609842581 #yiv7609842581ygrp-sponsor

#yiv7609842581ygrp-lc {

font-family:Arial;}



#yiv7609842581 #yiv7609842581ygrp-sponsor

#yiv7609842581ygrp-lc #yiv7609842581hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}



#yiv7609842581 #yiv7609842581ygrp-sponsor

#yiv7609842581ygrp-lc .yiv7609842581ad {

margin-bottom:10px;padding:0 0;}



#yiv7609842581 #yiv7609842581actions {

font-family:Verdana;font-size:11px;padding:10px 0;}



#yiv7609842581 #yiv7609842581activity {

background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}



#yiv7609842581 #yiv7609842581activity span {

font-weight:700;}



#yiv7609842581 #yiv7609842581activity span:first-child {

text-transform:uppercase;}



#yiv7609842581 #yiv7609842581activity span a {

color:#5085b6;text-decoration:none;}



#yiv7609842581 #yiv7609842581activity span span {

color:#ff7900;}



#yiv7609842581 #yiv7609842581activity span

.yiv7609842581underline {

text-decoration:underline;}



#yiv7609842581 .yiv7609842581attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}



#yiv7609842581 .yiv7609842581attach div a {

text-decoration:none;}



#yiv7609842581 .yiv7609842581attach img {

border:none;padding-right:5px;}



#yiv7609842581 .yiv7609842581attach label {

display:block;margin-bottom:5px;}



#yiv7609842581 .yiv7609842581attach label a {

text-decoration:none;}



#yiv7609842581 blockquote {

margin:0 0 0 4px;}



#yiv7609842581 .yiv7609842581bold {

font-family:Arial;font-size:13px;font-weight:700;}



#yiv7609842581 .yiv7609842581bold a {

text-decoration:none;}



#yiv7609842581 dd.yiv7609842581last p a {

font-family:Verdana;font-weight:700;}



#yiv7609842581 dd.yiv7609842581last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}



#yiv7609842581 dd.yiv7609842581last p

span.yiv7609842581yshortcuts {

margin-right:0;}



#yiv7609842581 div.yiv7609842581attach-table div div a {

text-decoration:none;}



#yiv7609842581 div.yiv7609842581attach-table {

width:400px;}



#yiv7609842581 div.yiv7609842581file-title a,
#yiv7609842581

div.yiv7609842581file-title a:active, #yiv7609842581

div.yiv7609842581file-title a:hover, #yiv7609842581

div.yiv7609842581file-title a:visited {

text-decoration:none;}



#yiv7609842581 div.yiv7609842581photo-title a,

#yiv7609842581 div.yiv7609842581photo-title a:active,

#yiv7609842581 div.yiv7609842581photo-title a:hover,

#yiv7609842581 div.yiv7609842581photo-title a:visited {

text-decoration:none;}



#yiv7609842581 div#yiv7609842581ygrp-mlmsg

#yiv7609842581ygrp-msg p a span.yiv7609842581yshortcuts
{

font-family:Verdana;font-size:10px;font-weight:normal;}



#yiv7609842581 .yiv7609842581green {

color:#628c2a;}



#yiv7609842581 .yiv7609842581MsoNormal {

margin:0 0 0 0;}



#yiv7609842581 o {

font-size:0;}



#yiv7609842581 #yiv7609842581photos div {

float:left;width:72px;}



#yiv7609842581 #yiv7609842581photos div div {

border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}



#yiv7609842581 #yiv7609842581photos div label {

color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}



#yiv7609842581 #yiv7609842581reco-category {

font-size:77%;}



#yiv7609842581 #yiv7609842581reco-desc {

font-size:77%;}



#yiv7609842581 .yiv7609842581replbq {

margin:4px;}



#yiv7609842581 #yiv7609842581ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}



#yiv7609842581 #yiv7609842581ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}



#yiv7609842581 #yiv7609842581ygrp-mlmsg table {

font-size:inherit;font:100%;}



#yiv7609842581 #yiv7609842581ygrp-mlmsg select,

#yiv7609842581 input, #yiv7609842581 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}



#yiv7609842581 #yiv7609842581ygrp-mlmsg pre,
#yiv7609842581

code {

font:115% monospace;}



#yiv7609842581 #yiv7609842581ygrp-mlmsg * {

line-height:1.22em;}



#yiv7609842581 #yiv7609842581ygrp-mlmsg #yiv7609842581logo
{

padding-bottom:10px;}





#yiv7609842581 #yiv7609842581ygrp-msg p a {

font-family:Verdana;}



#yiv7609842581 #yiv7609842581ygrp-msg

p#yiv7609842581attach-count span {

color:#1E66AE;font-weight:700;}



#yiv7609842581 #yiv7609842581ygrp-reco

#yiv7609842581reco-head {

color:#ff7900;font-weight:700;}



#yiv7609842581 #yiv7609842581ygrp-reco {

margin-bottom:20px;padding:0px;}



#yiv7609842581 #yiv7609842581ygrp-sponsor
#yiv7609842581ov

li a {

font-size:130%;text-decoration:none;}



#yiv7609842581 #yiv7609842581ygrp-sponsor
#yiv7609842581ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}



#yiv7609842581 #yiv7609842581ygrp-sponsor
#yiv7609842581ov

ul {

margin:0;padding:0 0 0 8px;}



#yiv7609842581 #yiv7609842581ygrp-text {

font-family:Georgia;}



#yiv7609842581 #yiv7609842581ygrp-text p {

margin:0 0 1em 0;}



#yiv7609842581 #yiv7609842581ygrp-text tt {

font-size:120%;}



#yiv7609842581 #yiv7609842581ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv7609842581

-a format un cerc al carui scop tinde la deschiderea de
scoli romanesti in Basarabia predarea limbii romanesti
dezvoltarea gustului pentru literatura romaneasca intr-un
cuvant s-a facut primul pas care fatal va duce la antagonism
si desigur majoritatea va prefera sa invete in limba materna
in cea romaneasca Deci instrainarea de Rusia e
inevitabila











#yiv3763177579 #yiv3763177579 --
#yiv3763177579ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv3763177579 #yiv3763177579ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3763177579 #yiv3763177579ygrp-mkp #yiv3763177579hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3763177579 #yiv3763177579ygrp-mkp #yiv3763177579ads {
margin-bottom:10px;}

#yiv3763177579 #yiv3763177579ygrp-mkp .yiv3763177579ad {
padding:0 0;}

#yiv3763177579 #yiv3763177579ygrp-mkp .yiv3763177579ad p {
margin:0;}

#yiv3763177579 #yiv3763177579ygrp-mkp .yiv3763177579ad a {
color:#0000ff;text-decoration:none;}
#yiv3763177579 #yiv3763177579ygrp-sponsor
#yiv3763177579ygrp-lc {
font-family:Arial;}

#yiv3763177579 #yiv3763177579ygrp-sponsor
#yiv3763177579ygrp-lc #yiv3763177579hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3763177579 #yiv3763177579ygrp-sponsor
#yiv3763177579ygrp-lc .yiv3763177579ad {
margin-bottom:10px;padding:0 0;}

#yiv3763177579 #yiv3763177579actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv3763177579 #yiv3763177579activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv3763177579 #yiv3763177579activity span {
font-weight:700;}

#yiv3763177579 #yiv3763177579activity span:first-child {
text-transform:uppercase;}

#yiv3763177579 #yiv3763177579activity span a {
color:#5085b6;text-decoration:none;}

#yiv3763177579 #yiv3763177579activity span span {
color:#ff7900;}

#yiv3763177579 #yiv3763177579activity span
.yiv3763177579underline {
text-decoration:underline;}

#yiv3763177579 .yiv3763177579attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv3763177579 .yiv3763177579attach div a {
text-decoration:none;}

#yiv3763177579 .yiv3763177579attach img {
border:none;padding-right:5px;}

#yiv3763177579 .yiv3763177579attach label {
display:block;margin-bottom:5px;}

#yiv3763177579 .yiv3763177579attach label a {
text-decoration:none;}

#yiv3763177579 blockquote {
margin:0 0 0 4px;}

#yiv3763177579 .yiv3763177579bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3763177579 .yiv3763177579bold a {
text-decoration:none;}

#yiv3763177579 dd.yiv3763177579last p a {
font-family:Verdana;font-weight:700;}

#yiv3763177579 dd.yiv3763177579last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv3763177579 dd.yiv3763177579last p
span.yiv3763177579yshortcuts {
margin-right:0;}

#yiv3763177579 div.yiv3763177579attach-table div div a {
text-decoration:none;}

#yiv3763177579 div.yiv3763177579attach-table {
width:400px;}

#yiv3763177579 div.yiv3763177579file-title a, #yiv3763177579
div.yiv3763177579file-title a:active, #yiv3763177579
div.yiv3763177579file-title a:hover, #yiv3763177579
div.yiv3763177579file-title a:visited {
text-decoration:none;}

#yiv3763177579 div.yiv3763177579photo-title a,
#yiv3763177579 div.yiv3763177579photo-title a:active,
#yiv3763177579 div.yiv3763177579photo-title a:hover,
#yiv3763177579 div.yiv3763177579photo-title a:visited {
text-decoration:none;}

#yiv3763177579 div#yiv3763177579ygrp-mlmsg
#yiv3763177579ygrp-msg p a span.yiv3763177579yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3763177579 .yiv3763177579green {
color:#628c2a;}

#yiv3763177579 .yiv3763177579MsoNormal {
margin:0 0 0 0;}

#yiv3763177579 o {
font-size:0;}

#yiv3763177579 #yiv3763177579photos div {
float:left;width:72px;}

#yiv3763177579 #yiv3763177579photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv3763177579 #yiv3763177579photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv3763177579 #yiv3763177579reco-category {
font-size:77%;}

#yiv3763177579 #yiv3763177579reco-desc {
font-size:77%;}

#yiv3763177579 .yiv3763177579replbq {
margin:4px;}

#yiv3763177579 #yiv3763177579ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv3763177579 #yiv3763177579ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv3763177579 #yiv3763177579ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv3763177579 #yiv3763177579ygrp-mlmsg select,
#yiv3763177579 input, #yiv3763177579 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv3763177579 #yiv3763177579ygrp-mlmsg pre, #yiv3763177579
code {
font:115% monospace;}

#yiv3763177579 #yiv3763177579ygrp-mlmsg * {
line-height:1.22em;}

#yiv3763177579 #yiv3763177579ygrp-mlmsg #yiv3763177579logo {
padding-bottom:10px;}


#yiv3763177579 #yiv3763177579ygrp-msg p a {
font-family:Verdana;}

#yiv3763177579 #yiv3763177579ygrp-msg
p#yiv3763177579attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3763177579 #yiv3763177579ygrp-reco
#yiv3763177579reco-head {
color:#ff7900;font-weight:700;}

#yiv3763177579 #yiv3763177579ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3763177579 #yiv3763177579ygrp-sponsor #yiv3763177579ov
li a {
font-size:130%;text-decoration:none;}

#yiv3763177579 #yiv3763177579ygrp-sponsor #yiv3763177579ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3763177579 #yiv3763177579ygrp-sponsor #yiv3763177579ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3763177579 #yiv3763177579ygrp-text {
font-family:Georgia;}

#yiv3763177579 #yiv3763177579ygrp-text p {
margin:0 0 1em 0;}

#yiv3763177579 #yiv3763177579ygrp-text tt {
font-size:120%;}

#yiv3763177579 #yiv3763177579ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv3763177579
-a urmat la tron Eduard al VII23 febr 18 mart - Legea generala a

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

3a

Re: Last and Next Earnings Report Date

Sat Jan 28, 2017 6:46 pm (PST) . Posted by:

lutherkinchen

Hey all, I've using the updated formulas Doug provided to retrieve earnings dates and times.
Some symbols will pull in earnings dates when I open the worksheet and others do not.
Below is a look at the first 5 lines of my spreadsheet and you'll see 3 of the 5 symbols do not pull in earnings dates. Does this happen to any of you. (the spreadsheet has over 100 symbol and 75% do pull in correctly.)


The formulas used for earnings date are (ie. A7 has the symbol AAPL)
=smfStrExtr(SUBSTITUTE(RCHGetWebData("https://www.earningswhispers.com/stocks/"&$A7,"og:description",100),"%20"," "),"earnings on ",". Shares")


The formula for the time earnings announce pre/post session are (ie. A7 has symbol AAPL)
=SUBSTITUTE(smfStrExtr(SUBSTITUTE(RCHGetWebData("https://www.earningswhispers.com/stocks/"&$A7,"twitter.com",150),"%20"," ")," at "," via")," ET","")



Here's a look at the first 5 stocks in the worksheet I review each weekend.
It pulls in earnings dates for AGU & APA, but will not pull them in for AAPL, AMGN and AMZN.
Seems odd that 75% of the symbols will pull in the earnings dates but not the other 25%.
Any ideas on what I could do to pull in 100%.
thanks
Luther


Sym Price LT ST PA NT Earnings Dys AM/PM AAPL 121.95 u https://www.earningswhispers.com/stocks Unknown AGU 104.29 x 2/9/2017 https://www.earningswhispers.com/stocks 12 5:30 PM AMGN 157.16 x https://www.earningswhispers.com/stocks Unknown AMZN 835.77 u https://www.earningswhispers.com/stocks Unknown APA 62.08 d 2/23/2017 https://www.earningswhispers.com/stocks 26 8:00 AM

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

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

Visit Your Group

• New Members 18

• Privacy • Unsubscribe • Terms of Use