3 Messages
Digest #3688
Messages
Sat Apr 30, 2016 7:20 am (PDT) . Posted by:
"Ron Spruell" hashky
Found my error. Since it was a string, I put quotes around the bracket. Thanks. It works perfectly.
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, April 28, 2016 9:31 PM
Subject: Re: [smf_addin] CEFconnect.com [Solved]
Hmmm. Mine looks like this:
| | Web Page: | http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/ |
| | String: | { |
| | | |
| Find Next | Start | Web page content |
| -- | 1 | [{"Ticker":"MFM","Name":"MFS Municipal Income","DistributionRateNAV":5.09,"LastUpdated":"2016-04-27T00:00:00","Discount":-3.97,"DistributionRatePrice":5.30,"ReturnOnNAV":7.43,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":7.25000,"PriceChange":-0.06,"NAV":7.550000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"CXE","Name":"MFS High Income Municipal","DistributionRateNAV":5.44,"LastUpdated":"2016-04-27T00:00:00","Discount":-4.54,"DistributionRat |
| 2 | 2 | {"Ticker":"MFM","Name":"MFS Municipal Income","DistributionRateNAV":5.09,"LastUpdated":"2016-04-27T00:00:00","Discount":-3.97,"DistributionRatePrice":5.30,"ReturnOnNAV":7.43,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":7.25000,"PriceChange":-0.06,"NAV":7.550000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"CXE","Name":"MFS High Income Municipal","DistributionRateNAV":5.44,"LastUpdated":"2016-04-27T00:00:00","Discount":-4.54,"DistributionRate |
| 353 | 354 | {"Ticker":"CXE","Name":"MFS High Income Municipal","DistributionRateNAV":5.44,"LastUpdated":"2016-04-27T00:00:00","Discount":-4.54,"DistributionRatePrice":5.70,"ReturnOnNAV":7.58,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":5.26000,"PriceChange":-0.03,"NAV":5.510000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"CMU","Name":"MFS High Yield Municipal Trust","DistributionRateNAV":5.58,"LastUpdated":"2016-04-27T00:00:00","Discount":-1.91,"Distri |
| 358 | 711 | {"Ticker":"CMU","Name":"MFS High Yield Municipal Trust","DistributionRateNAV":5.58,"LastUpdated":"2016-04-27T00:00:00","Discount":-1.91,"DistributionRatePrice":5.68,"ReturnOnNAV":7.49,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":4.85570,"PriceChange":-0.01,"NAV":4.950000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"NMZ","Name":"Nuveen Muni High Inc Opp","DistributionRateNAV":6.58,"LastUpdated":"2016-04-27T00:00:00","Discount":2.02,"Distribu |
| 363 | 1073 | {"Ticker":"NMZ","Name":"Nuveen Muni High Inc Opp","DistributionRateNAV":6.58,"LastUpdated":"2016-04-27T00:00:00","Discount":2.02,"DistributionRatePrice":6.45,"ReturnOnNAV":6.91,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":14.14000,"PriceChange":0.00,"NAV":13.860000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"MAV","Name":"Pioneer Muni High Inc Adv","DistributionRateNAV":6.69,"LastUpdated":"2016-04-27T00:00:00","Discount":11.71,"Distribution |
On Thu, Apr 28, 2016 at 7:13 PM, Ron Spruell hashky@...wrote:
I must be doing something wrong. I put in the JSON URL:"http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/
in Cell D7.
I put in "{" in D8.
I don't get the site broken down as it should be. Under Find Nest I get 32767.
#yiv3659385827 #yiv3659385827 -- #yiv3659385827ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3659385827 #yiv3659385827ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3659385827 #yiv3659385827ygrp-mkp #yiv3659385827hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3659385827 #yiv3659385827ygrp-mkp #yiv3659385827ads {margin-bottom:10px;}#yiv3659385827 #yiv3659385827ygrp-mkp .yiv3659385827ad {padding:0 0;}#yiv3659385827 #yiv3659385827ygrp-mkp .yiv3659385827ad p {margin:0;}#yiv3659385827 #yiv3659385827ygrp-mkp .yiv3659385827ad a {color:#0000ff;text-decoration:none;}#yiv3659385827 #yiv3659385827ygrp-sponsor #yiv3659385827ygrp-lc {font-family:Arial;}#yiv3659385827 #yiv3659385827ygrp-sponsor #yiv3659385827ygrp-lc #yiv3659385827hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3659385827 #yiv3659385827ygrp-sponsor #yiv3659385827ygrp-lc .yiv3659385827ad {margin-bottom:10px;padding:0 0;}#yiv3659385827 #yiv3659385827actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3659385827 #yiv3659385827activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3659385827 #yiv3659385827activity span {font-weight:700;}#yiv3659385827 #yiv3659385827activity span:first-child {text-transform:uppercase;}#yiv3659385827 #yiv3659385827activity span a {color:#5085b6;text-decoration:none;}#yiv3659385827 #yiv3659385827activity span span {color:#ff7900;}#yiv3659385827 #yiv3659385827activity span .yiv3659385827underline {text-decoration:underline;}#yiv3659385827 .yiv3659385827attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3659385827 .yiv3659385827attach div a {text-decoration:none;}#yiv3659385827 .yiv3659385827attach img {border:none;padding-right:5px;}#yiv3659385827 .yiv3659385827attach label {display:block;margin-bottom:5px;}#yiv3659385827 .yiv3659385827attach label a {text-decoration:none;}#yiv3659385827 blockquote {margin:0 0 0 4px;}#yiv3659385827 .yiv3659385827bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3659385827 .yiv3659385827bold a {text-decoration:none;}#yiv3659385827 dd.yiv3659385827last p a {font-family:Verdana;font-weight:700;}#yiv3659385827 dd.yiv3659385827last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3659385827 dd.yiv3659385827last p span.yiv3659385827yshortcuts {margin-right:0;}#yiv3659385827 div.yiv3659385827attach-table div div a {text-decoration:none;}#yiv3659385827 div.yiv3659385827attach-table {width:400px;}#yiv3659385827 div.yiv3659385827file-title a, #yiv3659385827 div.yiv3659385827file-title a:active, #yiv3659385827 div.yiv3659385827file-title a:hover, #yiv3659385827 div.yiv3659385827file-title a:visited {text-decoration:none;}#yiv3659385827 div.yiv3659385827photo-title a, #yiv3659385827 div.yiv3659385827photo-title a:active, #yiv3659385827 div.yiv3659385827photo-title a:hover, #yiv3659385827 div.yiv3659385827photo-title a:visited {text-decoration:none;}#yiv3659385827 div#yiv3659385827ygrp-mlmsg #yiv3659385827ygrp-msg p a span.yiv3659385827yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3659385827 .yiv3659385827green {color:#628c2a;}#yiv3659385827 .yiv3659385827MsoNormal {margin:0 0 0 0;}#yiv3659385827 o {font-size:0;}#yiv3659385827 #yiv3659385827photos div {float:left;width:72px;}#yiv3659385827 #yiv3659385827photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3659385827 #yiv3659385827photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3659385827 #yiv3659385827reco-category {font-size:77%;}#yiv3659385827 #yiv3659385827reco-desc {font-size:77%;}#yiv3659385827 .yiv3659385827replbq {margin:4px;}#yiv3659385827 #yiv3659385827ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3659385827 #yiv3659385827ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3659385827 #yiv3659385827ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3659385827 #yiv3659385827ygrp-mlmsg select, #yiv3659385827 input, #yiv3659385827 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3659385827 #yiv3659385827ygrp-mlmsg pre, #yiv3659385827 code {font:115% monospace;}#yiv3659385827 #yiv3659385827ygrp-mlmsg * {line-height:1.22em;}#yiv3659385827 #yiv3659385827ygrp-mlmsg #yiv3659385827logo {padding-bottom:10px;}#yiv3659385827 #yiv3659385827ygrp-msg p a {font-family:Verdana;}#yiv3659385827 #yiv3659385827ygrp-msg p#yiv3659385827attach-count span {color:#1E66AE;font-weight:700;}#yiv3659385827 #yiv3659385827ygrp-reco #yiv3659385827reco-head {color:#ff7900;font-weight:700;}#yiv3659385827 #yiv3659385827ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3659385827 #yiv3659385827ygrp-sponsor #yiv3659385827ov li a {font-size:130%;text-decoration:none;}#yiv3659385827 #yiv3659385827ygrp-sponsor #yiv3659385827ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3659385827 #yiv3659385827ygrp-sponsor #yiv3659385827ov ul {margin:0;padding:0 0 0 8px;}#yiv3659385827 #yiv3659385827ygrp-text {font-family:Georgia;}#yiv3659385827 #yiv3659385827ygrp-text p {margin:0 0 1em 0;}#yiv3659385827 #yiv3659385827ygrp-text tt {font-size:120%;}#yiv3659385827 #yiv3659385827ygrp-vital ul li:last-child {border-right:none !important;}#yiv3659385827
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, April 28, 2016 9:31 PM
Subject: Re: [smf_addin] CEFconnect.com [Solved]
Hmmm. Mine looks like this:
| | Web Page: | http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/ |
| | String: | { |
| | | |
| Find Next | Start | Web page content |
| -- | 1 | [{"Ticker":"MFM","Name":"MFS Municipal Income","DistributionRateNAV":5.09,"LastUpdated":"2016-04-27T00:00:00","Discount":-3.97,"DistributionRatePrice":5.30,"ReturnOnNAV":7.43,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":7.25000,"PriceChange":-0.06,"NAV":7.550000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"CXE","Name":"MFS High Income Municipal","DistributionRateNAV":5.44,"LastUpdated":"2016-04-27T00:00:00","Discount":-4.54,"DistributionRat |
| 2 | 2 | {"Ticker":"MFM","Name":"MFS Municipal Income","DistributionRateNAV":5.09,"LastUpdated":"2016-04-27T00:00:00","Discount":-3.97,"DistributionRatePrice":5.30,"ReturnOnNAV":7.43,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":7.25000,"PriceChange":-0.06,"NAV":7.550000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"CXE","Name":"MFS High Income Municipal","DistributionRateNAV":5.44,"LastUpdated":"2016-04-27T00:00:00","Discount":-4.54,"DistributionRate |
| 353 | 354 | {"Ticker":"CXE","Name":"MFS High Income Municipal","DistributionRateNAV":5.44,"LastUpdated":"2016-04-27T00:00:00","Discount":-4.54,"DistributionRatePrice":5.70,"ReturnOnNAV":7.58,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":5.26000,"PriceChange":-0.03,"NAV":5.510000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"CMU","Name":"MFS High Yield Municipal Trust","DistributionRateNAV":5.58,"LastUpdated":"2016-04-27T00:00:00","Discount":-1.91,"Distri |
| 358 | 711 | {"Ticker":"CMU","Name":"MFS High Yield Municipal Trust","DistributionRateNAV":5.58,"LastUpdated":"2016-04-27T00:00:00","Discount":-1.91,"DistributionRatePrice":5.68,"ReturnOnNAV":7.49,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":4.85570,"PriceChange":-0.01,"NAV":4.950000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"NMZ","Name":"Nuveen Muni High Inc Opp","DistributionRateNAV":6.58,"LastUpdated":"2016-04-27T00:00:00","Discount":2.02,"Distribu |
| 363 | 1073 | {"Ticker":"NMZ","Name":"Nuveen Muni High Inc Opp","DistributionRateNAV":6.58,"LastUpdated":"2016-04-27T00:00:00","Discount":2.02,"DistributionRatePrice":6.45,"ReturnOnNAV":6.91,"CategoryId":1,"CategoryName":"Tax-Free Income-High Yield","IsManagedDistribution":false,"Price":14.14000,"PriceChange":0.00,"NAV":13.860000,"NAVPublished":"2016-04-27T00:00:00"},{"Ticker":"MAV","Name":"Pioneer Muni High Inc Adv","DistributionRateNAV":6.69,"LastUpdated":"2016-04-27T00:00:00","Discount":11.71,"Distribution |
On Thu, Apr 28, 2016 at 7:13 PM, Ron Spruell hashky@...wrote:
I must be doing something wrong. I put in the JSON URL:"http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/
in Cell D7.
I put in "{" in D8.
I don't get the site broken down as it should be. Under Find Nest I get 32767.
#yiv3659385827 #yiv3659385827 -- #yiv3659385827ygrp-
Sat Apr 30, 2016 9:21 am (PDT) . Posted by:
mattdowney99
Hi All,
I'm hoping someone might be able to help me with an issue I'm having.
A while back I built a worksheet that evaluates and ranks a list of stocks based on various criteria (taken from the book "The Single Best Investment" if anyone is interested).
It was working well until a while ago when the industry information I was pulling from yahoo finance stopped working. Here is the formula I was using to get the price to book ratio for the industry:
=RCHGetTableCell("http://biz.yahoo.com/p/"&Industries!E3&"conameu.html",7,"Industry:")
Where "Industries!E3" is the yahoo industry number. So for example, ADM - Archer Daniels Midland would be industry number 341, farm products. So the resulting url is:
Industry Browser - Consumer Goods - Farm Products Industry - Company List https://biz.yahoo.com/p/341conameu.html
Industry Browser - Consumer Goods - Farm Products Industry - Company List https://biz.yahoo.com/p/341conameu.html Home Investing Market Overview Market Stats Stocks Mutual Funds ETFs Bonds Options Industries Currency Education News & Opinion Markets Investing Ideas Small Biz Expert Advice Special Editions
View on biz.yahoo.com https://biz.yahoo.com/p/341conameu.html
Preview by Yahoo
http://biz.yahoo.com/p/
I can't seem to get any data from this yahoo page anymore. The data is arranged in a table so it seems like it should work, but no matter what criteria I enter into the formula I just get "Error" as the output.
If anyone is also using data from this page and can help me out, I'd very much appreciate it.
Thanks,
Matt
I'm hoping someone might be able to help me with an issue I'm having.
A while back I built a worksheet that evaluates and ranks a list of stocks based on various criteria (taken from the book "The Single Best Investment" if anyone is interested).
It was working well until a while ago when the industry information I was pulling from yahoo finance stopped working. Here is the formula I was using to get the price to book ratio for the industry:
=RCHGetTableCell("http://biz.yahoo.com/p/"&Industries!E3&"conameu.html",7,"Industry:")
Where "Industries!E3" is the yahoo industry number. So for example, ADM - Archer Daniels Midland would be industry number 341, farm products. So the resulting url is:
Industry Browser - Consumer Goods - Farm Products Industry - Company List https://biz.yahoo.com/p/341conameu.html
Industry Browser - Consumer Goods - Farm Products Industry - Company List https://biz.yahoo.com/p/341conameu.html Home Investing Market Overview Market Stats Stocks Mutual Funds ETFs Bonds Options Industries Currency Education News & Opinion Markets Investing Ideas Small Biz Expert Advice Special Editions
View on biz.yahoo.com https://biz.yahoo.com/p/341conameu.html
Preview by Yahoo
http://biz.yahoo.com/p/
I can't seem to get any data from this yahoo page anymore. The data is arranged in a table so it seems like it should work, but no matter what criteria I enter into the formula I just get "Error" as the output.
If anyone is also using data from this page and can help me out, I'd very much appreciate it.
Thanks,
Matt
Sat Apr 30, 2016 9:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They've changed the URL. You need to use the "https://" protocol instead of
"http://"...
On Sat, Apr 30, 2016 at 8:36 AM, mattdowney99@
...wrote:
>
> I'm hoping someone might be able to help me with an issue I'm having.
>
> A while back I built a worksheet that evaluates and ranks a list of stocks
> based on various criteria (taken from the book "The Single Best Investment"
> if anyone is interested).
>
> It was working well until a while ago when the industry information I was
> pulling from yahoo finance stopped working. Here is the formula I was using
> to get the price to book ratio for the industry:
>
> =
>
> RCHGetTableCell("http://biz.yahoo.com/p/
> "&Industries!E3&"conameu.html",7,"Industry:")
>
> Where "Industries!E3" is the yahoo industry number. So for example, ADM -
> Archer Daniels Midland would be industry number 341, farm products. So the
> resulting url is:
>
> Industry Browser - Consumer Goods - Farm Products Industry - Company List
> <https://biz.yahoo.com/p/341conameu.html>
> Industry Browser - Consumer Goods - Farm Products Industry - Company List
> <https://biz.yahoo.com/p/341conameu.html>
> Home Investing Market Overview Market Stats Stocks Mutual Funds ETFs Bonds
> Options Industries Currency Education News & Opinion Markets Investing
> Ideas Small Biz Expert Advice Special Editions
> View on biz.yahoo.com <https://biz.yahoo.com/p/341conameu.html>
> Preview by Yahoo
>
> I can't seem to get any data from this yahoo page anymore. The data is
> arranged in a table so it seems like it should work, but no matter what
> criteria I enter into the formula I just get "Error" as the output.
>
> If anyone is also using data from this page and can help me out, I'd very
> much appreciate it.
>
>
"http://"...
On Sat, Apr 30, 2016 at 8:36 AM, mattdowney99@
...wrote:
>
> I'm hoping someone might be able to help me with an issue I'm having.
>
> A while back I built a worksheet that evaluates and ranks a list of stocks
> based on various criteria (taken from the book "The Single Best Investment"
> if anyone is interested).
>
> It was working well until a while ago when the industry information I was
> pulling from yahoo finance stopped working. Here is the formula I was using
> to get the price to book ratio for the industry:
>
> =
>
> RCHGetTableCell("http://biz.yahoo.com/p/
> "&Industries!E3&"conameu.html",7,"Industry:")
>
> Where "Industries!E3" is the yahoo industry number. So for example, ADM -
> Archer Daniels Midland would be industry number 341, farm products. So the
> resulting url is:
>
> Industry Browser - Consumer Goods - Farm Products Industry - Company List
> <https://biz.yahoo.com/p/341conameu.html>
> Industry Browser - Consumer Goods - Farm Products Industry - Company List
> <https://biz.yahoo.com/p/341conameu.html>
> Home Investing Market Overview Market Stats Stocks Mutual Funds ETFs Bonds
> Options Industries Currency Education News & Opinion Markets Investing
> Ideas Small Biz Expert Advice Special Editions
> View on biz.yahoo.com <https://biz.yahoo.com/p/341conameu.html>
> Preview by Yahoo
>
> I can't seem to get any data from this yahoo page anymore. The data is
> arranged in a table so it seems like it should work, but no matter what
> criteria I enter into the formula I just get "Error" as the output.
>
> If anyone is also using data from this page and can help me out, I'd very
> much appreciate it.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar