... Hi Randy, I understand that you are relunctant to try different tricks I sent you. May I just add that these tricks doesn't arm your addin behaviour using...
Randy, thx for the answer. I asked bc I'm familiar with the 2 strategies. I've read the studies. JB ... For more detailed information on what they actually...
Greetings, I just came across this wonderful group, and I hope that one or more of you can be of assistance to me. I have downloaded and installed the add-in,...
hope some of this is helpfull to do what you want does not require a Yahoo ID nor do you need to be signed in to anything. the spreadsheet has to be set up a...
... One of the reasons I started writing my own code to replace the queries, which gave birth to the add-in. ... In order to get the information using the...
Martin, I have posted my file to the upload area, it is called Aerospace.xls. I did not check the option to announce it to the entire group. Thanks you your...
Randy, Thanks for the wonderful reply. I have attempted to understand the arrays, but I am failing to understand them fully, yet. What I have done, hopefully...
... I moved your file to the "Requested Samples" folder in the files area. After modifying it to add the appropriate formula and its needed inputs, I also...
... 1,"",1) Randy, I tried to retrieve the top table from the web-site www.indexarb.com, it worked before but I put it aside to work on other stuffs. And now...
The "#NAME?" error is what you get when it can't find the function name. Have you moved or renamed the add-in since you created the formula in the original...
Randy I also get the #name error while a spreadsheet with many many "RCH" formulas is waiting to process each one. If I wait long enough (sometimes as much as...
Yes, I did move the add_in function to another location in my C-drive, the program file>SMF Add-in you recommend so I can have the access in my office's...
I made a slight modification to these templates -- the headings (e.g. "Quarterly Income Statement") now contain hyperlinks to the web page the data is...
Hi Randy Can we use the RCHGetHTMLTable function in such a way that "IBM" is replaced by Sticker as a reference to a named cell? I tried the following and it...
Yes, you can -- as Dale's example shows (thanks Dale). You just have to remember that you're concatenating the ticker symbol to the rest of the string. As...
Hey Folks, first of all, thanks a lot for this great tool! I have to write an empirical paper for an investment banking seminar at my university and hope to...
I would think the easiest thing to do would be to use a ticker symbol that the current function would recognize. For example, I am able to get the history for...
thanks a lot for the quick answer, I'll try it out as soon as I am back home. Using the american version with the ticker symbol might be allright. But your...
I'm trying to create a template to pull in Morningstar Financial statement data using RCHGetTableCell, but for some reason I'm getting errors every time I try...
I was able to set up a few formulas set up OK (and have saved it so I can make a template in the near future). For example, to get the first two cells of the...
Here's a different way to use a VBA method to use the SMF formulas. In this example, I will be retrieving history data for 3 different companies, although it...
I guess I could remove all calls directly to rch from my workbook and only do VBA calls, but I was wondering where would I put a test for internet connectivity...
Hmm. Couldn't you test for the connectivity BEFORE you opened the workbook? Or, you could automate the process within the workbook open event -- possibly...
You could just check the value of one of the functions you're saying is returning "Error" when you con't have internet connectivity. One that is unlikely to...
Thanks Randy. Wow, I wasn't even close. Everytime that I figure that you taught me how to fish, I quickly realize that you just gave me another fish, and I'm...
I was excited by your exchange and Randy's examples. Last night I created a template for PandL, Cash Flow and Balance Sheet (why should Randy have all the fun...
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.
