Hi - THanks for a fantastic tool. I've learn a lot from the folks that post. Was wondering if there was a website or field that pulls Proforma EPS numbers? ...
18738
Clark F. Grain
cgrain76
May 25, 2012 1:46 pm
I forgot to give instructions. Open the Start tab and type in the stock symbol in the upper left cell (Blue) press enter and wait about 30 seconds or so for...
18739
Randy Harmelink
rharmelink
May 25, 2012 1:55 pm
I don't even know what that would be......
18740
Juan
juangecko
May 25, 2012 4:04 pm
hello, i would like to know if it is possible to get the market cap for a specific date for a US stock. I am able to do it for the price......
18741
Jim
buckleca
May 25, 2012 4:07 pm
I'm using smfStrExtr to extract what I need from the search. The search finds: "45201020 - Communications Equipment" I'd like to extract "Communications...
18742
Randy Harmelink
rharmelink
May 25, 2012 4:09 pm
You would need to create it yourself by retrieving the price that way, but you would also need to get the number of shares from another source -- which isn't...
18743
Randy Harmelink
rharmelink
May 25, 2012 4:13 pm
The technique I use is to append a dummy string value to the end (or to the beginning if I need something there). I usually use "|" because it's not typically...
18744
Juan
juangecko
May 25, 2012 4:30 pm
Thanks Randy for your quick reply. i would only need the number of shares of their latest earnings report. also what the formula to get today's outstanding...
18745
Jim
buckleca
May 25, 2012 4:30 pm
Ingenious guy you are! In my formula: =+smfstrextr(GetNameExSW(+$A8,"c","Sector",2)& "|", "- ","|") returns: "Communications Equipment" Many Thanks...
18746
Randy Harmelink
rharmelink
May 25, 2012 4:33 pm
Check the list of elements that came with the add-in. There are a few choices, so I'm not sure which number of shares would be the appropriate one to use....
18747
Lucky Pierre
pierre_powell
May 25, 2012 5:32 pm
My excel (2010) will no longer pull down certain numbers. For example, the rchgetelementnumber function won't pull company name, dividends from msn or other...
Thanks Randy, I updated this file with no avail. I am also having problems bringing down from non-msn sites. I reinstalled and seem to be stuck. The...
18750
Malcolm
malcolmdlphi...
May 25, 2012 6:07 pm
Is there an explanation somewhere of how the SMF functions work? I am wondering if they can be ported to Perl or other scripting language. Does anyone know if...
18751
Randy Harmelink
rharmelink
May 25, 2012 6:13 pm
All of those element numbers are working fine here for ticker MMM. Only 989 is non-MSN. What do you get for: =RCHGetElementNumber("Version") ...
18752
Randy Harmelink
rharmelink
May 25, 2012 6:14 pm
The VBA code is open source, so that would be how they work....
18753
Lucky Pierre
pierre_powell
May 25, 2012 6:37 pm
I solved the problem. My permissions were denying me the ability to save the new smf-elements-1 file. I had to move the smf folder out of programs to get the...
18754
Kermit W. Prather
kermitpra
May 26, 2012 1:56 pm
Clark, thanks, I just downloaded both versions. They both work well. However, they both have problems on stocks that were listed after 2007, such as AGNC. ...
18755
rebalance85
May 26, 2012 2:34 pm
Hi Randy. I couldn't find some template about the SmartMoney Source. I am now working on the financial statements. 1....
18756
Randy Harmelink
rharmelink
May 26, 2012 3:27 pm
The appropriate place for discussion would be: http://tech.groups.yahoo.com/group/xltraders/ On Sat, May 26, 2012 at 6:56 AM, Kermit W. Prather ... The...
18757
Randy Harmelink
rharmelink
May 26, 2012 3:30 pm
Answers: 1. Use two search strings for the second item. Both can be "Depreciation". 2. The XLS file is just documentation. Nothing needs to go into it for your...
18758
rebalance85
May 26, 2012 4:08 pm
Many thanks. 2 and 3 solved. Question 1 is still problem, the second line, I use Depreciation Depreciation, the result is error. Could you please give me an...
18759
Randy Harmelink
rharmelink
May 26, 2012 6:18 pm
You can retrieve the first depreciation item with: =RCHGetTableCell(" http://www.smartmoney.com/quote/IBM/?story=financials&opt=YI ",5,"Depreciation") ...and...
18760
B B
kokdari82
May 26, 2012 11:53 pm
Since ADVFN seems to be the most stable of data sources at the moment, I'm trying to extract the basic stats from advfn but I'm having trouble extracting the...
18761
Randy Harmelink
rharmelink
May 27, 2012 12:14 am
You can use RCHGetTableCell() for both. However, you're still going to have to do manual extraction of the data you want because of the way it's presented...
18762
redcorolla9999
May 27, 2012 6:53 am
Hi, In Reuters (and most other sources), the cumulative data is given for the quarterly cash-flow statements. Does anyone know a good general way to convert...
18763
MikeM
mikemcq802
May 27, 2012 12:56 pm
Retrieve the last 5 quarters of data and include the quarterly period number from AdvFN. Put them in sequence. Example Quarter, Cash From Ops 2 120 ...
18764
B B
kokdari82
May 27, 2012 8:34 pm
perfect. Thank you. I was using 1 instead of 0 which kept throwing me off....
18765
dice962
May 27, 2012 11:38 pm
Thanks, solved my MSN updates. Thanks for all the hardwork on the add in !!!...
18766
Gordon
gordonjones123
May 28, 2012 3:22 pm
With formula =RCHGetElementNumber($E$6,1,"Error";) I used to get Company Description. I also can't get last price using the formula above using 25 as the...
