Hi Randy & all, I have downloaded the add-in just in order to view a spreadsheet based on Graham's formula. I find the add-in very useful and interesting, so I...
Hi guys, Is there any way to modify this template: RCHGetTableCell-Template-Reuters-Annual-Financials.xls which retrieves annual financial information,...
Yes and no. A similar template can be set up -- to retrieve all the lines of the financial statement regardless of their content. However, since MSN nests...
I have been playing with the valuepro excel template and it is fantastic. Quick (and probably dumb) question. What does PIGR stand for (plug in growth rate to...
Randy, this is (polite cough) somewhat off topic but I was wondering if you knew how to (or even if it's possible) to post a message to a Yahoo Group...
I don't see why not -- as long as the group allows email posting (some don't). It would just be a matter of sending the email to that group email posting...
Hi, I'm thinking about translating your code to VB.NET and post it on CodeGallery (http://code.msdn.microsoft.com/). Obviously I'll give you all the credit for...
Hi, I'm thinking about porting your code to VB.NET and post it on CodeGallery. I will give you all the credit for it and point people to this group. I assume...
I used parameters 7789-7795 and 6589-6605 to extract ROCI and free cash flow respectively (from ADVFN website). When I checked them with data from website,...
More details needed. Is your problem that you have the element numbers incorrect? I see ROCI as elements 7786-7795 and free cash flow as elements 6596-6605. ...
Randy, sorry to bother you on this again. I used your code and get the message "The transport failed to connect to the server". Areas of contention are 1. I...
On Sat, Apr 4, 2009 at 6:16 AM, John French ... It's just a convenience thing for me. When I change it between the various values, it automatically changes...
Other than actual SEC filings, does anyone know of sources on the web for "as reported" (i.e. non-standardized) financial statements, that precisely match the...
does smfGetCSVFile always return a 200x100 array? for example, data = smfGetCSVFile("http://www.google.com/finance/historical?q=NYSE:GKK&output=csv") this...
Sorry, but smfGetCSVFile() wasn't set up to be used in a VBA process that way. However, all the smfGetCSVFile() function does is call the RCHGetYahooQuotes()...
Randy, I've been using RCHGetYahooHistory for about a year to backtest ideas for various markets and it's worked great. I run a macro to send a list of...
Sorry, but when you get to that level of activity, any number of things could be happening. I think you'd be better off with a different tool, say something...
yep, that worked! now im gonna write a simple csv function that takes a url, row dim, col dim and have it call RCHGetYahooQuotes w/ that info. once again,...
Randy, Do any of your macros access data from Investors Business Daily? In particular data from Stock Checkup. Stock Checkup can be accessed only if you are...
I used the EXCEL Web Query process to login, then used the URL you gave below to extract data. I was able to. For example: Composite Rating 50 61 EPS Rating...
Is there a way to access financial data related to companies based in Europe (Germany, Norway, UK etc)? I am especially interested in balance sheet, income...
If AdvFN has the data for the companies you're interested in, you should be able to grab it. It would just be a matter of changing the URL's and/or symbols....
I test the getelementnumber function via advfn for some blue chips tickers (e.g. XE:SIE) but this does not seem to work. Will try the other services as well...
RCHGetElementNumber() may not work. There may be other parameters that need to be changed for foregign companies, which RCHGetElementNumber() is not set up to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
