1 Message
Digest #3868
Message
Sun Dec 18, 2016 8:35 am (PST) . Posted by:
"Bryce Goehring" brigity10
Anyone else having issues pulling Diluted EPS (element 962) from yahoo? I am just getting error for aapl and others.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, November 30, 2016 9:53 AM
Subject: Re: [smf_addin] Re: Yahoo Elements
It appears the JSON code is right in the web page of the Key Statistics. For example, this:
=RCHGetWebData("http://finance.yahoo.com/quote/MMM/key-statistics","""fiftyDayAverage"":")
...returns something like:
"fiftyDayAverage":{"raw":170.09029,"fmt":"170.09"},"trailingAnnualDividendRate":{"raw":4.355,"fmt":"4.36"},"open":{"raw":172.2,"fmt":"172.20"},"averageVolume10days":{"raw":1520300,"fmt":"1.52M","longFmt":"1,520,300"}...
For me, anyway. Try it and see what you get?
So you could go after each, one by one, using their field names...
A tool that might help is the SMF-Quick-Webpage-Examination.xls workbook. Go to the "By cascading value" worksheet and set:
D7: http://finance.yahoo.com/quote/MMM/key-statistics
D8: "raw":
...and it will parse the web page by each of the raw values it has on the web page. You should be able to do some manipulation from there to get the field names for each raw or formatted value. The format can vary as some field names have multiple values.
On Wed, Nov 30, 2016 at 8:03 AM, justy_sports@...wrote:
Is there a similar JSON page for the "Statistics" page? I tried using the module "defaultKeyStatistics" but it is missing certain items (like 50 day moving average). Just looking for the URL (if there is one), I can build the formula to extract the data from there.
#yiv4494248456 #yiv4494248456 -- #yiv4494248456ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4494248456 #yiv4494248456ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4494248456 #yiv4494248456ygrp-mkp #yiv4494248456hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4494248456 #yiv4494248456ygrp-mkp #yiv4494248456ads {margin-bottom:10px;}#yiv4494248456 #yiv4494248456ygrp-mkp .yiv4494248456ad {padding:0 0;}#yiv4494248456 #yiv4494248456ygrp-mkp .yiv4494248456ad p {margin:0;}#yiv4494248456 #yiv4494248456ygrp-mkp .yiv4494248456ad a {color:#0000ff;text-decoration:none;}#yiv4494248456 #yiv4494248456ygrp-sponsor #yiv4494248456ygrp-lc {font-family:Arial;}#yiv4494248456 #yiv4494248456ygrp-sponsor #yiv4494248456ygrp-lc #yiv4494248456hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4494248456 #yiv4494248456ygrp-sponsor #yiv4494248456ygrp-lc .yiv4494248456ad {margin-bottom:10px;padding:0 0;}#yiv4494248456 #yiv4494248456actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4494248456 #yiv4494248456activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4494248456 #yiv4494248456activity span {font-weight:700;}#yiv4494248456 #yiv4494248456activity span:first-child {text-transform:uppercase;}#yiv4494248456 #yiv4494248456activity span a {color:#5085b6;text-decoration:none;}#yiv4494248456 #yiv4494248456activity span span {color:#ff7900;}#yiv4494248456 #yiv4494248456activity span .yiv4494248456underline {text-decoration:underline;}#yiv4494248456 .yiv4494248456attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4494248456 .yiv4494248456attach div a {text-decoration:none;}#yiv4494248456 .yiv4494248456attach img {border:none;padding-right:5px;}#yiv4494248456 .yiv4494248456attach label {display:block;margin-bottom:5px;}#yiv4494248456 .yiv4494248456attach label a {text-decoration:none;}#yiv4494248456 blockquote {margin:0 0 0 4px;}#yiv4494248456 .yiv4494248456bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4494248456 .yiv4494248456bold a {text-decoration:none;}#yiv4494248456 dd.yiv4494248456last p a {font-family:Verdana;font-weight:700;}#yiv4494248456 dd.yiv4494248456last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4494248456 dd.yiv4494248456last p span.yiv4494248456yshortcuts {margin-right:0;}#yiv4494248456 div.yiv4494248456attach-table div div a {text-decoration:none;}#yiv4494248456 div.yiv4494248456attach-table {width:400px;}#yiv4494248456 div.yiv4494248456file-title a, #yiv4494248456 div.yiv4494248456file-title a:active, #yiv4494248456 div.yiv4494248456file-title a:hover, #yiv4494248456 div.yiv4494248456file-title a:visited {text-decoration:none;}#yiv4494248456 div.yiv4494248456photo-title a, #yiv4494248456 div.yiv4494248456photo-title a:active, #yiv4494248456 div.yiv4494248456photo-title a:hover, #yiv4494248456 div.yiv4494248456photo-title a:visited {text-decoration:none;}#yiv4494248456 div#yiv4494248456ygrp-mlmsg #yiv4494248456ygrp-msg p a span.yiv4494248456yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4494248456 .yiv4494248456green {color:#628c2a;}#yiv4494248456 .yiv4494248456MsoNormal {margin:0 0 0 0;}#yiv4494248456 o {font-size:0;}#yiv4494248456 #yiv4494248456photos div {float:left;width:72px;}#yiv4494248456 #yiv4494248456photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4494248456 #yiv4494248456photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4494248456 #yiv4494248456reco-category {font-size:77%;}#yiv4494248456 #yiv4494248456reco-desc {font-size:77%;}#yiv4494248456 .yiv4494248456replbq {margin:4px;}#yiv4494248456 #yiv4494248456ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4494248456 #yiv4494248456ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4494248456 #yiv4494248456ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4494248456 #yiv4494248456ygrp-mlmsg select, #yiv4494248456 input, #yiv4494248456 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4494248456 #yiv4494248456ygrp-mlmsg pre, #yiv4494248456 code {font:115% monospace;}#yiv4494248456 #yiv4494248456ygrp-mlmsg * {line-height:1.22em;}#yiv4494248456 #yiv4494248456ygrp-mlmsg #yiv4494248456logo {padding-bottom:10px;}#yiv4494248456 #yiv4494248456ygrp-msg p a {font-family:Verdana;}#yiv4494248456 #yiv4494248456ygrp-msg p#yiv4494248456attach-count span {color:#1E66AE;font-weight:700;}#yiv4494248456 #yiv4494248456ygrp-reco #yiv4494248456reco-head {color:#ff7900;font-weight:700;}#yiv4494248456 #yiv4494248456ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4494248456 #yiv4494248456ygrp-sponsor #yiv4494248456ov li a {font-size:130%;text-decoration:none;}#yiv4494248456 #yiv4494248456ygrp-sponsor #yiv4494248456ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4494248456 #yiv4494248456ygrp-sponsor #yiv4494248456ov ul {margin:0;padding:0 0 0 8px;}#yiv4494248456 #yiv4494248456ygrp-text {font-family:Georgia;}#yiv4494248456 #yiv4494248456ygrp-text p {margin:0 0 1em 0;}#yiv4494248456 #yiv4494248456ygrp-text tt {font-size:120%;}#yiv4494248456 #yiv4494248456ygrp-vital ul li:last-child {border-right:none !important;}#yiv4494248456
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, November 30, 2016 9:53 AM
Subject: Re: [smf_addin] Re: Yahoo Elements
It appears the JSON code is right in the web page of the Key Statistics. For example, this:
=RCHGetWebData("http://finance.yahoo.com/quote/MMM/key-statistics","""fiftyDayAverage"":")
...returns something like:
"fiftyDayAverage":{"raw":170.09029,"fmt":"170.09"},"trailingAnnualDividendRate":{"raw":4.355,"fmt":"4.36"},"open":{"raw":172.2,"fmt":"172.20"},"averageVolume10days":{"raw":1520300,"fmt":"1.52M","longFmt":"1,520,300"}...
For me, anyway. Try it and see what you get?
So you could go after each, one by one, using their field names...
A tool that might help is the SMF-Quick-Webpage-Examination.xls workbook. Go to the "By cascading value" worksheet and set:
D7: http://finance.yahoo.com/quote/MMM/key-statistics
D8: "raw"
...and it will parse the web page by each of the raw values it has on the web page. You should be able to do some manipulation from there to get the field names for each raw or formatted value. The format can vary as some field names have multiple values.
On Wed, Nov 30, 2016 at 8:03 AM, justy_sports@...wrote:
Is there a similar JSON page for the "Statistics&qu
#yiv4494248456 #yiv4494248456 -- #yiv4494248456ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar