Kamis, 03 April 2014

[smf_addin] Digest Number 3030

12 Messages

Digest #3030
1g
Net Income of sp500 by "Nikola Ganev" ganevniko
1h
Re: Net Income of sp500 by "Randy Harmelink" rharmelink
1i
Re: Net Income of sp500 by "Nikola Ganev" ganevniko
1j
Re: Net Income of sp500 by "Randy Harmelink" rharmelink
2b
Re: GetHTMLtable and Google Patent data by "Randy Harmelink" rharmelink

Messages

Wed Apr 2, 2014 7:24 am (PDT) . Posted by:

saad.khans90

Hey Everyone, I'm working on something similar to what SMF add-in does for financial history, but I'm doing this on Google. One main advantage this gives me is that I'm a MAC user and It allows me and everyone else to have access to it. If i have a group (team) involved in this, Well we can all work on it simultaneously.

If anybody is interested in having access to it, Please just drop me an email or drop a comment below.


Thanks,
Saad

Wed Apr 2, 2014 7:32 am (PDT) . Posted by:

"Darryl Bonfessuto"

I would be interested

Thanks Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of saad.khans90@yahoo.com
Sent: Wednesday, April 02, 2014 9:50 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] I'm working on somethign similar to SMF on Google Sheets.

Hey Everyone, I'm working on something similar to what SMF add-in does for financial history, but I'm doing this on Google. One main advantage this gives me is that I'm a MAC user and It allows me and everyone else to have access to it. If i have a group (team) involved in this, Well we can all work on it simultaneously.

If anybody is interested in having access to it, Please just drop me an email or drop a comment below.

Thanks,
Saad

Wed Apr 2, 2014 7:35 am (PDT) . Posted by:

"Darryl Bonfessuto"

I would like to have three different data sets each with different codes to validate the samples. I believe if you use google drive they may have some of this functionality.

darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of saad.khans90@yahoo.com
Sent: Wednesday, April 02, 2014 9:50 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] I'm working on somethign similar to SMF on Google Sheets.

Hey Everyone, I'm working on something similar to what SMF add-in does for financial history, but I'm doing this on Google. One main advantage this gives me is that I'm a MAC user and It allows me and everyone else to have access to it. If i have a group (team) involved in this, Well we can all work on it simultaneously.

If anybody is interested in having access to it, Please just drop me an email or drop a comment below.

Thanks,
Saad

Wed Apr 2, 2014 7:46 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Will this be a MAC only function?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of saad.khans90@yahoo.com
Sent: Wednesday, April 02, 2014 9:50 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] I'm working on somethign similar to SMF on Google Sheets.


Hey Everyone, I'm working on something similar to what SMF add-in does for financial history, but I'm doing this on Google. One main advantage this gives me is that I'm a MAC user and It allows me and everyone else to have access to it. If i have a group (team) involved in this, Well we can all work on it simultaneously.

If anybody is interested in having access to it, Please just drop me an email or drop a comment below.

Thanks,
Saad

Wed Apr 2, 2014 10:23 am (PDT) . Posted by:

"Darryl Bonfessuto"

Saad

Do you have a working excel file? Do you use dropbox or google drive how can I have access to it

Thanks Darryl

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of saad.khans90@yahoo.com
Sent: Wednesday, April 02, 2014 9:50 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] I'm working on somethign similar to SMF on Google Sheets.

Hey Everyone, I'm working on something similar to what SMF add-in does for financial history, but I'm doing this on Google. One main advantage this gives me is that I'm a MAC user and It allows me and everyone else to have access to it. If i have a group (team) involved in this, Well we can all work on it simultaneously.

If anybody is interested in having access to it, Please just drop me an email or drop a comment below.

Thanks,
Saad

Wed Apr 2, 2014 10:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

What are you using to get the data into the workbook?

I've found their API spreadsheet functions to be slow.

They do have something similar to VBA though, don't they?

On Wed, Apr 2, 2014 at 6:50 AM, <saad.khans90@yahoo.com> wrote:

>
> Hey Everyone, I'm working on something similar to what SMF add-in does for
> financial history, but I'm doing this on Google. One main advantage this
> gives me is that I'm a MAC user and It allows me and everyone else to have
> access to it. If i have a group (team) involved in this, Well we can all
> work on it simultaneously.
>
> If anybody is interested in having access to it, Please just drop me an
> email or drop a comment below.
>
>

Wed Apr 2, 2014 11:39 am (PDT) . Posted by:

"Nikola Ganev" ganevniko

Hi there,
I am trying to pull the net income of all sp500 companies on a quarterly basis for the last five years. I am currently doing it by pulling the tickers from SLYV and using the RCHgetelementnumber function but 500 companies for 20 quarters that is 10000 elements to pull and the spreadsheet becomes very heavy. Is there a way to do it with arrays so the spreadsheet is easier to load?
Thank you 

Wed Apr 2, 2014 12:06 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm not sure why you would use the S&P 600 ETF holdings, if you want a list
of S&P 500 companies?

In any case, the only way an array-entered function would speed up the
process is if you have a data source that provides all of the data in a
single Internet access.

I could do a screen on Portfolio123 and export the results quickly. Took me
about a minute to create a test screen with only two quarters of data, and
export the data.

Just curious, are you doing anything to align them, since the data could be
90 days or more out of sync due to fiscal quarter-end and filing date
considerations?

On Wed, Apr 2, 2014 at 11:36 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:

>
> I am trying to pull the net income of all sp500 companies on a quarterly
> basis for the last five years. I am currently doing it by pulling the
> tickers from SLYV and using the RCHgetelementnumber function but 500
> companies for 20 quarters that is 10000 elements to pull and the
> spreadsheet becomes very heavy. Is there a way to do it with arrays so the
> spreadsheet is easier to load?
>

Wed Apr 2, 2014 12:18 pm (PDT) . Posted by:

"Nikola Ganev" ganevniko

Sorry I meant I am using SPY to pull the tickers. aligning the data was going to be my next issue...what would you suggest using RCHgetelementnumber? with the ADVfn fonction I can pull the dates of the quarters so should I switch to ADVfn or there is a way with RCHgetelemetnumber?

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Wednesday, April 2, 2014 3:06 PM
Subject: Re: [smf_addin] Net Income of sp500

 
I'm not sure why you would use the S&P 600 ETF holdings, if you want a list of S&P 500 companies?

In any case, the only way an array-entered function would speed up the process is if you have a data source that provides all of the data in a single Internet access.

I could do a screen on Portfolio123 and export the results quickly. Took me about a minute to create a test screen with only two quarters of data, and export the data.

Just curious, are you doing anything to align them, since the data could be 90 days or more out of sync due to fiscal quarter-end and filing date considerations?

On Wed, Apr 2, 2014 at 11:36 AM, Nikola Ganev <ganevniko@yahoo.com> wrote:

>
>I am trying to pull the net income of all sp500 companies on a quarterly basis for the last five years. I am currently doing it by pulling the tickers from SLYV and using the RCHgetelementnumber function but 500 companies for 20 quarters that is 10000 elements to pull and the spreadsheet becomes very heavy. Is there a way to do it with arrays so the spreadsheet is easier to load?
>

Wed Apr 2, 2014 1:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If AdvFN would be a switch, what source are you using now?

I think the "quarter end date" would be the only thing on AdvFN that you
could use to align things, but that doesn't tell you what kind of lag there
is to actual reporting of the data. Although for S&P 500 companies, it may
not vary much.

On Wed, Apr 2, 2014 at 12:15 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:

>
> Sorry I meant I am using SPY to pull the tickers. aligning the data was
> going to be my next issue...what would you suggest using
> RCHgetelementnumber? with the ADVfn fonction I can pull the dates of the
> quarters so should I switch to ADVfn or there is a way with
> RCHgetelemetnumber?
>

Wed Apr 2, 2014 8:39 am (PDT) . Posted by:

jharlan

sure thing...

From http://www.google.com/patents/us7629964 http://www.google.com/patents/us7629964, there is a section with information like:


Title
Publication date Dec 8, 2009 Filing date Apr 26, 2007 Priority date Jun 26, 1998
Patent Citations http://www.google.com/patents/us7629964#backward-citations (106), Non-Patent Citations http://www.google.com/patents/us7629964#npl-citations (18), Referenced by http://www.google.com/patents/us7629964#forward-citations (5),Classifications http://www.google.com/patents/us7629964#classifications (29), Legal Events http://www.google.com/patents/us7629964#legal-events (3)



I'd like to pull the related data from "publication date", "filing date", "priority date", "patent citations" and "referenced by" into an excel spreadsheet using the RCHGetHTML function, if that's the right one.


So, my row looks like (with the above headings):12/8/2009, 4/26/2007, 6/26/1998, 106, 5 (respectively)


Thanks, Jim.

Wed Apr 2, 2014 9:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=DATEVALUE(RCHGetTableCell("http://www.google.com/patents/us7629964",1,">Publication
Date"))
=DATEVALUE(RCHGetTableCell("http://www.google.com/patents/us7629964",1,">Filing
Date"))
=DATEVALUE(RCHGetTableCell("http://www.google.com/patents/us7629964",1,">Priority
Date"))
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.google.com/patents/us7629964","span",-1,">Patent
Citations"),"(",")"))
=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.google.com/patents/us7629964","span",-1,">Referenced
by"),"(",")"))

On Wed, Apr 2, 2014 at 8:39 AM, <jharlan@yahoo.com> wrote:

>
> sure thing...
>
> From http://www.google.com/patents/us7629964, there is a section with
> information like:
>
> Title
> Publication dateDec 8, 2009Filing dateApr 26, 2007Priority dateJun 26,
> 1998
> Patent Citations<http://www.google.com/patents/us7629964#backward-citations>
> (106), Non-Patent Citations<http://www.google.com/patents/us7629964#npl-citations>
> (18), Referenced by<http://www.google.com/patents/us7629964#forward-citations>
> (5),Classifications<http://www.google.com/patents/us7629964#classifications>
> (29), Legal Events <http://www.google.com/patents/us7629964#legal-events>
> (3)
>
> I'd like to pull the related data from "publication date", "filing date",
> "priority date", "patent citations" and "referenced by" into an excel
> spreadsheet using the RCHGetHTML function, if that's the right one.
>
> So, my row looks like (with the above headings):12/8/2009, 4/26/2007,
> 6/26/1998, 106, 5 (respectively)
>
>
Diposting oleh EXCEL FEED LEARNING di 01.13

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)