Kamis, 07 Juni 2012

[smf_addin] Digest Number 2238

Messages In This Digest (13 Messages)

Messages

1a.

Re: Smart Money Financial Statements

Posted by: "rebalance85" rebalance85@yahoo.com   rebalance85

Wed Jun 6, 2012 1:44 am (PDT)



Randy,
When I replace "IBM" with "&Ticker", I got the Error. What's wrong with this formula:
=RCHGetTableCell("http://www.smartmoney.com/quote/"&Ticker/?story=financials&opt=YI",1,"Sales/Revenue")

Thanks


--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can retrieve the first depreciation item with:
>
> =RCHGetTableCell("
> http://www.smartmoney.com/quote/IBM/?story=financials&opt=YI
> ",5,"Depreciation")
>
> ...and the second with:
>
> =RCHGetTableCell("
> http://www.smartmoney.com/quote/IBM/?story=financials&opt=YI
> ",5,"Depreciation","Depreciation")
>
> On Sat, May 26, 2012 at 9:08 AM, rebalance85 <rebalance85@...> wrote:
>
> > Question 1 is still problem, the second line, I use Depreciation
> > Depreciation, the result is error.
> > Could you please give me an example?
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Answers:
> > >
> > > 1. Use two search strings for the second item. Both can be
> > > "Depreciation".
> > >
> > > On Sat, May 26, 2012 at 7:34 AM, rebalance85 <rebalance85@> wrote:
> > >
> > > > Hi Randy.
> > > > I couldn't find some template about the SmartMoney Source. I am now
> > > > working on the financial statements.
> > > > 1. =RCHGetTableCell("
> > > > http://www.smartmoney.com/quote/IBM/?story=financials&opt=YI
> > ",5,"Depreciation
> > > > & Amortization Expense")
> > > > and =RCHGetTableCell("
> > > > http://www.smartmoney.com/quote/IBM/?story=financials&opt=YI
> > ",5,"Depreciation"),
> > > > I got the same value.How to solve it?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
1b.

Re: Smart Money Financial Statements

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 6, 2012 4:11 am (PDT)



Because you didn't concatenate it to the string FOLLOWING the ticker symbol:

"http://www.smartmoney.com/quote/" & Ticker & "/?story=financials&opt=YI"

On Wed, Jun 6, 2012 at 1:44 AM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> When I replace "IBM" with "&Ticker", I got the Error. What's wrong with
> this formula:
> =RCHGetTableCell("http://www.smartmoney.com/quote/
> "&Ticker/?story=financials&opt=YI",1,"Sales/Revenue")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2.

Re: Digest Number 2237

Posted by: "Tom Ellis" mrtomellis@gmail.com   tom_b_ellis

Wed Jun 6, 2012 8:54 am (PDT)



This is one but hard to get to work.

On Wed, Jun 6, 2012 at 1:23 AM, <smf_addin@yahoogroups.com> wrote:

> **
> EXCEL Stock Market Functions Add-in
> <http://groups.yahoo.com/group/smf_addin;_ylc=X3oDMTJlbnQ2bGJkBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDaGRyBHNsawNocGgEc3RpbWUDMTMzODk3MTAyMw-->
> Messages In This Digest (5 Messages)
> 1a. Re: How to get greek letter of put option and Error of smfGetOXOptio<#137c0e474024d566_1a>From: Randy Harmelink 2a.
> Re: Error on RCHGetElementNumber-Template-AdvFN-Financial-Statements<#137c0e474024d566_2a>From: Jacob Jose 3a.
> Re: ELEMENT FUNCTION LIST-1 <#137c0e474024d566_3a> From: Randy H 4a. Daily
> Prices and TTM Ratio Chart <#137c0e474024d566_4a> From: invesco88 4b. Re:
> Daily Prices and TTM Ratio Chart <#137c0e474024d566_4b> From: Randy
> Harmelink
> View All Topics<http://groups.yahoo.com/group/smf_addin/messages;_ylc=X3oDMTJnNXBtbzVyBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZG1zZwRzbGsDYXRwYwRzdGltZQMxMzM4OTcxMDIz?xm=1&m=p&tidx=1>| Create
> New Topic<http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJnbGxwbzNnBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZG1zZwRzbGsDbnRwYwRzdGltZQMxMzM4OTcxMDIz>
> Messages
> 1a. Re: How to get greek letter of put option and Error of
> smfGetOXOptio
> <http://groups.yahoo.com/group/smf_addin/message/18864;_ylc=X3oDMTJzZmJzdTViBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMzM4OTcxMDIz> Posted
> by: "Randy Harmelink" rharmelink@gmail.com
> <rharmelink@gmail.com?Subject=+Re%3A%20How%20to%20get%20greek%20letter%20of%20put%20option%20and%20Error%20of%20smfGetOXOptio> rharmelink
> <http://profiles.yahoo.com/rharmelink> Tue Jun 5, 2012 3:29 am (PDT)
>
>
> Both formulas work fine here. Try the smfForceRecalculati**on macro (see
> LINKS area of the group for more info), as you may have saved a copy of the
> web page before you were logged in, which would not contain the data you
> need and cause the function to return an error.
>
> Another option would be to get a quote using the EXCEL Web Query dialog, as
> the version of IE EXCEL uses may be different than what you are using as a
> browser.
>
> On Tue, Jun 5, 2012 at 1:11 AM, ไป ็Ž‹ <id123.id123@**yahoo.com.**cn<id123.id123%40yahoo.com.cn>>
> wrote:
>
> >
> > Upon your instruction, I can get the strike price
> > =smfGet888OptionQuo**te("SPY",**"C",DATE(**2012,6,8)**,123,"s")
> > However, this function is still Error
> > =smfGet888OptionQuo**te("SPY",**"C",DATE(**2012,6,8)**,123,"b") ?
> > I got the page of SPY and logged in.
> >
> Back to top <#137c0e474024d566_toc>
> Reply to sender
> <rharmelink@gmail.com?Subject=Re%3A%20How%20to%20get%20greek%20letter%20of%20put%20option%20and%20Error%20of%20smfGetOXOptio>| Reply
> to group
> <smf_addin@yahoogroups.com?Subject=+Re%3A%20How%20to%20get%20greek%20letter%20of%20put%20option%20and%20Error%20of%20smfGetOXOptio>| Reply
> via web post
> <http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJzZjZsN2h1BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NARzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMzM4OTcxMDIz?act=reply&messageNum=18864>
> Messages in this topic
> <http://groups.yahoo.com/group/smf_addin/message/18858;_ylc=X3oDMTM4MW1ydXRuBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NARzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxMzM4OTcxMDIzBHRwY0lkAzE4ODU4>(6)
> 2a. Re: Error on
> RCHGetElementNumber-Template-AdvFN-Financial-Statements
> <http://groups.yahoo.com/group/smf_addin/message/18865;_ylc=X3oDMTJzdWZqM2R2BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NQRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMzM4OTcxMDIz> Posted
> by: "Jacob Jose" pepecan47@yahoo.ca
> <pepecan47@yahoo.ca?Subject=+Re%3A%20Error%20on%20RCHGetElementNumber-Template-AdvFN-Financial-Statements> pepecan47
> <http://profiles.yahoo.com/pepecan47> Tue Jun 5, 2012 7:47 am (PDT)
>
>
> Randy, thx a lot.. it works perfectly now.
>
> Regards,
> Jose L. Jacob
>
> ____________**_________**_________**__
> From: Randy Harmelink <rharmelink@gmail.**com <rharmelink%40gmail.com>>
> To: smf_addin@yahoogrou**ps.com <smf_addin%40yahoogroups.com>
> Sent: Tuesday, June 5, 2012 12:35:17 AM
> Subject: Re: [smf_addin] Error on RCHGetElementNumber**-Template-**
> AdvFN-Financial-**Statements.**xls
>
>
> The problem is that ca.advfn.com reacts to ticker symbols differently,
> because of the Canadian default perspective.
>
> If I go there are type in just MCD, it brings up Macarthur Diamonds --
> TSX:MCD.
>
> If you want McDonald's, you need to use NYSE:MCD as the ticker symbol.
>
> On Mon, Jun 4, 2012 at 9:04 PM, Jacob Jose <pepecan47@yahoo.**ca<pepecan47%40yahoo.ca>>
> wrote:
>
> >
> >I nned to use AdvFN data, this is what I did:
> >
> >- Installed the SMF Add-in from the Works-In-Progress folder
> >- Copied the smf-elements-**1.txt from the Works-In-Progress folder to
> my SMF folder
> >- Created a file smf-AdvFN-prefix.**txt with the 2 characters "ca" in
> the SMF folder. I work from Canada.
> >
> >When using RCHGetElementNumber**-Template-**AdvFN-Financial-**Statements.
> **xls, it works fine with PG, JNJ but I cannot make it work with MCD.
> >
> >I can access the AdvFN web site and I see the data for MCD, but I get
> Erros in all cells when accesing from the template.
> >
> >Can somebody from Canada try the tempalte using MCD?x
> >
>
> Back to top <#137c0e474024d566_toc>
> Reply to sender
> <pepecan47@yahoo.ca?Subject=Re%3A%20Error%20on%20RCHGetElementNumber-Template-AdvFN-Financial-Statements>| Reply
> to group
> <smf_addin@yahoogroups.com?Subject=+Re%3A%20Error%20on%20RCHGetElementNumber-Template-AdvFN-Financial-Statements>| Reply
> via web post
> <http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJzazk5NnY5BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NQRzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMzM4OTcxMDIz?act=reply&messageNum=18865>
> Messages in this topic
> <http://groups.yahoo.com/group/smf_addin/message/18856;_ylc=X3oDMTM4dDJxanA1BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NQRzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxMzM4OTcxMDIzBHRwY0lkAzE4ODU2>(3)
> 3a. Re: ELEMENT FUNCTION LIST-1
> <http://groups.yahoo.com/group/smf_addin/message/18866;_ylc=X3oDMTJzcmRjZGRhBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NgRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMzM4OTcxMDIz> Posted
> by: "Randy H" rharmelink@gmail.com
> <rharmelink@gmail.com?Subject=+Re%3A%20ELEMENT%20FUNCTION%20LIST-1> rharmelink
> <http://profiles.yahoo.com/rharmelink> Tue Jun 5, 2012 12:50 pm (PDT)
>
>
> What do you get for the following:
>
> =RCHGetElementNumbe**r("Version"**)
> =smfGetAParms(**27)
> =RCHGetElementNumbe**r("MMM",27)
>
> PS: Please keep all add-in related queries on this forum. I found your
> message sent to me in my SPAM folder and could easily have deleted it
> without ever seeing it.
>
> On Tue, Jun 5, 2012 at 12:24 PM, David Nicholas <ufdn16@...
> <mailto:ufdn16@yahoo.**com <ufdn16%40yahoo.com>> > wrote:
> I imported the new element file found in work in process and extracted
> it into programs/smf_**addin folder.I have an excel worksheet that is
> populated with all sorts of data. Generally , very pleased.However, I
> just don't get it: code 25, 27,28,29 return error. I saw in another
> email that someone did the samething I did and was getting the price but
> it wasn't current.I don't even get that. Please explain how I can get
> the info I want. Thanks! David
>
> Back to top <#137c0e474024d566_toc>
> Reply to sender
> <rharmelink@gmail.com?Subject=Re%3A%20ELEMENT%20FUNCTION%20LIST-1> | Reply
> to group
> <smf_addin@yahoogroups.com?Subject=+Re%3A%20ELEMENT%20FUNCTION%20LIST-1>| Reply
> via web post
> <http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJzanByaGlyBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NgRzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMzM4OTcxMDIz?act=reply&messageNum=18866>
> Messages in this topic
> <http://groups.yahoo.com/group/smf_addin/message/18854;_ylc=X3oDMTM4bTdjYm4xBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NgRzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxMzM4OTcxMDIzBHRwY0lkAzE4ODU0>(3)
> 4a. Daily Prices and TTM Ratio Chart
> <http://groups.yahoo.com/group/smf_addin/message/18867;_ylc=X3oDMTJzYWJjOWw3BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NwRzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMzM4OTcxMDIz> Posted
> by: "invesco88" franklin.forward@gmail.com
> <franklin.forward@gmail.com?Subject=+Re%3A%20Daily%20Prices%20and%20TTM%20Ratio%20Chart> invesco88
> <http://profiles.yahoo.com/invesco88> Tue Jun 5, 2012 5:09 pm (PDT)
>
>
> I'm trying to duplicate the chart below in excel using ADVfin quarterly
> data and an import of Yahoo daily historical prices for a stock. The
> problem I'm running into is that I have two sets of data with different
> frequencies (daily prices and quarterly per share data) and I can't seem
> to get the daily change in the TTM ratio without manually copy/pasting,
> which isn't useful if you have to enter a different ticker with
> different quarterly dates. Does anyone have a solution for this? Ideally
> it would be easiest to use the RCHCreateComment function to pull it from
> a site that has this data available for free but I haven't found a site
> that has the daily Price/FCF TTM for free so I'm trying to build this
> into my valuation model. Thanks Randy for the Add-in, it's a life saver.
>
> Back to top <#137c0e474024d566_toc>
> Reply to sender
> <franklin.forward@gmail.com?Subject=Re%3A%20Daily%20Prices%20and%20TTM%20Ratio%20Chart>| Reply
> to group
> <smf_addin@yahoogroups.com?Subject=+Re%3A%20Daily%20Prices%20and%20TTM%20Ratio%20Chart>| Reply
> via web post
> <http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJzYzBqZ2l2BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NwRzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMzM4OTcxMDIz?act=reply&messageNum=18867>
> Messages in this topic
> <http://groups.yahoo.com/group/smf_addin/message/18867;_ylc=X3oDMTM4bW41a2o2BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2NwRzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxMzM4OTcxMDIzBHRwY0lkAzE4ODY3>(2)
> 4b. Re: Daily Prices and TTM Ratio Chart
> <http://groups.yahoo.com/group/smf_addin/message/18868;_ylc=X3oDMTJzdG1nOWRsBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2OARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMzM4OTcxMDIz> Posted
> by: "Randy Harmelink" rharmelink@gmail.com
> <rharmelink@gmail.com?Subject=+Re%3A%20Daily%20Prices%20and%20TTM%20Ratio%20Chart> rharmelink
> <http://profiles.yahoo.com/rharmelink> Tue Jun 5, 2012 5:55 pm (PDT)
>
>
> I would retrieve the FCF TTM and the posting date of same, then just align
> it up with the daily quotes. You should just be able to do a
> MATCH()/INDEX(**) or VLOOKUP() to find which FCF TTM applies to which
> historical quotes dates.
>
> On Tue, Jun 5, 2012 at 5:09 PM, invesco88 <franklin.forward@**gmail.com<franklin.forward%40gmail.com>
> >wrote:
>
> >
> > I'm trying to duplicate the chart below in excel using ADVfin quarterly
> > data and an import of Yahoo daily historical prices for a stock. The
> > problem I'm running into is that I have two sets of data with different
> > frequencies (daily prices and quarterly per share data) and I can't seem
> to
> > get the daily change in the TTM ratio without manually copy/pasting,
> which
> > isn't useful if you have to enter a different ticker with different
> > quarterly dates. Does anyone have a solution for this? Ideally it would
> be
> > easiest to use the RCHCreateComment function to pull it from a site that
> > has this data available for free but I haven't found a site that has the
> > daily Price/FCF TTM for free so I'm trying to build this into my
> valuation
> > model. Thanks Randy for the Add-in, it's a life saver.
> >
> Back to top <#137c0e474024d566_toc>
> Reply to sender
> <rharmelink@gmail.com?Subject=Re%3A%20Daily%20Prices%20and%20TTM%20Ratio%20Chart>| Reply
> to group
> <smf_addin@yahoogroups.com?Subject=+Re%3A%20Daily%20Prices%20and%20TTM%20Ratio%20Chart>| Reply
> via web post
> <http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJzY2ppOXNlBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2OARzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMzM4OTcxMDIz?act=reply&messageNum=18868>
> Messages in this topic
> <http://groups.yahoo.com/group/smf_addin/message/18867;_ylc=X3oDMTM4YXJ0Z2ZsBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARtc2dJZAMxODg2OARzZWMDZG1zZwRzbGsDdnRwYwRzdGltZQMxMzM4OTcxMDIzBHRwY0lkAzE4ODY3>(2)
> Recent Activity
>
> - 87
> New Members<http://groups.yahoo.com/group/smf_addin/members;_ylc=X3oDMTJncnU2bGpyBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxMzM4OTcxMDIz?o=6>
>
> Visit Your Group
> <http://groups.yahoo.com/group/smf_addin;_ylc=X3oDMTJmOWFocTdrBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzEzMzg5NzEwMjM->
> Yahoo! Finance
>
> It's Now Personal<http://global.ard.yahoo.com/SIG=15lkt8544/M=493064.14543953.14365457.8674578/D=groups/S=1705632198:NC/Y=YAHOO/EXP=1338978224/L=ee1a3146-afb0-11e1-bf15-43f5fe756ada/B=YkN5Bdj8fbQ-/J=1338971024192698/K=N2DklSJHI7qT7szT.vOtZw/A=4507179/R=0/SIG=12de4rskk/*http://us.rd.yahoo.com/evt=50284/*http://finance.yahoo.com/personal-finance>
>
> Guides, news,
>
> advice & more.
> New business?
>
> Get new customers.<http://global.ard.yahoo.com/SIG=15llbm1vn/M=493064.14543973.14365498.8674578/D=groups/S=1705632198:NC/Y=YAHOO/EXP=1338978224/L=ee1a3146-afb0-11e1-bf15-43f5fe756ada/B=Y0N5Bdj8fbQ-/J=1338971024192698/K=N2DklSJHI7qT7szT.vOtZw/A=3848640/R=0/SIG=131an6mds/*http://searchmarketing.yahoo.com/arp/srchv2.php?o=US2002&cmp=Yahoo&ctv=Groups1&s=Y&s2=&s3=&b=50>
>
> List your web site
>
> in Yahoo! Search.
> Yahoo! News
>
> Get it all here<http://global.ard.yahoo.com/SIG=15lfu3iut/M=493064.14543974.14365499.8674578/D=groups/S=1705632198:NC/Y=YAHOO/EXP=1338978224/L=ee1a3146-afb0-11e1-bf15-43f5fe756ada/B=YUN5Bdj8fbQ-/J=1338971024192698/K=N2DklSJHI7qT7szT.vOtZw/A=3848627/R=0/SIG=10obc6i69/*http://news.yahoo.com/>
>
> Breaking news to
>
> entertainment news
> Need to Reply?
>
> Click one of the "Reply" links to respond to a specific message in the
> Daily Digest.
> Create New Topic
> <http://groups.yahoo.com/group/smf_addin/post;_ylc=X3oDMTJmbWg1NG5xBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNudHBjBHN0aW1lAzEzMzg5NzEwMjM->| Visit
> Your Group on the Web<http://groups.yahoo.com/group/smf_addin;_ylc=X3oDMTJkZjM4ZzI1BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNocARzdGltZQMxMzM4OTcxMDIz>
> Messages<http://groups.yahoo.com/group/smf_addin/messages;_ylc=X3oDMTJmNmJpcmdoBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNtc2dzBHN0aW1lAzEzMzg5NzEwMjM->|
> Files<http://groups.yahoo.com/group/smf_addin/files;_ylc=X3oDMTJnbXFzZmczBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNmaWxlcwRzdGltZQMxMzM4OTcxMDIz>|
> Photos<http://groups.yahoo.com/group/smf_addin/photos;_ylc=X3oDMTJmM2E0cmpoBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNwaG90BHN0aW1lAzEzMzg5NzEwMjM->|
> Polls<http://groups.yahoo.com/group/smf_addin/polls;_ylc=X3oDMTJnczYzYWY1BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNwb2xscwRzdGltZQMxMzM4OTcxMDIz>
> [image: Yahoo! Groups]<http://groups.yahoo.com/;_ylc=X3oDMTJlNnI3dW50BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTMzODk3MTAyMw-->
> Change settings via the Web<http://groups.yahoo.com/group/smf_addin/join;_ylc=X3oDMTJnN2FzZGYxBF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNzdG5ncwRzdGltZQMxMzM4OTcxMDIz>(Yahoo! ID required)
> Change settings via email: Switch delivery to Individual<smf_addin-normal@yahoogroups.com?subject=Email+Delivery:+Indiviual+Email>| Switch
> format to Traditional<smf_addin-traditional@yahoogroups.com?subject=Change+Delivery+Format:+Traditional>
> Visit Your Group
> <http://groups.yahoo.com/group/smf_addin;_ylc=X3oDMTJla3I0OWo2BF9TAzk3MzU5NzE1BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNocGYEc3RpbWUDMTMzODk3MTAyMw-->| Yahoo!
> Groups Terms of Use <http://docs.yahoo.com/info/terms/> | Unsubscribe
> <smf_addin-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>

--
Tom Ellis
707-347-9550
mrtomellis@gmail.com
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
3a.

Re: Daily Prices and TTM Ratio Chart

Posted by: "invesco88" franklin.forward@gmail.com   invesco88

Wed Jun 6, 2012 5:11 pm (PDT)



Randy thanks for the response. I'm still having trouble getting the
Index/Match functions to behave correctly. I'm trying to write one
formula that will match the correct TTM Cash Flow per share value to the
corresponding daily prices for that specific quarter. I've been able to
do it with different formulas but if I change the ticker the dates
obviously change and then I'm back to square one. I've attached a
screenshot of the workbook. Any help or direction in writing a formula
would be much appreciated. Thanks again.
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3b.

Re: Daily Prices and TTM Ratio Chart

Posted by: "Randy H" rharmelink@gmail.com   rharmelink

Wed Jun 6, 2012 5:20 pm (PDT)



It would be easier if you uploaded a sample workbook with data.

--- In smf_addin@yahoogroups.com, "invesco88" <franklin.forward@...>
wrote:
>
> Randy thanks for the response. I'm still having trouble getting the
> Index/Match functions to behave correctly. I'm trying to write one
> formula that will match the correct TTM Cash Flow per share value to
the
> corresponding daily prices for that specific quarter. I've been able
to
> do it with different formulas but if I change the ticker the dates
> obviously change and then I'm back to square one. I've attached a
> screenshot of the workbook. Any help or direction in writing a formula
> would be much appreciated. Thanks again.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

company name

Posted by: "perpetualcfa" perpetualcfa@yahoo.com   perpetualcfa

Wed Jun 6, 2012 6:52 pm (PDT)



the company name functions don't seem to be working. do you have any advice?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: company name

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 6, 2012 6:53 pm (PDT)



Without any additional specifics:

=RCHGetYahooQuotes("MMM","n")

On Wed, Jun 6, 2012 at 6:43 PM, perpetualcfa <perpetualcfa@yahoo.com> wrote:

> the company name functions don't seem to be working. do you have any
> advice?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5a.

function smfPricesBetween() not working for me, why?

Posted by: "investor952" investor952@yahoo.com   investor952

Wed Jun 6, 2012 7:42 pm (PDT)



I am using Windows 7 and Excel 2010.

I am using the function (in an array):

=smfPricesBetween(C8,TODAY()-10,TODAY(),"0708")

where the value in c8 is FSENX. The "0708" means
I want the closing date and the closing price.

I get the following results in my spreadsheet
for 10 periods..(rows)...

fsenx


item Date Close
1 41066 45.42
2 41066 45.42
3 41066 45.42
4 41066 45.42
5 41066 45.42
6 41066 45.42
7 41066 45.42
8 41066 45.42
9 41066 45.42
10 41066 45.42

Note..my spreadsheet is set for automatic calculation.

Why is each day's results the same?...I realize that I have to
format the date column to date.

I entered the equation using ctl-shift-enter to get the array but
all the rows populate with the same date and close...why? How can I fix this? thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5b.

Re: function smfPricesBetween() not working for me, why?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 6, 2012 7:55 pm (PDT)



Why do you have 10 rows? The function is only returning two data items.

On Wed, Jun 6, 2012 at 7:42 PM, investor952 <investor952@yahoo.com> wrote:

> I am using Windows 7 and Excel 2010.
>
> I am using the function (in an array):
>
> =smfPricesBetween(C8,TODAY()-10,TODAY(),"0708")
>
> where the value in c8 is FSENX. The "0708" means
> I want the closing date and the closing price.
>
> I get the following results in my spreadsheet
> for 10 periods..(rows)...
>
> fsenx
>
>
> item Date Close
> 1 41066 45.42
> 2 41066 45.42
> 3 41066 45.42
> 4 41066 45.42
> 5 41066 45.42
> 6 41066 45.42
> 7 41066 45.42
> 8 41066 45.42
> 9 41066 45.42
> 10 41066 45.42
>
>
> Note..my spreadsheet is set for automatic calculation.
>
> Why is each day's results the same?...I realize that I have to
> format the date column to date.
>
> I entered the equation using ctl-shift-enter to get the array but
> all the rows populate with the same date and close...why? How can I fix
> this? thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5c.

Re: function smfPricesBetween() not working for me, why?

Posted by: "investor952" investor952@yahoo.com   investor952

Wed Jun 6, 2012 8:02 pm (PDT)



Hello Randy..

OK..I must misunderstand something..

I want, say, the last 10 days dates and closing prices for the given ticker..in this case, FSENX (a mutual fund).

If this is not the correct function to use for this..which one would you suggest. In reality, I need more than 10 days of price data..but this is an example.

Note..in my excel sheet, I did input the formula as an array..but when i copy pasted the formula into this message board, the left and right squiggles that identify it as an array didn't print out.

I thought that if i entered it as an array..it would print out each day's data by date. Pls advise. thx.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Why do you have 10 rows? The function is only returning two data items.
>
> On Wed, Jun 6, 2012 at 7:42 PM, investor952 <investor952@...> wrote:
>
> > I am using Windows 7 and Excel 2010.
> >
> > I am using the function (in an array):
> >
> > =smfPricesBetween(C8,TODAY()-10,TODAY(),"0708")
> >
> > where the value in c8 is FSENX. The "0708" means
> > I want the closing date and the closing price.
> >
> > I get the following results in my spreadsheet
> > for 10 periods..(rows)...
> >
> > fsenx
> >
> >
> > item Date Close
> > 1 41066 45.42
> > 2 41066 45.42
> > 3 41066 45.42
> > 4 41066 45.42
> > 5 41066 45.42
> > 6 41066 45.42
> > 7 41066 45.42
> > 8 41066 45.42
> > 9 41066 45.42
> > 10 41066 45.42
> >
> >
> > Note..my spreadsheet is set for automatic calculation.
> >
> > Why is each day's results the same?...I realize that I have to
> > format the date column to date.
> >
> > I entered the equation using ctl-shift-enter to get the array but
> > all the rows populate with the same date and close...why? How can I fix
> > this? thanks.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
5d.

Re: function smfPricesBetween() not working for me, why?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 6, 2012 9:22 pm (PDT)



smfPricesBetween() SUMMARIZES the data between the two dates -- open for
the period, close for the period, highest high for the period, etc.

If you just want the latest 10 days of quotes, array-enter
RCHGetYahooHistory() over 10 rows. You don't even need to specify any dates.

On Wed, Jun 6, 2012 at 8:02 PM, investor952 <investor952@yahoo.com> wrote:

>
> OK..I must misunderstand something..
>
> I want, say, the last 10 days dates and closing prices for the given
> ticker..in this case, FSENX (a mutual fund).
>
> If this is not the correct function to use for this..which one would you
> suggest. In reality, I need more than 10 days of price data..but this is an
> example.
>
> Note..in my excel sheet, I did input the formula as an array..but when i
> copy pasted the formula into this message board, the left and right
> squiggles that identify it as an array didn't print out.
>
> I thought that if i entered it as an array..it would print out each day's
> data by date. Pls advise. thx.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
6a.

Trouble getting some information from a Morningstar site

Posted by: "sharkshockey83" srichards83@gmail.com   sharkshockey83

Wed Jun 6, 2012 10:16 pm (PDT)



I'm having trouble extracting a piece of information from a Morningstar website. The website is http://findingmoats.morningstar.com/littlebook_intro.aspx?p=1. You have to be logged in to access the information, but even when I log in and refresh my Excel spreadsheet the formula is returning "Error". The piece of information I want is the economic moat. Basically, in the example below I'm looking to get the "Wide" returned to my spreadsheet. Another thing that might be complicating matters is that the information appears on the page twice. So far I have tried:

=RCHGetWebData("http://findingmoats.morningstar.com/tool/littlebook.aspx?p=1&symbol="&'Model Selection'!$H$2,">Economic Moat",1)

and

=smfGetTagContent("http://findingmoats.morningstar.com/tool/littlebook.aspx?p=1&symbol="&'Model Selection'!$H$2,"span",1,">Economic Moat")

Here are the two places in the source code that the information I want shows up:

<div class="lb_layer5">
<p class="lb_title"><strong><span id="ctl00_ContentPlaceHolder1_lblSecname">Microsoft Corporation</span>
<span id="ctl00_ContentPlaceHolder1_lblTicker">MSFT</span></strong>
<span id="ctl00_ContentPlaceHolder1_lblExchange">XNAS</span><br>
<strong>Economic Moat</strong> <span id="ctl00_ContentPlaceHolder1_lblMoat">Wide</span>
<br>
</div>

A little bit later the information appears again:

<div class="lb_layer7">
<div class="lb_row">
<div class="lb_dataP">Economic Moat</div>
<div class="lb_data2"><span id="ctl00_ContentPlaceHolder1_lblMoat2">Wide</span></div>
</div>

Is there anyway to get this info (the "Wide")?

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: Trouble getting some information from a Morningstar site

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Wed Jun 6, 2012 10:55 pm (PDT)



Several items:

- If the data is displayed dynamically, you're not going to be able to
retrieve it with the add-in.

- You say "refresh" -- that would be with the smfForceRecalculation
macro, correct?

- Logging in with something like FireFox won't do the trick. Preferably,
you should use the EXCEL Web Query dialog, but generally IE will do the the
trick.

- To see if you can even retrieve the web page, try RCHGetWebData() with
just the URL and no other parameters.

On Wed, Jun 6, 2012 at 10:14 PM, sharkshockey83 <srichards83@gmail.com>wrote:

> I'm having trouble extracting a piece of information from a Morningstar
> website. The website is
> http://findingmoats.morningstar.com/littlebook_intro.aspx?p=1. You have
> to be logged in to access the information, but even when I log in and
> refresh my Excel spreadsheet the formula is returning "Error". The piece of
> information I want is the economic moat. Basically, in the example below
> I'm looking to get the "Wide" returned to my spreadsheet. Another thing
> that might be complicating matters is that the information appears on the
> page twice. So far I have tried:
>
> =RCHGetWebData("
> http://findingmoats.morningstar.com/tool/littlebook.aspx?p=1&symbol="&'Model
> Selection'!$H$2,">Economic Moat",1)
>
> and
>
> =smfGetTagContent("
> http://findingmoats.morningstar.com/tool/littlebook.aspx?p=1&symbol="&'Model
> Selection'!$H$2,"span",1,">Economic Moat")
>
> Here are the two places in the source code that the information I want
> shows up:
>
> <div class="lb_layer5">
> <p class="lb_title"><strong><span
> id="ctl00_ContentPlaceHolder1_lblSecname">Microsoft Corporation</span>
> <span id="ctl00_ContentPlaceHolder1_lblTicker">MSFT</span></strong>
> <span id="ctl00_ContentPlaceHolder1_lblExchange">XNAS</span><br>
> <strong>Economic Moat</strong> <span
> id="ctl00_ContentPlaceHolder1_lblMoat">Wide</span>
> <br>
> </div>
>
> A little bit later the information appears again:
>
> <div class="lb_layer7">
> <div class="lb_row">
> <div class="lb_dataP">Economic Moat</div>
> <div class="lb_data2"><span
> id="ctl00_ContentPlaceHolder1_lblMoat2">Wide</span></div>
> </div>
>
>
> Is there anyway to get this info (the "Wide")?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Get it all here

Breaking news to

entertainment news

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.23

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)