Jumat, 21 November 2014

[smf_addin] Digest Number 3246

15 Messages

Digest #3246
1a
1b
Re: invalid syntax by "Randy Harmelink" rharmelink
2a
Re: cefconnect - 3 general things by "Ron Spruell" hashky
2b
Re: cefconnect - 3 general things by "Randy Harmelink" rharmelink
3b
Re: RCHGETYAHOOQUOTES ISSUE by "Randy Harmelink" rharmelink
4a
Re: cefconnect by "Ron Spruell" hashky
5a

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?
>
>

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&quot;":",","))

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

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.
>

Fri Nov 21, 2014 4:59 am (PST) . Posted by:

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

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
>

Fri Nov 21, 2014 6:48 am (PST) . Posted by:

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&quot;":",","))

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

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.

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&#39;

Fri Nov 21, 2014 9:12 am (PST) . Posted by:

nbkih44

good work all. feed appears to be working again

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&#39; 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.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar