15 Messages
Digest #3246
Messages
Fri Nov 21, 2014 3:05 am (PST) . Posted by:
rho49m
Has yahoo changed their syntax I seem to be getting an error when trying to update data from yahoo finance?
Fri Nov 21, 2014 4:31 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I can only guess what you might be asking. More details please.
On Fri, Nov 21, 2014 at 4:05 AM, rho49m@... wrote:
> Has yahoo changed their syntax I seem to be getting an error when trying
> to update data from yahoo finance?
>
>
On Fri, Nov 21, 2014 at 4:05 AM, rho49m@... wrote:
> Has yahoo changed their syntax I seem to be getting an error when trying
> to update data from yahoo finance?
>
>
Fri Nov 21, 2014 3:12 am (PST) . Posted by:
"Ron Spruell" hashky
I don't know what your Firefox HTTPfix is. I searched Yahoo and could not find it.
I also looked for "SMF-Quick-Webpage-Examination.xls" template.
I have done cascading extractions before, but since I could not find the "SMF-Quick-Webpage-Examination.xls" template then naturally I could not find the "Cascading Value" worksheet.
Can you point me to these?
The user friendliness of the "new" Yahoo Groups sites leaves a lot to be desired.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, November 20, 2014 10:57 AM
Subject: Re: [smf_addin] cefconnect
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.
#yiv9397089040 #yiv9397089040 -- #yiv9397089040ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9397089040 #yiv9397089040ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9397089040 #yiv9397089040ygrp-mkp #yiv9397089040hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9397089040 #yiv9397089040ygrp-mkp #yiv9397089040ads {margin-bottom:10px;}#yiv9397089040 #yiv9397089040ygrp-mkp .yiv9397089040ad {padding:0 0;}#yiv9397089040 #yiv9397089040ygrp-mkp .yiv9397089040ad p {margin:0;}#yiv9397089040 #yiv9397089040ygrp-mkp .yiv9397089040ad a {color:#0000ff;text-decoration:none;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ygrp-lc {font-family:Arial;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ygrp-lc #yiv9397089040hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ygrp-lc .yiv9397089040ad {margin-bottom:10px;padding:0 0;}#yiv9397089040 #yiv9397089040actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9397089040 #yiv9397089040activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9397089040 #yiv9397089040activity span {font-weight:700;}#yiv9397089040 #yiv9397089040activity span:first-child {text-transform:uppercase;}#yiv9397089040 #yiv9397089040activity span a {color:#5085b6;text-decoration:none;}#yiv9397089040 #yiv9397089040activity span span {color:#ff7900;}#yiv9397089040 #yiv9397089040activity span .yiv9397089040underline {text-decoration:underline;}#yiv9397089040 .yiv9397089040attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9397089040 .yiv9397089040attach div a {text-decoration:none;}#yiv9397089040 .yiv9397089040attach img {border:none;padding-right:5px;}#yiv9397089040 .yiv9397089040attach label {display:block;margin-bottom:5px;}#yiv9397089040 .yiv9397089040attach label a {text-decoration:none;}#yiv9397089040 blockquote {margin:0 0 0 4px;}#yiv9397089040 .yiv9397089040bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9397089040 .yiv9397089040bold a {text-decoration:none;}#yiv9397089040 dd.yiv9397089040last p a {font-family:Verdana;font-weight:700;}#yiv9397089040 dd.yiv9397089040last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9397089040 dd.yiv9397089040last p span.yiv9397089040yshortcuts {margin-right:0;}#yiv9397089040 div.yiv9397089040attach-table div div a {text-decoration:none;}#yiv9397089040 div.yiv9397089040attach-table {width:400px;}#yiv9397089040 div.yiv9397089040file-title a, #yiv9397089040 div.yiv9397089040file-title a:active, #yiv9397089040 div.yiv9397089040file-title a:hover, #yiv9397089040 div.yiv9397089040file-title a:visited {text-decoration:none;}#yiv9397089040 div.yiv9397089040photo-title a, #yiv9397089040 div.yiv9397089040photo-title a:active, #yiv9397089040 div.yiv9397089040photo-title a:hover, #yiv9397089040 div.yiv9397089040photo-title a:visited {text-decoration:none;}#yiv9397089040 div#yiv9397089040ygrp-mlmsg #yiv9397089040ygrp-msg p a span.yiv9397089040yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9397089040 .yiv9397089040green {color:#628c2a;}#yiv9397089040 .yiv9397089040MsoNormal {margin:0 0 0 0;}#yiv9397089040 o {font-size:0;}#yiv9397089040 #yiv9397089040photos div {float:left;width:72px;}#yiv9397089040 #yiv9397089040photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9397089040 #yiv9397089040photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9397089040 #yiv9397089040reco-category {font-size:77%;}#yiv9397089040 #yiv9397089040reco-desc {font-size:77%;}#yiv9397089040 .yiv9397089040replbq {margin:4px;}#yiv9397089040 #yiv9397089040ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9397089040 #yiv9397089040ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9397089040 #yiv9397089040ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9397089040 #yiv9397089040ygrp-mlmsg select, #yiv9397089040 input, #yiv9397089040 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9397089040 #yiv9397089040ygrp-mlmsg pre, #yiv9397089040 code {font:115% monospace;}#yiv9397089040 #yiv9397089040ygrp-mlmsg * {line-height:1.22em;}#yiv9397089040 #yiv9397089040ygrp-mlmsg #yiv9397089040logo {padding-bottom:10px;}#yiv9397089040 #yiv9397089040ygrp-msg p a {font-family:Verdana;}#yiv9397089040 #yiv9397089040ygrp-msg p#yiv9397089040attach-count span {color:#1E66AE;font-weight:700;}#yiv9397089040 #yiv9397089040ygrp-reco #yiv9397089040reco-head {color:#ff7900;font-weight:700;}#yiv9397089040 #yiv9397089040ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ov li a {font-size:130%;text-decoration:none;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ov ul {margin:0;padding:0 0 0 8px;}#yiv9397089040 #yiv9397089040ygrp-text {font-family:Georgia;}#yiv9397089040 #yiv9397089040ygrp-text p {margin:0 0 1em 0;}#yiv9397089040 #yiv9397089040ygrp-text tt {font-size:120%;}#yiv9397089040 #yiv9397089040ygrp-vital ul li:last-child {border-right:none !important;}#yiv9397089040
I also looked for "SMF-Quick-Webpage-Examination.xls" template.
I have done cascading extractions before, but since I could not find the "SMF-Quick-Webpage-Examination.xls" template then naturally I could not find the "Cascading Value" worksheet.
Can you point me to these?
The user friendliness of the "new" Yahoo Groups sites leaves a lot to be desired.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, November 20, 2014 10:57 AM
Subject: Re: [smf_addin] cefconnect
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","
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 "}"
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-
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"
#yiv9397089040 #yiv9397089040 -- #yiv9397089040ygrp-
Fri Nov 21, 2014 4:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, my bad -- HTTPFox (not Fix):
https://addons.mozilla.org/en-US/firefox/addon/httpfox/
The workbook template is on the website, not the Yahoo group:
http://ogres-crypt.com/SMF/Templates/#Debug
On Fri, Nov 21, 2014 at 4:12 AM, Ron Spruell hashky@...wrote:
>
> I don't know what your Firefox HTTPfix is. I searched Yahoo and could not
> find it.
>
> I also looked for "SMF-Quick-Webpage-Examination.xls" template.
>
> I have done cascading extractions before, but since I could not find the
> "SMF-Quick-Webpage-Examination.xls" template then naturally I could not
> find the "Cascading Value" worksheet.
>
> Can you point me to these?
>
> The user friendliness of the "new" Yahoo Groups sites leaves a lot to be
> desired.
>
https://addons.mozilla.org/en-US/firefox/addon/httpfox/
The workbook template is on the website, not the Yahoo group:
http://ogres-crypt.com/SMF/Templates/#Debug
On Fri, Nov 21, 2014 at 4:12 AM, Ron Spruell hashky@...wrote:
>
> I don't know what your Firefox HTTPfix is. I searched Yahoo and could not
> find it.
>
> I also looked for "SMF-Quick-
>
> I have done cascading extractions before, but since I could not find the
> "SMF-Quick-
> find the "Cascading Value" worksheet.
>
> Can you point me to these?
>
> The user friendliness of the "new" Yahoo Groups sites leaves a lot to be
> desired.
>
I have used the RCHGETYAHOOQUOTES function with L1 on my SpreadSheets for awhile now with no issues whatsoever.
Beginning Yesterday, it stop updating current prices.
I've tried: ForceRecalculation, F9, and <ctrl><alt>F9 to no avail.
I've attempted using the NOW() parameter and have closed the SS and reopened it. Still nothing.
I checked the prices at the Yahoo site vs the ones in my spreadsheet. Indeed, prices have not updated.
Any clues? Hints? Thanks
Armando
Beginning Yesterday, it stop updating current prices.
I've tried: ForceRecalculation, F9, and <ctrl>
I've attempted using the NOW() parameter and have closed the SS and reopened it. Still nothing.
I checked the prices at the Yahoo site vs the ones in my spreadsheet. Indeed, prices have not updated.
Any clues? Hints? Thanks
Armando
Fri Nov 21, 2014 5:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out yesterday's "Getting quotes from yesterday's close" thread on the
group.
On Fri, Nov 21, 2014 at 5:59 AM, armando@... wrote:
> I have used the RCHGETYAHOOQUOTES function with L1 on my SpreadSheets
> for awhile now with no issues whatsoever.
>
> Beginning Yesterday, it stop updating current prices.
>
> I've tried: ForceRecalculation, F9, and <ctrl><alt>F9 to no avail.
>
> I've attempted using the NOW() parameter and have closed the SS and
> reopened it. Still nothing.
>
> I checked the prices at the Yahoo site vs the ones in my spreadsheet. Indeed,
> prices have not updated.
>
> Any clues? Hints? Thanks
>
group.
On Fri, Nov 21, 2014 at 5:59 AM, armando@... wrote:
> I have used the RCHGETYAHOOQUOTES function with L1 on my SpreadSheets
> for awhile now with no issues whatsoever.
>
> Beginning Yesterday, it stop updating current prices.
>
> I've tried: ForceRecalculation, F9, and <ctrl>
>
> I've attempted using the NOW() parameter and have closed the SS and
> reopened it. Still nothing.
>
> I checked the prices at the Yahoo site vs the ones in my spreadsheet. Indeed,
> prices have not updated.
>
> Any clues? Hints? Thanks
>
Thanks Randy... didn't realize it was the same issue.
Fri Nov 21, 2014 5:55 am (PST) . Posted by:
"Ron Spruell" hashky
I may be able to make "Ticker" work. The real issue is setting up a portfolio on "http://www.cefconnect.com/Portfolio/Portfolio.aspx" and then get the Tickers into Excel. I can see them. I can copy and paste the whole table into Excel. But I don't know how to import the tickers.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, November 20, 2014 10:57 AM
Subject: Re: [smf_addin] cefconnect
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.
#yiv9397089040 #yiv9397089040 -- #yiv9397089040ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9397089040 #yiv9397089040ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9397089040 #yiv9397089040ygrp-mkp #yiv9397089040hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9397089040 #yiv9397089040ygrp-mkp #yiv9397089040ads {margin-bottom:10px;}#yiv9397089040 #yiv9397089040ygrp-mkp .yiv9397089040ad {padding:0 0;}#yiv9397089040 #yiv9397089040ygrp-mkp .yiv9397089040ad p {margin:0;}#yiv9397089040 #yiv9397089040ygrp-mkp .yiv9397089040ad a {color:#0000ff;text-decoration:none;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ygrp-lc {font-family:Arial;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ygrp-lc #yiv9397089040hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ygrp-lc .yiv9397089040ad {margin-bottom:10px;padding:0 0;}#yiv9397089040 #yiv9397089040actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9397089040 #yiv9397089040activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9397089040 #yiv9397089040activity span {font-weight:700;}#yiv9397089040 #yiv9397089040activity span:first-child {text-transform:uppercase;}#yiv9397089040 #yiv9397089040activity span a {color:#5085b6;text-decoration:none;}#yiv9397089040 #yiv9397089040activity span span {color:#ff7900;}#yiv9397089040 #yiv9397089040activity span .yiv9397089040underline {text-decoration:underline;}#yiv9397089040 .yiv9397089040attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9397089040 .yiv9397089040attach div a {text-decoration:none;}#yiv9397089040 .yiv9397089040attach img {border:none;padding-right:5px;}#yiv9397089040 .yiv9397089040attach label {display:block;margin-bottom:5px;}#yiv9397089040 .yiv9397089040attach label a {text-decoration:none;}#yiv9397089040 blockquote {margin:0 0 0 4px;}#yiv9397089040 .yiv9397089040bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9397089040 .yiv9397089040bold a {text-decoration:none;}#yiv9397089040 dd.yiv9397089040last p a {font-family:Verdana;font-weight:700;}#yiv9397089040 dd.yiv9397089040last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9397089040 dd.yiv9397089040last p span.yiv9397089040yshortcuts {margin-right:0;}#yiv9397089040 div.yiv9397089040attach-table div div a {text-decoration:none;}#yiv9397089040 div.yiv9397089040attach-table {width:400px;}#yiv9397089040 div.yiv9397089040file-title a, #yiv9397089040 div.yiv9397089040file-title a:active, #yiv9397089040 div.yiv9397089040file-title a:hover, #yiv9397089040 div.yiv9397089040file-title a:visited {text-decoration:none;}#yiv9397089040 div.yiv9397089040photo-title a, #yiv9397089040 div.yiv9397089040photo-title a:active, #yiv9397089040 div.yiv9397089040photo-title a:hover, #yiv9397089040 div.yiv9397089040photo-title a:visited {text-decoration:none;}#yiv9397089040 div#yiv9397089040ygrp-mlmsg #yiv9397089040ygrp-msg p a span.yiv9397089040yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9397089040 .yiv9397089040green {color:#628c2a;}#yiv9397089040 .yiv9397089040MsoNormal {margin:0 0 0 0;}#yiv9397089040 o {font-size:0;}#yiv9397089040 #yiv9397089040photos div {float:left;width:72px;}#yiv9397089040 #yiv9397089040photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9397089040 #yiv9397089040photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9397089040 #yiv9397089040reco-category {font-size:77%;}#yiv9397089040 #yiv9397089040reco-desc {font-size:77%;}#yiv9397089040 .yiv9397089040replbq {margin:4px;}#yiv9397089040 #yiv9397089040ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9397089040 #yiv9397089040ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9397089040 #yiv9397089040ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9397089040 #yiv9397089040ygrp-mlmsg select, #yiv9397089040 input, #yiv9397089040 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9397089040 #yiv9397089040ygrp-mlmsg pre, #yiv9397089040 code {font:115% monospace;}#yiv9397089040 #yiv9397089040ygrp-mlmsg * {line-height:1.22em;}#yiv9397089040 #yiv9397089040ygrp-mlmsg #yiv9397089040logo {padding-bottom:10px;}#yiv9397089040 #yiv9397089040ygrp-msg p a {font-family:Verdana;}#yiv9397089040 #yiv9397089040ygrp-msg p#yiv9397089040attach-count span {color:#1E66AE;font-weight:700;}#yiv9397089040 #yiv9397089040ygrp-reco #yiv9397089040reco-head {color:#ff7900;font-weight:700;}#yiv9397089040 #yiv9397089040ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ov li a {font-size:130%;text-decoration:none;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9397089040 #yiv9397089040ygrp-sponsor #yiv9397089040ov ul {margin:0;padding:0 0 0 8px;}#yiv9397089040 #yiv9397089040ygrp-text {font-family:Georgia;}#yiv9397089040 #yiv9397089040ygrp-text p {margin:0 0 1em 0;}#yiv9397089040 #yiv9397089040ygrp-text tt {font-size:120%;}#yiv9397089040 #yiv9397089040ygrp-vital ul li:last-child {border-right:none !important;}#yiv9397089040
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, November 20, 2014 10:57 AM
Subject: Re: [smf_addin] cefconnect
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","
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 "}"
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-
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"
#yiv9397089040 #yiv9397089040 -- #yiv9397089040ygrp-
Fri Nov 21, 2014 6:28 am (PST) . Posted by:
"Juj Chan Hyjun" JCHyjun
I was too optimist: Yahoo Hong Kong quotes are also frozen as 11/20/14.
Fri Nov 21, 2014 7:48 am (PST) . Posted by:
nelsonmuntz1000
Updated my quotes this morning, briefly had closing prices for November 20, then it reverted back to November 19 closing prices.
As Randy suggested yesterday, send your feedback to Yahoo and/or vote.
Link is:
The "Download Data (Delayed)" links on quote pages are not updating https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments
https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments
The "Download Data (Delayed)" links on quote p... https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments The "Download Data (Delayed)" links on quote pages are not updating. They are providing stale data from yesterday.
View on yahoo.uservoice.com https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments
Preview by Yahoo
Currently ranked 16th at 10:46 this morning.
Thanks for the great add-in Randy.
As Randy suggested yesterday, send your feedback to Yahoo and/or vote.
Link is:
The "Download Data (Delayed)" links on quote pages are not updating https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments
https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments
The "Download Data (Delayed)" links on quote p... https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments The "Download Data (Delayed)" links on quote pages are not updating. They are providing stale data from yesterday.
View on yahoo.uservoice.com https://yahoo.uservoice.com/forums/207809-finance-gs/suggestions/6746386-the-download-data-delayed-links-on-quote-pages#comments
Preview by Yahoo
Currently ranked 16th at 10:46 this morning.
Thanks for the great add-in Randy.
Fri Nov 21, 2014 8:47 am (PST) . Posted by:
sheydon
It's now up to 9th. Also, for those unfamiliar with the Yahoo "voting" system - you need to do more than just place a comment - you'll see a VOTE button in the upper left corner. Make sure you do that as well - I missed it the first time, thinking by writing a comment I was 'voting'
Fri Nov 21, 2014 9:01 am (PST) . Posted by:
steelesoftca
A couple of things I've discovered:
1. If you have a portfolio set up on finance.yahoo.com, the 'export' function appears to be stuck on November 19th closing prices as well. I was worried that Yahoo had decided to stop allowing price downloads altogether, but I can't imagine them deliberately breaking a function on their own website.
2. A historical price download from http//ichart.finance.yahoo.com DOES contain the November 20th closing price.
1. If you have a portfolio set up on finance.yahoo.
2. A historical price download from http//ichart.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar