Jumat, 15 Juli 2011

[smf_addin] Digest Number 1887[2 Attachments]

Messages In This Digest (24 Messages)

1a.
Can I download financial data that are listed in Pakistan From: Amir
1b.
Re: Can I download financial data that are listed in Pakistan From: Randy Harmelink
1c.
Re: Can I download financial data that are listed in Pakistan From: Amir Rehman
2a.
Daily Quotes From: lexstar
2b.
Re: Daily Quotes From: Randy Harmelink
3a.
Want to add "One Year Price Target" to my worksheet. From: David
3b.
Re: Want to add "One Year Price Target" to my worksheet. From: Randy Harmelink
3c.
Re: Want to add "One Year Price Target" to my worksheet. From: investor952
3d.
Re: Want to add "One Year Price Target" to my worksheet. From: David Nicholas
3e.
Re: Want to add "One Year Price Target" to my worksheet. From: Randy Harmelink
3f.
Re: Want to add "One Year Price Target" to my worksheet. From: David Nicholas
4a.
Need to pull the total return from a specified date range to another From: Bernie
4b.
Re: Need to pull the total return from a specified date range to ano From: Randy Harmelink
4c.
Re: Need to pull the total return from a specified date range to ano From: Bernie
4d.
Re: Need to pull the total return from a specified date range to ano From: Martin Topper
4e.
Re: Need to pull the total return from a specified date range to ano From: Randy Harmelink
5a.
historic quarterly info and S&P 500 index From: steven_rourk
5b.
Re: historic quarterly info and S&P 500 index From: Kermit W. Prather
5c.
Re: historic quarterly info and S&P 500 index From: Sam Sawyer
5d.
Re: historic quarterly info and S&P 500 index From: Randy Harmelink
6a.
is smf-addin down? From: Christopher
6b.
Re: is smf-addin down? From: Randy Harmelink
7a.
smfGetOptionQuotes give wrong numbers for ADBE From: Glen Fullmer
7b.
Re: smfGetOptionQuotes give wrong numbers for ADBE [2 Attachments] From: Randy Harmelink

Messages

1a.

Can I download financial data that are listed in Pakistan

Posted by: "Amir" amir.rehman@yahoo.com   amir.rehman

Thu Jul 14, 2011 5:37 am (PDT)



Hello,

I want to know that can I download financial data that are listed in Pakistan?

For example; I want to download the data for;
1: Fauji Fertilizer Company Limited
2: Fauji Cement Company Limited

Thanks,
Amir

1b.

Re: Can I download financial data that are listed in Pakistan

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

Thu Jul 14, 2011 8:23 am (PDT)



It would all depend on the available data source -- how they present the
data.

On Thu, Jul 14, 2011 at 5:37 AM, Amir <amir.rehman@yahoo.com> wrote:

>
> I want to know that can I download financial data that are listed in
> Pakistan?
>
> For example; I want to download the data for;
> 1: Fauji Fertilizer Company Limited
> 2: Fauji Cement Company Limited
>
1c.

Re: Can I download financial data that are listed in Pakistan

Posted by: "Amir Rehman" amir.rehman@yahoo.com   amir.rehman

Thu Jul 14, 2011 8:25 am (PDT)



Thanks for your response. Can you explain me little bit. I am trying to download data from kse.com.pk
 
Kind Regards
Amir Rehman

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, July 14, 2011 8:23 PM
Subject: Re: [smf_addin] Can I download financial data that are listed in Pakistan

 
It would all depend on the available data source -- how they present the data.

On Thu, Jul 14, 2011 at 5:37 AM, Amir <amir.rehman@yahoo.com> wrote:

>I want to know that can I download financial data that are listed in Pakistan?
>
>For example; I want to download the data for;
>  1: Fauji Fertilizer Company Limited
>  2: Fauji Cement Company Limited
>

2a.

Daily Quotes

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

Thu Jul 14, 2011 6:56 am (PDT)



If I just want to find the OPEN and CLOSE of a particular day in the past, what's the best function to use? I think there's a function that can retrieve the OPEN (such as the OPEN for a stock/etf for say June 1, 2005), but dont' seem to remember what it is. I got the CLose.

Anyone help?

2b.

Re: Daily Quotes

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

Thu Jul 14, 2011 8:22 am (PDT)



Use the RCHGetYahooHistory() function.

On Thu, Jul 14, 2011 at 6:55 AM, lexstar <lexstar@yahoo.com> wrote:

> If I just want to find the OPEN and CLOSE of a particular day in the past,
> what's the best function to use? I think there's a function that can
> retrieve the OPEN (such as the OPEN for a stock/etf for say June 1, 2005),
> but dont' seem to remember what it is. I got the CLose.
>
> Anyone help?
>
3a.

Want to add "One Year Price Target" to my worksheet.

Posted by: "David" dnicholas6@comcast.net   dnicholas4967

Thu Jul 14, 2011 9:10 am (PDT)



What is the source for extracting a stock's "One Year Price Target"?
Thanks, David

3b.

Re: Want to add "One Year Price Target" to my worksheet.

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

Thu Jul 14, 2011 9:12 am (PDT)



You can find the source of a defined element with:

=RCHGetElementNumber("Source",1)

Check the documentation for other informational tags.

On Thu, Jul 14, 2011 at 9:10 AM, David <dnicholas6@comcast.net> wrote:

> What is the source for extracting a stock's "One Year Price Target"?
>
3c.

Re: Want to add "One Year Price Target" to my worksheet.

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

Thu Jul 14, 2011 1:07 pm (PDT)



=RCHGetYahooQuotes($B16,"t8")

Where $b16 is the cell where the stock ticker symbol is

the above should get you Yahoo's 1 yr price target
it is what i use

--- In smf_addin@yahoogroups.com, "David" <dnicholas6@...> wrote:
>
> What is the source for extracting a stock's "One Year Price Target"?
> Thanks, David
>

3d.

Re: Want to add "One Year Price Target" to my worksheet.

Posted by: "David Nicholas" dnicholas6@comcast.net   dnicholas4967

Thu Jul 14, 2011 2:14 pm (PDT)



Hi, that didn't work for me.

From: investor952
Sent: Thursday, July 14, 2011 3:06 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Want to add "One Year Price Target" to my worksheet.

=RCHGetYahooQuotes($B16,"t8")

Where $b16 is the cell where the stock ticker symbol is

the above should get you Yahoo's 1 yr price target
it is what i use

--- In mailto:smf_addin%40yahoogroups.com, "David" <dnicholas6@...> wrote:
>
> What is the source for extracting a stock's "One Year Price Target"?
> Thanks, David
>

3e.

Re: Want to add "One Year Price Target" to my worksheet.

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

Thu Jul 14, 2011 2:23 pm (PDT)



"Didn't work" isn't likely to get the problem resolved. Your problem could
be as simple as Yahoo not having a 1-year price target for the ticker symbol
you used.

On Thu, Jul 14, 2011 at 2:13 PM, David Nicholas <dnicholas6@comcast.net>wrote:

>
> Hi, that didn't work for me.
>
> *From:* investor952 <investor952@yahoo.com>
> *Sent:* Thursday, July 14, 2011 3:06 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] Re: Want to add "One Year Price Target" to my
> worksheet.
>
>
> =RCHGetYahooQuotes($B16,"t8")
>
> Where $b16 is the cell where the stock ticker symbol is
>
> the above should get you Yahoo's 1 yr price target
> it is what i use
>
3f.

Re: Want to add "One Year Price Target" to my worksheet.

Posted by: "David Nicholas" dnicholas6@comcast.net   dnicholas4967

Thu Jul 14, 2011 2:45 pm (PDT)



Thanks, I'll try a few other more prominent names. David

From: Randy Harmelink
Sent: Thursday, July 14, 2011 4:23 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: Want to add "One Year Price Target" to my worksheet.

"Didn't work" isn't likely to get the problem resolved. Your problem could be as simple as Yahoo not having a 1-year price target for the ticker symbol you used.

On Thu, Jul 14, 2011 at 2:13 PM, David Nicholas <dnicholas6@comcast.net> wrote:

Hi, that didn't work for me.

From: investor952
Sent: Thursday, July 14, 2011 3:06 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Want to add "One Year Price Target" to my worksheet.

=RCHGetYahooQuotes($B16,"t8")

Where $b16 is the cell where the stock ticker symbol is

the above should get you Yahoo's 1 yr price target
it is what i use

4a.

Need to pull the total return from a specified date range to another

Posted by: "Bernie" bernie.sandford@gmail.com   diamondtrap

Thu Jul 14, 2011 11:12 am (PDT)



Have been using RCHGetYahooQuotes Template which is great but need to add new column for "Total Return 10/12/07 to 3/6/09.

Need to list historical quotes for 37 stocks, calculate the total return on those stocks for 10/12/07 thru 3/6/09, and pull that return # into the other sheet.

Also, how do I add "Beta" to the drop down menu?

Can anyone help with this please?

Thank you.

B

4b.

Re: Need to pull the total return from a specified date range to ano

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

Thu Jul 14, 2011 11:18 am (PDT)



You can use the smfPricesByDates() function to retrieve the adjusted prices
for the two dates and compute the total return.

Beta cannot be added to the drop-down menu -- it's not a field offered by
Yahoo on their CSV file. You could use one of the other add-in functions to
retrieve beta, but it will be slower as you'd need to retrieve a web page
for each ticker symbol. However, you'd also have to decide on what
definition of beta you want to use. Different data sources display beta, but
they can be for different periods.

On Thu, Jul 14, 2011 at 10:55 AM, Bernie <bernie.sandford@gmail.com> wrote:

> Have been using RCHGetYahooQuotes Template which is great but need to add
> new column for "Total Return 10/12/07 to 3/6/09.
>
> Need to list historical quotes for 37 stocks, calculate the total return on
> those stocks for 10/12/07 thru 3/6/09, and pull that return # into the other
> sheet.
>
> Also, how do I add "Beta" to the drop down menu?
>
> Can anyone help with this please?
>
4c.

Re: Need to pull the total return from a specified date range to ano

Posted by: "Bernie" bernie.sandford@gmail.com   diamondtrap

Thu Jul 14, 2011 1:20 pm (PDT)



Hi Randy-Thanks for the prompt response. Can you break it down a little more basic for me as to how to use the smfPricesByDates() function?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can use the smfPricesByDates() function to retrieve the adjusted prices
> for the two dates and compute the total return.
>
> Beta cannot be added to the drop-down menu -- it's not a field offered by
> Yahoo on their CSV file. You could use one of the other add-in functions to
> retrieve beta, but it will be slower as you'd need to retrieve a web page
> for each ticker symbol. However, you'd also have to decide on what
> definition of beta you want to use. Different data sources display beta, but
> they can be for different periods.
>
> On Thu, Jul 14, 2011 at 10:55 AM, Bernie <bernie.sandford@...> wrote:
>
> > Have been using RCHGetYahooQuotes Template which is great but need to add
> > new column for "Total Return 10/12/07 to 3/6/09.
> >
> > Need to list historical quotes for 37 stocks, calculate the total return on
> > those stocks for 10/12/07 thru 3/6/09, and pull that return # into the other
> > sheet.
> >
> > Also, how do I add "Beta" to the drop down menu?
> >
> > Can anyone help with this please?
> >
>

4d.

Re: Need to pull the total return from a specified date range to ano

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Thu Jul 14, 2011 1:28 pm (PDT)



see the following link. Folder 4.2 explains the syntax used in SMFPricesByDates

http://finance.groups.yahoo.com/group/smf_addin/files/Documentation/

Marty

________________________________
From: Bernie <bernie.sandford@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thu, July 14, 2011 4:14:58 PM
Subject: [smf_addin] Re: Need to pull the total return from a specified date
range to another sheet

Hi Randy-Thanks for the prompt response. Can you break it down a little more
basic for me as to how to use the smfPricesByDates() function?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can use the smfPricesByDates() function to retrieve the adjusted prices
> for the two dates and compute the total return.
>
> Beta cannot be added to the drop-down menu -- it's not a field offered by
> Yahoo on their CSV file. You could use one of the other add-in functions to
> retrieve beta, but it will be slower as you'd need to retrieve a web page
> for each ticker symbol. However, you'd also have to decide on what
> definition of beta you want to use. Different data sources display beta, but
> they can be for different periods.
>
> On Thu, Jul 14, 2011 at 10:55 AM, Bernie <bernie.sandford@...> wrote:
>
> > Have been using RCHGetYahooQuotes Template which is great but need to add
> > new column for "Total Return 10/12/07 to 3/6/09.
> >
> > Need to list historical quotes for 37 stocks, calculate the total return on
> > those stocks for 10/12/07 thru 3/6/09, and pull that return # into the other
> > sheet.
> >
> > Also, how do I add "Beta" to the drop down menu?
> >
> > Can anyone help with this please?
> >
>

4e.

Re: Need to pull the total return from a specified date range to ano

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

Thu Jul 14, 2011 2:20 pm (PDT)



Where are you running into problems with the documentation of the function?

On Thu, Jul 14, 2011 at 1:14 PM, Bernie <bernie.sandford@gmail.com> wrote:

> Hi Randy-Thanks for the prompt response. Can you break it down a little
> more basic for me as to how to use the smfPricesByDates() function?
>
5a.

historic quarterly info and S&P 500 index

Posted by: "steven_rourk" steven_rourk@hotmail.com   steven_rourk

Thu Jul 14, 2011 4:58 pm (PDT)



Does anyone know of a site besides ADFN that has at least 8 historic quarterly financial info?

And does anyone know of a site that lists the companies included in the S&P500 without having to register in the S&P web site?. Specifically I would want to put a ticker symbol in a worksheet so that it returns if it is part of S&P or not. Yahoo used to have this info in the profile of each company quoted but now they say they dont have access....that you have to register with S&P.... they still have it for the Dow Jones index, but not for the S&P500 index.

5b.

Re: historic quarterly info and S&P 500 index

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

Thu Jul 14, 2011 6:37 pm (PDT)



You can go to www.freestockcharts.com and open the SP-500 watchlist.


-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of steven_rourk
Sent: Thursday, July 14, 2011 7:57 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] historic quarterly info and S&P 500 index

Does anyone know of a site besides ADFN that has at least 8 historic
quarterly financial info?

And does anyone know of a site that lists the companies included in the
S&P500 without having to register in the S&P web site?. Specifically I would
want to put a ticker symbol in a worksheet so that it returns if it is part
of S&P or not. Yahoo used to have this info in the profile of each company
quoted but now they say they dont have access....that you have to register
with S&P.... they still have it for the Dow Jones index, but not for the
S&P500 index.



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

Yahoo! Groups Links



5c.

Re: historic quarterly info and S&P 500 index

Posted by: "Sam Sawyer" sam_sawyer@yahoo.com   sam_sawyer

Thu Jul 14, 2011 7:31 pm (PDT)



Steven, it looks like Finviz.com has that information.  I tried a few stock symbols and they do show which index a stock is a member of.  See the screen shot below for Altria. See the second row from the bottom of the screen shot below.

It's a free site and the information and technical charts are pretty good.

Sam

 

________________________________
From: steven_rourk <steven_rourk@hotmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, July 14, 2011 4:57 PM
Subject: [smf_addin] historic quarterly info and S&P 500 index

 
Does anyone know of a site besides ADFN that has at least 8 historic quarterly financial info?

And does anyone know of a site that lists the companies included in the S&P500 without having to register in the S&P web site?. Specifically I would want to put a ticker symbol in a worksheet so that it returns if it is part of S&P or not. Yahoo used to have this info in the profile of each company quoted but now they say they dont have access....that you have to register with S&P.... they still have it for the Dow Jones index, but not for the S&P500 index.

5d.

Re: historic quarterly info and S&P 500 index

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

Thu Jul 14, 2011 7:34 pm (PDT)



You can get the S&P 500 list from one of the ETF index fund websites -- for
example:

=smfGetCSVFile("
http://us.ishares.com/product_info/fund/excel_holdings.htm?ticker=IVV")

I think this would tell you whether a ticker symbol is in the index fund or
not:

=IF(RCHGetWebData("
http://us.ishares.com/product_info/fund/excel_holdings.htm?ticker=IVV",LEFT(C4&"
",10)&",",5)="Error","Not in Index","In Index")

The NASDAQ website has more quarters than most (see
http://finance.groups.yahoo.com/group/smf_addin/message/8315):

http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=2&Duration=1&NumPeriods=12&selected=AAPL

However, I've had spotty results retrieving data from that web page.
Sometimes it works. Sometimes it freezes EXCEL. Not sure why.

On Thu, Jul 14, 2011 at 4:57 PM, steven_rourk <steven_rourk@hotmail.com>wrote:

> Does anyone know of a site besides ADFN that has at least 8 historic
> quarterly financial info?
>
> And does anyone know of a site that lists the companies included in the
> S&P500 without having to register in the S&P web site?. Specifically I would
> want to put a ticker symbol in a worksheet so that it returns if it is part
> of S&P or not. Yahoo used to have this info in the profile of each company
> quoted but now they say they dont have access....that you have to register
> with S&P.... they still have it for the Dow Jones index, but not for the
> S&P500 index.
>
6a.

is smf-addin down?

Posted by: "Christopher" clucas42@hotmail.com   christopher.lucas

Thu Jul 14, 2011 8:17 pm (PDT)



Just ran it and it doesnt seem to pull the data. All blanks. It was working before until late this evening.

6b.

Re: is smf-addin down?

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

Thu Jul 14, 2011 8:21 pm (PDT)



The add-in doesn't "go down" -- what functions are you using?

On Thu, Jul 14, 2011 at 8:10 PM, Christopher <clucas42@hotmail.com> wrote:

> Just ran it and it doesnt seem to pull the data. All blanks. It was working
> before until late this evening.
>
7a.

smfGetOptionQuotes give wrong numbers for ADBE

Posted by: "Glen Fullmer" gfullmer@cox.net   gfullmer

Thu Jul 14, 2011 8:46 pm (PDT)

[Attachment(s) from Glen Fullmer included below]

Hi Randy,

Long time no talk, not because I haven't been using your great program
but because it works pretty flawless, however, here seems to be an
exception, but it might be a user error:

The formula has the form:

=smfGetOptionQuotes("ADBE JAN 2012 $35 PUT","b",0,"Y") returning 5.35

Which is wrong. Here are the results on a test spreadsheet.

ADBE Test for January 2012 PUT
Yahoo MSN OX2
Bid Ask Bid Ask Bid Ask
34 4.65 4.75 5.55 5.65 5.55 5.65
35 5.35 5.45 6.35 6.45 6.35 6.45
Version Stock Market Functions add-in, Version 2.1.2010.08.02

It appears that Yahoo is returning numbers that are not correct, yet
they are correct on the Yahoo web page. I have enclosed the spreadsheet
and the Yahoo screenshot of the ADBE options.

Any ideas, besides using a provider besides Yahoo?

Thanks again for a great product,
Glen
PS posted this, or something like it this morning directly on the web
site (post function and it never got posted and I didn't include any
enclosures.
--
Glen Fullmer, gfullmer@cox.net, http://members.cox.net/gfullmer
---
http://personalcashflow.blogspot.com - cash flow blog
http://www.alreadytoharvest.com - historical novel
http://www.youtube.com/gfullmer - fractal Movies
"True love doesn't want anything" - Eckhardt Tolle
"Charity doesn't think about itself" - St. Paul
"all things whatsoever ye would that men
should do to you, do ye even so to them" - Jesus
---

Attachment(s) from Glen Fullmer

1 of 1 Photo(s)

1 of 1 File(s)

7b.

Re: smfGetOptionQuotes give wrong numbers for ADBE [2 Attachments]

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

Thu Jul 14, 2011 10:25 pm (PDT)



Probably one of two issues:

1. The add-in is extracting the data from a web page it had saved from
earlier. To resolve this, run the smfForceRecalculation macro (see the
"Links" area of the group for info).

2. The add-in is picking up an old page from IE's cache. To resolve, see:

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

On Thu, Jul 14, 2011 at 8:46 PM, Glen Fullmer <gfullmer@cox.net> wrote:

>
> Long time no talk, not because I haven't been using your great program
> but because it works pretty flawless, however, here seems to be an
> exception, but it might be a user error:
>
> The formula has the form:
>
> =smfGetOptionQuotes("ADBE JAN 2012 $35 PUT","b",0,"Y") returning 5.35
>
> Which is wrong. Here are the results on a test spreadsheet.
>
> ADBE Test for January 2012 PUT
> Yahoo MSN OX2
> Bid Ask Bid Ask Bid Ask
> 34 4.65 4.75 5.55 5.65 5.55 5.65
> 35 5.35 5.45 6.35 6.45 6.35 6.45
> Version Stock Market Functions add-in, Version 2.1.2010.08.02
>
> It appears that Yahoo is returning numbers that are not correct, yet
> they are correct on the Yahoo web page. I have enclosed the spreadsheet
> and the Yahoo screenshot of the ADBE options.
>
> Any ideas, besides using a provider besides Yahoo?
>
Recent Activity
Visit Your Group
Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Tidak ada komentar:

Posting Komentar