7 Messages
Digest #3679
Messages
Mon Apr 18, 2016 6:15 am (PDT) . Posted by:
nkfmn
Dear Mr. Harmelink,
Great !
Thank you very much.
Nehemia K.
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
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.
>
>
>
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
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.
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?
I was using this code for years and suddenly it becomes a string of "Value".
=RCHGetTableCell("http://www.zacks.com/stock/quote/"&A44&"
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?
>
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&"
>
> 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