2 Messages
Digest #3113
Messages
Hi Randy.
First of all congratulations for your work on this. It is simply outstanding.
I spent my 4th of July putting it to work for me. I was unable to find a couple of data I normally use, so thought of bother you with a few questions:
(1) Could not find Net Asset Value info on Morningstar data elements nor could I find it on Yahoo either.
(2) The following data elements 979, 5079, 5059 and 5064 give me "Error".
(3) Are 5079 and 5086 the same? Could not verify this because they also produce Error.
(4) Morningstar has info on both ETFs and CEFs the only difference is the location they appear on their QUOTE screen. So, I thought that could explain the Error, but it seems they have been happening for both.
(5) Any plans to make FinViz data elements?
By the way, I downloaded and installed version 2.1.2014.01.30, run Excel 2010 on a Windows 7 system.
Thanks
Armando
First of all congratulations for your work on this. It is simply outstanding.
I spent my 4th of July putting it to work for me. I was unable to find a couple of data I normally use, so thought of bother you with a few questions:
(1) Could not find Net Asset Value info on Morningstar data elements nor could I find it on Yahoo either.
(2) The following data elements 979, 5079, 5059 and 5064 give me "Error"
(3) Are 5079 and 5086 the same? Could not verify this because they also produce Error.
(4) Morningstar has info on both ETFs and CEFs the only difference is the location they appear on their QUOTE screen. So, I thought that could explain the Error, but it seems they have been happening for both.
(5) Any plans to make FinViz data elements?
By the way, I downloaded and installed version 2.1.2014.01.
Thanks
Armando
Mon Jul 7, 2014 3:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Mon, Jul 7, 2014 at 1:27 PM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> (1) Could not find Net Asset Value info on Morningstar data elements nor
> could I find it on Yahoo either.
>
I almost exclusively use U.S. Stocks, so there will be a bias toward that
aspect. You can get NAV from MorningStar with:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?&t=SPY", "span", 0,
"vkey=""NAV"">"))
...or from Yahoo with:
=RCHGetTableCell("http://finance.yahoo.com/q?s=SPY",1,">NAV")
> (2) The following data elements 979, 5079, 5059 and 5064 give me "Error".
>
These worked fine for me:
=RCHGetElementNumber("MMM",979)
=RCHGetElementNumber("VFINX",5079)
=RCHGetElementNumber("VFINX",5059)
=RCHGetElementNumber("VFINX",5064)
(3) Are 5079 and 5086 the same? Could not verify this because they also
> produce Error.
>
No. 5079 is for the mutual find, 5086 is the average for the mutual fund's
category.
Here's the web page they both come from:
http://finance.yahoo.com/q/pr?s=VFINX
(4) Morningstar has info on both ETFs and CEFs the only difference is the
> location they appear on their QUOTE screen. So, I thought that could
> explain the Error, but it seems they have been happening for both.
>
Without specific examples of how you're getting "Error" results, it's
impossible for me to tell what is going wrong.
(5) Any plans to make FinViz data elements?
>
No. Because they can be retrieved in groups of stocks with other formulas.
Much more efficient than me defining elements for each ticker symbol.
See the "Tips and FAQs" web page for more information on group retrieval of
FinViz data.
By the way, I downloaded and installed version 2.1.2014.01.30, run Excel
> 2010 on a Windows 7 system.
>
Note that some updated element definitions can be found on the "Works in
Progress" web page.
smf_addin@yahoogroups.com> wrote:
> (1) Could not find Net Asset Value info on Morningstar data elements nor
> could I find it on Yahoo either.
>
I almost exclusively use U.S. Stocks, so there will be a bias toward that
aspect. You can get NAV from MorningStar with:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?&t=SPY", "span", 0,
"vkey=""NAV"">"))
...or from Yahoo with:
=RCHGetTableCell("http://finance.yahoo.com/q?s=SPY",1,">NAV")
> (2) The following data elements 979, 5079, 5059 and 5064 give me "Error".
>
These worked fine for me:
=RCHGetElementNumber("MMM",979)
=RCHGetElementNumber("VFINX",5079)
=RCHGetElementNumber("VFINX",5059)
=RCHGetElementNumber("VFINX",5064)
(3) Are 5079 and 5086 the same? Could not verify this because they also
> produce Error.
>
No. 5079 is for the mutual find, 5086 is the average for the mutual fund's
category.
Here's the web page they both come from:
http://finance.yahoo.com/q/pr?s=VFINX
(4) Morningstar has info on both ETFs and CEFs the only difference is the
> location they appear on their QUOTE screen. So, I thought that could
> explain the Error, but it seems they have been happening for both.
>
Without specific examples of how you're getting "Error" results, it's
impossible for me to tell what is going wrong.
(5) Any plans to make FinViz data elements?
>
No. Because they can be retrieved in groups of stocks with other formulas.
Much more efficient than me defining elements for each ticker symbol.
See the "Tips and FAQs" web page for more information on group retrieval of
FinViz data.
By the way, I downloaded and installed version 2.1.2014.01.
> 2010 on a Windows 7 system.
>
Note that some updated element definitions can be found on the "Works in
Progress" web page.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar