Selasa, 23 Desember 2014

[smf_addin] Digest Number 3273[1 Attachment]

15 Messages

Digest #3273
1.1
Re: RCHGetElementNumber by "Randy Harmelink" rharmelink
1.2
3a
Yahoo data returning errors by "Scott Hutchens" shhutchens6
3b
Re: Yahoo data returning errors by "Jose Jacob" pepecan47
3d
Re: Yahoo data returning errors by "Randy Harmelink" rharmelink
3e
Re: Yahoo data returning errors by "Jose Jacob" pepecan47
3f
Re: Yahoo data returning errors by "Randy Harmelink" rharmelink
4a
Current Price? by megaloellhnas
4b
Re: Current Price? by "Randy Harmelink" rharmelink
4c
Re: Current Price? by megaloellhnas

Messages

Tue Dec 23, 2014 3:33 am (PST) . Posted by:

"Randy Harmelink" rharmelink

HKG:1043 *does* work -- for the few line items that match up. That
particular example has a lot of different line items than IBM does. Keep in
mind that a template is just as example for you to work from, to build your
own worksheets -- not to be an end product. So you may need to customize it
for the line items you're interested in.

On Tue, Dec 23, 2014 at 2:09 AM, wongkayau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Just a follow up on the
> "SMF-Template-Google-Income-Statement-Tables.xls". It works for ticker
> "IBM", but does not for HK stocks (e.g. HKG:1043). Could you pls advise me?
>
>

Tue Dec 23, 2014 4:49 am (PST) . Posted by:

wongkayau

Hi Randy,


No wonder. It shows only few lines for HK-listed stocks.


Thank you so much for your help.


Cheers, L

Tue Dec 23, 2014 3:51 am (PST) . Posted by:

jchealey66

Hi,

Does anybody know why I cannot retrieve prices (data) for the following indices Spain IBEX 35, China Shanghai Comp and India BSE Sensex?

Data is available on the Yahoo Finance Website.

Yahoo Symbols are:
^IBEX
000001.SS
^BSESN


I am based in the UK


Thanks,
Regards,
James

Tue Dec 23, 2014 4:41 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I was able to use RCHGetYahooQuotes() on ^IBEX and 000001.SS, but Yahoo
didn't have data available for ^BSESN. Using the CSV file interface, anyway
(the "Download delayed data" link on the summary pages).

On Tue, Dec 23, 2014 at 4:51 AM, jameshealey@... wrote:
>
>
> Does anybody know why I cannot retrieve prices (data) for the following
> indices Spain IBEX 35, China Shanghai Comp and India BSE Sensex?
>
> Data is available on the Yahoo Finance Website.
>
> Yahoo Symbols are:
> ^IBEX
> 000001.SS
> ^BSESN
>
> I am based in the UK
>
>

Tue Dec 23, 2014 8:06 am (PST) . Posted by:

"James Healey" jchealey66

Thanks for reply,

I am using the attached file (SMF-Template-RCHGetYahooQuotes) to get my data which I downloaded from SMF Templates area. I have added the ticker symbols to the end of the list but I cannot get any data. All other symbols entered are working fine.

I cannot get ^IBEX or 000001.SS to work so am I doing something wrong????

Thanks again,

James

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: 23 December 2014 12:41
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Cannot get data for Spain IBEX, China Shanghai Comp and India BSE Sensex

I was able to use RCHGetYahooQuotes() on ^IBEX and 000001.SS, but Yahoo didn't have data available for ^BSESN. Using the CSV file interface, anyway (the "Download delayed data" link on the summary pages).

On Tue, Dec 23, 2014 at 4:51 AM, jameshealey@... wrote:

Does anybody know why I cannot retrieve prices (data) for the following indices Spain IBEX 35, China Shanghai Comp and India BSE Sensex?

Data is available on the Yahoo Finance Website.

Yahoo Symbols are:
^IBEX
000001.SS
^BSESN

I am based in the UK

Attachment(s) from James Healey
1 of 1 File(s)

Tue Dec 23, 2014 8:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Now I'm getting data for ^IBEX and ^BSESN, but not 000001.SS. Both using
the add-in function and the Yahoo web page options. So I'm thinking it's a
Yahoo glitch...

On Tue, Dec 23, 2014 at 9:06 AM, 'James Healey' jameshealey@,,, wrote:
>
>
> I am using the attached file (SMF-Template-RCHGetYahooQuotes) to get my
> data which I downloaded from SMF Templates area. I have added the ticker
> symbols to the end of the list but I cannot get any data. All other symbols
> entered are working fine.
>
>
>
> I cannot get ^IBEX or 000001.SS to work so am I doing something wrong????
>
>
>
>

Tue Dec 23, 2014 8:02 am (PST) . Posted by:

"Scott Hutchens" shhutchens6

Hi there,Im pulling data from yahoo and it seems my spreadsheet only loads about two thirds of the different metrics from yahoo like earnings and sales numbers. This spreadsheet has worked well in the past it has 200 tickers and about 7 different metrics per ticker. Not sure if anyone else is having this issue. I think it might be yahoos issue to solve. I was wondering if there is a macro to update only the values that return errors in the spreadsheet. I have tried smfforcerecalculation but just want to recalculate the returned errors. Thanks.-Scott

Tue Dec 23, 2014 8:47 am (PST) . Posted by:

"Jose Jacob" pepecan47

I am having similar issues with Yahoo. In my case my spreadsheet has less than 40 tickers, and randomly give me errors in about 5-10 of them.

I thought that it was only me. Maybe it is a Yahoo thing.

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 12/23/14, Scott Hutchens shhutchens6@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: [smf_addin] Yahoo data returning errors
To: "Randy Harmelink" <rharmelink@gmail.com>, "Smf_addin" <smf_addin@yahoogroups.com>
Received: Tuesday, December 23, 2014, 10:59 AM


 









Hi
there,Im pulling
data from yahoo and it seems my spreadsheet only loads about
two thirds of the different metrics from yahoo like earnings
and sales numbers. This spreadsheet has worked well in the
past it has 200 tickers and about 7 different metrics per
ticker. Not sure if anyone else is having this issue. I
think it might be yahoos issue to solve. I was wondering if
there is a macro to update only the values that return
errors in the spreadsheet. I have tried
smfforcerecalculation but just want to recalculate the
returned errors. Thanks.-Scott









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

#yiv1662240913 #yiv1662240913ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1662240913 #yiv1662240913ygrp-mkp #yiv1662240913hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1662240913 #yiv1662240913ygrp-mkp #yiv1662240913ads {
margin-bottom:10px;}

#yiv1662240913 #yiv1662240913ygrp-mkp .yiv1662240913ad {
padding:0 0;}

#yiv1662240913 #yiv1662240913ygrp-mkp .yiv1662240913ad p {
margin:0;}

#yiv1662240913 #yiv1662240913ygrp-mkp .yiv1662240913ad a {
color:#0000ff;text-decoration:none;}
#yiv1662240913 #yiv1662240913ygrp-sponsor
#yiv1662240913ygrp-lc {
font-family:Arial;}

#yiv1662240913 #yiv1662240913ygrp-sponsor
#yiv1662240913ygrp-lc #yiv1662240913hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1662240913 #yiv1662240913ygrp-sponsor
#yiv1662240913ygrp-lc .yiv1662240913ad {
margin-bottom:10px;padding:0 0;}

#yiv1662240913 #yiv1662240913actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv1662240913 #yiv1662240913activity span {
font-weight:700;}

#yiv1662240913 #yiv1662240913activity span:first-child {
text-transform:uppercase;}

#yiv1662240913 #yiv1662240913activity span a {
color:#5085b6;text-decoration:none;}

#yiv1662240913 #yiv1662240913activity span span {
color:#ff7900;}

#yiv1662240913 #yiv1662240913activity span
.yiv1662240913underline {
text-decoration:underline;}

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

#yiv1662240913 .yiv1662240913attach div a {
text-decoration:none;}

#yiv1662240913 .yiv1662240913attach img {
border:none;padding-right:5px;}

#yiv1662240913 .yiv1662240913attach label {
display:block;margin-bottom:5px;}

#yiv1662240913 .yiv1662240913attach label a {
text-decoration:none;}

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

#yiv1662240913 .yiv1662240913bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1662240913 .yiv1662240913bold a {
text-decoration:none;}

#yiv1662240913 dd.yiv1662240913last p a {
font-family:Verdana;font-weight:700;}

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

#yiv1662240913 dd.yiv1662240913last p
span.yiv1662240913yshortcuts {
margin-right:0;}

#yiv1662240913 div.yiv1662240913attach-table div div a {
text-decoration:none;}

#yiv1662240913 div.yiv1662240913attach-table {
width:400px;}

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

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

#yiv1662240913 div#yiv1662240913ygrp-mlmsg
#yiv1662240913ygrp-msg p a span.yiv1662240913yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1662240913 .yiv1662240913green {
color:#628c2a;}

#yiv1662240913 .yiv1662240913MsoNormal {
margin:0 0 0 0;}

#yiv1662240913 o {
font-size:0;}

#yiv1662240913 #yiv1662240913photos div {
float:left;width:72px;}

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

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

#yiv1662240913 #yiv1662240913reco-category {
font-size:77%;}

#yiv1662240913 #yiv1662240913reco-desc {
font-size:77%;}

#yiv1662240913 .yiv1662240913replbq {
margin:4px;}

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

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

#yiv1662240913 #yiv1662240913ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv1662240913 #yiv1662240913ygrp-mlmsg pre, #yiv1662240913
code {
font:115% monospace;}

#yiv1662240913 #yiv1662240913ygrp-mlmsg * {
line-height:1.22em;}

#yiv1662240913 #yiv1662240913ygrp-mlmsg #yiv1662240913logo {
padding-bottom:10px;}


#yiv1662240913 #yiv1662240913ygrp-msg p a {
font-family:Verdana;}

#yiv1662240913 #yiv1662240913ygrp-msg
p#yiv1662240913attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1662240913 #yiv1662240913ygrp-reco
#yiv1662240913reco-head {
color:#ff7900;font-weight:700;}

#yiv1662240913 #yiv1662240913ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1662240913 #yiv1662240913ygrp-sponsor #yiv1662240913ov
li a {
font-size:130%;text-decoration:none;}

#yiv1662240913 #yiv1662240913ygrp-sponsor #yiv1662240913ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1662240913 #yiv1662240913ygrp-sponsor #yiv1662240913ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1662240913 #yiv1662240913ygrp-text {
font-family:Georgia;}

#yiv1662240913 #yiv1662240913ygrp-text p {
margin:0 0 1em 0;}

#yiv1662240913 #yiv1662240913ygrp-text tt {
font-size:120%;}

#yiv1662240913 #yiv1662240913ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv1662240913


Tue Dec 23, 2014 8:49 am (PST) . Posted by:

rharmelink

Sounds like you're running into the 1000-webpage limit per session. The add-in needs to save a web page before it can extract data from it, but there are 1000 slots for saving the web pages.

There is no macro to only update values with errors. But you could convert successful items to values before running smfForceRecalculation.

The smfUpdateDownloadTable macro process might give you more flexibility. Earlier this year, I added the capability to have it update only selected rows, columns, or ranges within the table.

---In smf_addin@yahoogroups.com, <shhutchens6@yahoo.com> wrote :

Hi there,
Im pulling data from yahoo and it seems my spreadsheet only loads about two thirds of the different metrics from yahoo like earnings and sales numbers. This spreadsheet has worked well in the past it has 200 tickers and about 7 different metrics per ticker. Not sure if anyone else is having this issue. I think it might be yahoos issue to solve. I was wondering if there is a macro to update only the values that return errors in the spreadsheet. I have tried smfforcerecalculation but just want to recalculate the returned errors. Thanks.
-Scott



Tue Dec 23, 2014 8:52 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If yours are RCHGetYahooQuotes() functions, you may get a lot better
performance by array-entering one over a range instead of using functions
in individual cells or rows...

On Tue, Dec 23, 2014 at 9:47 AM, Jose Jacob pepecan47@... wrote:
>
> I am having similar issues with Yahoo. In my case my spreadsheet has less
> than 40 tickers, and randomly give me errors in about 5-10 of them.
>
> I thought that it was only me. Maybe it is a Yahoo thing.
>
>

Tue Dec 23, 2014 10:17 am (PST) . Posted by:

"Jose Jacob" pepecan47

One of the functions that give me errors for some tickers and it is ok for others:

=RCHGetTableCell("http://finance.yahoo.com/q/ae?s="&A15,1,"Next 5 Years (per annum)")

I got errors for AFL, ED, JNJ, KO. It's ok for BAX, CLX, KMB

When I go to Yahoo Finance using IE, enter the ticker, and when going to the KEY STATISTICS tab, sometimes I get a big message "SERVER INTERNAL ERROR", then I refresh the session and it's ok. Most of the times is ok, but sometimes got this error.

Regards,
Jose L. Jacob

--------------------------------------------
On Tue, 12/23/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Yahoo data returning errors
To: smf_addin@yahoogroups.com
Received: Tuesday, December 23, 2014, 11:52 AM


 









If yours are RCHGetYahooQuotes()
functions, you may get a lot better performance by
array-entering one over a range instead of using functions
in individual cells or rows...

On Tue, Dec 23, 2014 at
9:47 AM, Jose Jacob pepecan47@...
wrote:I am having similar
issues with Yahoo. In my case my spreadsheet has less than
40 tickers, and randomly give me errors in about 5-10 of
them.



I thought that it was only me. Maybe it is a Yahoo thing.














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

#yiv6493725056 #yiv6493725056ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv6493725056 #yiv6493725056ygrp-mkp #yiv6493725056hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv6493725056 #yiv6493725056ygrp-mkp #yiv6493725056ads {
margin-bottom:10px;}

#yiv6493725056 #yiv6493725056ygrp-mkp .yiv6493725056ad {
padding:0 0;}

#yiv6493725056 #yiv6493725056ygrp-mkp .yiv6493725056ad p {
margin:0;}

#yiv6493725056 #yiv6493725056ygrp-mkp .yiv6493725056ad a {
color:#0000ff;text-decoration:none;}
#yiv6493725056 #yiv6493725056ygrp-sponsor
#yiv6493725056ygrp-lc {
font-family:Arial;}

#yiv6493725056 #yiv6493725056ygrp-sponsor
#yiv6493725056ygrp-lc #yiv6493725056hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv6493725056 #yiv6493725056ygrp-sponsor
#yiv6493725056ygrp-lc .yiv6493725056ad {
margin-bottom:10px;padding:0 0;}

#yiv6493725056 #yiv6493725056actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv6493725056 #yiv6493725056activity span {
font-weight:700;}

#yiv6493725056 #yiv6493725056activity span:first-child {
text-transform:uppercase;}

#yiv6493725056 #yiv6493725056activity span a {
color:#5085b6;text-decoration:none;}

#yiv6493725056 #yiv6493725056activity span span {
color:#ff7900;}

#yiv6493725056 #yiv6493725056activity span
.yiv6493725056underline {
text-decoration:underline;}

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

#yiv6493725056 .yiv6493725056attach div a {
text-decoration:none;}

#yiv6493725056 .yiv6493725056attach img {
border:none;padding-right:5px;}

#yiv6493725056 .yiv6493725056attach label {
display:block;margin-bottom:5px;}

#yiv6493725056 .yiv6493725056attach label a {
text-decoration:none;}

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

#yiv6493725056 .yiv6493725056bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv6493725056 .yiv6493725056bold a {
text-decoration:none;}

#yiv6493725056 dd.yiv6493725056last p a {
font-family:Verdana;font-weight:700;}

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

#yiv6493725056 dd.yiv6493725056last p
span.yiv6493725056yshortcuts {
margin-right:0;}

#yiv6493725056 div.yiv6493725056attach-table div div a {
text-decoration:none;}

#yiv6493725056 div.yiv6493725056attach-table {
width:400px;}

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

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

#yiv6493725056 div#yiv6493725056ygrp-mlmsg
#yiv6493725056ygrp-msg p a span.yiv6493725056yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv6493725056 .yiv6493725056green {
color:#628c2a;}

#yiv6493725056 .yiv6493725056MsoNormal {
margin:0 0 0 0;}

#yiv6493725056 o {
font-size:0;}

#yiv6493725056 #yiv6493725056photos div {
float:left;width:72px;}

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

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

#yiv6493725056 #yiv6493725056reco-category {
font-size:77%;}

#yiv6493725056 #yiv6493725056reco-desc {
font-size:77%;}

#yiv6493725056 .yiv6493725056replbq {
margin:4px;}

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

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

#yiv6493725056 #yiv6493725056ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv6493725056 #yiv6493725056ygrp-mlmsg pre, #yiv6493725056
code {
font:115% monospace;}

#yiv6493725056 #yiv6493725056ygrp-mlmsg * {
line-height:1.22em;}

#yiv6493725056 #yiv6493725056ygrp-mlmsg #yiv6493725056logo {
padding-bottom:10px;}


#yiv6493725056 #yiv6493725056ygrp-msg p a {
font-family:Verdana;}

#yiv6493725056 #yiv6493725056ygrp-msg
p#yiv6493725056attach-count span {
color:#1E66AE;font-weight:700;}

#yiv6493725056 #yiv6493725056ygrp-reco
#yiv6493725056reco-head {
color:#ff7900;font-weight:700;}

#yiv6493725056 #yiv6493725056ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv6493725056 #yiv6493725056ygrp-sponsor #yiv6493725056ov
li a {
font-size:130%;text-decoration:none;}

#yiv6493725056 #yiv6493725056ygrp-sponsor #yiv6493725056ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv6493725056 #yiv6493725056ygrp-sponsor #yiv6493725056ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv6493725056 #yiv6493725056ygrp-text {
font-family:Georgia;}

#yiv6493725056 #yiv6493725056ygrp-text p {
margin:0 0 1em 0;}

#yiv6493725056 #yiv6493725056ygrp-text tt {
font-size:120%;}

#yiv6493725056 #yiv6493725056ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv6493725056


Tue Dec 23, 2014 10:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If IE is getting an error, that same thing would cause the add-in results
to result in an error. Not much to do about it if the error is on Yahoo's
side....sigh.

On Tue, Dec 23, 2014 at 11:17 AM, Jose Jacob pepecan47@... wrote:
>
> One of the functions that give me errors for some tickers and it is ok for
> others:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ae?s="&A15,1,"Next 5 Years
> (per annum)")
>
> I got errors for AFL, ED, JNJ, KO. It's ok for BAX, CLX, KMB
>
> When I go to Yahoo Finance using IE, enter the ticker, and when going to
> the KEY STATISTICS tab, sometimes I get a big message "SERVER INTERNAL
> ERROR", then I refresh the session and it's ok. Most of the times is ok,
> but sometimes got this error.
>
>

Tue Dec 23, 2014 9:26 am (PST) . Posted by:

megaloellhnas

Hello,

New to the group and using the SMF add-in. I most commonly just want to see the current (or last available) price of a stock while the market is open or closed. I can't seem to find this option in the long list of available elements. This sounds like a dumb question as I type this out... Surely this must be available?

Tue Dec 23, 2014 9:28 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Take a look at the RCHGetYahooQuotes() function. For example, to just get
last price:

=RCHGetYahooQuotes("MMM","l1")

On Tue, Dec 23, 2014 at 10:18 AM, megaloellhnas@...wrote:
>
>
> New to the group and using the SMF add-in. I most commonly just want to
> see the current (or last available) price of a stock while the market is
> open or closed. I can't seem to find this option in the long list of
> available elements. This sounds like a dumb question as I type this out...
> Surely this must be available?
>

Tue Dec 23, 2014 12:03 pm (PST) . Posted by:

megaloellhnas

Thanks Randy! This is way better than the old MSN Money add-in I've used for years.

One other quick questions, how I do manually (or automatically) have all the data (retrieved from Yahoo) update so I can see the latest prices?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 12.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)