5 Messages
Digest #3114
Messages
body{font-size:10pt;font-family:arial,sans-serif;background-color\
:#ffffff;color:black;}p{margin:0px;}Good morning Randy and thanks
a lot for your prompt reply.
Here are the results of my testing following your instructions:
(1) NAV
(a) smfConvertData:
It did work, but it seems that the command requires hard coding
the Ticker into the command line. I tried entering a cell rather
than the ticker which result in Error.
(b) smfGetTableCell
Same as in (a).
In addition, it produced Error when I entered HYF as the Ticker.
Is there a way to enter a cell or a range of cells in either (a)
or (b)? Or is there a different way to do it?
(2) Data Elements producing Error: 979, 5079, 5059 and 5064
Here is the command I've used: =RCHGetElementNumber(+C3, 979)
It results in Error for all those Data Elements and for both CEFs
and ETFs. I've tried for HYF, REM, VNQI, JPS.
It did work for your example "VFINX" though. So I suspect those
Data Elements are Mutual Funds not for ETFs or CEFs.
Am I right? If so, how to do it? I am not interested in Mutual
Funds, but in CEFs and ETFs.
Thanks again,
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Jul 7, 2014 7:15 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] NEWBIE Question
On Mon, Jul 7, 2014 at 1:27 PM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto: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/f\
und/c-header?&t=SPY
<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
<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
<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.
:#ffffff;color:black;}p{margin:0px;}Good morning Randy and thanks
a lot for your prompt reply.
Here are the results of my testing following your instructions:
(1) NAV
(a) smfConvertData:
It did work, but it seems that the command requires hard coding
the Ticker into the command line. I tried entering a cell rather
than the ticker which result in Error.
(b) smfGetTableCell
Same as in (a).
In addition, it produced Error when I entered HYF as the Ticker.
Is there a way to enter a cell or a range of cells in either (a)
or (b)? Or is there a different way to do it?
(2) Data Elements producing Error: 979, 5079, 5059 and 5064
Here is the command I've used: =RCHGetElementNumber(+C3, 979)
It results in Error for all those Data Elements and for both CEFs
and ETFs. I've tried for HYF, REM, VNQI, JPS.
It did work for your example "VFINX" though. So I suspect those
Data Elements are Mutual Funds not for ETFs or CEFs.
Am I right? If so, how to do it? I am not interested in Mutual
Funds, but in CEFs and ETFs.
Thanks again,
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Jul 7, 2014 7:15 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] NEWBIE Question
On Mon, Jul 7, 2014 at 1:27 PM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto: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/f\
und/c-header?&t=SPY
<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
<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
<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.
run Excel 2010 on a Windows 7 system.
Note that some updated element definitions can be found on the
"Works in Progress" web page.
Tue Jul 8, 2014 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Tue, Jul 8, 2014 at 4:01 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Here are the results of my testing following your instructions:
>
> (1) NAV
>
> (a) smfConvertData:
>
> It did work, but it seems that the command requires hard coding the Ticker
> into the command line. I tried entering a cell rather than the ticker
> which result in Error.
>
You just need to use plain old EXCEL string concatenation:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?&t="&C5, "span", 0,
"vkey=""NAV"">"))
> (b) smfGetTableCell
>
> Same as in (a).
>
Same solution -- plain old EXCEL string concatenation:
=RCHGetTableCell("http://finance.yahoo.com/q?s="&C5,1,">NAV")
> In addition, it produced Error when I entered HYF as the Ticker.
>
Those data items are extracted from mutual fund web pages. I don't see NAV
on Yahoo for HYF, but from MorningStar:
=RCHGetTableCell("http://cef.morningstar.com/cef-header?&t=HYF
",0,"id=""last-act-nav""")
...or, with the ticker in a cell:
=RCHGetTableCell("http://cef.morningstar.com/cef-header?&t=
"&C8,0,"id=""last-act-nav""")
Is there a way to enter a cell or a range of cells in either (a) or (b)?
> Or is there a different way to do it?
>
Not for a range of cells, but plain old EXCEL string concatenation gets a
single ticker from a cell.
> (2) Data Elements producing Error: 979, 5079, 5059 and 5064
>
> Here is the command I've used: =RCHGetElementNumber(+C3, 979)
>
> It results in Error for all those Data Elements and for both CEFs and
> ETFs. I've tried for HYF, REM, VNQI, JPS.
>
> It did work for your example "VFINX" though. So I suspect those Data
> Elements are Mutual Funds not for ETFs or CEFs.
>
> Am I right? If so, how to do it? I am not interested in Mutual Funds,
> but in CEFs and ETFs.
>
In general, element 979 is only for stocks (as per
RCHGetElementNumber-Element-Definitions.xls), but it depends on what Yahoo
is displaying on their quotes page. The other three elements come from
Yahoo mutual fund web pages, although they sometimes do display the data
for ETFs.
I haven't defined any elements specifically for CEFs, so if that's what
you're interested in, you'll need to write up your own extractions using
RCHGetTableCell() and smfGetTagContent().
smf_addin@yahoogroups.com> wrote:
>
> Here are the results of my testing following your instructions:
>
> (1) NAV
>
> (a) smfConvertData:
>
> It did work, but it seems that the command requires hard coding the Ticker
> into the command line. I tried entering a cell rather than the ticker
> which result in Error.
>
You just need to use plain old EXCEL string concatenation:
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?&t="&C5, "span", 0,
"vkey=""NAV"">"))
> (b) smfGetTableCell
>
> Same as in (a).
>
Same solution -- plain old EXCEL string concatenation:
=RCHGetTableCell("http://finance.yahoo.com/q?s="&C5,1,">NAV")
> In addition, it produced Error when I entered HYF as the Ticker.
>
Those data items are extracted from mutual fund web pages. I don't see NAV
on Yahoo for HYF, but from MorningStar:
=RCHGetTableCell("http://cef.morningstar.com/cef-header?&t=HYF
",0,"id=""last-act-nav""")
...or, with the ticker in a cell:
=RCHGetTableCell("http://cef.morningstar.com/cef-header?&t=
"&C8,0,
Is there a way to enter a cell or a range of cells in either (a) or (b)?
> Or is there a different way to do it?
>
Not for a range of cells, but plain old EXCEL string concatenation gets a
single ticker from a cell.
> (2) Data Elements producing Error: 979, 5079, 5059 and 5064
>
> Here is the command I've used: =RCHGetElementNumbe
>
> It results in Error for all those Data Elements and for both CEFs and
> ETFs. I've tried for HYF, REM, VNQI, JPS.
>
> It did work for your example "VFINX" though. So I suspect those Data
> Elements are Mutual Funds not for ETFs or CEFs.
>
> Am I right? If so, how to do it? I am not interested in Mutual Funds,
> but in CEFs and ETFs.
>
In general, element 979 is only for stocks (as per
RCHGetElementNumber
is displaying on their quotes page. The other three elements come from
Yahoo mutual fund web pages, although they sometimes do display the data
for ETFs.
I haven't defined any elements specifically for CEFs, so if that's what
you're interested in, you'll need to write up your own extractions using
RCHGetTableCell(
Tue Jul 8, 2014 6:19 am (PDT) . Posted by:
"steve" sgschollaert
Sup smf
http://langlieure.com/wordpress/wp-content/themes/therestaurant/ever.php?nwad2539vz
usrepat@hotmail.com
http://langlieure.com/wordpress/wp-content/themes/therestaurant/ever.php?nwad2539vz
usrepat@hotmail.com
Tue Jul 8, 2014 12:07 pm (PDT) . Posted by:
patriot3489
Hey guys I'm a newbie, just got the add-in installed and the Yahoo calls are working well but when trying to tap into financial statement data from Google, I can't seem to get anything back with the RCHGetElementNumber() function. I'm sure I'm doing something wrong but can't figure it out. Some help would be great thanks.
Tue Jul 8, 2014 12:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sounds like a location error on a template? See the "Tips and FAQs" web
page for information on that.
You could just try running the smfFixLinks macro, but make sure the
worksheet is unprotected.
Otherwise, some need the AdvFN fix for domain issues on Google. Also on the
T&F web page.
On Tue, Jul 8, 2014 at 11:23 AM, larrydyson1@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Hey guys I'm a newbie, just got the add-in installed and the Yahoo calls
> are working well but when trying to tap into financial statement data from
> Google, I can't seem to get anything back with the RCHGetElementNumber()
> function. I'm sure I'm doing something wrong but can't figure it out. Some
> help would be great thanks.
>
page for information on that.
You could just try running the smfFixLinks macro, but make sure the
worksheet is unprotected.
Otherwise, some need the AdvFN fix for domain issues on Google. Also on the
T&F web page.
On Tue, Jul 8, 2014 at 11:23 AM, larrydyson1@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Hey guys I'm a newbie, just got the add-in installed and the Yahoo calls
> are working well but when trying to tap into financial statement data from
> Google, I can't seem to get anything back with the RCHGetElementNumber
> function. I'm sure I'm doing something wrong but can't figure it out. Some
> help would be great thanks.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar