Rabu, 01 Juni 2016

[smf_addin] Digest Number 3716

12 Messages

Digest #3716

Messages

Tue May 31, 2016 3:10 am (PDT) . Posted by:

jsawyermib


Where the data should come up is just a hyphen (-)


I am located in the UK


regards


J

Tue May 31, 2016 3:34 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You probably need the AdvFN fix from the "Tips and FAQs" web page,
documented here:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/21069

The test is to see what URL you end up on when you use this URL in the
browser:

http://www.advfn.com/stock-market/NYSE/MMM/financials

Do you still have the "www" there, or it it redirect you somewhere else?

On Tue, May 31, 2016 at 3:10 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Where the data should come up is just a hyphen (-)
>
> I am located in the UK
>
>
>

Tue May 31, 2016 4:45 am (PDT) . Posted by:

jsawyermib

I'm getting the www. and its displaying the site for the URL you gave without re-directing me




http://www.advfn.com/stock-market/NYSE/MMM/financials http://www.advfn.com/stock-market/NYSE/MMM/financials
3M Company Financial Information http://www.advfn.com/stock-market/NYSE/MMM/financials

http://www.advfn.com/stock-market/NYSE/MMM/financials

3M Company Financial Information http://www.advfn.com/stock-market/NYSE/MMM/financials 3M Co. financial information, fundamentals and company reports including full balance sheet, profit and Loss, debtors, creditors, financial ratios...



View on www.advfn.com http://www.advfn.com/stock-market/NYSE/MMM/financials
Preview by Yahoo








Tue May 31, 2016 5:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What do you get for each of the following formulas:

=smfGetTagContent("http://www.advfn.com/stock-market/NYSE/MMM/financials
","span",-1,"id=""account-buttons""")

=RCHGetWebData("http://www.advfn.com/stock-market/NYSE/MMM/financials",
"stock-market/", 50)

=smfGetADVFNElement("MMM","A",999)

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

=smfGetADVFNElement("MMM","A",1,">year end date<")

=RCHGetTableCell("
http://www.advfn.com/stock-market/NYSE/MMM/financials?btn=start_date&start_date=11&mode=annual_reports",2,">Year
End Date")

On Tue, May 31, 2016 at 4:45 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I'm getting the www. and its displaying the site for the URL you gave
> without re-directing me
>
>
>

Tue May 31, 2016 9:56 am (PDT) . Posted by:

jsawyermib


What do you get for each of the following formulas: Results Below - <a href="http://www.advfn.com/p.php?pid=register" class="header-btn" >Free Membership</a> <a href="http://www.advfn.com/common/account/login" class="header-btn" role='login' >Login</a> <div id="pm-icon" class="Element PrivateMessageIconElement "></div>
stock-market/NYSE/MMM/financials"><link rel="searc Error 22 http://www.advfn.com/stock-market/NYSE/MMM/financials?mode=annual_reports&btn=start_date Error 2005/12 http://www.advfn.com/stock-market/NYSE/MMM/financials?btn=start_date&start_date=11&mode=annual_reports


Tue May 31, 2016 11:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Those results confound me completely. At this point, I don't know what else
to look at. This formula:

=smfGetADVFNElement("MMM","A",1,">year end date<")

...should be generating this extraction:

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

The only reason I can see that the second one would work and the first
would return "Error" is if the smfGetADVFNElement() function was creating a
different URL, and I can't think of a way to discover that without stepping
through the VBA code and checking what is generated at the time the call to
RCHGetTableCell() is done...

On Tue, May 31, 2016 at 9:56 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> What do you get for each of the following formulas:
> Results Below -
>
> <a href="http://www.advfn.com/p.php?pid=register" class="header-btn" >Free
> Membership</a> <a href="http://www.advfn.com/common/account/login"
> class="header-btn" role='login' >Login</a> <div id="pm-icon"
> class="Element PrivateMessageIconElement "></div>
> <http://www.advfn.com/stock-market/NYSE/MMM/financials>
> stock-market/NYSE/MMM/financials"><link rel="searc
> <http://www.advfn.com/stock-market/NYSE/MMM/financials>
> Error
> 22
> <http://www.advfn.com/stock-market/NYSE/MMM/financials?mode=annual_reports&btn=start_date>
> Error
> 2005/12
> <http://www.advfn.com/stock-market/NYSE/MMM/financials?btn=start_date&start_date=11&mode=annual_reports>
>
>

Tue May 31, 2016 1:54 pm (PDT) . Posted by:

jsawyermib

If it helps, I have also tried this on another machine I use that also runs Windows 7 and the same version of Office and have the same version of the addin loaded with the same results. kind regards


John

Tue May 31, 2016 3:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That just leads me to believe it is a regional type issue, which doesn't
appear to be the case based on tests I had you do.

Just a last grasp -- do you have the IE cross-domain settings set as
described by the AdvFN item on the "Tips and FAQs" web page?

On Tue, May 31, 2016 at 1:54 PM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> If it helps, I have also tried this on another machine I use that also
> runs Windows 7 and the same version of Office and have the same version of
> the addin loaded with the same results.
> kind regards
>
>
>

Wed Jun 1, 2016 12:35 am (PDT) . Posted by:

jsawyermib

Where can I find this "Tips & FAQ's" page? BTW I am using Chrome and not IE


J

Wed Jun 1, 2016 12:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

http://ogres-crypt.com/SMF/Tips-and-FAQs/

It doesn't matter what you use as a browser. EXCEL and the add-in used the
same Internet engine MicroSoft wrote for IE. So all three use the same
Internet setting, shared files, and cookies.

On Wed, Jun 1, 2016 at 12:35 AM, jsawyermib@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Where can I find this "Tips & FAQ's" page?
> BTW I am using Chrome and not IE
>
>
>

Tue May 31, 2016 7:53 am (PDT) . Posted by:

nlavery

Question about the titled spreadsheet. This used to work very well but now the latest data shown in the spreadsheet is for yearend 2013 - two years out of date. Any suggestions for a fix?


A related question about a similar 10-year spreadsheet based on GuruFocus, which was great but no longer works for me.


Thanks............Toby

Tue May 31, 2016 9:04 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

That AdvFN file is not one of mine, so I wouldn't be updating it. And it
returns mostly "Error" for me.

I'd suggest trying the two templates on the website:

http://ogres-crypt.com/SMF/Templates/#AdvFN

AdvFN has made a number of changes in the last few years. You may need the
most recent official release of the add-in (2016-04-19).

As far as GuruFocus, the most recent template, which uses the new function
I wrote, in in the "Works in Progress" folder:

http://ogres-crypt.com/SMF/Works-In-Progress/smfGetGuruFocusItem-Full-Template.xls

I think they now limit non-subscribers to only 5 years of data instead of
10 now?

If you want all the available financial statements data from GuruFocus, try
out their CSV file:

=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol=MMM")

That gets 20 annual and 80 quarterly periods + TTM for me, but I'm a
subscriber.

On Tue, May 31, 2016 at 7:53 AM, toby.avery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Question about the titled spreadsheet. This used to work very well but
> now the latest data shown in the spreadsheet is for yearend 2013 - two
> years out of date. Any suggestions for a fix?
>
> A related question about a similar 10-year spreadsheet based on GuruFocus,
> which was great but no longer works for me.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar