Selasa, 19 April 2016

[smf_addin] Digest Number 3679

7 Messages

Digest #3679
2a
CEFconnect.com by "Ron Spruell" hashky
2b
Re: CEFconnect.com by "Randy Harmelink" rharmelink
4b
Re: Unable to get Sales from Zacks by "Randy Harmelink" rharmelink

Messages

Mon Apr 18, 2016 6:15 am (PDT) . Posted by:

nkfmn

Dear Mr. Harmelink,


Great !


Thank you very much.


Nehemia K.


Mon Apr 18, 2016 9:51 am (PDT) . Posted by:

"Ron Spruell" hashky

Randy -
CEFconnect.com changed their Website.  They now use Javascript.  My spreadsheet that worked so well no longer works.  I have tried to find the information, but I am at a loss.  Can you help?
The specific equation for extracting the Distribution is a follows:
=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"": """&$B6&""",",,-400),"{","}"),"""DistributionRatePrice"":",","))
I can view at http://www.cefconnect.com/closed-end-funds-daily-pricingI cannot download into Excel
Many others don't work either, but if you could show me to get this answer I can probably get the others.

Ron Spruell

Mon Apr 18, 2016 11:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They changed the URL of the returned JSON file, and rearranged things a
bit. Try something like:

=smfConvertData(smfStrExtr(RCHGetWebData("
http://www.cefconnect.com/api/v3/DailyPricing?props=Ticker,Name,DistributionRateNAV,LastUpdated,Discount,DistributionRatePrice,ReturnOnNAV,CategoryId,CategoryName,IsManagedDistribution,Price,PriceChange,NAV,NAVPublished,Cusip/
","""Ticker"":"""&B6&"""",1000),"""DistributionRatePrice"":",","))

On Mon, Apr 18, 2016 at 9:48 AM, Ron Spruell hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Randy -
>
> CEFconnect.com changed their Website. They now use Javascript. My
> spreadsheet that worked so well no longer works. I have tried to find the
> information, but I am at a loss. Can you help?
>
> The specific equation for extracting the Distribution is a follows:
> =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"":
> """&$B6&""",",,-400),"{","}"),"""DistributionRatePrice"":",","))
>
> I can view at http://www.cefconnect.com/closed-end-funds-daily-pricing
> I cannot download into Excel
> Many others don't work either, but if you could show me to get this answer
> I can probably get the others.
>
>
>

Mon Apr 18, 2016 6:06 pm (PDT) . Posted by:

sushiwaitress

Hello,

I've been using this excel plugin for about 3 years now, and I just encountered a weird error that I hope someone can help me with.

I have a spreadsheet that tracks the current value of a bunch of stock holdings, and the formula to get the latest price is the same on every row. All rows work just fine and return the latest price, EXCEPT for the row in which I list the ticker symbol for the recent Under Armour split -- UA.C.

Does anyone know of a fix? My guess is that the code isn't expecting ticker symbols that contain periods. The split became effective on April 7, so it's been official for a while now --- the online data sources should be updated by now, right?

None of the formulas work when the UA.C ticker is an argument.

Any ideas on how to resolve this?

Ruth



Mon Apr 18, 2016 6:13 pm (PDT) . Posted by:

sushiwaitress

OK, I fixed it myself. After I took 5 mins to actually start troubleshooting I found that Yahoo itself didn't recognize UA.C, but UA-C works just fine.

D'oh.

Thanks anyway. Plugin works like a charm, as usual.

Mon Apr 18, 2016 10:47 pm (PDT) . Posted by:

tzewei_79

Hi,

I was using this code for years and suddenly it becomes a string of "Value".
=RCHGetTableCell("http://www.zacks.com/stock/quote/"&A44&"/income-statement",1,"Sales";)


I went to Zacks to check the table and it seems to be unchange. Anyone encounter this and has a solution?







Mon Apr 18, 2016 11:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This is an example of why I say ordinary words are not good search terms.
They can pop up before the table in a different context. Here's what a
search on "Sales" is finding:

...provides a comprehensive overview of the company business drivers,
complete with earnings and sales charts;...

So not the "Sales" you want from the table. In most cases, depending on how
the web page is coded, a simple ">" prefix in front of the search term can
fix the problem -- the ">" is the end of the HTML tag before the word
"Sales", so that the simple term in a sentence would not satisfy the search.

This works fine for me:

=RCHGetTableCell("http://www.zacks.com/stock/quote/
"&A44&"/income-statement",1,">Sales")

On Mon, Apr 18, 2016 at 10:47 PM, tzewei_79@... wrote:

>
> I was using this code for years and suddenly it becomes a string of
> "Value".
> =RCHGetTableCell("http://www.zacks.com/stock/quote/
> "&A44&"/income-statement",1,"Sales";)
>
> I went to Zacks to check the table and it seems to be unchange. Anyone
> encounter this and has a solution?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar