15 New Messages
Digest #2274
Messages
Thu Jul 12, 2012 4:55 am (PDT) . Posted by:
"bushpilote@yahoo.ca" bushpilote
Hi Randy and Josh,
One solution is to place the entire link address ("http://....1") into a cell (eg "A1") and then build your rchCreateComment function [rchCreateComment(A1,99,250,250,1)].
I work with Excel 2007.
--- In smf_addin@yahoogroups.com , "Joshua" <jmart99@...> wrote:
>
> Hi Randy,
> I would like to display a chart from Bigcharts using rchCreateComment. The webaddress is longer longer than 255 characters which causes problems in excel. Have you found a relatively easy work-around for this?
>
> The chart I'd like to view in excel can be found here:
> http://bigcharts.marketwatch.com/kaavio.Webhost/charts/big.chart?nosettings=1&symb=qcom&uf=0&type=2&size=2&sid=8267&style=320&freq=5&entitlementtoken=0c33378313484ba9b46b8e24ded87dd6&time=13&rand=1599134777&compidx=aaaaa%3a0&ma=0&maval=9&lf=8388608&lf2=0&lf3=0&height=335&width=579&mocktick=1
>
> My ultimate goal is to be able to view/extract the high and low PE of a company each year.
>
> Thanks,
> Josh
>
One solution is to place the entire link address ("http://....1") into a cell (eg "A1") and then build your rchCreateComment function [rchCreateComment(
I work with Excel 2007.
--- In smf_addin@yahoogrou
>
> Hi Randy,
> I would like to display a chart from Bigcharts using rchCreateComment. The webaddress is longer longer than 255 characters which causes problems in excel. Have you found a relatively easy work-around for this?
>
> The chart I'd like to view in excel can be found here:
> http://bigcharts.
>
> My ultimate goal is to be able to view/extract the high and low PE of a company each year.
>
> Thanks,
> Josh
>
Thu Jul 12, 2012 5:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. That does work. I must be thinking of a length limitation on something
else -- it was EXCEL that wouldn't allow the URL to be over 99 bytes long,
when the VBA statement ran. I thought it was for the background image of a
comment (which is what RCHCreateComment is doing). Apparently not.
Thanks for jumping in.
On Thu, Jul 12, 2012 at 4:55 AM, <bushpilote@yahoo.ca > wrote:
> Hi Randy and Josh,
> One solution is to place the entire link address ("http://....1") into a
> cell (eg "A1") and then build your rchCreateComment function
> [rchCreateComment(A1,99,250,250,1)].
>
> I work with Excel 2007.
>
else -- it was EXCEL that wouldn't allow the URL to be over 99 bytes long,
when the VBA statement ran. I thought it was for the background image of a
comment (which is what RCHCreateComment is doing). Apparently not.
Thanks for jumping in.
On Thu, Jul 12, 2012 at 4:55 AM, <bushpilote@yahoo.
> Hi Randy and Josh,
> One solution is to place the entire link address ("http://....1") into a
> cell (eg "A1") and then build your rchCreateComment function
> [rchCreateComment(
>
> I work with Excel 2007.
>
Thu Jul 12, 2012 6:46 am (PDT) . Posted by:
"Keith M. Elis" zarathustra_winced
Hi, I'm new to the add-in, but have been using it to good effect for a few days. To say thanks, here's quick function using the add-in to pull bond yields from the table at yahoo.
Public Function GetBondYield(iIssuer As Integer, iMaturity As Integer) As Variant
Dim sIssuerStr As String
Dim sMaturityStr As String
Select Case iIssuer
Case 1: sIssuerStr = "US Treasury Bonds"
Select Case iMaturity
Case 1: sMaturityStr = "3 Month"
Case 2: sMaturityStr = "6 Month"
Case 3: sMaturityStr = "2 Year"
Case 4: sMaturityStr = "3 Year"
Case 5: sMaturityStr = "5 Year"
Case 6: sMaturityStr = "10 Year"
Case 7: sMaturityStr = "30 Year"
End Select
Case 2: sIssuerStr = "Municipal Bonds"
Select Case iMaturity
Case 1: sMaturityStr = "2yr AA"
Case 2: sMaturityStr = "2yr AAA"
Case 3: sMaturityStr = "2yr A"
Case 4: sMaturityStr = "5yr AAA"
Case 5: sMaturityStr = "5yr AA"
Case 6: sMaturityStr = "5yr A"
Case 7: sMaturityStr = "10yr AAA"
Case 8: sMaturityStr = "10yr AA"
Case 9: sMaturityStr = "10yr A"
Case 10: sMaturityStr = "20yr AAA"
Case 11: sMaturityStr = "20yr AA"
Case 12: sMaturityStr = "20yr A"
End Select
Case 3: sIssuerStr = "Corporate Bonds"
Select Case iMaturity
Case 1: sMaturityStr = "2yr AA"
Case 2: sMaturityStr = "2yr A"
Case 3: sMaturityStr = "5yr AAA"
Case 4: sMaturityStr = "5yr AA"
Case 5: sMaturityStr = "5yr A"
Case 6: sMaturityStr = "10yr AAA"
Case 7: sMaturityStr = "10yr AA"
Case 8: sMaturityStr = "10yr A"
Case 9: sMaturityStr = "20yr AAA"
Case 10: sMaturityStr = "20yr AA"
Case 11: sMaturityStr = "20yr A"
End Select
End Select
GetBondYield = RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates ", 1, sIssuerStr, sMaturityStr)
End Function
Public Function GetBondYield(
Dim sIssuerStr As String
Dim sMaturityStr As String
Select Case iIssuer
Case 1: sIssuerStr = "US Treasury Bonds"
Select Case iMaturity
Case 1: sMaturityStr = "3 Month"
Case 2: sMaturityStr = "6 Month"
Case 3: sMaturityStr = "2 Year"
Case 4: sMaturityStr = "3 Year"
Case 5: sMaturityStr = "5 Year"
Case 6: sMaturityStr = "10 Year"
Case 7: sMaturityStr = "30 Year"
End Select
Case 2: sIssuerStr = "Municipal Bonds"
Select Case iMaturity
Case 1: sMaturityStr = "2yr AA"
Case 2: sMaturityStr = "2yr AAA"
Case 3: sMaturityStr = "2yr A"
Case 4: sMaturityStr = "5yr AAA"
Case 5: sMaturityStr = "5yr AA"
Case 6: sMaturityStr = "5yr A"
Case 7: sMaturityStr = "10yr AAA"
Case 8: sMaturityStr = "10yr AA"
Case 9: sMaturityStr = "10yr A"
Case 10: sMaturityStr = "20yr AAA"
Case 11: sMaturityStr = "20yr AA"
Case 12: sMaturityStr = "20yr A"
End Select
Case 3: sIssuerStr = "Corporate Bonds"
Select Case iMaturity
Case 1: sMaturityStr = "2yr AA"
Case 2: sMaturityStr = "2yr A"
Case 3: sMaturityStr = "5yr AAA"
Case 4: sMaturityStr = "5yr AA"
Case 5: sMaturityStr = "5yr A"
Case 6: sMaturityStr = "10yr AAA"
Case 7: sMaturityStr = "10yr AA"
Case 8: sMaturityStr = "10yr A"
Case 9: sMaturityStr = "20yr AAA"
Case 10: sMaturityStr = "20yr AA"
Case 11: sMaturityStr = "20yr A"
End Select
End Select
GetBondYield = RCHGetTableCell(
End Function
Thu Jul 12, 2012 6:30 am (PDT) . Posted by:
"christianilson79" christianilson79
Hey Randy,
thats the file I got.
I justed assumed an outdated file might be the issue, since my last request regarding the MSN-connection was solved like this.
Does it work for everybody else? If so, do you have an idea what the cause of my error might be then?
(e.g. I get an error for =RCHGetElementNumber("NVS";4661))
Thanks in advance,
Chris
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The last update of the smf-elements-3.txt file was 2011-02-16, so it hasn't
> been changed since version 2.1.2012.02.02 of the add-in. Are you current
> with that version of the add-in?
>
> On Wed, Jul 11, 2012 at 9:09 AM, christianilson79 <
> christian.weitert@...> wrote:
>
> >
> > when I try to retrieve data from Google Finance for the range that is
> > saved in smf-elements-3 I constantly get an error. The same goes for higher
> > codes, e.g. Morning Star. Is there an updated Version of the file or could
> > someone please explain me how to update it myself (if that is possible with
> > my limited knowledge).
> > Thanks for your help and the great tool, I hope at some point I can give
> > something back an contribute to further imrpove it.
> >
>
thats the file I got.
I justed assumed an outdated file might be the issue, since my last request regarding the MSN-connection was solved like this.
Does it work for everybody else? If so, do you have an idea what the cause of my error might be then?
(e.g. I get an error for =RCHGetElementNumbe
Thanks in advance,
Chris
--- In smf_addin@yahoogrou
>
> The last update of the smf-elements-
> been changed since version 2.1.2012.02.
> with that version of the add-in?
>
> On Wed, Jul 11, 2012 at 9:09 AM, christianilson79 <
> christian.weitert@
>
> >
> > when I try to retrieve data from Google Finance for the range that is
> > saved in smf-elements-
> > codes, e.g. Morning Star. Is there an updated Version of the file or could
> > someone please explain me how to update it myself (if that is possible with
> > my limited knowledge).
> > Thanks for your help and the great tool, I hope at some point I can give
> > something back an contribute to further imrpove it.
> >
>
Thu Jul 12, 2012 6:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The Total Return MorningStar web page elements are only for mutual funds...
On Thu, Jul 12, 2012 at 6:30 AM, christianilson79 <
christian.weitert@googlemail.com > wrote:
>
> thats the file I got.
> I justed assumed an outdated file might be the issue, since my last
> request regarding the MSN-connection was solved like this.
> Does it work for everybody else? If so, do you have an idea what the cause
> of my error might be then?
> (e.g. I get an error for =RCHGetElementNumber("NVS";4661))
>
On Thu, Jul 12, 2012 at 6:30 AM, christianilson79 <
christian.weitert@
>
> thats the file I got.
> I justed assumed an outdated file might be the issue, since my last
> request regarding the MSN-connection was solved like this.
> Does it work for everybody else? If so, do you have an idea what the cause
> of my error might be then?
> (e.g. I get an error for =RCHGetElementNumbe
>
Thu Jul 12, 2012 6:57 am (PDT) . Posted by:
"christianilson79" christianilson79
Ok,
that was a bad example, I just played around with codes. How about =RCHGetElementNumber("NVS";3380), the operating Income from google finance. That does not work for me either.
cheers,
Chris
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The Total Return MorningStar web page elements are only for mutual funds...
>
> On Thu, Jul 12, 2012 at 6:30 AM, christianilson79 <
> christian.weitert@...> wrote:
>
> >
> > thats the file I got.
> > I justed assumed an outdated file might be the issue, since my last
> > request regarding the MSN-connection was solved like this.
> > Does it work for everybody else? If so, do you have an idea what the cause
> > of my error might be then?
> > (e.g. I get an error for =RCHGetElementNumber("NVS";4661))
> >
>
that was a bad example, I just played around with codes. How about =RCHGetElementNumbe
cheers,
Chris
--- In smf_addin@yahoogrou
>
> The Total Return MorningStar web page elements are only for mutual funds...
>
> On Thu, Jul 12, 2012 at 6:30 AM, christianilson79 <
> christian.weitert@
>
> >
> > thats the file I got.
> > I justed assumed an outdated file might be the issue, since my last
> > request regarding the MSN-connection was solved like this.
> > Does it work for everybody else? If so, do you have an idea what the cause
> > of my error might be then?
> > (e.g. I get an error for =RCHGetElementNumbe
> >
>
Thu Jul 12, 2012 7:21 am (PDT) . Posted by:
"christianilson79" christianilson79
For other Ticker Symbols its working...Strange, or am I missing something?
--- In smf_addin@yahoogroups.com , "christianilson79" <christian.weitert@...> wrote:
>
> Ok,
>
> that was a bad example, I just played around with codes. How about =RCHGetElementNumber("NVS";3380), the operating Income from google finance. That does not work for me either.
>
> cheers,
>
> Chris
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > The Total Return MorningStar web page elements are only for mutual funds...
> >
> > On Thu, Jul 12, 2012 at 6:30 AM, christianilson79 <
> > christian.weitert@> wrote:
> >
> > >
> > > thats the file I got.
> > > I justed assumed an outdated file might be the issue, since my last
> > > request regarding the MSN-connection was solved like this.
> > > Does it work for everybody else? If so, do you have an idea what the cause
> > > of my error might be then?
> > > (e.g. I get an error for =RCHGetElementNumber("NVS";4661))
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Ok,
>
> that was a bad example, I just played around with codes. How about =RCHGetElementNumbe
>
> cheers,
>
> Chris
>
> --- In smf_addin@yahoogrou
> >
> > The Total Return MorningStar web page elements are only for mutual funds...
> >
> > On Thu, Jul 12, 2012 at 6:30 AM, christianilson79 <
> > christian.weitert@
> >
> > >
> > > thats the file I got.
> > > I justed assumed an outdated file might be the issue, since my last
> > > request regarding the MSN-connection was solved like this.
> > > Does it work for everybody else? If so, do you have an idea what the cause
> > > of my error might be then?
> > > (e.g. I get an error for =RCHGetElementNumbe
> > >
> >
>
Thu Jul 12, 2012 7:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That one works fine for me. What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(3380)
On Thu, Jul 12, 2012 at 6:57 AM, christianilson79 <
christian.weitert@googlemail.com > wrote:
>
> that was a bad example, I just played around with codes. How about
> =RCHGetElementNumber("NVS";3380), the operating Income from google finance.
> That does not work for me either.
>
=RCHGetElementNumbe
=smfGetAParms(
On Thu, Jul 12, 2012 at 6:57 AM, christianilson79 <
christian.weitert@
>
> that was a bad example, I just played around with codes. How about
> =RCHGetElementNumbe
> That does not work for me either.
>
Thu Jul 12, 2012 8:12 am (PDT) . Posted by:
"taurines_morgan" taurines_morgan
hi,
Does someone know why the excel formula that i use works for one ticker
(Mo:us) and does not work for another one (DSM:NA)
formula:
=smfStrExtr(smfGetTagContent(businessweekadress;"div";1;CONCATEnate(">";"Company Name));"value=";"size=")
where businessweekadress= http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker= + ticker
thanks a lot for your help.
morgan
Does someone know why the excel formula that i use works for one ticker
(Mo:us) and does not work for another one (DSM:NA)
formula:
=smfStrExtr(
where businessweekadress= http://investing.
thanks a lot for your help.
morgan
Thu Jul 12, 2012 8:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Works for both ticker symbols here.
I would just pick it up from the title of the web page:
=smfStrExtr("|"&smfGetTagContent(businessweekadress,"title",1),"|","(")
On Thu, Jul 12, 2012 at 8:12 AM, taurines_morgan
<taurines_morgan@yahoo.fr >wrote:
>
> Does someone know why the excel formula that i use works for one ticker
> (Mo:us) and does not work for another one (DSM:NA)
>
> formula:
> =smfStrExtr(smfGetTagContent(businessweekadress;"div";1;CONCATEnate(">";"Company
> Name));"value=";"size=")
>
> where businessweekadress=
> http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=+ ticker
>
> thanks a lot for your help.
>
I would just pick it up from the title of the web page:
=smfStrExtr(
On Thu, Jul 12, 2012 at 8:12 AM, taurines_morgan
<taurines_morgan@
>
> Does someone know why the excel formula that i use works for one ticker
> (Mo:us) and does not work for another one (DSM:NA)
>
> formula:
> =smfStrExtr(
> Name));"value=
>
> where businessweekadress=
> http://investing.
>
> thanks a lot for your help.
>
Thu Jul 12, 2012 1:33 pm (PDT) . Posted by:
"taurines morgan" taurines_morgan
does not work randy for DSM even with your formula
very weird
here are some other tickers that work and don't work
AVP:US AVP AVON PRODUCTS INC
PEP:US PEP does not work
MDT:US MDT does not work
PG:US PG PROCTER & GAMBLE CO/THE
________________________________
De : Randy Harmelink <rharmelink@gmail.com >
À : smf_addin@yahoogroups.com
Envoyé le : Jeudi 12 juillet 2012 17h29
Objet : Re: [smf_addin] businessweek - get company name
Works for both ticker symbols here.
I would just pick it up from the title of the web page:
=smfStrExtr("|"&smfGetTagContent(businessweekadress,"title",1),"|","(")
On Thu, Jul 12, 2012 at 8:12 AM, taurines_morgan <taurines_morgan@yahoo.fr > wrote:
>Does someone know why the excel formula that i use works for one ticker
>(Mo:us) and does not work for another one (DSM:NA)
>
>formula:
>=smfStrExtr(smfGetTagContent(businessweekadress;"div";1;CONCATEnate(">";"Company Name));"value=";"size=")
>
>where businessweekadress= http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker= + ticker
>
>thanks a lot for your help.
>
very weird
here are some other tickers that work and don't work
AVP:US AVP AVON PRODUCTS INC
PEP:US PEP does not work
MDT:US MDT does not work
PG:US PG PROCTER & GAMBLE CO/THE
____________
De : Randy Harmelink <rharmelink@gmail.
À : smf_addin@yahoogrou
Envoyé le : Jeudi 12 juillet 2012 17h29
Objet : Re: [smf_addin] businessweek - get company name
Works for both ticker symbols here.
I would just pick it up from the title of the web page:
=smfStrExtr(
On Thu, Jul 12, 2012 at 8:12 AM, taurines_morgan <taurines_morgan@
>Does someone know why the excel formula that i use works for one ticker
>(Mo:us) and does not work for another one (DSM:NA)
>
>formula:
>=smfStrExtr(
>
>where businessweekadress= http://investing.
>
>thanks a lot for your help.
>
Thu Jul 12, 2012 2:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
All of the tickers below work for both formulas for me. Business Week must
be delivering different web page content for you?
On Thu, Jul 12, 2012 at 1:33 PM, taurines morgan
<taurines_morgan@yahoo.fr >wrote:
>
> does not work randy for DSM even with your formula
> very weird
> here are some other tickers that work and don't work
> AVP:US AVP AVON PRODUCTS INC PEP:US PEP does not work MDT:US MDT does
> not work PG:US PG PROCTER & GAMBLE CO/THE
> ------------------------------
> **
>
be delivering different web page content for you?
On Thu, Jul 12, 2012 at 1:33 PM, taurines morgan
<taurines_morgan@
>
> does not work randy for DSM even with your formula
> very weird
> here are some other tickers that work and don't work
> AVP:US AVP AVON PRODUCTS INC PEP:US PEP does not work MDT:US MDT does
> not work PG:US PG PROCTER & GAMBLE CO/THE
> ------------
> **
>
Thu Jul 12, 2012 9:31 am (PDT) . Posted by:
"davidphillips2976" davidphillips2976
--- In smf_addin@yahoogrou
>
> What is the formula for getting company name? I can't recall anything that
> would get name from MorningStar.
>
> On Wed, Jul 11, 2012 at 8:24 AM, davidphillips2976 <david45@...
>
> > I am trying to locate a current version of the Morningstar Ratings
> > Retrieval Worksheet that uses SMF. It retrieves Morningstar ratings for
> > stocks and was created in Excel 2007. A user must be logged in to the
> > premium section of Morningstar for this to work.
> >
> > The version I have will no longer get the company name but everything else
> > works fine.
> >
> > Thanks very much.
> >
>
Randy, all I can tell you is that I have a version of this spreadsheet that did retrieve the company name. I will be glad to forward a copy to you if that would be helpful.
Thank you.
Thu Jul 12, 2012 9:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not really interested in digging through other people's workbooks. If
someone else developed that workbook for you, and you don't know how it
works, then you should be contacting them to get a fix.
My suspicion is that you need to update the MSN element definitions, since
the company name did break there when MSN updated their web page layout.
That's why I asked you how it gets company name.
http://finance.groups.yahoo.com/group/smf_addin/message/19282
On Thu, Jul 12, 2012 at 9:31 AM, davidphillips2976 <david45@bellsouth.net >wrote:
>
> Randy, all I can tell you is that I have a version of this spreadsheet
> that did retrieve the company name. I will be glad to forward a copy to
> you if that would be helpful.
>
someone else developed that workbook for you, and you don't know how it
works, then you should be contacting them to get a fix.
My suspicion is that you need to update the MSN element definitions, since
the company name did break there when MSN updated their web page layout.
That's why I asked you how it gets company name.
http://finance.
On Thu, Jul 12, 2012 at 9:31 AM, davidphillips2976 <david45@bellsouth.
>
> Randy, all I can tell you is that I have a version of this spreadsheet
> that did retrieve the company name. I will be glad to forward a copy to
> you if that would be helpful.
>
Thu Jul 12, 2012 12:14 pm (PDT) . Posted by:
"davidphillips2976" davidphillips2976
Thank you, Randy, I am almost positive that I downloaded this spreadsheet from this user group and know of no other place where I would have found it. As far as I know, it doesn't use MSN; only Morningstar. Anyway, thanks for your kindness in replying.
David
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not really interested in digging through other people's workbooks. If
> someone else developed that workbook for you, and you don't know how it
> works, then you should be contacting them to get a fix.
>
> My suspicion is that you need to update the MSN element definitions, since
> the company name did break there when MSN updated their web page layout.
> That's why I asked you how it gets company name.
>
> http://finance.groups.yahoo.com/group/smf_addin/message/19282
>
> On Thu, Jul 12, 2012 at 9:31 AM, davidphillips2976 <david45@...>wrote:
>
> >
> > Randy, all I can tell you is that I have a version of this spreadsheet
> > that did retrieve the company name. I will be glad to forward a copy to
> > you if that would be helpful.
> >
>
David
--- In smf_addin@yahoogrou
>
> I'm not really interested in digging through other people's workbooks. If
> someone else developed that workbook for you, and you don't know how it
> works, then you should be contacting them to get a fix.
>
> My suspicion is that you need to update the MSN element definitions, since
> the company name did break there when MSN updated their web page layout.
> That's why I asked you how it gets company name.
>
> http://finance.
>
> On Thu, Jul 12, 2012 at 9:31 AM, davidphillips2976 <david45@...
>
> >
> > Randy, all I can tell you is that I have a version of this spreadsheet
> > that did retrieve the company name. I will be glad to forward a copy to
> > you if that would be helpful.
> >
>
Tidak ada komentar:
Posting Komentar