... 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...
684
JL
cue147pro
Nov 2, 2006 6:57 am
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...
685
sirfawkes
Nov 2, 2006 9:28 pm
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,...
686
Martin Topper
mtopper
Nov 2, 2006 10:32 pm
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...
687
Randy Harmelink
rharmelink
Nov 2, 2006 10:43 pm
... 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...
688
sirfawkes
Nov 2, 2006 11:43 pm
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...
689
sirfawkes
Nov 3, 2006 12:04 am
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...
690
Randy Harmelink
rharmelink
Nov 3, 2006 12:27 am
I updated two templates that use the RCHGetTableCell() function to retrieve financial statements data from MSN: ...
691
Randy Harmelink
rharmelink
Nov 3, 2006 12:35 am
... 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...
692
cykwan80
Nov 3, 2006 4:44 am
... 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...
693
Randy Harmelink
rharmelink
Nov 3, 2006 5:01 am
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...
694
Martin Topper
mtopper
Nov 3, 2006 2:24 pm
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...
695
cykwan80
Nov 3, 2006 2:32 pm
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...
696
Randy Harmelink
rharmelink
Nov 3, 2006 4:02 pm
It may be that the workbook hasn't finished recalculating, if it's a large workbook -- see Martin's response (thanks, Martin!)....
697
Randy Harmelink
rharmelink
Nov 3, 2006 4:58 pm
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...
700
SoundTrader
soundtrader2000
Nov 8, 2006 9:08 pm
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...
701
optiontrader3290
optiontrader...
Nov 8, 2006 9:50 pm
SoundTrader: Try this RCHGetHTMLTable("http://finance.yahoo.com/q/ud?s="&Sticker, "Research Firm", -1, "Research Firm", 1) Dale ... replaced by Sticker as a...
702
Randy Harmelink
rharmelink
Nov 8, 2006 11:30 pm
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...
703
donbraingnon
Nov 10, 2006 5:07 pm
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...
704
Randy Harmelink
rharmelink
Nov 10, 2006 6:31 pm
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...
705
donbraingnon
Nov 13, 2006 12:10 pm
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...
706
bpeven
Nov 13, 2006 10:03 pm
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...
707
Randy Harmelink
rharmelink
Nov 13, 2006 11:21 pm
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...
708
Randy Harmelink
rharmelink
Nov 14, 2006 6:57 am
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...
709
ajiusdc
Nov 14, 2006 7:08 am
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...
710
Randy Harmelink
rharmelink
Nov 14, 2006 7:52 am
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...
711
ajiusdc
Nov 14, 2006 3:47 pm
Well, yeah, thing is, I am not sure how to test for Internet connectivity in an Excel Macro......
712
Randy Harmelink
rharmelink
Nov 14, 2006 4:20 pm
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...
713
bpeven
Nov 14, 2006 6:06 pm
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...
714
Martin Topper
mtopper
Nov 14, 2006 7:38 pm
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...
