Minggu, 01 Maret 2015

[smf_addin] Digest Number 3341

10 Messages

Digest #3341

Messages

Sat Feb 28, 2015 1:35 pm (PST) . Posted by:

eremon9

I'm suddenly getting incorrect historical results for array-entered RCHGetYahooHistory formulas. Example tickers are RSP, IBM, WFC, DTV, among others. Is anyone else seeing this? -tom

Sat Feb 28, 2015 2:33 pm (PST) . Posted by:

"Yahoo!" lewglenn

I'm getting bogus results for IEF. The data in "Historical Prices" in Yahoo Finance looks OK, but the RCHGetYahooHistory function is returning garbage. But the function seems to be working OK when I use it to retrieve SPY, TLT, and EFA. Very strange.

On Saturday, February 28, 2015 1:35 PM, "tamurphy@cableone.net [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  I'm suddenly getting incorrect historical results for array-entered RCHGetYahooHistory formulas. Example tickers are RSP, IBM, WFC, DTV, among others. Is anyone else seeing this?   -tom #yiv4676362114 #yiv4676362114 -- #yiv4676362114ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4676362114 #yiv4676362114ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4676362114 #yiv4676362114ygrp-mkp #yiv4676362114hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4676362114 #yiv4676362114ygrp-mkp #yiv4676362114ads {margin-bottom:10px;}#yiv4676362114 #yiv4676362114ygrp-mkp .yiv4676362114ad {padding:0 0;}#yiv4676362114 #yiv4676362114ygrp-mkp .yiv4676362114ad p {margin:0;}#yiv4676362114 #yiv4676362114ygrp-mkp .yiv4676362114ad a {color:#0000ff;text-decoration:none;}#yiv4676362114 #yiv4676362114ygrp-sponsor #yiv4676362114ygrp-lc {font-family:Arial;}#yiv4676362114 #yiv4676362114ygrp-sponsor #yiv4676362114ygrp-lc #yiv4676362114hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4676362114 #yiv4676362114ygrp-sponsor #yiv4676362114ygrp-lc .yiv4676362114ad {margin-bottom:10px;padding:0 0;}#yiv4676362114 #yiv4676362114actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4676362114 #yiv4676362114activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4676362114 #yiv4676362114activity span {font-weight:700;}#yiv4676362114 #yiv4676362114activity span:first-child {text-transform:uppercase;}#yiv4676362114 #yiv4676362114activity span a {color:#5085b6;text-decoration:none;}#yiv4676362114 #yiv4676362114activity span span {color:#ff7900;}#yiv4676362114 #yiv4676362114activity span .yiv4676362114underline {text-decoration:underline;}#yiv4676362114 .yiv4676362114attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4676362114 .yiv4676362114attach div a {text-decoration:none;}#yiv4676362114 .yiv4676362114attach img {border:none;padding-right:5px;}#yiv4676362114 .yiv4676362114attach label {display:block;margin-bottom:5px;}#yiv4676362114 .yiv4676362114attach label a {text-decoration:none;}#yiv4676362114 blockquote {margin:0 0 0 4px;}#yiv4676362114 .yiv4676362114bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4676362114 .yiv4676362114bold a {text-decoration:none;}#yiv4676362114 dd.yiv4676362114last p a {font-family:Verdana;font-weight:700;}#yiv4676362114 dd.yiv4676362114last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4676362114 dd.yiv4676362114last p span.yiv4676362114yshortcuts {margin-right:0;}#yiv4676362114 div.yiv4676362114attach-table div div a {text-decoration:none;}#yiv4676362114 div.yiv4676362114attach-table {width:400px;}#yiv4676362114 div.yiv4676362114file-title a, #yiv4676362114 div.yiv4676362114file-title a:active, #yiv4676362114 div.yiv4676362114file-title a:hover, #yiv4676362114 div.yiv4676362114file-title a:visited {text-decoration:none;}#yiv4676362114 div.yiv4676362114photo-title a, #yiv4676362114 div.yiv4676362114photo-title a:active, #yiv4676362114 div.yiv4676362114photo-title a:hover, #yiv4676362114 div.yiv4676362114photo-title a:visited {text-decoration:none;}#yiv4676362114 div#yiv4676362114ygrp-mlmsg #yiv4676362114ygrp-msg p a span.yiv4676362114yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4676362114 .yiv4676362114green {color:#628c2a;}#yiv4676362114 .yiv4676362114MsoNormal {margin:0 0 0 0;}#yiv4676362114 o {font-size:0;}#yiv4676362114 #yiv4676362114photos div {float:left;width:72px;}#yiv4676362114 #yiv4676362114photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4676362114 #yiv4676362114photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4676362114 #yiv4676362114reco-category {font-size:77%;}#yiv4676362114 #yiv4676362114reco-desc {font-size:77%;}#yiv4676362114 .yiv4676362114replbq {margin:4px;}#yiv4676362114 #yiv4676362114ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4676362114 #yiv4676362114ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4676362114 #yiv4676362114ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4676362114 #yiv4676362114ygrp-mlmsg select, #yiv4676362114 input, #yiv4676362114 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4676362114 #yiv4676362114ygrp-mlmsg pre, #yiv4676362114 code {font:115% monospace;}#yiv4676362114 #yiv4676362114ygrp-mlmsg * {line-height:1.22em;}#yiv4676362114 #yiv4676362114ygrp-mlmsg #yiv4676362114logo {padding-bottom:10px;}#yiv4676362114 #yiv4676362114ygrp-msg p a {font-family:Verdana;}#yiv4676362114 #yiv4676362114ygrp-msg p#yiv4676362114attach-count span {color:#1E66AE;font-weight:700;}#yiv4676362114 #yiv4676362114ygrp-reco #yiv4676362114reco-head {color:#ff7900;font-weight:700;}#yiv4676362114 #yiv4676362114ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4676362114 #yiv4676362114ygrp-sponsor #yiv4676362114ov li a {font-size:130%;text-decoration:none;}#yiv4676362114 #yiv4676362114ygrp-sponsor #yiv4676362114ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4676362114 #yiv4676362114ygrp-sponsor #yiv4676362114ov ul {margin:0;padding:0 0 0 8px;}#yiv4676362114 #yiv4676362114ygrp-text {font-family:Georgia;}#yiv4676362114 #yiv4676362114ygrp-text p {margin:0 0 1em 0;}#yiv4676362114 #yiv4676362114ygrp-text tt {font-size:120%;}#yiv4676362114 #yiv4676362114ygrp-vital ul li:last-child {border-right:none !important;}#yiv4676362114

Sat Feb 28, 2015 3:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I looked at those online and they don't look good. Almost no change in
prices and nearly all days of zero volume.

On Sat, Feb 28, 2015 at 2:35 PM, tamurphy@cableone.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm suddenly getting incorrect historical results for array-entered
> RCHGetYahooHistory formulas. Example tickers are RSP, IBM, WFC, DTV, among
> others. Is anyone else seeing this? -tom
>

Sat Feb 28, 2015 3:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The historical prices web page on Yahoo looks bad to me, as does the CSV
file. All the prices are between $1.00 and $1.50.

On Sat, Feb 28, 2015 at 3:32 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm getting bogus results for *IEF. *The data in "Historical Prices" in
> Yahoo Finance looks OK, but the RCHGetYahooHistory function is returning
> garbage. But the function seems to be working OK when I use it to
> retrieve SPY, TLT, and EFA. Very strange.
>

Sat Feb 28, 2015 4:38 pm (PST) . Posted by:

"Yahoo!" lewglenn

Right you are. The "Historical Prices" page must have changed since I last looked at it. And, based on tamurphy's observations, Yahoo appears to have a problem on multiple listings. I'll report.
Thanks, Randy.


On Saturday, February 28, 2015 3:46 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  The historical prices web page on Yahoo looks bad to me, as does the CSV file. All the prices are between $1.00 and $1.50.

On Sat, Feb 28, 2015 at 3:32 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I'm getting bogus results for IEF. The data in "Historical Prices" in Yahoo Finance looks OK, but the RCHGetYahooHistory function is returning garbage. But the function seems to be working OK when I use it to retrieve SPY, TLT, and EFA. Very strange.

#yiv5666826423 #yiv5666826423 -- #yiv5666826423ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5666826423 #yiv5666826423ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5666826423 #yiv5666826423ygrp-mkp #yiv5666826423hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5666826423 #yiv5666826423ygrp-mkp #yiv5666826423ads {margin-bottom:10px;}#yiv5666826423 #yiv5666826423ygrp-mkp .yiv5666826423ad {padding:0 0;}#yiv5666826423 #yiv5666826423ygrp-mkp .yiv5666826423ad p {margin:0;}#yiv5666826423 #yiv5666826423ygrp-mkp .yiv5666826423ad a {color:#0000ff;text-decoration:none;}#yiv5666826423 #yiv5666826423ygrp-sponsor #yiv5666826423ygrp-lc {font-family:Arial;}#yiv5666826423 #yiv5666826423ygrp-sponsor #yiv5666826423ygrp-lc #yiv5666826423hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5666826423 #yiv5666826423ygrp-sponsor #yiv5666826423ygrp-lc .yiv5666826423ad {margin-bottom:10px;padding:0 0;}#yiv5666826423 #yiv5666826423actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5666826423 #yiv5666826423activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5666826423 #yiv5666826423activity span {font-weight:700;}#yiv5666826423 #yiv5666826423activity span:first-child {text-transform:uppercase;}#yiv5666826423 #yiv5666826423activity span a {color:#5085b6;text-decoration:none;}#yiv5666826423 #yiv5666826423activity span span {color:#ff7900;}#yiv5666826423 #yiv5666826423activity span .yiv5666826423underline {text-decoration:underline;}#yiv5666826423 .yiv5666826423attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5666826423 .yiv5666826423attach div a {text-decoration:none;}#yiv5666826423 .yiv5666826423attach img {border:none;padding-right:5px;}#yiv5666826423 .yiv5666826423attach label {display:block;margin-bottom:5px;}#yiv5666826423 .yiv5666826423attach label a {text-decoration:none;}#yiv5666826423 blockquote {margin:0 0 0 4px;}#yiv5666826423 .yiv5666826423bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5666826423 .yiv5666826423bold a {text-decoration:none;}#yiv5666826423 dd.yiv5666826423last p a {font-family:Verdana;font-weight:700;}#yiv5666826423 dd.yiv5666826423last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5666826423 dd.yiv5666826423last p span.yiv5666826423yshortcuts {margin-right:0;}#yiv5666826423 div.yiv5666826423attach-table div div a {text-decoration:none;}#yiv5666826423 div.yiv5666826423attach-table {width:400px;}#yiv5666826423 div.yiv5666826423file-title a, #yiv5666826423 div.yiv5666826423file-title a:active, #yiv5666826423 div.yiv5666826423file-title a:hover, #yiv5666826423 div.yiv5666826423file-title a:visited {text-decoration:none;}#yiv5666826423 div.yiv5666826423photo-title a, #yiv5666826423 div.yiv5666826423photo-title a:active, #yiv5666826423 div.yiv5666826423photo-title a:hover, #yiv5666826423 div.yiv5666826423photo-title a:visited {text-decoration:none;}#yiv5666826423 div#yiv5666826423ygrp-mlmsg #yiv5666826423ygrp-msg p a span.yiv5666826423yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5666826423 .yiv5666826423green {color:#628c2a;}#yiv5666826423 .yiv5666826423MsoNormal {margin:0 0 0 0;}#yiv5666826423 o {font-size:0;}#yiv5666826423 #yiv5666826423photos div {float:left;width:72px;}#yiv5666826423 #yiv5666826423photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5666826423 #yiv5666826423photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5666826423 #yiv5666826423reco-category {font-size:77%;}#yiv5666826423 #yiv5666826423reco-desc {font-size:77%;}#yiv5666826423 .yiv5666826423replbq {margin:4px;}#yiv5666826423 #yiv5666826423ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5666826423 #yiv5666826423ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5666826423 #yiv5666826423ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5666826423 #yiv5666826423ygrp-mlmsg select, #yiv5666826423 input, #yiv5666826423 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5666826423 #yiv5666826423ygrp-mlmsg pre, #yiv5666826423 code {font:115% monospace;}#yiv5666826423 #yiv5666826423ygrp-mlmsg * {line-height:1.22em;}#yiv5666826423 #yiv5666826423ygrp-mlmsg #yiv5666826423logo {padding-bottom:10px;}#yiv5666826423 #yiv5666826423ygrp-msg p a {font-family:Verdana;}#yiv5666826423 #yiv5666826423ygrp-msg p#yiv5666826423attach-count span {color:#1E66AE;font-weight:700;}#yiv5666826423 #yiv5666826423ygrp-reco #yiv5666826423reco-head {color:#ff7900;font-weight:700;}#yiv5666826423 #yiv5666826423ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5666826423 #yiv5666826423ygrp-sponsor #yiv5666826423ov li a {font-size:130%;text-decoration:none;}#yiv5666826423 #yiv5666826423ygrp-sponsor #yiv5666826423ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5666826423 #yiv5666826423ygrp-sponsor #yiv5666826423ov ul {margin:0;padding:0 0 0 8px;}#yiv5666826423 #yiv5666826423ygrp-text {font-family:Georgia;}#yiv5666826423 #yiv5666826423ygrp-text p {margin:0 0 1em 0;}#yiv5666826423 #yiv5666826423ygrp-text tt {font-size:120%;}#yiv5666826423 #yiv5666826423ygrp-vital ul li:last-child {border-right:none !important;}#yiv5666826423

Sat Feb 28, 2015 8:12 pm (PST) . Posted by:

eremon9

Thanks for looking into this and confirming the problem. I just recalculated my historical prices spreadsheet, and am hopeful that Yahoo has resolved the problem. At first glance, it appears the prices are more normal. I'll know for sure in about fifteen minutes.

Sat Feb 28, 2015 5:37 pm (PST) . Posted by:

cruel_toad

So here is an odd problem. I have not problem getting most figures from GuruFocus. But when I try to get PFCF via RCHGetTableCell("http://www.gurufocus.com/stock/ACHI", 1, "PFCF"), all I get back is a blank cell. No error or anything - just blank. Any idea what I could be doing wrong?


Thanks

Sat Feb 28, 2015 5:54 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27828

On Sat, Feb 28, 2015 at 6:37 PM, baseball@reverenddave.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> So here is an odd problem. I have not problem getting most figures from
> GuruFocus. But when I try to get PFCF via RCHGetTableCell("
> http://www.gurufocus.com/stock/ACHI", 1, "PFCF"), all I get back is a
> blank cell. No error or anything - just blank. Any idea what I could be
> doing wrong?
>
>

Sun Mar 1, 2015 1:34 am (PST) . Posted by:

rjemery7

For any given stock or fund symbol, how and from where could I capture a current value for the RSI (Relative Strength Index) as a number between 0 and 100?

Sun Mar 1, 2015 1:58 am (PST) . Posted by:

"Randy Harmelink" rharmelink

What definition of RSI are you referring to? There are multiple
definitions, besides just a period of time associated with it. For example,
the BarChart template has elements defined for 5 different periods of RSI.

On Sun, Mar 1, 2015 at 2:32 AM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> For any given stock or fund symbol, how and from where could I capture a
> current value for the RSI (Relative Strength Index) as a number between 0
> and 100?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar