Messages In This Digest (25 Messages)
- 1a.
- Retrieve Industry for each stock in S&P500 From: tanya_1bg
- 1b.
- Re: Retrieve Industry for each stock in S&P500 From: paul messerschmidt
- 1c.
- Re: Retrieve Industry for each stock in S&P500 From: Luano César
- 1d.
- Re: Retrieve Industry for each stock in S&P500 From: Randy Harmelink
- 1e.
- Re: Retrieve Industry for each stock in S&P500 From: Randy Harmelink
- 2a.
- Retrieveing Bond Fund Data From: addison.ingle
- 2b.
- Re: Retrieveing Bond Fund Data From: Randy Harmelink
- 2c.
- Re: Retrieveing Bond Fund Data From: addison.ingle
- 2d.
- Re: Retrieveing Bond Fund Data From: Randy Harmelink
- 2e.
- Re: Retrieveing Bond Fund Data From: addison.ingle
- 2f.
- Re: Retrieveing Bond Fund Data From: Randy Harmelink
- 3a.
- smfPricesByDates() From: lexstar
- 3b.
- Re: smfPricesByDates() From: lexstar
- 3c.
- Re: smfPricesByDates() From: Randy Harmelink
- 4a.
- Automate data retrieval from a public website? From: dwightpearson
- 4b.
- Re: Automate data retrieval from a public website? From: dguillett1
- 4c.
- Re: Automate data retrieval from a public website? From: Dwight Pearson
- 4d.
- Re: Automate data retrieval from a public website? From: Randy Harmelink
- 4e.
- Automate data retrieval from a public website? From: PY & Associates
- 5a.
- 10k and 10q data extract From: kevin martin
- 5b.
- Re: 10k and 10q data extract From: Randy Harmelink
- 6a.
- Re: Historical prices won't pull in for specific SP5 telecom ETF From: naderphilip
- 6b.
- Re: Historical prices won't pull in for specific SP5 telecom ETF From: Randy Harmelink
- 7a.
- S&P 500 Total Return History? From: naderphilip
- 7b.
- Re: S&P 500 Total Return History? From: Randy Harmelink
Messages
- 1a.
-
Retrieve Industry for each stock in S&P500
Posted by: "tanya_1bg" tanya_1bg@yahoo.com tanya_1bg
Fri Feb 24, 2012 6:54 am (PST)
Hi all,
I am looking to analyze stocks by industry. Is there a way to look up the "Industry" for each ticker? I tried using RCHGetElementNumber(B7,4)and RCHGetElementNumber (B7,877) but neither worked.
Many thanks in advance!
Tatyana
- 1b.
-
Re: Retrieve Industry for each stock in S&P500
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Fri Feb 24, 2012 8:48 am (PST)
how granular do you want to get in your analysis?
s&p has already divided the 500 stocks into nine groups (e.g., energy,
finance, utilities, etc.), each represented by its own etf (e.g., XLE, XLF,
XLU, respectively)
you can get more granular if you use 'sic codes' either 2-digit, or finer
resolution using 4-digit codes
examples here
http://www.barchart.com/stocks/ sectors/sic/
<http://www.barchart.com/stocks/ >sectors/sic/
http://www.barchart.com/stocks/ sectors/- 491B
<http://www.barchart.com/stocks/ >just to make it moresectors/- 491B
confusing, dow jones has its own taxonomy.
Dow Jones Indexes which classifies securities at four levels of
specificity: 10 broad Industries, 19 Supersectors, 41 Sectors, and at the
most granular level, 114 Subsectors.
http://www.djindexes.com/sectors/
and then you have the question of where some large companies belong. GE -
industrial or finance?; IBM - technology or service?
you can even subdivide categories like reits into warehouse, multifamily,
mortgage, commercial, etc., etc., etc.
let the group know what you find
know what you trade; trade what you know...
On Fri, Feb 24, 2012 at 9:54 AM, tanya_1bg <tanya_1bg@yahoo.com > wrote:
> **
>
>
> Hi all,
>
> I am looking to analyze stocks by industry. Is there a way to look up the
> "Industry" for each ticker? I tried using RCHGetElementNumber(B7,4)and
> RCHGetElementNumber(B7,877) but neither worked.
>
> Many thanks in advance!
>
> Tatyana
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 1c.
-
Re: Retrieve Industry for each stock in S&P500
Posted by: "Luano César" luanocesar@gmail.com luanocesar
Fri Feb 24, 2012 9:23 am (PST)
Hello everybody..
I'm new here. I would like help in how to setup Excel to receive BOVESPA
ticket informations.
BOVESPA is São Paulo - Brazil Stock.
Best Regards.
--
Luano César
- 1d.
-
Re: Retrieve Industry for each stock in S&P500
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 9:32 am (PST)
As I note on the front page of the group, "It doesn't work" gives me no
room to help. What tickers did you use? What results did you get?
I just tried both of the element numbers for ticker MMM and they worked
fine, returning "Conglomerates" and "Diversified Industrials".
In any case, what I would suggest is using FinViz to grab the data. You can
use their screener to get all the data in one Internet access, instead of
doing it ticker by ticker. See the "Links" area of the group for
information on it. But, as an example:
=smfGetCSVFIle("
http://finviz.com/export. ")ashx?v=152& f=idx_sp500& c=0,1,2,3, 4,6,24,25, 65,68
On Fri, Feb 24, 2012 at 7:54 AM, tanya_1bg <tanya_1bg@yahoo.com > wrote:
>
> I am looking to analyze stocks by industry. Is there a way to look up the
> "Industry" for each ticker? I tried using RCHGetElementNumber(B7,4)and
> RCHGetElementNumber(B7,877) but neither worked.
>
- 1e.
-
Re: Retrieve Industry for each stock in S&P500
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 9:35 am (PST)
I don't see such a company on Yahoo...
On Fri, Feb 24, 2012 at 7:58 AM, Luano César <luanocesar@gmail.com > wrote:
>
> I'm new here. I would like help in how to setup Excel to receive BOVESPA
> ticket informations.
>
> BOVESPA is São Paulo - Brazil Stock.
>
>
- 2a.
-
Retrieveing Bond Fund Data
Posted by: "addison.ingle" addison.ingle@gmail.com addison.ingle
Fri Feb 24, 2012 7:18 am (PST)
Randy,
I have read #4224 and #6643, as well as the documentation for RCHGetTableCell() function. But, using your comments in #6643 about how to extract Yield, Avg Eff Duration, Eff Maturity, and Avg credit quality, I simply get "error".
This is my formula for retrieving "Yield", as pulled from the message board:
=RCHGetTableCell("http://quicktake. morningstar. "&$A4,1,"Yield"com/FundNet/ Snapshot. aspx?Symbol= ,,,,1,"</ table")
Any suggestions?
Thanks.....
- 2b.
-
Re: Retrieveing Bond Fund Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 9:25 am (PST)
Example ticker symbol please -- I do nothing with bonds...
On Fri, Feb 24, 2012 at 8:18 AM, addison.ingle <addison.ingle@gmail.com >wrote:
> Randy,
>
> I have read #4224 and #6643, as well as the documentation for
> RCHGetTableCell() function. But, using your comments in #6643 about how to
> extract Yield, Avg Eff Duration, Eff Maturity, and Avg credit quality, I
> simply get "error".
>
> This is my formula for retrieving "Yield", as pulled from the message
> board:
>
> =RCHGetTableCell("
> http://quicktake.morningstar. com/FundNet/ Snapshot. aspx?Symbol=
> "&$A4,1,"Yield",,,,1,"</ table")
>
> Any suggestions?
>
- 2c.
-
Re: Retrieveing Bond Fund Data
Posted by: "addison.ingle" addison.ingle@gmail.com addison.ingle
Fri Feb 24, 2012 9:32 am (PST)
You bet...
=RCHGetTableCell("http://quicktake. morningstar. ",1,"Yield",com/FundNet/ Snapshot. aspx?Symbol= HABDX ,,,1,"</table" )
HABDX is the ticker for Harbor Bond Instl.....
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Example ticker symbol please -- I do nothing with bonds...
>
> On Fri, Feb 24, 2012 at 8:18 AM, addison.ingle <addison.ingle@...>wrote:
>
> > Randy,
> >
> > I have read #4224 and #6643, as well as the documentation for
> > RCHGetTableCell() function. But, using your comments in #6643 about how to
> > extract Yield, Avg Eff Duration, Eff Maturity, and Avg credit quality, I
> > simply get "error".
> >
> > This is my formula for retrieving "Yield", as pulled from the message
> > board:
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar. com/FundNet/ Snapshot. aspx?Symbol=
> > "&$A4,1,"Yield",,,,1,"</ table")
> >
> > Any suggestions?
> >
>
- 2d.
-
Re: Retrieveing Bond Fund Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 9:41 am (PST)
The problem is that the URL you are using is a web page with dynamically
generated data, so there is nothing within the source code of the web page
for the add-in to extract.
However, they do have a "print report" web page that the data can be pulled
from:
=RCHGetTableCell("
http://quicktake.morningstar. com/fundnet/ printreport. aspx?symbol= HABDX
",1,">Yield")
=RCHGetTableCell("
http://quicktake.morningstar. ",1,">Averagecom/fundnet/ printreport. aspx?symbol= HABDX
Eff Duration")
=RCHGetTableCell("
http://quicktake.morningstar. ",1,">Averagecom/fundnet/ printreport. aspx?symbol= HABDX
Eff Maturity")
=RCHGetTableCell("
http://quicktake.morningstar. ",1,">Averagecom/fundnet/ printreport. aspx?symbol= HABDX
Credit Quality")
On Fri, Feb 24, 2012 at 10:32 AM, addison.ingle <addison.ingle@gmail.com >wrote:
> You bet...
>
> =RCHGetTableCell("
> http://quicktake.morningstar. com/FundNet/ Snapshot. aspx?Symbol= HABDX
> ",1,"Yield",,,,1,"</table" )
>
> HABDX is the ticker for Harbor Bond Instl.....
>
> > > I have read #4224 and #6643, as well as the documentation for
> > > RCHGetTableCell() function. But, using your comments in #6643 about
> how to
> > > extract Yield, Avg Eff Duration, Eff Maturity, and Avg credit quality,
> I
> > > simply get "error".
> > >
> > > This is my formula for retrieving "Yield", as pulled from the message
> > > board:
> > >
> > > =RCHGetTableCell("
> > > http://quicktake.morningstar. com/FundNet/ Snapshot. aspx?Symbol=
> > > "&$A4,1,"Yield",,,,1,"</ table")
> > >
> > > Any suggestions?
>
- 2e.
-
Re: Retrieveing Bond Fund Data
Posted by: "addison.ingle" addison.ingle@gmail.com addison.ingle
Fri Feb 24, 2012 9:50 am (PST)
Please, where do I send the donation? This is fantastic!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that the URL you are using is a web page with dynamically
> generated data, so there is nothing within the source code of the web page
> for the add-in to extract.
>
> However, they do have a "print report" web page that the data can be pulled
> from:
>
> =RCHGetTableCell("
> http://quicktake.morningstar. com/fundnet/ printreport. aspx?symbol= HABDX
> ",1,">Yield")
> =RCHGetTableCell("
> http://quicktake.morningstar. ",1,">Averagecom/fundnet/ printreport. aspx?symbol= HABDX
> Eff Duration")
> =RCHGetTableCell("
> http://quicktake.morningstar. ",1,">Averagecom/fundnet/ printreport. aspx?symbol= HABDX
> Eff Maturity")
> =RCHGetTableCell("
> http://quicktake.morningstar. ",1,">Averagecom/fundnet/ printreport. aspx?symbol= HABDX
> Credit Quality")
>
> On Fri, Feb 24, 2012 at 10:32 AM, addison.ingle <addison.ingle@...>wrote:
>
> > You bet...
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar. com/FundNet/ Snapshot. aspx?Symbol= HABDX
> > ",1,"Yield",,,,1,"</table" )
> >
> > HABDX is the ticker for Harbor Bond Instl.....
> >
> > > > I have read #4224 and #6643, as well as the documentation for
> > > > RCHGetTableCell() function. But, using your comments in #6643 about
> > how to
> > > > extract Yield, Avg Eff Duration, Eff Maturity, and Avg credit quality,
> > I
> > > > simply get "error".
> > > >
> > > > This is my formula for retrieving "Yield", as pulled from the message
> > > > board:
> > > >
> > > > =RCHGetTableCell("
> > > > http://quicktake.morningstar. com/FundNet/ Snapshot. aspx?Symbol=
> > > > "&$A4,1,"Yield",,,,1,"</ table")
> > > >
> > > > Any suggestions?
> >
>
- 2f.
-
Re: Retrieveing Bond Fund Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 10:02 am (PST)
Consider "Paying it forward" by donating to a worthy charity? Share the
wealth. :)
On Fri, Feb 24, 2012 at 10:50 AM, addison.ingle <addison.ingle@gmail.com >wrote:
> Please, where do I send the donation? This is fantastic!
>
- 3a.
-
smfPricesByDates()
Posted by: "lexstar" lexstar@yahoo.com lexstar
Fri Feb 24, 2012 11:56 am (PST)
So 2 months ago I used smfPricesByDates() to retrieve the adjusted OHLC for various different months' data points. I then copied and paste those OHLC data points into a table.
Yesterday, as I was checking my data, I noticed that after running another smfPricesByDates() for the same date period, I get a whole new set of data, different from the ones that I got 2 months ago.
Is this what's mean by adjusted OHLC? If that's so, why doesn't the data for some tickers (ie. VFINX) change then? I'm so confused.
Can anyone enlighten me on this?
- 3b.
-
Re: smfPricesByDates()
Posted by: "lexstar" lexstar@yahoo.com lexstar
Fri Feb 24, 2012 12:05 pm (PST)
Oops, I meant the function smfPricesBetween(), not smfPricesByDates( )...
--- In smf_addin@yahoogroups.com , "lexstar" <lexstar@...> wrote:
>
> So 2 months ago I used smfPricesByDates() to retrieve the adjusted OHLC for various different months' data points. I then copied and paste those OHLC data points into a table.
>
> Yesterday, as I was checking my data, I noticed that after running another smfPricesByDates() for the same date period, I get a whole new set of data, different from the ones that I got 2 months ago.
>
> Is this what's mean by adjusted OHLC? If that's so, why doesn't the data for some tickers (ie. VFINX) change then? I'm so confused.
>
> Can anyone enlighten me on this?
>
- 3c.
-
Re: smfPricesByDates()
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 12:08 pm (PST)
VFINX should change -- it pays dividends. Maybe there wasn't a dividend
payment in the past two months...
When a stock splits or pays out a dividend, all historical quotes are
adjusted proportionately to account for that change in the current price.
So, if a $10 stock pays out a $1 dividend, the adjusted closing price on
Yahoo will be reduced by 10% for all history.
The add-in applies the ratio of the adjusted closing price to the actual
closing prices to the OHLC amounts to get adjusted amounts.
On Fri, Feb 24, 2012 at 12:56 PM, lexstar <lexstar@yahoo.com > wrote:
> So 2 months ago I used smfPricesByDates() to retrieve the adjusted OHLC
> for various different months' data points. I then copied and paste those
> OHLC data points into a table.
>
> Yesterday, as I was checking my data, I noticed that after running another
> smfPricesByDates() for the same date period, I get a whole new set of data,
> different from the ones that I got 2 months ago.
>
> Is this what's mean by adjusted OHLC? If that's so, why doesn't the data
> for some tickers (ie. VFINX) change then? I'm so confused.
>
> Can anyone enlighten me on this?
>
- 4a.
-
Automate data retrieval from a public website?
Posted by: "dwightpearson" dwightpearson@yahoo.com dwightpearson
Fri Feb 24, 2012 12:13 pm (PST)
This question is primarily to Randy or anybody in the group who wishes to respond.
I'm wanting to automate the process of accessing tax information from a government website. The data is public information so no security requirements(logon and password) are required. Several browser (pages) displays are involved. The only information entered is a pre-known account number. Otherwise the remaining input is clicking on the appropriate selections.
I've tried to use your RCHGetWebData (smfGetTagContent) function but having trouble making heads or tails from the data returned. I need some direction or recommended resources.
Any help would be appreciated!
Dwight
- 4b.
-
Re: Automate data retrieval from a public website?
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Fri Feb 24, 2012 12:35 pm (PST)
Provide urls, etc and I’ll take a look using an external query.
Don Guillett
SalesAid Software
dguillett1@gmail.com
From: dwightpearson
Sent: Friday, February 24, 2012 2:13 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Automate data retrieval from a public website?
This question is primarily to Randy or anybody in the group who wishes to respond.
I'm wanting to automate the process of accessing tax information from a government website. The data is public information so no security requirements(logon and password) are required. Several browser (pages) displays are involved. The only information entered is a pre-known account number. Otherwise the remaining input is clicking on the appropriate selections.
I've tried to use your RCHGetWebData (smfGetTagContent) function but having trouble making heads or tails from the data returned. I need some direction or recommended resources.
Any help would be appreciated!
Dwight
- 4c.
-
Re: Automate data retrieval from a public website?
Posted by: "Dwight Pearson" dwightpearson@yahoo.com dwightpearson
Fri Feb 24, 2012 1:43 pm (PST)
Don,
The URL is: http://www.tarrantcounty.com/ eGov/site/ default.asp
Select "Property Tax" then "Account Search"
Enter valid account # such as: 06967914 and hit "GO"
Select Acct # (there's only one)
Retrieve (capture) tax table with totals
Don, I certainly appreciate your help!
Dwight
--- On Fri, 2/24/12, dguillett1 <dguillett1@gmail.com > wrote:
From: dguillett1 <dguillett1@gmail.com >
Subject: Re: [smf_addin] Automate data retrieval from a public website?
To: smf_addin@yahoogroups.com
Date: Friday, February 24, 2012, 2:35 PM
Provide urls, etc and I’ll take a look using an external query.
Don Guillett
SalesAid Software
dguillett1@gmail.com
From: dwightpearson
Sent: Friday, February 24, 2012 2:13 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Automate data retrieval from a public website?
This question is primarily to Randy or anybody in the group who wishes to respond.
I'm wanting to automate the process of accessing tax information from a government website. The data is public information so no security requirements(logon and password) are required. Several browser (pages) displays are involved. The only information entered is a pre-known account number. Otherwise the remaining input is clicking on the appropriate selections.
I've tried to use your RCHGetWebData (smfGetTagContent) function but having trouble making heads or tails from the data returned. I need some direction or recommended resources.
Any help would be appreciated!
Dwight
- 4d.
-
Re: Automate data retrieval from a public website?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 2:12 pm (PST)
I don't see a way to get a bookmarkable URL, which the add-in would need to
know where to extract the data from.
On Fri, Feb 24, 2012 at 1:13 PM, dwightpearson <dwightpearson@yahoo.com >wrote:
> This question is primarily to Randy or anybody in the group who wishes to
> respond.
>
> I'm wanting to automate the process of accessing tax information from a
> government website. The data is public information so no security
> requirements(logon and password) are required. Several browser (pages)
> displays are involved. The only information entered is a pre-known account
> number. Otherwise the remaining input is clicking on the appropriate
> selections.
>
> I've tried to use your RCHGetWebData (smfGetTagContent) function but
> having trouble making heads or tails from the data returned. I need some
> direction or recommended resources.
>
> Any help would be appreciated!
>
- 4e.
-
Automate data retrieval from a public website?
Posted by: "PY & Associates" pynasocas@yahoo.com.sg pynasocas
Sat Feb 25, 2012 12:07 am (PST)
I used this as an opportunity to learn IE automation.
This program tested working, but not well written.
You have to input the pre-known account numbers in an outer loop.
Sub tax()
Dim url As String
Dim IE As InternetExplorer
Dim HTMLdoc As HTMLDocument
Dim TDelements As IHTMLElementCollection
Dim TDelement As HTMLTableCell
Dim r As Long
Set IE = New InternetExplorer
'URL to open
url = "http://taxoffice.tarrantcounty. "com/AccountSearc h.asp
With IE
.Navigate url
.Visible = True
While .Busy Or .readyState <> READYSTATE_COMPLETE: DoEvents: Wend
Set HTMLdoc = .document
End With
Set xmlNodes = HTMLdoc.getElementsByTagName( "input")
For Each xmlnode In xmlNodes
If xmlnode.Name = "txtSearch" Then xmlnode.Value = "06967914"
If xmlnode.ID = "submit" Then
xmlnode.Click
While IE.Busy Or IE.readyState <> READYSTATE_COMPLETE: DoEvents: Wend
Set HTMLdoc = IE.document
Set clinks = HTMLdoc.Links
For Each link In clinks
If InStr(1, link.href, "row=1", vbTextCompare) > 0 Then link.Click
Next link
End If
Next xmlnode
IE.Quit
End Sub
KC
From: dwightpearson
Sent: Friday, February 24, 2012 2:13 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Automate data retrieval from a public website?
I want to automate the process of accessing tax information from a government website. The data is public information so no security requirements(logon and password) are required. Several browser (pages) displays are involved. The only information entered is a pre-known account number. Otherwise the remaining input is clicking on the appropriate selections.
The URL is: http://www.tarrantcounty.com/ eGov/site/ default.asp
Select "Property Tax" then "Account Search"
Enter valid account # such as: 06967914 and hit "GO"
Select Acct # (there's only one)
Retrieve (capture) tax table with totals
Dwight
- 5a.
-
10k and 10q data extract
Posted by: "kevin martin" kmartin4503@gmail.com kmart4503
Fri Feb 24, 2012 2:04 pm (PST)
Hello all,
I'm wondering if anyone has anything set up to automatically pull comparable 10q and 10k data into excel(detailed-not just what Yahoo/Google has)? I'm trying to set up some time series analysis stuff in excel. Please let me know if anyone has anything.
Thanks,
Kevin
- 5b.
-
Re: 10k and 10q data extract
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 2:15 pm (PST)
The last time I looked at it, I was able to get the data. The difficulty
was in getting the URLs from which to extract the data -- especially for a
time series, since formats can vary from time period to time period. Try
doing a search of the message archives of the group and you may find some
of the discussions.
Have you looked at AdvFN? It has more detailed financial statements data
than Yahoo/Google/MSN.
On Fri, Feb 24, 2012 at 2:42 PM, kevin martin <kmartin4503@gmail.com > wrote:
>
> I'm wondering if anyone has anything set up to automatically pull
> comparable 10q and 10k data into excel(detailed-not just what Yahoo/Google
> has)? I'm trying to set up some time series analysis stuff in excel.
> Please let me know if anyone has anything.
>
- 6a.
-
Re: Historical prices won't pull in for specific SP5 telecom ETF
Posted by: "naderphilip" naderphilip@yahoo.com naderphilip
Fri Feb 24, 2012 8:00 pm (PST)
Hey Randy,
Thanks for the prompt reply. Well I meant to say it doesn't pull up data before 1/27/2011. Can you see if it works for you?
It's driving me nuts. I have every sector ETF and a ton of stocks in this spreadsheet linked to a few cells with the dates and everything else using the same code, so I'm pretty sure it's not the regional settings.
I've tried just typing the ticker XTL into a column that is working fine, and same result. Doesn't pull up the closing prices prior to 1/27/11.
I mean i probably could have just went to yahoofinance.com and copy and pasted the prices 100 times over from the time i've spent trying to figure this out haha
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just tried:
>
> =RCHGetYahooHistory("XTL")
>
> ...and it worked fine for me. Could you possibly have your regional
> settings on something that doesn't conform to mm/dd/yyyy? That would cause
> VBA to have an issue when it tried to convert the dates.
>
> On Thu, Feb 23, 2012 at 10:53 PM, naderphilip <naderphilip@...> wrote:
>
> > Hello,
> > I can't seem to pull in the historical prices for ticker: XTL (Select
> > Spyder Telecom ETF.
> > I've used the same formula for plenty other companies and tickers in my
> > spreadsheet but for some reason this one won't calculate the closing prices
> > after 12/1/2011.
> > I'm using the RCHgetyahoohistory- i've tried inputting the dates as well
> > as just highlighting an array and it still stops at 12/1/2011.
> >
> > Would anyone happen to know why?
> >
>
- 6b.
-
Re: Historical prices won't pull in for specific SP5 telecom ETF
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 9:45 pm (PST)
It would be difficult to get prices prior to the fund's inception date...
You're getting all the data you can get.
On Fri, Feb 24, 2012 at 9:00 PM, naderphilip <naderphilip@yahoo.com > wrote:
> Well I meant to say it doesn't pull up data before 1/27/2011. Can you see
> if it works for you?
> It's driving me nuts. I have every sector ETF and a ton of stocks in this
> spreadsheet linked to a few cells with the dates and everything else using
> the same code, so I'm pretty sure it's not the regional settings.
> I've tried just typing the ticker XTL into a column that is working fine,
> and same result. Doesn't pull up the closing prices prior to 1/27/11.
> I mean i probably could have just went to yahoofinance.com and copy and
> pasted the prices 100 times over from the time i've spent trying to figure
> this out haha
>
- 7a.
-
S&P 500 Total Return History?
Posted by: "naderphilip" naderphilip@yahoo.com naderphilip
Fri Feb 24, 2012 8:33 pm (PST)
Hi Randy,
Do you know if there's a way to pull in historical prices for the S&P500 Total Return Index?
The normal ^GSPC is just the price index and isn't very accurate as the dividends aren't really taken into account, even though is says 'adjusted for dividends'.
I could use the closing price of SPY and add dividends but it'd be off by a couple bps and I'd rather have the exact figures.
Was wondering if you had ever done this..
Thanks,
Nader
- 7b.
-
Re: S&P 500 Total Return History?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 24, 2012 9:51 pm (PST)
I just use SPY, since the adjusted returns there include the dividends. You
wouldn't need to "add" dividends.
^GSPC *is* dividend adjusted, because the INDEX itself doesn't pay
dividends.
Otherwise, I think you'll need to use Google and search for another source
of the data.
On Fri, Feb 24, 2012 at 9:33 PM, naderphilip <naderphilip@yahoo.com > wrote:
> Hi Randy,
> Do you know if there's a way to pull in historical prices for the S&P500
> Total Return Index?
> The normal ^GSPC is just the price index and isn't very accurate as the
> dividends aren't really taken into account, even though is says 'adjusted
> for dividends'.
> I could use the closing price of SPY and add dividends but it'd be off by
> a couple bps and I'd rather have the exact figures.
> Was wondering if you had ever done this..
>
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