I am getting the #Name? error message when trying to run this. I have run throught the download procedures a couple times just to be sure. I installed a...
Typically, #NAME? means the add-in functions aren't available due to some type of problem with the installation and/or activation of the add-in. However, if...
Thanks for the help..I wrote the email in a starbucks and had typos etc...reloaded and seems to work just fine. Sorry for the confusion on my first post in...
The main problem you're having is because the contact information isn't being presented as individual items within a table. It's all presented as a single...
Hi Randy: One last market volatility question - if I wanted to get the CBOE closing VIX number, what would I add after the URL? I currently have this, but it's...
I think the only problem is you used an incorrect URL. Try this: =RCHGetTableCell("http://www.cboe.com/data/mktstat.aspx", 4,">VIX - CBOE Volatility...
Randy: When you gather balance sheet and/or cash flow statement numbers, which group of element numbers with SMFUpdateDownload do you use with the fewest data...
It depends on how much data I want, and other considerations. If I want more data -- years and/or quarters -- then AdvFN is the only option. Otherwise, I...
Randy, Need your help on this one. My goal is to put in a ticker symbol and get the symbols of its competitors. I have found SmartMoney to be the best for...
First -- have you looked at this file in the "RCHGetTableCell Templates" of the folder area: RCHGetTableCell-Template-Yahoo-Industry-Browser-For-Ticker.xls It...
This should be an easy one (not for me, though..) I have a 1D array of weekly returns (in percent): 0.02 0.018 0.012 -0.03 To calculate compounded return I...
I do that all the time, with an array-entered function. For example, if your weekly returns are in cell D9:G9, you'd array-enter this: =PRODUCT(1+D9:G9)-1 ...
okay, i've been pulling out my hair for several hours trying to get this to work. i created several spreadsheets using the smf add in with earlier versions of...
For some reason it doesn't work for me. To simplify: 5 7 35 6 1st line: data 2nd: =PRODUCT(A3:B3) 3rd: =PRODUCT(1+A3:B3) I also tried: =PRODUCT(1+(A3:B3)) but...
I get 48. It looks like you're not array-entering the formula. You need to press Ctrl-Shift-Enter instead of just Enter after typing in the formula....
this is something i encounter quite often, but still don't have a good and clean fix. the latest application can be illustrated in the file i downloaded from...
... Randy, first I'd like to say that you are the most helpful person I've ever seen on the 'net. Thank you for all your contributions. Related to arvin0's...
I didn't see where he was asking about the AVERAGE return, just the compounded return? I usually just add exponentiation to get the average compounded return,...
oh, i assumed you knew about his site. zeelotes doesn't want people to post the website address in public forum. one needs to send him an email and request for...
I've got it working just fine. Trying to remember how I did it is a different matter. I know it was a tough go for me as well. A couple of pieces I do...
The issue isn't to get RANK() to avoid cells with non-numerical values, but that the cell contain cells with calculation errors. That automatically causes...
