Thanks, Randy. It looks like things might be clearing up on their end - - I've had no problems yesterday or today so far. I'll probably jinx myself by saying...
All, Does anyone know of a good Web-based source for historical financial data for public companies (sans the SEC, too cumbersome). I have been using ADVFN,...
Randy, Could you post a simple example of how to get intrinsic value data from this site, by passing in an assumed growth rate and an 8% discount rate: sTemp =...
I assume you are wanting to get IV on a single issue. To access the seceval site, you only need Quicken software (any) and you need to register it. Mine came...
Just use the 9th parameter ("Data Items") to specify the order you want. The default value is "DOHLCVA", but if you want to see Date/Volume/Open/Low/Close,...
Has anyone every gotten these functions working for open office? I was trying them out and can see where they could be extremely helpful in my research, but...
A better solution may be to simply calculate it yourself. Does the website have any documentation on how the calculation is being done? There are MANY forms...
Here is the cut and paste for the stock: KO I think they do a 2 stage DCF calculation. Calculate Intrinsic Value/Share Initial earnings: Earnings growth rate...
Randy, I am trying to use your template as the "get-data source" for a 20MB spreadsheet with lots of sheets and macros relying on it. I copied all of your...
Well, if you're using the smfGetYahooHistory() module, the add-in itself is irrelevant to the process. And I'm not sure what you mean by "defined the name...
Hi, Randy! Here's an easy one. I have used RCHGetYahooHistory to obtain a historical quote. How do I adjust for dividends? For example, I am interested in...
There is a parameter to tell RCHGetYahooHistory() to adjust the O/H/L/C prices. Or you could just get the adjusted closing price directly. For example, the...
How about between two dates that aren't year end or quarter end? For example is there an easy way to figure out total return of say, GE between 3/23/06 and...
You should be able to use the adjusted closing prices between two dates to include the effect of dividends -- the earlier price will be adjusted for any...
I've been trying (to no avail) to find a way to programmatically enter an array-entered functions (RCHGetTableCell specifically), and am hoping for some help...
It's definitely possible. How to do it depends on exactly what you want to do though. A simple example would be something like: Sub Test() For Each oCell In...
Well, this *does* work, but something is off, and I'm pretty sure it's not me (nor do I think it is the AddIn). In an empty sheet, I've got this code being...
Typically, the dimensions of the returned table is set by the range the function is array-entered over. Since you are doing it programmatically instead of as...
Here is the link to the help page (username, password is not required): http://help.quicken.com/support/investments/stkeval/help/intrinsic.q.calc.html I...
Thanks! Works beautifully. -- Shreeder ("adiabatic") ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Monday, February 5,...
I totally agree with the previous post. It looks like they suggest 15% discount rate as a base, then adjust upwards if firm age < 9yrs. My opinion is thats...
..........but my point is that valuation techniques need to be broad and encompassing so that implications of the input assumptions can be understood...
My version of fcffginzu.xls is 14mb big and also contains proprietorial data from S&P that I won't be able to share with this group. Maybe Mr/Ms Tmuller2's...
