1 Message
Digest #3954
Message
Sun Apr 2, 2017 6:59 am (PDT) . Posted by:
"Ron Spruell" hashky
Here is a spreadsheet that Randy helped me build (over the last 3 years) It works OK for CEF bonds and Tax Advantages Equity. I have found it to be very useful.The only downside is you have to go to cefconnect.com to update the Tickers when they change.
Ron Spruell
From: "scwalker1986@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, April 1, 2017 9:32 AM
Subject: [smf_addin] CEF
Randy,
A thousands thanks for good work you do, and the kindness you show to others. I have used code on and off over the years you have enabled, and I am grateful to have benefited from your work and others that have built templates from it. I wish you the best with your health.
I am working improving my CEF investing, and getting to the true income distribution (vs the gross distribution) is important. I came across the your post from Sept 2013 on getting to this information (https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/23587), but it appears that code no longer works, while on the surface the site did not change since then.
As an example, longer at NBB http://www.cefconnect.com/fund/NBBI wanted to get to at least the latest "Income" value of .103 (in this case same as distribution, but in others different). Looking at the source page, the cusip is 67074C103
|
| Declared Date | Payable Date | Ex Date | Distrib Amount | Income | Long Gain | Short Gain | ROC |
| 3/1/2017 | 4/3/2017 | 3/13/2017 | $0.1030
| $0.1030 | $0.0000 | $0.0000
|
So then this code would be what would have worked before
=RCHGetWebData("http://www.cefconnect.com/Resources/TableData/?Type=DistributionHistory¶m0=1/1/1980¶m1=12/31/2020&Cusip=67074C103")
But now it gets an error.
Any ideas?
Thanks again.
Scott
#yiv0882021598 #yiv0882021598 -- #yiv0882021598ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0882021598 #yiv0882021598ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0882021598 #yiv0882021598ygrp-mkp #yiv0882021598hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0882021598 #yiv0882021598ygrp-mkp #yiv0882021598ads {margin-bottom:10px;}#yiv0882021598 #yiv0882021598ygrp-mkp .yiv0882021598ad {padding:0 0;}#yiv0882021598 #yiv0882021598ygrp-mkp .yiv0882021598ad p {margin:0;}#yiv0882021598 #yiv0882021598ygrp-mkp .yiv0882021598ad a {color:#0000ff;text-decoration:none;}#yiv0882021598 #yiv0882021598ygrp-sponsor #yiv0882021598ygrp-lc {font-family:Arial;}#yiv0882021598 #yiv0882021598ygrp-sponsor #yiv0882021598ygrp-lc #yiv0882021598hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0882021598 #yiv0882021598ygrp-sponsor #yiv0882021598ygrp-lc .yiv0882021598ad {margin-bottom:10px;padding:0 0;}#yiv0882021598 #yiv0882021598actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0882021598 #yiv0882021598activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0882021598 #yiv0882021598activity span {font-weight:700;}#yiv0882021598 #yiv0882021598activity span:first-child {text-transform:uppercase;}#yiv0882021598 #yiv0882021598activity span a {color:#5085b6;text-decoration:none;}#yiv0882021598 #yiv0882021598activity span span {color:#ff7900;}#yiv0882021598 #yiv0882021598activity span .yiv0882021598underline {text-decoration:underline;}#yiv0882021598 .yiv0882021598attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0882021598 .yiv0882021598attach div a {text-decoration:none;}#yiv0882021598 .yiv0882021598attach img {border:none;padding-right:5px;}#yiv0882021598 .yiv0882021598attach label {display:block;margin-bottom:5px;}#yiv0882021598 .yiv0882021598attach label a {text-decoration:none;}#yiv0882021598 blockquote {margin:0 0 0 4px;}#yiv0882021598 .yiv0882021598bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0882021598 .yiv0882021598bold a {text-decoration:none;}#yiv0882021598 dd.yiv0882021598last p a {font-family:Verdana;font-weight:700;}#yiv0882021598 dd.yiv0882021598last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0882021598 dd.yiv0882021598last p span.yiv0882021598yshortcuts {margin-right:0;}#yiv0882021598 div.yiv0882021598attach-table div div a {text-decoration:none;}#yiv0882021598 div.yiv0882021598attach-table {width:400px;}#yiv0882021598 div.yiv0882021598file-title a, #yiv0882021598 div.yiv0882021598file-title a:active, #yiv0882021598 div.yiv0882021598file-title a:hover, #yiv0882021598 div.yiv0882021598file-title a:visited {text-decoration:none;}#yiv0882021598 div.yiv0882021598photo-title a, #yiv0882021598 div.yiv0882021598photo-title a:active, #yiv0882021598 div.yiv0882021598photo-title a:hover, #yiv0882021598 div.yiv0882021598photo-title a:visited {text-decoration:none;}#yiv0882021598 div#yiv0882021598ygrp-mlmsg #yiv0882021598ygrp-msg p a span.yiv0882021598yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0882021598 .yiv0882021598green {color:#628c2a;}#yiv0882021598 .yiv0882021598MsoNormal {margin:0 0 0 0;}#yiv0882021598 o {font-size:0;}#yiv0882021598 #yiv0882021598photos div {float:left;width:72px;}#yiv0882021598 #yiv0882021598photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0882021598 #yiv0882021598photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0882021598 #yiv0882021598reco-category {font-size:77%;}#yiv0882021598 #yiv0882021598reco-desc {font-size:77%;}#yiv0882021598 .yiv0882021598replbq {margin:4px;}#yiv0882021598 #yiv0882021598ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0882021598 #yiv0882021598ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0882021598 #yiv0882021598ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0882021598 #yiv0882021598ygrp-mlmsg select, #yiv0882021598 input, #yiv0882021598 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0882021598 #yiv0882021598ygrp-mlmsg pre, #yiv0882021598 code {font:115% monospace;}#yiv0882021598 #yiv0882021598ygrp-mlmsg * {line-height:1.22em;}#yiv0882021598 #yiv0882021598ygrp-mlmsg #yiv0882021598logo {padding-bottom:10px;}#yiv0882021598 #yiv0882021598ygrp-msg p a {font-family:Verdana;}#yiv0882021598 #yiv0882021598ygrp-msg p#yiv0882021598attach-count span {color:#1E66AE;font-weight:700;}#yiv0882021598 #yiv0882021598ygrp-reco #yiv0882021598reco-head {color:#ff7900;font-weight:700;}#yiv0882021598 #yiv0882021598ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0882021598 #yiv0882021598ygrp-sponsor #yiv0882021598ov li a {font-size:130%;text-decoration:none;}#yiv0882021598 #yiv0882021598ygrp-sponsor #yiv0882021598ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0882021598 #yiv0882021598ygrp-sponsor #yiv0882021598ov ul {margin:0;padding:0 0 0 8px;}#yiv0882021598 #yiv0882021598ygrp-text {font-family:Georgia;}#yiv0882021598 #yiv0882021598ygrp-text p {margin:0 0 1em 0;}#yiv0882021598 #yiv0882021598ygrp-text tt {font-size:120%;}#yiv0882021598 #yiv0882021598ygrp-vital ul li:last-child {border-right:none !important;}#yiv0882021598
Ron Spruell
From: "scwalker1986@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Saturday, April 1, 2017 9:32 AM
Subject: [smf_addin] CEF
Randy,
A thousands thanks for good work you do, and the kindness you show to others. I have used code on and off over the years you have enabled, and I am grateful to have benefited from your work and others that have built templates from it. I wish you the best with your health.
I am working improving my CEF investing, and getting to the true income distribution (vs the gross distribution) is important. I came across the your post from Sept 2013 on getting to this information (https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/23587), but it appears that code no longer works, while on the surface the site did not change since then.
As an example, longer at NBB http://www.cefconnect.com/fund/NBBI wanted to get to at least the latest "Income" value of .103 (in this case same as distribution, but in others different). Looking at the source page, the cusip is 67074C103
|
| Declared Date | Payable Date | Ex Date | Distrib Amount | Income | Long Gain | Short Gain | ROC |
| 3/1/2017 | 4/3/2017 | 3/13/2017 | $0.1030
| $0.1030 | $0.0000 | $0.0000
|
So then this code would be what would have worked before
=RCHGetWebData("http://www.cefconnect.com/Resources/TableData/?Type=DistributionHistory¶m0=1/1/1980¶m1=12/31/2020&Cusip=67074C103")
But now it gets an error.
Any ideas?
Thanks again.
Scott
#yiv0882021598 #yiv0882021598 -- #yiv0882021598ygrp-
Attachment(s) from Ron Spruell
1 of 1 File(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar