4 Messages
Digest #3953
Messages
Sat Apr 1, 2017 7:32 am (PDT) . Posted by:
sdwcyberdude
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/NBB http://www.cefconnect.com/fund/NBB
I 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
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/NBB http://www.cefconnect.com/fund/NBB
I 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
Sat Apr 1, 2017 12:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like they've changed the JSON calls.
Using my HttpFox extension in FireFox, I found these JSON calls when I
display the NBB web page:
http://www.cefconnect.com/api/v3/distributionhistory/fund/NB
B/04-01-2016/04-01-2017
http://www.cefconnect.com/api/v3/PriceHistory/NBB/1M/03-01-2017
http://www.cefconnect.com/api/v3/pricinghistory/NBB/1Y
http://www.cefconnect.com/api/v3/distributioncharter/fund/NBB/All
http://www.cefconnect.com/api/v3/distributioncharter/fund/NBB/1Y
http://www.cefconnect.com/api/v3/DiscountCharter/fund/NBB/1Y
http://www.cefconnect.com/api/v3/performance/calendar/NBB
http://www.cefconnect.com/api/v3/performance/annualized/NBB
http://www.cefconnect.com/api/v3/assetallocation/NBB
http://www.cefconnect.com/api/v3/callexposure/NBB
http://www.cefconnect.com/api/v3/creditquality/NBB
http://www.cefconnect.com/api/v3/maturity/NBB
The first contains your distributions. I included the others in case you
wanted to explore them.
On Sat, Apr 1, 2017 at 7:32 AM, scwalker1986@
...wrote:
>
> 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/NBB
> I 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 DatePayable DateEx DateDistrib AmountIncomeLong GainShort GainROC
> 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/TableDat
> a/?Type=DistributionHistory¶m0=1/1/1980¶m1=12/31/202
> 0&Cusip=67074C103")
>
> But now it gets an error.
>
> Any ideas?
>
>
Using my HttpFox extension in FireFox, I found these JSON calls when I
display the NBB web page:
http://www.cefconnect.com/api/v3/distributionhistory/fund/NB
B/04-01-2016/04-01-2017
http://www.cefconnect.com/api/v3/PriceHistory/NBB/1M/03-01-2017
http://www.cefconnect.com/api/v3/pricinghistory/NBB/1Y
http://www.cefconnect.com/api/v3/distributioncharter/fund/NBB/All
http://www.cefconnect.com/api/v3/distributioncharter/fund/NBB/1Y
http://www.cefconnect.com/api/v3/DiscountCharter/fund/NBB/1Y
http://www.cefconnect.com/api/v3/performance/calendar/NBB
http://www.cefconnect.com/api/v3/performance/annualized/NBB
http://www.cefconnect.com/api/v3/assetallocation/NBB
http://www.cefconnect.com/api/v3/callexposure/NBB
http://www.cefconnect.com/api/v3/creditquality/NBB
http://www.cefconnect.com/api/v3/maturity/NBB
The first contains your distributions. I included the others in case you
wanted to explore them.
On Sat, Apr 1, 2017 at 7:32 AM, scwalker1986@
...wrote:
>
> 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/NBB
> I 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 DatePayable DateEx DateDistrib AmountIncomeLong GainShort GainROC
> 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/TableDat
> a/?Type=Distributio
> 0&Cusip=67074C103&q
>
> But now it gets an error.
>
> Any ideas?
>
>
Sat Apr 1, 2017 5:41 pm (PDT) . Posted by:
sdwcyberdude
Interesting, thank you.
Is there a straight forward way to download this with your existing tools?
Fallback, I might dive into learning Excel Power Query.
Scott
Is there a straight forward way to download this with your existing tools?
Fallback, I might dive into learning Excel Power Query.
Scott
Sat Apr 1, 2017 6:08 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's the same technique that was in:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/23587
The only difference is that the RCHGetWebData() function would be used on
the new URL.
On Sat, Apr 1, 2017 at 5:41 PM, scwalker1986@
...wrote:
>
> Interesting, thank you.
>
> Is there a straight forward way to download this with your existing tools?
>
> Fallback, I might dive into learning Excel Power Query.
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/23587
The only difference is that the RCHGetWebData(
the new URL.
On Sat, Apr 1, 2017 at 5:41 PM, scwalker1986@
...wrote:
>
> Interesting, thank you.
>
> Is there a straight forward way to download this with your existing tools?
>
> Fallback, I might dive into learning Excel Power Query.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar