It also worked for me. After changing the link to the SMF addin location. Kermit From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf...
18812
Christina Guo
cguo563
Jun 1, 2012 4:58 pm
I restarted my computer and loaded it again. Perfect. Thanks so much. ________________________________ From: Kermit W. Prather <kermitp@...> To:...
18813
rebalance85
Jun 2, 2012 4:50 am
Hello, Randy! I downloaded "RCHGetTableCell-Template-MSN-Financial-Statements", and find some cell value is #value!, but I couldn't find the problem. Period...
18814
Randy Harmelink
rharmelink
Jun 2, 2012 5:05 am
That formula works fine for me for ticker symbol MMM....
18815
rebalance85
Jun 2, 2012 5:05 am
Hi! I just download "Cash_Flow Model_v17" written by Turley M Muller. And you see the link of MSN Finance has been changed, I corrected most of them, but I...
18816
rebalance85
Jun 2, 2012 5:15 am
Mine is not working, #value!. Is there any other formula to replace this one?...
18817
rebalance85
Jun 2, 2012 5:28 am
I try =DATEVALUE(12/31/2011), it seems that the excel couldn't reconige the 12/31/2011....
18818
Randy Harmelink
rharmelink
Jun 2, 2012 6:18 am
That's the same reason I had to redefine so many elements. MSN has revamped their website structure. So you would need to remap all of the URL references in...
18819
Randy Harmelink
rharmelink
Jun 2, 2012 6:19 am
You must not be using U.S. Regional settings. Just take off the DATEVALUE() function and leave the date as a string literal....
18820
rebalance85
Jun 2, 2012 7:50 am
Thanks Randy. You see from the formula, it will get the " per share items" in the annual incom statement, but I couldn't find this item in that page. That's my...
18821
Randy Harmelink
rharmelink
Jun 2, 2012 8:08 am
Not precisely sure what it's picking up -- try: =RCHGetTableCell(" http://investing.money.msn.com/investments/stock-income-statement/?symbol=MMM";,-1,"Period ...
18822
antonvanas1989
Jun 2, 2012 9:42 am
Dear Randy, how can i get the latest outstanding shares from any stock from google finance? Example WMT: http://www.google.com/finance?cid=38230# It shows...
18823
antonvanas1989
Jun 2, 2012 9:56 am
Randy, i have today downloaded the new Text 1 file again (with closing excel and deleting older file), and still the #25 element and the #13862 are not...
It is OK now. I find another formula get result ERROR: =RCHGetTableCell("...
18826
Randy Harmelink
rharmelink
Jun 2, 2012 10:44 am
What version of EXCEL do you have? What do you get for: =RCHGetElementNumber("Version") =smfGetAParms(13862) =RCHGetElementNumber("MMM";,13862) ...
18827
Randy Harmelink
rharmelink
Jun 2, 2012 10:46 am
Your search string is not what MSN is using as the label -- try: =RCHGetTableCell(" ...
18828
antonvanas1989
Jun 2, 2012 10:56 am
Stock Market Functions add-in, Version 2.1.2010.08.02 (Nothing) Error 3M Co Bad move from MSN then... Hope they will fix it soon....
18829
antonvanas1989
Jun 2, 2012 11:03 am
=smfGetAParms(13862) it now gives this: MSN;Company...
18830
Randy Harmelink
rharmelink
Jun 2, 2012 3:40 pm
But does element 13862 now work? The "nothing" return you got before would indicate no element definition was loaded. You are running with a very old copy of...
18831
cherry77tree
Jun 2, 2012 7:52 pm
Is there a way to return a stock's listing exchange? (e.g., "IBM" would return NYSE, "CMMCY" would return Pink or OTC) I thought =RCHGetElementNumber("IBM";,3)...
18832
Randy Harmelink
rharmelink
Jun 2, 2012 8:45 pm
You probably need the new MSN element definitions file from the "Works in Progress" folder: http://finance.groups.yahoo.com/group/smf_addin/message/18529 On...
18833
rebalance85
Jun 3, 2012 10:37 am
Thank you very much, it is ok now. When I use the number to calculate some ratios, I met this problem, for example: ...
18834
Randy Harmelink
rharmelink
Jun 3, 2012 3:21 pm
Check out the documentation for the function, you can have the function return something other than "Error" if you want, when there is an error....
18835
ufdn16
Jun 3, 2012 9:19 pm
The element number 25 is not functioning in my worksheet any longer. How do I now get the current price? Thanks, David...
18836
Randy Harmelink
rharmelink
Jun 3, 2012 9:20 pm
Use the RCHGetYahooQuotes() function. It's what it is intended for....
18837
antonvanas1989
Jun 3, 2012 9:39 pm
The element 13862 still not working.. It now says "Print" Btw i have updated the RCH module by now, i'm using europe setting so i'm not realy looking for new...
18838
Randy Harmelink
rharmelink
Jun 3, 2012 9:47 pm
You get "Print" for ticker MMM on element #13862? I can't give any advice on non-U.S. conversions. It's not an area I want to get into. ... You get "Print" for...
18839
oryxius
Jun 4, 2012 4:37 am
Any idea where to find the industry Cash Flow/Sales ratio? Any website providing this ratio?...
