Messages In This Digest (19 Messages)

1a.: Re: s&p 500 symbols list From: mshuffma97
1b.: Re: s&p 500 symbols list From: dguillett1
1c.: Re: s&p 500 symbols list From: sudhir agarwal
1d.: Re: s&p 500 symbols list [1 Attachment] From: devendra khede

2a.: Re: Microsoft Office From: dguillett1

3a.: download history prices From: Lawrence
3b.: Re: download history prices From: Randy Harmelink
3c.: Re: download history prices From: Lawrence

4a.: RCHGetHTMLTable or smfGetTagContent help From: digsupply
4b.: Re: RCHGetHTMLTable or smfGetTagContent help From: Randy Harmelink
4c.: Re: RCHGetHTMLTable or smfGetTagContent help From: digsupply
4d.: Re: RCHGetHTMLTable or smfGetTagContent help From: Randy Harmelink

5a.: Getting data from other sources Except MSN From: sudhir agarwal
5b.: Re: Getting data from other sources Except MSN From: Randy Harmelink

6.1.: New file uploaded to smf_addin From: smf_addin@yahoogroups.com
6.2.: Re: New file uploaded to smf_addin From: Kermit W. Prather

7.: Cash conversion cycle From: d_j_ricks

8a.: quote Technical Analysis yahoo From: choni
8b.: Re: quote Technical Analysis yahoo From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Re: s&p 500 symbols list

Posted by: "mshuffma97" mshuffma97@gmail.com mshuffma97

Mon Mar 19, 2012 4:13 am (PDT)

Don't think this spreadsheet is current. BRK-B is not on the list, but is currently in the S&P 500.

Near as I can tell, this Wikipedia list is correct as of today:

http://en.wikipedia.org/wiki/List_of_S&P_500_companies

Just copy the table from the web page and paste into a spreadsheet.

--- In smf_addin@yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@...
>
> From: rr76012
> Sent: Saturday, March 17, 2012 8:03 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] s&p 500 symbols list
>
>
> Does anyone have a spreadsheet they are willing to share, with the current s&p 500 symbols list?
>
> Happy St. Patricks Day,
>
> Thanks
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.: Re: s&p 500 symbols list

Posted by: "dguillett1" dguillett1@gmail.com donaldb36

Mon Mar 19, 2012 5:30 am (PDT)

[Attachment(s) from dguillett1 included below]

I have added the wikipedia. Now you can look at both and refresh.

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@gmail.com

From: mshuffma97
Sent: Monday, March 19, 2012 4:06 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: s&p 500 symbols list

Don't think this spreadsheet is current. BRK-B is not on the list, but is currently in the S&P 500.

Near as I can tell, this Wikipedia list is correct as of today:

http://en.wikipedia.org/wiki/List_of_S&P_500_companies

Just copy the table from the web page and paste into a spreadsheet.

--- In mailto:smf_addin%40yahoogroups.com, "dguillett1" <dguillett1@...> wrote:
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@...
>
> From: rr76012
> Sent: Saturday, March 17, 2012 8:03 AM
> To: mailto:smf_addin%40yahoogroups.com
> Subject: [smf_addin] s&p 500 symbols list
>
>
> Does anyone have a spreadsheet they are willing to share, with the current s&p 500 symbols list?
>
> Happy St. Patricks Day,
>
> Thanks
>

Attachment(s) from dguillett1

1 of 1 File(s)

Symbols_S&P500.xls

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1c.: Re: s&p 500 symbols list

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Mon Mar 19, 2012 7:54 am (PDT)

[Attachment(s) from sudhir agarwal included below]

Attached is the list of S&P and NYSE companies.
It has more details than you may be looking for...
Sudhir

On Sat, Mar 17, 2012 at 9:03 AM, rr76012 <rr76012@yahoo.com> wrote:

> **
>
>
> Does anyone have a spreadsheet they are willing to share, with the current
> s&p 500 symbols list?
>
> Happy St. Patricks Day,
>
> Thanks
>
>
>

Attachment(s) from sudhir agarwal

1 of 1 File(s)

List of NYSE and S&P companies.xlsx

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1d.: Re: s&p 500 symbols list [1 Attachment]

Posted by: "devendra khede" devendrakhede@yahoo.co.in devendrakhede

Mon Mar 19, 2012 11:46 pm (PDT)

hello sudhir sir..

i recieved your precious email...and thanks allot for this...
can you u email me..BSE/NSE list.

thanks
warm regards
devendra khede

--- On Mon, 19/3/12, sudhir agarwal <Agarwal.sudhir@gmail.com> wrote:

From: sudhir agarwal <Agarwal.sudhir@gmail.com>
Subject: Re: [smf_addin] s&p 500 symbols list [1 Attachment]
To: smf_addin@yahoogroups.com
Date: Monday, 19 March, 2012, 8:24 PM

[Attachment(s) from sudhir agarwal included below]

Attached is the list of S&P and NYSE companies.
It has more details than you may be looking for...
Sudhir

On Sat, Mar 17, 2012 at 9:03 AM, rr76012 <rr76012@yahoo.com> wrote:

Does anyone have a spreadsheet they are willing to share, with the current s&p 500 symbols list?

Happy St. Patricks Day,

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

2a.: Re: Microsoft Office

Posted by: "dguillett1" dguillett1@gmail.com donaldb36

Mon Mar 19, 2012 5:05 am (PDT)

Just make sure you get a LEGAL copy
http://www.ebay.com/sch/i.html?_trksid=p5197.m570.l1313&_nkw=excel+2003&_sacat=0

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@gmail.com

From: buccaneerfan55
Sent: Sunday, March 18, 2012 8:22 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Microsoft Office

Do I need to purchase the Microsoft Office to use smf addin? I thought maybe because I'm not "manipulating" the information, I could get by with just the "read only" mode. But, I'm pretty sure I will need to purchase to the package (around $110.00 or so).

I have an older computer (2007) with Excel but have used my "trial" period and not sure what options to consider.

Any thoughts? Thx.
MJS

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3a.: download history prices

Posted by: "Lawrence" lawrence.leesh@gmail.com lawleesh

Mon Mar 19, 2012 8:00 am (PDT)

Hi

I would like to download five years of monthly stock prices. How do I use RCHGetYahooHistory? Do I need to install another addin? I already have RCHGetElementNumber.

thanks

LL

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3b.: Re: download history prices

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 8:15 am (PDT)

You can find the documentation in the "Files" area of the group, in the
"Documentation" folder. The add-in has all of the functions in it.

On Mon, Mar 19, 2012 at 8:00 AM, Lawrence <lawrence.leesh@gmail.com> wrote:

>
> I would like to download five years of monthly stock prices. How do I use
> RCHGetYahooHistory? Do I need to install another addin? I already have
> RCHGetElementNumber.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3c.: Re: download history prices

Posted by: "Lawrence" lawrence.leesh@gmail.com lawleesh

Mon Mar 19, 2012 7:06 pm (PDT)

Thanks Randy. I found the info in that folder.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can find the documentation in the "Files" area of the group, in the
> "Documentation" folder. The add-in has all of the functions in it.
>
> On Mon, Mar 19, 2012 at 8:00 AM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > I would like to download five years of monthly stock prices. How do I use
> > RCHGetYahooHistory? Do I need to install another addin? I already have
> > RCHGetElementNumber.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

4a.: RCHGetHTMLTable or smfGetTagContent help

Posted by: "digsupply" picsound@gmail.com digsupply

Mon Mar 19, 2012 8:49 am (PDT)

I am trying to use one of these functions to extract the "Business Summary" data from http://finance.yahoo.com/q/pr?s=ENTR+Profile.
I have tried to do it following the Syntax but no matter how hard I've tried I have had no success. Can anybody help me?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4b.: Re: RCHGetHTMLTable or smfGetTagContent help

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 8:54 am (PDT)

Do a search of the group's messages. It's been discussed several times in
the past.

On Mon, Mar 19, 2012 at 8:49 AM, digsupply <picsound@gmail.com> wrote:

> I am trying to use one of these functions to extract the "Business
> Summary" data from http://finance.yahoo.com/q/pr?s=ENTR+Profile.
> I have tried to do it following the Syntax but no matter how hard I've
> tried I have had no success. Can anybody help me?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4c.: Re: RCHGetHTMLTable or smfGetTagContent help

Posted by: "digsupply" picsound@gmail.com digsupply

Mon Mar 19, 2012 9:44 am (PDT)

Hi Randy. Thank you for your answer, I have already done that. I've spent several hours following the instructions and examples in the messages. I have successfully been able to extract data from other sources,like Stock Scouter rating Summary from MSN,using smfGetTagContent. I will post that file here, in case someone finds it useful. However I haven't been able to use it to extract data from the Yahoo Profile page, that's why I am asking for help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Do a search of the group's messages. It's been discussed several times in
> the past.
>
> On Mon, Mar 19, 2012 at 8:49 AM, digsupply <picsound@...> wrote:
>
> > I am trying to use one of these functions to extract the "Business
> > Summary" data from http://finance.yahoo.com/q/pr?s=ENTR+Profile.
> > I have tried to do it following the Syntax but no matter how hard I've
> > tried I have had no success. Can anybody help me?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4d.: Re: RCHGetHTMLTable or smfGetTagContent help

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 1:39 pm (PDT)

When I search the archives for "Business Summary", the message immediately
prior to yours in the search has a working solution. See:

http://finance.groups.yahoo.com/group/smf_addin/message/17501

On Mon, Mar 19, 2012 at 9:44 AM, digsupply <picsound@gmail.com> wrote:

>
> Hi Randy. Thank you for your answer, I have already done that. I've spent
> several hours following the instructions and examples in the messages. I
> have successfully been able to extract data from other sources,like Stock
> Scouter rating Summary from MSN,using smfGetTagContent. I will post that
> file here, in case someone finds it useful. However I haven't been able to
> use it to extract data from the Yahoo Profile page, that's why I am asking
> for help.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

5a.: Getting data from other sources Except MSN

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Mon Mar 19, 2012 9:42 am (PDT)

Hi All,
I am trying to get data from different sources but getting only from MSN
and not from any other sources.
I am trying to do the data pull for all 500 s&P companies together.
Is anyone else facing similar issue..
Thanks,
Sudhir

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.: Re: Getting data from other sources Except MSN

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 1:36 pm (PDT)

You may have to adjust your Internet Options to get AdvFN data -- see the
item in the "Links" area of the group.

Also, the add-in has a built in limit of retrieving 1000 web pages per
session. It's not intended for building databases.

On Mon, Mar 19, 2012 at 9:41 AM, sudhir agarwal <Agarwal.sudhir@gmail.com>wrote:

> I am trying to get data from different sources but getting only from MSN
> and not from any other sources.
> I am trying to do the data pull for all 500 s&P companies together.
> Is anyone else facing similar issue..
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

6.1.: New file uploaded to smf_addin

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Mon Mar 19, 2012 9:48 am (PDT)

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /SCOUTER.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : StockScouter RATING SUMMARY from MSN

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/SCOUTER.xlsm

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

digsupply <picsound@gmail.com>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (247)
6.2.: Re: New file uploaded to smf_addin

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Mon Mar 19, 2012 3:24 pm (PDT)

I see it has a macro involved. What does the macro do that the add-in can't
do?

Kermit

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, March 19, 2012 12:48 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New file uploaded to smf_addin

Hello,

This email message is a notification to let you know that a file has been
uploaded to the Files area of the smf_addin group.

File : /SCOUTER.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : StockScouter RATING SUMMARY from MSN

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/SCOUTER.xlsm

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

digsupply <picsound@gmail.com>

------------------------------------

Yahoo! Groups Links

.
that file here, in case someone finds it useful. However I haven't been able
to use it to extract data from the Yahoo Profile page, that's why I am
asking for help.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (247)

7.: Cash conversion cycle

Posted by: "d_j_ricks" d_j_ricks@yahoo.com d_j_ricks

Mon Mar 19, 2012 1:34 pm (PDT)

Has anyone here developed a spread sheet to follow a company's cash conversion cycle?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

8a.: quote Technical Analysis yahoo

Posted by: "choni" Choni59@gmail.com simhonik

Tue Mar 20, 2012 12:47 am (PDT)

Hi

Is there a way to quote Technical Analysis such as RSI ect.

Tnx

C

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
8b.: Re: quote Technical Analysis yahoo

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Mar 20, 2012 12:51 am (PDT)

There are several technical analysis templates that may have what you need.

Otherwise, you could always get something like TA-Lib (see "Links" area of
group for more info) and generate your own.

On Tue, Mar 20, 2012 at 12:43 AM, choni <Choni59@gmail.com> wrote:

>
> Is there a way to quote Technical Analysis such as RSI ect.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Selasa, 20 Maret 2012

Messages In This Digest (19 Messages)

Messages

Posted by: "mshuffma97" mshuffma97@gmail.com mshuffma97

Mon Mar 19, 2012 4:13 am (PDT)

Posted by: "dguillett1" dguillett1@gmail.com donaldb36

Mon Mar 19, 2012 5:30 am (PDT)

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Mon Mar 19, 2012 7:54 am (PDT)

Posted by: "devendra khede" devendrakhede@yahoo.co.in devendrakhede

Mon Mar 19, 2012 11:46 pm (PDT)

Posted by: "dguillett1" dguillett1@gmail.com donaldb36

Mon Mar 19, 2012 5:05 am (PDT)

Posted by: "Lawrence" lawrence.leesh@gmail.com lawleesh

Mon Mar 19, 2012 8:00 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 8:15 am (PDT)

Posted by: "Lawrence" lawrence.leesh@gmail.com lawleesh

Mon Mar 19, 2012 7:06 pm (PDT)

Posted by: "digsupply" picsound@gmail.com digsupply

Mon Mar 19, 2012 8:49 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 8:54 am (PDT)

Posted by: "digsupply" picsound@gmail.com digsupply

Mon Mar 19, 2012 9:44 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 1:39 pm (PDT)

Posted by: "sudhir agarwal" Agarwal.sudhir@gmail.com sudhir_agarwal1

Mon Mar 19, 2012 9:42 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon Mar 19, 2012 1:36 pm (PDT)

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Mon Mar 19, 2012 9:48 am (PDT)

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com kermitpra

Mon Mar 19, 2012 3:24 pm (PDT)

Posted by: "d_j_ricks" d_j_ricks@yahoo.com d_j_ricks

Mon Mar 19, 2012 1:34 pm (PDT)

Posted by: "choni" Choni59@gmail.com simhonik

Tue Mar 20, 2012 12:47 am (PDT)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Tue Mar 20, 2012 12:51 am (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me