Yes. I check three tickers: IBM: NYSE/LSE; ANV: AMEX/TSE; CYAN: NASDAQ/LSE. So, if it's possible help me to update the template, correct the ticker as:...
Hello all, I am not sure about what you are trying to accomplish. I think you are interested in downloading financial data, for specific companies, in order...
Thank you very much for your kindess. We want to have 10 years financial statments, the goal is the same, find, analysis, buy and sell. I want to put some tab...
Randy, I have extracted the files within Works In Progress created on April 7,2012, "RCH_Stock_Market_Functions-2.1.2012.04.07.zip" to the following location...
I know nothing about Win7 or EXCEL 2010. On Vista, I would just tell FireFox to download the file, and then drag and drop it into the folder from where it was...
Just use it as your ticker symbol when accessing AdvFN data. I think you're going to need to use the exchange for all ticker symbols, since you don't know what...
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? ...
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...
I'm using smfStrExtr to extract what I need from the search. The search finds: "45201020 - Communications Equipment" I'd like to extract "Communications...
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...
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...
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...
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....
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...
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...
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...
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. ...
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...
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...
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...
You can retrieve the first depreciation item with: =RCHGetTableCell(" http://www.smartmoney.com/quote/IBM/?story=financials&opt=YI ",5,"Depreciation") ...and...
