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/Documentat ion/
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_ ",LEFT(C4&"info/fund/ excel_holdings. htm?ticker= IVV
",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_fundament als.asp?document Type=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. - cash flow blogcom
http://www.alreadytoharvest. - historical novelcom
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?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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
Tidak ada komentar:
Posting Komentar