5 Messages
Digest #3170
Messages
Thu Sep 4, 2014 8:16 am (PDT) . Posted by:
bigzippy@bellsouth.net
https://personal.vanguard.com/us/funds/snapshot?FundId=0968&FundIntExt=INT https://personal.vanguard.com/us/funds/snapshot?FundId=0968&FundIntExt=INT
http://us.spindices.com/indices/equity/sp-500 http://us.spindices.com/indices/equity/sp-500
https://www.spdrs.com/product/fund.seam?ticker=spy https://www.spdrs.com/product/fund.seam?ticker=spy
http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf
Her are some links I found that have the data, but cannot get them in excel. Any ideas on data source or getting any of these to work in SMF????
Thank you
http://us.spindices.com/indices/equity/sp-500 http://us.spindices.com/indices/equity/sp-500
https://www.spdrs.com/product/fund.seam?ticker=spy https://www.spdrs.com/product/fund.seam?ticker=spy
http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf
Her are some links I found that have the data, but cannot get them in excel. Any ideas on data source or getting any of these to work in SMF????
Thank you
Thu Sep 4, 2014 8:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The first three are all dynamically generated. No luck there. However, the
last appears to be usable. For example:
=smfConvertData(smfGetTagContent("
http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf","p",1,"%
of Market Value",">Information Technology"))
They are in the MorningStar Portfolio Attributes template on the web site
as well. But I notice the numbers are a bit different. No idea why. One
says as of 9/2, the other as of 9/3, but I can't see them changing as much
as they are showing, in a day.
On Thu, Sep 4, 2014 at 8:16 AM, bigzippy@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> https://personal.vanguard.com/us/funds/snapshot?FundId=0968&FundIntExt=INT
>
> http://us.spindices.com/indices/equity/sp-500
>
> https://www.spdrs.com/product/fund.seam?ticker=spy
>
> http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf
>
> Her are some links I found that have the data, but cannot get them in
> excel. Any ideas on data source or getting any of these to work in SMF????
>
>
last appears to be usable. For example:
=smfConvertData(smfGetTagContent("
http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf","p",1,"%
of Market Value",">Information Technology"))
They are in the MorningStar Portfolio Attributes template on the web site
as well. But I notice the numbers are a bit different. No idea why. One
says as of 9/2, the other as of 9/3, but I can't see them changing as much
as they are showing, in a day.
On Thu, Sep 4, 2014 at 8:16 AM, bigzippy@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> https://personal.vanguard.com/us/funds/snapshot?FundId=0968&FundIntExt=INT
>
> http://us.spindices.com/indices/equity/sp-500
>
> https://www.spdrs.com/product/fund.seam?ticker=spy
>
> http://www.ishares.com/us/products/239726/ishares-core-sp-500-etf
>
> Her are some links I found that have the data, but cannot get them in
> excel. Any ideas on data source or getting any of these to work in SMF????
>
>
Thu Sep 4, 2014 12:08 pm (PDT) . Posted by:
"Douglas Haas" mdouglashaas
Randy,
Thanks for the tip on using Zacks screener.
Is there a way to automate downloading the four desired data items in CSV format from Zacks using the SMF Add-in function smfGetCSVFile() without doing the manual screen and manual file export?
Thanks for your consideration.
Douglas Haas
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, September 02, 2014 11:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Possible Expansion of RCHGetYahooQuotes() Function
Sorry, but it's not possible for me to add data items to RCHGetYahooQuotes(). It is retrieving a data file from Yahoo, and parsing the data out of that returned file. Yahoo defines what data elements can be requested to be put onto the file.
That's the reason an array-entered RCHGetYahooQuotes() is so much faster -- all of the data can be requested in one Internet access, and Yahoo returns the file with the requested data.
One workaround is to get the data from Zacks screener. For example, if you set a criteria like "Price > 5", you'll get about 7000 stocks. Then add the fields you want to see on the output file and export the CSV file. Then, you can do VLOOKUP() functions on that returned data to grab the data you want for your 100 companies. This is what a sample file might look like:
Company Name
Ticker
Beta
Current Avg Broker Rec
Last Close
# Rating Strong Buy or Buy
# Rating Hold
# Rating Strong Sell or Sell
Average Target Price
AGILENT TECH
A
1.64
1.22
57.16
8
1
0
64
ALCOA INC
AA
1.74
2.23
16.61
7
7
1
15.6
AAC TECH HLDGS
AACAY
0.61
4
61.96
0
0
1
On Tue, Sep 2, 2014 at 7:12 PM, 'Douglas Haas' douglashaas4974@... wrote:
Is it possible to add the following data items:
Beta (RCHGetElementNumber = 24), Strong Buy (RCHGetElementNumber = 362), Hold (RCHGetElementNumber = 370), Sell (RCHGetElementNumber = 378), to the RCHGetYahooQuotes() function in order get these four data items for 100 or so stocks.
If so, I would plan to use the RCHGetYahooQoutes() function as an array entered formula to get the data more efficiently than using 400 separate entries of RCHGetElementNumber().
My main focus is obtaining these four data items for 100 or so stocks in a minimum of time and in the most efficient manner. If you have an alternative suggestion, it would be appreciated.
Many thanks for your dedication and knowledge with respect to this Addin. It is simply Super!
Thanks for the tip on using Zacks screener.
Is there a way to automate downloading the four desired data items in CSV format from Zacks using the SMF Add-in function smfGetCSVFile() without doing the manual screen and manual file export?
Thanks for your consideration.
Douglas Haas
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, September 02, 2014 11:45 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Possible Expansion of RCHGetYahooQuotes(
Sorry, but it's not possible for me to add data items to RCHGetYahooQuotes(
That's the reason an array-entered RCHGetYahooQuotes(
One workaround is to get the data from Zacks screener. For example, if you set a criteria like "Price > 5", you'll get about 7000 stocks. Then add the fields you want to see on the output file and export the CSV file. Then, you can do VLOOKUP() functions on that returned data to grab the data you want for your 100 companies. This is what a sample file might look like:
Company Name
Ticker
Beta
Current Avg Broker Rec
Last Close
# Rating Strong Buy or Buy
# Rating Hold
# Rating Strong Sell or Sell
Average Target Price
AGILENT TECH
A
1.64
1.22
57.16
8
1
0
64
ALCOA INC
AA
1.74
2.23
16.61
7
7
1
15.6
AAC TECH HLDGS
AACAY
0.61
4
61.96
0
0
1
On Tue, Sep 2, 2014 at 7:12 PM, 'Douglas Haas' douglashaas4974@
Is it possible to add the following data items:
Beta (RCHGetElementNumbe
If so, I would plan to use the RCHGetYahooQoutes(
My main focus is obtaining these four data items for 100 or so stocks in a minimum of time and in the most efficient manner. If you have an alternative suggestion, it would be appreciated.
Many thanks for your dedication and knowledge with respect to this Addin. It is simply Super!
Thu Sep 4, 2014 12:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no. I used to be able to do it, but when I tried it yesterday, that
method no longer worked.
On Thu, Sep 4, 2014 at 12:08 PM, 'Douglas Haas'
douglashaas4974@earthlink.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Thanks for the tip on using Zacks screener.
>
>
>
> Is there a way to automate downloading the four desired data items in CSV
> format from Zacks using the SMF Add-in function smfGetCSVFile() without
> doing the manual screen and manual file export?
>
>
>
method no longer worked.
On Thu, Sep 4, 2014 at 12:08 PM, 'Douglas Haas'
douglashaas4974@earthlink.net [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> Thanks for the tip on using Zacks screener.
>
>
>
> Is there a way to automate downloading the four desired data items in CSV
> format from Zacks using the SMF Add-in function smfGetCSVFile(
> doing the manual screen and manual file export?
>
>
>
Thu Sep 4, 2014 4:28 pm (PDT) . Posted by:
digsupply
Thanks to your idea of checking the formula step by step I managed to get the results I needed. That wouldn't have been possible without your help. Thanks a lot!!!
The problem was that smfStrExtr and FIND couldn't find brackets and colons. """data"" : [ ","]"),"
smfStrExtr now works fine, I am attaching the worksheet in case you would like to see it.
Thank you again!
The problem was that smfStrExtr and FIND couldn't find brackets and colons. ""
smfStrExtr now works fine, I am attaching the worksheet in case you would like to see it.
Thank you again!
Attachment(s) from
1 of 1 File(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar