15 Messages
Digest #3244
Messages
Thu Nov 20, 2014 7:22 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
Could you please give me a sample of what you use and how to use it? I think it is RCHGetTableCell(), but I am not sure.
For example,how would I pull "Discount" for NPI?
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, November 19, 2014 5:57 PM
Subject: Re: [smf_addin] cefconnect
According to my FireFox HTTPFix extension, it looks like the data is here:
http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip
On Wed, Nov 19, 2014 at 4:43 PM, Ron Spruell hashky@...wrote:
I am back at the trough to beg and grovel again. I had a great spreadsheet written that worked well, and then cefconnect.com changed their website to java script. I would like to be able to put in a portfolio and pull data from cefconnect and morningstar. But the cefconnect portion is broken.
I was pulling in
| Ticker | Fund Name | Strategy | ClosingPrice | PriceChange | NAV | Premium/Discount | DistributionRate |
using
=RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx",">Fund Name",-1,"",1)in an array.
Can you help? I don't know where to go to look for the data.
Ron Spruell
#yiv3429672347 #yiv3429672347 -- #yiv3429672347ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3429672347 #yiv3429672347ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3429672347 #yiv3429672347ygrp-mkp #yiv3429672347hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3429672347 #yiv3429672347ygrp-mkp #yiv3429672347ads {margin-bottom:10px;}#yiv3429672347 #yiv3429672347ygrp-mkp .yiv3429672347ad {padding:0 0;}#yiv3429672347 #yiv3429672347ygrp-mkp .yiv3429672347ad p {margin:0;}#yiv3429672347 #yiv3429672347ygrp-mkp .yiv3429672347ad a {color:#0000ff;text-decoration:none;}#yiv3429672347 #yiv3429672347ygrp-sponsor #yiv3429672347ygrp-lc {font-family:Arial;}#yiv3429672347 #yiv3429672347ygrp-sponsor #yiv3429672347ygrp-lc #yiv3429672347hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3429672347 #yiv3429672347ygrp-sponsor #yiv3429672347ygrp-lc .yiv3429672347ad {margin-bottom:10px;padding:0 0;}#yiv3429672347 #yiv3429672347actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3429672347 #yiv3429672347activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3429672347 #yiv3429672347activity span {font-weight:700;}#yiv3429672347 #yiv3429672347activity span:first-child {text-transform:uppercase;}#yiv3429672347 #yiv3429672347activity span a {color:#5085b6;text-decoration:none;}#yiv3429672347 #yiv3429672347activity span span {color:#ff7900;}#yiv3429672347 #yiv3429672347activity span .yiv3429672347underline {text-decoration:underline;}#yiv3429672347 .yiv3429672347attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3429672347 .yiv3429672347attach div a {text-decoration:none;}#yiv3429672347 .yiv3429672347attach img {border:none;padding-right:5px;}#yiv3429672347 .yiv3429672347attach label {display:block;margin-bottom:5px;}#yiv3429672347 .yiv3429672347attach label a {text-decoration:none;}#yiv3429672347 blockquote {margin:0 0 0 4px;}#yiv3429672347 .yiv3429672347bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3429672347 .yiv3429672347bold a {text-decoration:none;}#yiv3429672347 dd.yiv3429672347last p a {font-family:Verdana;font-weight:700;}#yiv3429672347 dd.yiv3429672347last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3429672347 dd.yiv3429672347last p span.yiv3429672347yshortcuts {margin-right:0;}#yiv3429672347 div.yiv3429672347attach-table div div a {text-decoration:none;}#yiv3429672347 div.yiv3429672347attach-table {width:400px;}#yiv3429672347 div.yiv3429672347file-title a, #yiv3429672347 div.yiv3429672347file-title a:active, #yiv3429672347 div.yiv3429672347file-title a:hover, #yiv3429672347 div.yiv3429672347file-title a:visited {text-decoration:none;}#yiv3429672347 div.yiv3429672347photo-title a, #yiv3429672347 div.yiv3429672347photo-title a:active, #yiv3429672347 div.yiv3429672347photo-title a:hover, #yiv3429672347 div.yiv3429672347photo-title a:visited {text-decoration:none;}#yiv3429672347 div#yiv3429672347ygrp-mlmsg #yiv3429672347ygrp-msg p a span.yiv3429672347yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3429672347 .yiv3429672347green {color:#628c2a;}#yiv3429672347 .yiv3429672347MsoNormal {margin:0 0 0 0;}#yiv3429672347 o {font-size:0;}#yiv3429672347 #yiv3429672347photos div {float:left;width:72px;}#yiv3429672347 #yiv3429672347photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3429672347 #yiv3429672347photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3429672347 #yiv3429672347reco-category {font-size:77%;}#yiv3429672347 #yiv3429672347reco-desc {font-size:77%;}#yiv3429672347 .yiv3429672347replbq {margin:4px;}#yiv3429672347 #yiv3429672347ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3429672347 #yiv3429672347ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3429672347 #yiv3429672347ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3429672347 #yiv3429672347ygrp-mlmsg select, #yiv3429672347 input, #yiv3429672347 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3429672347 #yiv3429672347ygrp-mlmsg pre, #yiv3429672347 code {font:115% monospace;}#yiv3429672347 #yiv3429672347ygrp-mlmsg * {line-height:1.22em;}#yiv3429672347 #yiv3429672347ygrp-mlmsg #yiv3429672347logo {padding-bottom:10px;}#yiv3429672347 #yiv3429672347ygrp-msg p a {font-family:Verdana;}#yiv3429672347 #yiv3429672347ygrp-msg p#yiv3429672347attach-count span {color:#1E66AE;font-weight:700;}#yiv3429672347 #yiv3429672347ygrp-reco #yiv3429672347reco-head {color:#ff7900;font-weight:700;}#yiv3429672347 #yiv3429672347ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3429672347 #yiv3429672347ygrp-sponsor #yiv3429672347ov li a {font-size:130%;text-decoration:none;}#yiv3429672347 #yiv3429672347ygrp-sponsor #yiv3429672347ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3429672347 #yiv3429672347ygrp-sponsor #yiv3429672347ov ul {margin:0;padding:0 0 0 8px;}#yiv3429672347 #yiv3429672347ygrp-text {font-family:Georgia;}#yiv3429672347 #yiv3429672347ygrp-text p {margin:0 0 1em 0;}#yiv3429672347 #yiv3429672347ygrp-text tt {font-size:120%;}#yiv3429672347 #yiv3429672347ygrp-vital ul li:last-child {border-right:none !important;}#yiv3429672347
Could you please give me a sample of what you use and how to use it? I think it is RCHGetTableCell(), but I am not sure.
For example,how would I pull "Discount" for NPI?
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, November 19, 2014 5:57 PM
Subject: Re: [smf_addin] cefconnect
According to my FireFox HTTPFix extension, it looks like the data is here:
http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip
On Wed, Nov 19, 2014 at 4:43 PM, Ron Spruell hashky@...wrote:
I am back at the trough to beg and grovel again. I had a great spreadsheet written that worked well, and then cefconnect.com changed their website to java script. I would like to be able to put in a portfolio and pull data from cefconnect and morningstar. But the cefconnect portion is broken.
I was pulling in
| Ticker | Fund Name | Strategy | ClosingPrice | PriceChange | NAV | Premium/Discount | DistributionRate |
using
=RCHGetHTMLTable("http://www.cefconnect.com/Pricing/DailyPricing.aspx","
Can you help? I don't know where to go to look for the data.
Ron Spruell
#yiv3429672347 #yiv3429672347 -- #yiv3429672347ygrp-
Thu Nov 20, 2014 7:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
There's no HTML coding within the source code of that URL, so only
RCHGetWebData() can be used to grab data.
I think this would work, providing they always do "X" prefix and suffix on
an actual ticker symbol:
=smfConvertData(smfstrExtr(smfstrExtr(RCHGetWebData("
http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip
","""XNPIX""",800),"~","}"),"""Discount"":",","))
On Thu, Nov 20, 2014 at 8:22 AM, Ron Spruell hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Could you please give me a sample of what you use and how to use it? I
> think it is RCHGetTableCell(), but I am not sure.
>
> For example,how would I pull "Discount"; for NPI?
>
RCHGetWebData() can be used to grab data.
I think this would work, providing they always do "X" prefix and suffix on
an actual ticker symbol:
=smfConvertData(smfstrExtr(smfstrExtr(RCHGetWebData("
http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip
","""XNPIX""",800),"~","}"),"""Discount"":",","))
On Thu, Nov 20, 2014 at 8:22 AM, Ron Spruell hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Could you please give me a sample of what you use and how to use it? I
> think it is RCHGetTableCell(
>
> For example,how would I pull "Discount"
>
Thu Nov 20, 2014 8:20 am (PST) . Posted by:
"Ron Spruell" hashky
Amazing! I would have never figured that out.
All "ticker" begin with the "X" prefix. The 2nd letter in this case is an "N" which stand for Nuveen, the fund sponsor. The real "Ticker" (ticker symbol) with a capital "T" is 14 rows down. (Notice the "PIX" is not "NPI".) There has to be a way around this.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, November 20, 2014 9:35 AM
Subject: Re: [smf_addin] cefconnect
There's no HTML coding within the source code of that URL, so only RCHGetWebData() can be used to grab data.
I think this would work, providing they always do "X" prefix and suffix on an actual ticker symbol:
=smfConvertData(smfstrExtr(smfstrExtr(RCHGetWebData("http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip","""XNPIX""",800),"~","}"),"""Discount"":",","))
On Thu, Nov 20, 2014 at 8:22 AM, Ron Spruell hashky@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Could you please give me a sample of what you use and how to use it? I think it is RCHGetTableCell(), but I am not sure.
For example,how would I pull "Discount"; for NPI?
#yiv6156934456 #yiv6156934456 -- #yiv6156934456ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6156934456 #yiv6156934456ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6156934456 #yiv6156934456ygrp-mkp #yiv6156934456hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6156934456 #yiv6156934456ygrp-mkp #yiv6156934456ads {margin-bottom:10px;}#yiv6156934456 #yiv6156934456ygrp-mkp .yiv6156934456ad {padding:0 0;}#yiv6156934456 #yiv6156934456ygrp-mkp .yiv6156934456ad p {margin:0;}#yiv6156934456 #yiv6156934456ygrp-mkp .yiv6156934456ad a {color:#0000ff;text-decoration:none;}#yiv6156934456 #yiv6156934456ygrp-sponsor #yiv6156934456ygrp-lc {font-family:Arial;}#yiv6156934456 #yiv6156934456ygrp-sponsor #yiv6156934456ygrp-lc #yiv6156934456hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6156934456 #yiv6156934456ygrp-sponsor #yiv6156934456ygrp-lc .yiv6156934456ad {margin-bottom:10px;padding:0 0;}#yiv6156934456 #yiv6156934456actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6156934456 #yiv6156934456activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6156934456 #yiv6156934456activity span {font-weight:700;}#yiv6156934456 #yiv6156934456activity span:first-child {text-transform:uppercase;}#yiv6156934456 #yiv6156934456activity span a {color:#5085b6;text-decoration:none;}#yiv6156934456 #yiv6156934456activity span span {color:#ff7900;}#yiv6156934456 #yiv6156934456activity span .yiv6156934456underline {text-decoration:underline;}#yiv6156934456 .yiv6156934456attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6156934456 .yiv6156934456attach div a {text-decoration:none;}#yiv6156934456 .yiv6156934456attach img {border:none;padding-right:5px;}#yiv6156934456 .yiv6156934456attach label {display:block;margin-bottom:5px;}#yiv6156934456 .yiv6156934456attach label a {text-decoration:none;}#yiv6156934456 blockquote {margin:0 0 0 4px;}#yiv6156934456 .yiv6156934456bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6156934456 .yiv6156934456bold a {text-decoration:none;}#yiv6156934456 dd.yiv6156934456last p a {font-family:Verdana;font-weight:700;}#yiv6156934456 dd.yiv6156934456last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6156934456 dd.yiv6156934456last p span.yiv6156934456yshortcuts {margin-right:0;}#yiv6156934456 div.yiv6156934456attach-table div div a {text-decoration:none;}#yiv6156934456 div.yiv6156934456attach-table {width:400px;}#yiv6156934456 div.yiv6156934456file-title a, #yiv6156934456 div.yiv6156934456file-title a:active, #yiv6156934456 div.yiv6156934456file-title a:hover, #yiv6156934456 div.yiv6156934456file-title a:visited {text-decoration:none;}#yiv6156934456 div.yiv6156934456photo-title a, #yiv6156934456 div.yiv6156934456photo-title a:active, #yiv6156934456 div.yiv6156934456photo-title a:hover, #yiv6156934456 div.yiv6156934456photo-title a:visited {text-decoration:none;}#yiv6156934456 div#yiv6156934456ygrp-mlmsg #yiv6156934456ygrp-msg p a span.yiv6156934456yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6156934456 .yiv6156934456green {color:#628c2a;}#yiv6156934456 .yiv6156934456MsoNormal {margin:0 0 0 0;}#yiv6156934456 o {font-size:0;}#yiv6156934456 #yiv6156934456photos div {float:left;width:72px;}#yiv6156934456 #yiv6156934456photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6156934456 #yiv6156934456photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6156934456 #yiv6156934456reco-category {font-size:77%;}#yiv6156934456 #yiv6156934456reco-desc {font-size:77%;}#yiv6156934456 .yiv6156934456replbq {margin:4px;}#yiv6156934456 #yiv6156934456ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6156934456 #yiv6156934456ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6156934456 #yiv6156934456ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6156934456 #yiv6156934456ygrp-mlmsg select, #yiv6156934456 input, #yiv6156934456 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6156934456 #yiv6156934456ygrp-mlmsg pre, #yiv6156934456 code {font:115% monospace;}#yiv6156934456 #yiv6156934456ygrp-mlmsg * {line-height:1.22em;}#yiv6156934456 #yiv6156934456ygrp-mlmsg #yiv6156934456logo {padding-bottom:10px;}#yiv6156934456 #yiv6156934456ygrp-msg p a {font-family:Verdana;}#yiv6156934456 #yiv6156934456ygrp-msg p#yiv6156934456attach-count span {color:#1E66AE;font-weight:700;}#yiv6156934456 #yiv6156934456ygrp-reco #yiv6156934456reco-head {color:#ff7900;font-weight:700;}#yiv6156934456 #yiv6156934456ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6156934456 #yiv6156934456ygrp-sponsor #yiv6156934456ov li a {font-size:130%;text-decoration:none;}#yiv6156934456 #yiv6156934456ygrp-sponsor #yiv6156934456ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6156934456 #yiv6156934456ygrp-sponsor #yiv6156934456ov ul {margin:0;padding:0 0 0 8px;}#yiv6156934456 #yiv6156934456ygrp-text {font-family:Georgia;}#yiv6156934456 #yiv6156934456ygrp-text p {margin:0 0 1em 0;}#yiv6156934456 #yiv6156934456ygrp-text tt {font-size:120%;}#yiv6156934456 #yiv6156934456ygrp-vital ul li:last-child {border-right:none !important;}#yiv6156934456
All "ticker" begin with the "X" prefix. The 2nd letter in this case is an "N" which stand for Nuveen, the fund sponsor. The real "Ticker" (ticker symbol) with a capital "T" is 14 rows down. (Notice the "PIX" is not "NPI".) There has to be a way around this.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, November 20, 2014 9:35 AM
Subject: Re: [smf_addin] cefconnect
There's no HTML coding within the source code of that URL, so only RCHGetWebData() can be used to grab data.
I think this would work, providing they always do "X" prefix and suffix on an actual ticker symbol:
=smfConvertData(smfstrExtr(smfstrExtr(RCHGetWebData("http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip","""XNPIX""",800),"~","}"),"""Discount"":",","))
On Thu, Nov 20, 2014 at 8:22 AM, Ron Spruell hashky@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Could you please give me a sample of what you use and how to use it? I think it is RCHGetTableCell(
For example,how would I pull "Discount"
#yiv6156934456 #yiv6156934456 -- #yiv6156934456ygrp-
Thu Nov 20, 2014 8:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's a lot more difficult to go after "Ticker" than "ticker". Mainly
because you need to back up from "Ticker" and it may not always be a set
length to back up. This would appear to work:
=smfConvertData(smfstrExtr(smfstrExtr(RCHGetWebData("
http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip","""Ticker"":
""NPI"",",,-800),"{","}"),"""Discount"":",","))
However, note the "-800" -- I'm backing up 800 bytes to make sure I can
find the start of the grouping. The group is delimited by "{" and "}". This
would have a problem getting the first ticker symbol, since backing up 800
bytes might be too much.
The other alternative is to do a cascading extraction of the entire data
table, and then do a MATCH() and INDEX() on the actual data you need. That
might be a better way to go if you need all the data instead of just the
data for one ticker symbol...
As a quick example of that, pull up the "SMF-Quick-Webpage-Examination.xls"
template, go to the "By Cascading Value" worksheet, then plug in the URL
and use a "String" of "{". The "Web Page Content" column should then show
you the raw data of each data line, which could then be extracted with
smfStrExtr() functions. That's actually where I started looking at the
extraction process for the data. I use that worksheet a lot to identify
patterns in this type of web page. Mostly for JSON or XML or JavaScript
extractions.
On Thu, Nov 20, 2014 at 9:20 AM, Ron Spruell hashky@... wrote:
>
> Amazing! I would have never figured that out.
>
> All "ticker" begin with the "X" prefix. The 2nd letter in this case is an
> "N" which stand for Nuveen, the fund sponsor. The real "Ticker" (ticker
> symbol) with a capital "T" is 14 rows down. (Notice the "PIX" is not
> "NPI".) There has to be a way around this.
>
because you need to back up from "Ticker" and it may not always be a set
length to back up. This would appear to work:
=smfConvertData(smfstrExtr(smfstrExtr(RCHGetWebData("
http://www.cefconnect.com/Resources/Funds/?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip","
""
However, note the "-800" -- I'm backing up 800 bytes to make sure I can
find the start of the grouping. The group is delimited by "{" and "}"
would have a problem getting the first ticker symbol, since backing up 800
bytes might be too much.
The other alternative is to do a cascading extraction of the entire data
table, and then do a MATCH() and INDEX() on the actual data you need. That
might be a better way to go if you need all the data instead of just the
data for one ticker symbol...
As a quick example of that, pull up the "SMF-Quick-
template, go to the "By Cascading Value" worksheet, then plug in the URL
and use a "String" of "{"
you the raw data of each data line, which could then be extracted with
smfStrExtr() functions. That's actually where I started looking at the
extraction process for the data. I use that worksheet a lot to identify
patterns in this type of web page. Mostly for JSON or XML or JavaScript
extractions.
On Thu, Nov 20, 2014 at 9:20 AM, Ron Spruell hashky@... wrote:
>
> Amazing! I would have never figured that out.
>
> All "ticker" begin with the "X" prefix. The 2nd letter in this case is an
> "N" which stand for Nuveen, the fund sponsor. The real "Ticker" (ticker
> symbol) with a capital "T" is 14 rows down. (Notice the "PIX" is not
> "NPI"
>
Thu Nov 20, 2014 8:55 am (PST) . Posted by:
garyhartling
This hasn't happened to me before. All the quotes I get are not from today but from yesterday's close price.
--Gary
--Gary
Thu Nov 20, 2014 9:02 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Looks like a Yahoo problem. I get the same results when I use the download
link on the equity web pages. They also indicate last traded date and time
as yesterday at 4 pm or so:
http://finance.yahoo.com/q?s=MMM
So it looks like Yahoo isn't updating one of their feeds. About all you can
do is use the "Send Feedback" link on the web page and let them know the
"Download Data (delayed)" is providing data from yesterday's close and not
reflecting current day's trading.
On Thu, Nov 20, 2014 at 9:55 AM, Gary.Hartling@...wrote:
> This hasn't happened to me before. All the quotes I get are not from
> today but from yesterday's close price.
>
>
link on the equity web pages. They also indicate last traded date and time
as yesterday at 4 pm or so:
http://finance.yahoo.com/q?s=MMM
So it looks like Yahoo isn't updating one of their feeds. About all you can
do is use the "Send Feedback" link on the web page and let them know the
"Download Data (delayed)" is providing data from yesterday'
reflecting current day's trading.
On Thu, Nov 20, 2014 at 9:55 AM, Gary.Hartling@
> This hasn't happened to me before. All the quotes I get are not from
> today but from yesterday'
>
>
Thu Nov 20, 2014 9:11 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The one I cited. The "Send Feedback" link is in the footer of the web page.
You should use the context I gave you. If you mention the add-in, they
might ignore the complaint thinking it's a problem with the tool you're
using, instead of a problem with their web page option.
On Thu, Nov 20, 2014 at 10:09 AM, Gary.Hartling@wrote:
>
> What web page do you send feedback from?
>
You should use the context I gave you. If you mention the add-in, they
might ignore the complaint thinking it's a problem with the tool you're
using, instead of a problem with their web page option.
On Thu, Nov 20, 2014 at 10:09 AM, Gary.Hartling@
>
> What web page do you send feedback from?
>
Thu Nov 20, 2014 9:32 am (PST) . Posted by:
garyhartling
This could go on for awhile. There's already a complaint about stale data but it is ranked 2382nd supposedly on their things to do list.
Thu Nov 20, 2014 9:41 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Up to 435 now. People need to add their votes here:
https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages
On Thu, Nov 20, 2014 at 10:32 AM, Gary.Hartling@...wrote:
>
> This could go on for awhile. There's already a complaint about stale data
> but it is ranked *2382nd *supposedly on their things to do list.
>
https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages
On Thu, Nov 20, 2014 at 10:32 AM, Gary.Hartling@
>
> This could go on for awhile. There's already a complaint about stale data
> but it is ranked *2382nd *supposedly on their things to do list.
>
Thu Nov 20, 2014 12:30 pm (PST) . Posted by:
perfectalpha@ymail.com
Thanks, I'm also suffering from this problem (first time I've seen it though in 2 years of using it). I've added my vote.
On another note, is there a similar function in Excel that is as painless to use that grabs the data from another data source than Yahoo (e.g. like Google or another site)?
On another note, is there a similar function in Excel that is as painless to use that grabs the data from another data source than Yahoo (e.g. like Google or another site)?
Thu Nov 20, 2014 12:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't know of any other free site that offers the data as well as Yahoo
does. If the data is critical, you may need to look at the paid data
services. That should also improve data quality.
On Thu, Nov 20, 2014 at 1:26 PM, perfectalpha@... wrote:
>
> Thanks, I'm also suffering from this problem (first time I've seen it
> though in 2 years of using it). I've added my vote.
>
> On another note, is there a similar function in Excel that is as painless
> to use that grabs the data from another data source than Yahoo (e.g. like
> Google or another site)?
>
>
does. If the data is critical, you may need to look at the paid data
services. That should also improve data quality.
On Thu, Nov 20, 2014 at 1:26 PM, perfectalpha@
>
> Thanks, I'm also suffering from this problem (first time I've seen it
> though in 2 years of using it). I've added my vote.
>
> On another note, is there a similar function in Excel that is as painless
> to use that grabs the data from another data source than Yahoo (e.g. like
> Google or another site)?
>
>
Thu Nov 20, 2014 12:29 pm (PST) . Posted by:
anacottrading
Good evening, i need download historical prices on ETPs.
I tried RCHGetYahooHistory-Function http://www.ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooHistory-Function.html but i haven't found all the ETPs prices available.
Why they are not available? Only real-time data on such ETPs are available..
Others ETPs instad have historical data but 2,3.. days later, which is the "normal" time lag to have historical data available?
Thanks
I tried RCHGetYahooHistory-Function http://www.ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooHistory-Function.html but i haven't found all the ETPs prices available.
Why they are not available? Only real-time data on such ETPs are available..
Others ETPs instad have historical data but 2,3.. days later, which is the "normal" time lag to have historical data available?
Thanks
Thu Nov 20, 2014 12:42 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I can't answer any questions on availability. You'd have to direct those to
Yahoo.
On Thu, Nov 20, 2014 at 1:05 PM, anacottrading@...wrote:
>
> Good evening, i need download historical prices on ETPs.
> I tried RCHGetYahooHistory-Function
> <http://www.ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooHistory-Function.html>
> but i haven't found all the ETPs prices available.
> Why they are not available? Only real-time data on such ETPs are
> available..
> Others ETPs instad have historical data but 2,3.. days later, which is the
> "normal" time lag to have historical data available?
>
Yahoo.
On Thu, Nov 20, 2014 at 1:05 PM, anacottrading@...wrote:
>
> Good evening, i need download historical prices on ETPs.
> I tried RCHGetYahooHistory-Function
> <http://www.ogres-crypt.com/SMF/Documentation/viewer.php?name=RCHGetYahooHistory-Function.html>
> but i haven't found all the ETPs prices available.
> Why they are not available? Only real-time data on such ETPs are
> available..
> Others ETPs instad have historical data but 2,3.. days later, which is the
> "normal" time lag to have historical data available?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar