[smf_addin] Digest Number 3407

EXCEL Stock Market Functions Add-in Group

9 Messages

Digest #3407

1a

Re: Retrieving data from Gurufocus.com by hamishthedenizen

1b

Re: Retrieving data from Gurufocus.com by "Randy Harmelink" rharmelink

2a

S&P 500 Companies Spreadsheet by ridgebacksexcel

2b

S&P 500 Companies Spreadsheet by ridgebacksexcel

2c

Re: S&P 500 Companies Spreadsheet by "Randy Harmelink" rharmelink

2d

Re: S&P 500 Companies Spreadsheet by ridgebacksexcel

3a

Re: Google Element Number Errors by bozzboy1

3b

Re: Google Element Number Errors by "Randy Harmelink" rharmelink

4a

Re: Tourist FX Rates by philip_r_small

Messages

1a

Re: Retrieving data from Gurufocus.com

Wed May 13, 2015 7:29 am (PDT) . Posted by:

hamishthedenizen

I don't have access to the EV-to-EBITDA stuff since it's for paying members only, but try this:
=RCHGetTableCell("http://www.gurufocus.com/financials/CSCO",11,"except for per share",">EV-to-EBITDA")
Note that this will only work for companies with a long financial history or the TTM number won't be in column 11.

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

1b

Re: Retrieving data from Gurufocus.com

Wed May 13, 2015 8:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Dan mentioned that EV-to-EBITDA is for members only. Have you created the
IE security cookie, so that the members only data is available to EXCEL and
the add-in?

On Tue, May 12, 2015 at 11:22 AM, Guy Lanfarm guylanfarm@... wrote:

>
> I tried your string. It gave me an "ERROR".
>
>

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

2a

S&P 500 Companies Spreadsheet

Wed May 13, 2015 9:21 am (PDT) . Posted by:

ridgebacksexcel

Does anyone have or know a good way to download all the current S&P 500 companies into a spreadsheet?


This site had a spreadsheet that used Finviz to get the data but the formula no longer works. I believe Finviz charges for that ability now.


Here was the formula:


={smfGetCSVFIle("http://finviz.com/export.ashx?v=152&f=idx_sp500&c=1,2,3,4")}


Any help is appreciated.


Thanks.

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

2b

S&P 500 Companies Spreadsheet

Wed May 13, 2015 9:26 am (PDT) . Posted by:

ridgebacksexcel

Does anyone have or know a good way to download all the current S&P 500 companies?
Finviz used to be able to do it and there was a template spreadsheet I used from this site but it no longer works. I believe Finviz charges for that ability now.


Here was the array formula that used to work:


={smfGetCSVFIle("http://finviz.com/export.ashx?v=152&f=idx_sp500&c=1,2,3,4")}


Any ideas for a new way to download the data?


Thanks.

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

2c

Re: S&P 500 Companies Spreadsheet

Wed May 13, 2015 10:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I know of two easy sources:

1. MorningStar has a list of all holdings for ETFs, so you could grab the
CSV file for SPY:

=smfGetCSVFile("
http://portfolios.morningstar.com/fund/holdingsExport?t=SPY&exportType=details
")

However, although sector is a field on that file, industry group is not.

2. You can use Zacks screener. Use the S&P 500 index as your criteria, then
select whatever fields you want to view, and then export the file. That
can't be easily automated with the add-in.

On Wed, May 13, 2015 at 9:21 AM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Does anyone have or know a good way to download all the current S&P 500
> companies into a spreadsheet?
>
> This site had a spreadsheet that used Finviz to get the data but the
> formula no longer works. I believe Finviz charges for that ability now.
>
> Here was the formula:
>
> ={smfGetCSVFIle("http://finviz.com/export.ashx?v=152&f=idx_sp500&c=1,2,3,4
> ")}
>
> Any help is appreciated.
>

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

2d

Re: S&P 500 Companies Spreadsheet

Wed May 13, 2015 10:35 am (PDT) . Posted by:

ridgebacksexcel

Ok Thanks Randy. I will look into both options.

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

3a

Re: Google Element Number Errors

Wed May 13, 2015 1:54 pm (PDT) . Posted by:

bozzboy1

Thanks again Randy.

Is there anyway for me to find out such information easily without bombarding you with questions all the time?


I'm a relative noob to the add-in I'm afraid.

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

3b

Re: Google Element Number Errors

Wed May 13, 2015 3:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I had to go to the source web pages to see what was there. You can use the
various text strings to find out the specifics of an element -- see the
documentation. For example:

=RCHGetElementNumber("P-URL", 14388)

Just replace the five tildas in the returned URL with a ticker symbol.

On Wed, May 13, 2015 at 1:54 PM, bozzboy1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there anyway for me to find out such information easily without
> bombarding you with questions all the time?
>
> I'm a relative noob to the add-in I'm afraid.
>

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

4a

Re: Tourist FX Rates

Thu May 14, 2015 12:43 am (PDT) . Posted by:

philip_r_small

Thanks Randy, that works perfectly. I have not used that SMF function before, so i'll look at it in more detail. It will probably help with a lot of sites where the Gettablecell doesn't work.

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 22

• Privacy • Unsubscribe • Terms of Use