Hi Randy,

Previously I had made the suggested .IB change. Can you remind me please which file that applied to so I can go back and remove.

Thanks for your help

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Thanks Randy I really miss the ADVFn data. I've been getting by with the Gurufocus data but it just isn't the same.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I just uploaded beta version 2.1.2013.10.16 of the add-in to the "Works in Progress" folder of the FILES area of the group.

I made changes to the smfGetAdvFNElement() routine that should allow data to be retrieved, using their new URL scheme. That means RCHGetElementNumber() functions for AdvFN elements should also work.

It appears to work for both general templates in the FILES area.

However, I can only test changes using their "www" prefix. I don't know if other regional prefixes will work or not. Or whether you even NEED to use other regional prefixes any more.

And, of course, when they do go their new beta format, all bets are off until THAT gets stabilized.

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1c

Re: Beta version of add-in updated to work for AdvFN URL changes

Sat Oct 19, 2013 10:52 am (PDT) . Posted by:

cs.holdings

This is the version readback I get with the updated suffix. I showing error message with the new beta and I think it has to do with the suffix .ib

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

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Hi Randy,

Previously I had made the suggested .IB change. Can you remind me please which file that applied to so I can go back and remove.

Thanks for your help

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Thanks Randy I really miss the ADVFn data. I've been getting by with the Gurufocus data but it just isn't the same.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

I just uploaded beta version 2.1.2013.10.16 of the add-in to the "Works in Progress" folder of the FILES area of the group.

I made changes to the smfGetAdvFNElement() routine that should allow data to be retrieved, using their new URL scheme. That means RCHGetElementNumber() functions for AdvFN elements should also work.

It appears to work for both general templates in the FILES area.

However, I can only test changes using their "www" prefix. I don't know if other regional prefixes will work or not. Or whether you even NEED to use other regional prefixes any more.

And, of course, when they do go their new beta format, all bets are off until THAT gets stabilized.

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1d

Re: Beta version of add-in updated to work for AdvFN URL changes

Sat Oct 19, 2013 11:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's the smf-AdvFN-Prefix.txt file that is in the folder with the add-in.
Either delete that file or change the content to be just "www" (without the
quotes).

On Sat, Oct 19, 2013 at 10:44 AM, <pc_babe@msn.com> wrote:

> Previously I had made the suggested .IB change. Can you remind me please
> which file that applied to so I can go back and remove.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

1e

Re: Beta version of add-in updated to work for AdvFN URL changes

Sat Oct 19, 2013 12:06 pm (PDT) . Posted by:

cs.holdings

oooh ahhh ... yep. Thanks!

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

It's the smf-AdvFN-Prefix.txt file that is in the folder with the add-in. Either delete that file or change the content to be just "www" (without the quotes).

On Sat, Oct 19, 2013 at 10:44 AM, <pc_babe@... mailto:pc_babe@...> wrote:
Previously I had made the suggested .IB change. Can you remind me please which file that applied to so I can go back and remove.

Reply to sender . Reply to group . Reply via Web Post . All Messages (16) . Top ^

2a

element number 13166

Sat Oct 19, 2013 4:39 pm (PDT) . Posted by:

kkkutty

Hi Randy,

With the updated smfaddin for the ADVFN beta site, I have a question regarding element number 13166...it appears the most recent quarter, for example GOOG, I get 0.10 and for the next 19 quarters I get:

14.80 15.00 15.50 17.20 17.50 16.70 17.50 17.30 17.10 18.40 18.30 18.20 18.40 18.10 14.60 14.50 14.50 15.00 18.40

I checked with "Return on Assets (element number 13206) and I get similar results. It appears there's and error with how the addin is retrieving the most recent quarter's data for that element? Why is it completely off? Thanks in advance!

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2b

Re: element number 13166

Sat Oct 19, 2013 4:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

When I check the AdvFN site, those are the numbers I see:

http://www.advfn.com/exchanges/NASDAQ/GOOG/financials?btn=quarterly_reports&mode=company_data

So it's not an add-in issue. It's just retrieving what they have posted.

On Sat, Oct 19, 2013 at 4:39 PM, <kkkutty@yahoo.com> wrote:

>
> With the updated smfaddin for the ADVFN beta site, I have a question
> regarding element number 13166...it appears the most recent quarter, for
> example GOOG, I get 0.10 and for the next 19 quarters I get:
>
> 14.80 15.00 15.50 17.20 17.50 16.70 17.50 17.30 17.10 18.40 18.30 18.20
> 18.40 18.10 14.60 14.50 14.50 15.00 18.40
>
> I checked with "Return on Assets (element number 13206) and I get similar
> results. It appears there's and error with how the addin is retrieving the
> most recent quarter's data for that element? Why is it completely off?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2c

Re: element number 13166

Sat Oct 19, 2013 5:03 pm (PDT) . Posted by:

kkkutty

Oh I see...so are some of the elements being pulled from the new beta site and some from the old site? Because if you go to the new beta site, the ROCI for the period ending 6/30/13 is 14.93%. But I see what you're saying...the old site shows 0.1. Thanks.

---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

When I check the AdvFN site, those are the numbers I see:

http://www.advfn.com/exchanges/NASDAQ/GOOG/financials?btn=quarterly_reports&mode=company_data http://www.advfn.com/exchanges/NASDAQ/GOOG/financials?btn=quarterly_reports&mode=company_data

So it's not an add-in issue. It's just retrieving what they have posted.

On Sat, Oct 19, 2013 at 4:39 PM, <kkkutty@... mailto:kkkutty@...> wrote:

With the updated smfaddin for the ADVFN beta site, I have a question regarding element number 13166...it appears the most recent quarter, for example GOOG, I get 0.10 and for the next 19 quarters I get:

14.80 15.00 15.50 17.20 17.50 16.70 17.50 17.30 17.10 18.40 18.30 18.20 18.40 18.10 14.60 14.50 14.50 15.00 18.40

I checked with "Return on Assets (element number 13206) and I get similar results. It appears there's and error with how the addin is retrieving the most recent quarter's data for that element? Why is it completely off?

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2d

Re: element number 13166

Sat Oct 19, 2013 5:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Nothing is using the new beta format web pages.

On Sat, Oct 19, 2013 at 5:03 PM, <kkkutty@yahoo.com> wrote:

> Oh I see...so are some of the elements being pulled from the new beta
> site and some from the old site? Because if you go to the new beta site,
> the ROCI for the period ending 6/30/13 is 14.93%. But I see what you're
> saying...the old site shows 0.1. Thanks.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3a

extracting company profile from bloomberg

Sat Oct 19, 2013 11:02 pm (PDT) . Posted by:

weekeewawa

hi randy,

how do i extract the short company profile snaplet from IBM

http://www.bloomberg.com/quote/IBM:US/profile http://www.bloomberg.com/quote/IBM:US/profile

International Business Machines Corporation (IBM) provides computer solutions through the use of advanced information technology. The Company's solutions include technologies, systems, products, services, software, and financing. IBM offers its products through its global sales and distribution organization, as well as through a variety of third party distributors and resellers.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: extracting company profile from bloomberg

Sat Oct 19, 2013 11:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US/profile
","p",-1,"extended_profile")

On Sat, Oct 19, 2013 at 11:02 PM, <weekeewawa@yahoo.com> wrote:

>
> how do i extract the short company profile snaplet from IBM
>
> http://www.bloomberg.com/quote/IBM:US/profile
>
>