Sabtu, 07 Maret 2015

[smf_addin] Digest Number 3347

12 Messages

Digest #3347
3b
Re: ROIC Sanity Check from AdvFn by "Randy Harmelink" rharmelink

Messages

Fri Mar 6, 2015 5:33 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I just tried it with your formula and it worked fine. But I changed it to
the suggested stock-market, NOT stock-markets. That is:

="http://www.advfn.com/stock-market/"&smfStrExtr(RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&symbol=
"&Ticker,"canonical",150),"/stock-market/","/financials")&"/financials?btn="&IF(rAQ="A","annual","quarterly")&"_reports"

On Fri, Mar 6, 2015 at 2:23 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks Randy. I downloaded the latest addin, but I think the problem seems
> to be changes to the advfn url for annual company accounts data and
> unfortunately replacing the "exchanges" with "stock-markets" as suggested
> by your link did not fix the problem. Would you or others on this forum
> perhaps have any suggestions on how I could amend my url code to again be
> able to retrieve the historical accounts data?
>
> ="http://www.advfn.com/exchanges/"&smfstrExtr(RCHGetWebData("
> http://www.advfn.com/p.php?pid=financials&symbol=
> "&Ticker,"canonical&quot;,150),"/exchanges/","/financials")&"/financials?btn="&IF(rAQ="A","annual","quarterly")&"_reports"
>

Fri Mar 6, 2015 10:40 am (PST) . Posted by:

jsawyermib

Thanks, amending it to "market" now loads in the element name into my row title. Unfortunately I am still getter only "error" showing for the data in my worksheet (C6 being the row title).

=IF(OR(UPPER(Ticker)="NONE",COLUMNS($D:D)>rPeriods),"--",smfGetADVFNElement(Ticker,rAQ,COLUMNS($D:D),">"&$C6&"<",,"--"))

Fri Mar 6, 2015 10:52 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Did you exit EXCEL and install the latest beta version of the add-in
(version 2015.03.05)? I had to make program changes to the add-in.

On Fri, Mar 6, 2015 at 11:40 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks, amending it to "market" now loads in the element name into my row
> title. Unfortunately I am still getter only "error" showing for the data in
> my worksheet (C6 being the row title).
>
>
> =IF(OR(UPPER(Ticker)="NONE",COLUMNS($D:D)>rPeriods),"--",smfGetADVFNElement(Ticker,rAQ,COLUMNS($D:D),">"&$C6&"<",,"--"))
>

Fri Mar 6, 2015 3:33 pm (PST) . Posted by:

jsawyermib

Yes. To make sure, I removed the old versions and replaced them with your new one and closed and re-opened excel. The row title appear, but without and data, only "error". This was tested on a stock ticker (IPG) which worked fine only last month.
:(

Fri Mar 6, 2015 4:20 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What do you get with the following formulas:

=RCHGetElementNumber("Version")

=smfStrExtr(RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=IPG",
"/stock-market/", 50), "/stock-market/", "/")

=smfGetAdvFNElement("IPG","A",999)

=smfConvertData(smfStrExtr(RIGHT(smfGetTagContent("
http://www.advfn.com/stock-market/NYSE/IPG/financials?&mode=annual_reports&btn=start_date",
"select", 1, "Select start date"), 35), "'", "'"))

=smfGetAdvFNElement("IPG","A",1,">year end date<")

=RCHGetElementNumber("IPG", 5196)

=RCHGetTableCell("
http://www.advfn.com/stock-market/NYSE/IPG/financials?&mode=annual_reports&btn=start_date",
5,">year end date<")

On Fri, Mar 6, 2015 at 4:33 PM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Yes. To make sure, I removed the old versions and replaced them with your
> new one and closed and re-opened excel. The row title appear, but without
> and data, only "error". This was tested on a stock ticker (IPG) which
> worked fine only last month.
> :(
>

Fri Mar 6, 2015 4:32 pm (PST) . Posted by:

jsawyermib

Those resulted in the following:

Stock Market Functions add-in, Version 2.1.2013.10.17(C:\Program Files\SMF Add-in;;44)

NYSE

Error

21

Error

Error

2014/12

Fri Mar 6, 2015 4:37 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

As noted twice earlier in this message thread, you would need the
2015.03.05 version of the add-in, from the "Works in Progress" web page, to
get rid of those "Error" results. I had to make changes to the add-in code
to account for the AdvFN web site changes.

On Fri, Mar 6, 2015 at 5:32 PM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Those resulted in the following:
>
> Stock Market Functions add-in, Version 2.1.2013.10.17(C:\Program Files\SMF
> Add-in;;44)
>
> NYSE
>
> Error
>
> 21
>
> Error
>
> Error
>
> 2014/12
>

Fri Mar 6, 2015 4:40 pm (PST) . Posted by:

jsawyermib

I see what the problem was. I must have had two versions of the add-in on my computer. I have now erased the older ones and now have just the new one which works fine. Very many thanks for the help. most appreciated.

best

John

Fri Mar 6, 2015 4:13 pm (PST) . Posted by:

"Kermit W. Prather" kermitpra

The website I was using to pull dividend history appears to have switched to a JavaScript for the dividend history.

Site I tried are (they all use Javascript) Now:

www.dividend.com
www.dividendchannel.com
www.nasdaq.com __,
www.dividend.com Fee based

Anyone have a site they use, preferably one that is free, such as yahoo.com.
They provide free dividend payouts and yield. But I have found their data not that reliable sometimes.


I need to pull the last 40 payouts using the RCHGetHTMLTable function. Unless someone has a better idea.

I'm open to suggestions.


Kermit
_._,___

Fri Mar 6, 2015 4:32 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Do any of these get you what you need?

=smfGetCSVFile("http://www.gurufocus.com/download_dividend.php?symbol=MMM","
")
=RCHGetHTMLTable("
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM
","",1,"",1)

On Fri, Mar 6, 2015 at 5:13 PM, 'Kermit W. Prather' kermitp@... wrote:

>
> *The website I was using to pull dividend history appears to have switched
> to a JavaScript for the dividend history.*
>
>
>
> *Site I tried are (they all use Javascript) Now:*
>
>
>
> *www.dividend.com <http://www.dividend.com>*
>
> *www.dividendchannel.com <http://www.dividendchannel.com>*
>
> *www.nasdaq.com <http://www.nasdaq.com> *__,
>
> www.dividend.com Fee based
>
>
>
> Anyone have a site they use, preferably one that is free, such as
> yahoo.com.
>
> They provide free dividend payouts and yield. But I have found their data
> not that reliable sometimes.
>
>
>
> I need to pull the last 40 payouts using the RCHGetHTMLTable function.
> Unless someone has a better idea.
>
>
>
> I'm open to suggestions.
>
>
>

Fri Mar 6, 2015 5:27 pm (PST) . Posted by:

freefaller6

Hi Randy, thanks again for your help with the AdvFn fix yesterday. I was looking at historical ROIC's for various companies and the values for FY1 and FY2 (GetElementNumbers 7786, 7787) don't seem to pass the sniff test. For example the ROIC values provided for Apple are 0.3 and 0.3, respectively. A quick check of their actual financials shows that these are wrong. The other years, FY3-FY10 seem to be in the ballpark, but those first two seem way out of whack.


If you have minute, would you please spot check those? Are you seeing what I'm seeing?


Thanks,
Brent

Fri Mar 6, 2015 6:17 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I see what you see, on their web pages.

http://www.advfn.com/stock-market/NASDAQ/AAPL/financials?btn=annual_reports&mode=company_data

So at least it's not an add-in issue. Or does that make it worse?

My first suspicion would be that they left it as a raw (truncated) value of
0.3 instead of as a 30 something percentage number.

On Fri, Mar 6, 2015 at 6:27 PM, freefaller6@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hi Randy, thanks again for your help with the AdvFn fix yesterday. I
> was looking at historical ROIC's for various companies and the values for
> FY1 and FY2 (GetElementNumbers 7786, 7787) don't seem to pass the sniff
> test. For example the ROIC values provided for Apple are 0.3 and 0.3,
> respectively. A quick check of their actual financials shows that these
> are wrong. The other years, FY3-FY10 seem to be in the ballpark, but those
> first two seem way out of whack.
>
> If you have minute, would you please spot check those? Are you seeing
> what I'm seeing?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.33

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)