Senin, 07 April 2014

[smf_addin] Digest Number 3035[1 Attachment]

15 Messages

Digest #3035
2c
Re: GetHTMLtable and Google Patent data by "Randy Harmelink" rharmelink
2d
Re: GetHTMLtable and Google Patent data by "Randy Harmelink" rharmelink
3a
Trouble Installing with Office 2010 and XP by "Daniel Berntson" daniel.berntson
3b
Re: Trouble Installing with Office 2010 and XP by "Randy Harmelink" rharmelink

Messages

Mon Apr 7, 2014 9:10 am (PDT) . Posted by:

jharlan

I think the GoogleFinance function is limited to 50 instances. While for small pulls it may be good, certainly not for anything worth while.

Mon Apr 7, 2014 12:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There is a way around that...use a preprocessor on the Internet to combine
the necessary data. I used to do that with AdvFN data. I had a PHP routine
that collected all of the 5-year tables and combined them into a single web
page.

But I still find the "import" functions on Google to be slow. I can't
imagine having 50 of them.

On Mon, Apr 7, 2014 at 9:10 AM, <jharlan@yahoo.com> wrote:

>
> I think the GoogleFinance function is limited to 50 instances. While for
> small pulls it may be good, certainly not for anything worth while.
>

Mon Apr 7, 2014 10:10 am (PDT) . Posted by:

jharlan

perfect. thx. I am beginning to understand. What about if my fxn produces a list of 4 items like:

=smfGetTagContent("http://patentscope.wipo.int/search/en/WO2001080485","span",1,"Inventors")



results in:


<B>SVANBERG, Emil</B>; (SE).<BR/><B>JOHANSSON, Joachim</B>; (SE).<BR/><B>TORGER, Anders</B>; (SE).<BR/><B>NORRGÅRD, Joakim</B>; (SE).<BR/><B>LARSSON, Anders</B>; (SE)

How do I parse out the names between the <B> and </B> tags to get a list like:


SVANBERG, Emil; JOHANSSON, Joachim; TORGER, Anders; NORRGÅRD, Joakim; LARSSON, Anders



for example?




Mon Apr 7, 2014 10:12 am (PDT) . Posted by:

jharlan

or better yet, from:

=smfGetTagContent("http://www.google.com/patents/US7190698","td",-1,"ininventor")



that returns with:


<span class="patent-bibdata-value-list"><span class="patent-bibdata-value"><a href="http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Emil+Svanberg%22">Emil Svanberg</a>, </span><span class="patent-bibdata-value"><a href="http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Joachim+Johansson%22">Joachim Johansson</a>, </span><span class="patent-bibdata-value"><a href="http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Anders+Torger%22">Anders Torger</a>, </span><span class="patent-bibdata-value"><a href="http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Joakim+Norrgard%22">Joakim Norrgard</a>, </span><span class="patent-bibdata-value"><a href="http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Anders+Larsson%22">Anders Larsson</a></span></span>


To create a cell with the following elements: Emil Svanberg, Joachim Johansson


etc that is iterative and between the "a href" tags.


thoughs/suggestions?


thx,

Mon Apr 7, 2014 1:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For that, I would use the SMF utilities (i.e. smfWord() and smfStrExtr())
and EXCEL functions to parse the data. For example, to get the first name:

=SUBSTITUTE(SUBSTITUTE(smfWord(smfGetTagContent("
http://patentscope.wipo.int/search/en/WO2001080485
","span",1,"Inventors"),1,"<BR/>"),"<B>",""),"</B>","")

I used smfWord() to parse out the first name and then SUBSTITUTE()
functions to remove the HTML tags. I recently worked on some PHP code and
found out that PHP has a function to remove all HTML tags. I may have to
create an SMF utility function for that. It's been an issue from time to
time.

On Mon, Apr 7, 2014 at 10:10 AM, <jharlan@yahoo.com> wrote:

>
> perfect. thx. I am beginning to understand. What about if my fxn
> produces a list of 4 items like:
>
> =smfGetTagContent("http://patentscope.wipo.int/search/en/WO2001080485
> ","span",1,"Inventors")
>
> results in:
>
> <B>SVANBERG, Emil</B>; (SE).<BR/><B>JOHANSSON, Joachim</B>;
> (SE).<BR/><B>TORGER, Anders</B>; (SE).<BR/><B>NORRGÅRD, Joakim</B>;
> (SE).<BR/><B>LARSSON, Anders</B>; (SE)
> How do I parse out the names between the <B> and </B> tags to get a list
> like:
>
> SVANBERG, Emil; JOHANSSON, Joachim; TORGER, Anders; NORRGÅRD, Joakim; LARSSON,
> Anders
>
> for example?
>
>
>
>
>
>

Mon Apr 7, 2014 1:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

To extract the first name:

=smfStrExtr(smfWord(smfGetTagContent("
http://www.google.com/patents/US7190698","td",-1,"ininventor"),2,"<a
"),">","<")

The smfWord() function breaks it up into pieces based on the "<a " HTML
tag, then uses the smfStrExtr() function to extract the data in between the
remaining HTML delimiters.

Another option:

=smfGetTagContent("http://www.google.com/patents/US7190698
","a",2,"ininventor")

...but then the question is how to decide when to stop.

On Mon, Apr 7, 2014 at 10:12 AM, <jharlan@yahoo.com> wrote:

>
> or better yet, from:
>
> =smfGetTagContent("http://www.google.com/patents/US7190698
> ","td",-1,"ininventor")
>
> that returns with:
> <span class="patent-bibdata-value-list"><span
> class="patent-bibdata-value"><a href="
> http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Emil+Svanberg%22">Emil
> Svanberg</a>, </span><span class="patent-bibdata-value"><a href="
> http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Joachim+Johansson%22">Joachim
> Johansson</a>, </span><span class="patent-bibdata-value"><a href="
> http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Anders+Torger%22">Anders
> Torger</a>, </span><span class="patent-bibdata-value"><a href="
> http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Joakim+Norrgard%22">Joakim
> Norrgard</a>, </span><span class="patent-bibdata-value"><a href="
> http://www.google.com/search?tbo=p&tbm=pts&hl=en&q=ininventor:%22Anders+Larsson%22">Anders
> Larsson</a></span></span>
> To create a cell with the following elements: Emil Svanberg, Joachim
> Johansson
>
> etc that is iterative and between the "a href" tags.
>
> thoughs/suggestions?
>
> thx,
>

Mon Apr 7, 2014 12:54 pm (PDT) . Posted by:

"Daniel Berntson" daniel.berntson

Hi everyone,

I'm really excited to start using the smf add-on. Unfortunately, I've hit a
snag. I'm trying to run the latest version of the add-on with Office 2010
and Windows XP. I've followed the installation instruction but, when I try
to use the RCHGetElementNumber function, it tells me that "the formula you
typed contains an error." I'm quite sure that it doesn't, since I get the
same message when using one of the example files from Randy's site.

Any ideas? I was thinking of downgrading to Office 2003 and trying that.

Daniel

Mon Apr 7, 2014 1:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It would help if you'd show us what your RCHGetElementNumber() function
looked like.

One issue that did come up from a blog that discussed the add-in is that
they gave an example with MicroSoft Word quotes. That is, it used a left
double-quote and a right double-quote. Since EXCEL just uses the general
purpose double quote, anyone doing a copy and paste from that blog item
would get a complaint from EXCEL that the formula contained an error.

On Mon, Apr 7, 2014 at 7:03 AM, Daniel Berntson
<daniel.berntson@gmail.com>wrote:

>
> I'm really excited to start using the smf add-on. Unfortunately, I've hit
> a snag. I'm trying to run the latest version of the add-on with Office 2010
> and Windows XP. I've followed the installation instruction but, when I try
> to use the RCHGetElementNumber function, it tells me that "the formula you
> typed contains an error." I'm quite sure that it doesn't, since I get the
> same message when using one of the example files from Randy's site.
>
> Any ideas? I was thinking of downgrading to Office 2003 and trying that.
>
>

Mon Apr 7, 2014 6:41 pm (PDT) . Posted by:

daniel.berntson

Ah, I just realized that I've been making a silly mistake. In Google Docs, you can separate the inputs to a function with a comma. Not so in Excel. Everything is working fine now.


Thanks Randy for making such a useful and helpful plug-in. Getting comparable data through an official provider would cost thousands of dollars a year!


Daniel

Mon Apr 7, 2014 10:04 pm (PDT) . Posted by:

linhle1784

Good evening fellow users, This is my second day using SMF and i'm completely lost as to how to generate the 10-year financials data (income statement, balance sheet, and statement of cash flows) for my companies (CLR, TSO, and COG) to practice my valuation skills. Please help. Thank you.


V/R,
Le

Mon Apr 7, 2014 10:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'd suggest taking a look at some of the templates.There are also a number
of 10-year models in the "Uploaded by Forum Members" folder in the FILES
area.

On Mon, Apr 7, 2014 at 9:55 PM, <linhle1784@yahoo.com> wrote:

>
> This is my second day using SMF and i'm completely lost as to how to
> generate the 10-year financials data (income statement, balance sheet, and
> statement of cash flows) for my companies (CLR, TSO, and COG) to practice
> my valuation skills. Please help. Thank you.
>

Mon Apr 7, 2014 10:50 pm (PDT) . Posted by:

"Linh Le" linhle1784

Thank you for the suggestions but how come every time i download the templates excel won't let me see the functions even after i've enabled editing? I understand that the authors have protected their work for good reasons. 
On Monday, April 7, 2014 11:32 PM, Randy Harmelink <rharmelink@gmail.com> wrote:

 
I'd suggest taking a look at some of the templates.There are also a number of 10-year models in the "Uploaded by Forum Members" folder in the FILES area.

On Mon, Apr 7, 2014 at 9:55 PM, <linhle1784@yahoo.com> wrote:

>This is my second day using SMF and i'm completely lost as to how to generate the 10-year financials data (income statement, balance sheet, and statement of cash flows) for my companies (CLR, TSO, and COG) to practice my valuation skills. Please help. Thank you.
>

Mon Apr 7, 2014 11:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What templates are you looking at where you can't see the functions? I
wasn't aware of anything like that.

On Mon, Apr 7, 2014 at 10:47 PM, Linh Le <linhle1784@yahoo.com> wrote:

>
> Thank you for the suggestions but how come every time i download the
> templates excel won't let me see the functions even after i've enabled
> editing? I understand that the authors have protected their work for good
> reasons.
>

Mon Apr 7, 2014 11:19 pm (PDT) . Posted by:

"Linh Le" linhle1784

I've tried both the templates available through your examples and those uploaded by the groups'. Excel prompt me to "update links" every time i open the sheets. I just want to be able to see the functions in order to replicate for my companies' financial statements. Thank you so much. 
On Tuesday, April 8, 2014 12:13 AM, Randy Harmelink <rharmelink@gmail.com> wrote:

 
What templates are you looking at where you can't see the functions? I wasn't aware of anything like that.

On Mon, Apr 7, 2014 at 10:47 PM, Linh Le <linhle1784@yahoo.com> wrote:

>
>Thank you for the suggestions but how come every time i download the templates excel won't let me see the functions even after i've enabled editing? I understand that the authors have protected their work for good reasons.
>

Mon Apr 7, 2014 11:22 pm (PDT) . Posted by:

scott.vo@sbcglobal.net

Linh,

Download RCH_Stock_Market_Functions, then follow these steps

Click Enable Content --> Edit Links --> Change Source --> Select the RCH_Stock_Market_Functions file --> OK --> Close

You should good to go.
Scott
Attachment(s) from
1 of 1 File(s)
Diposting oleh EXCEL FEED LEARNING di 23.22

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)