Hi Randy First of all happy new year. Hope it will be a blessed year for you. I hope you can help me with this. I have data in multiple workbooks in one...
Try creating an object when you do the open, so that you don't need to activate it and have something to refer back to easily. For example, something like: ...
Hi Randy Thanks for the reply. Would I do that before the "Do While" instruction and would this be the correct name? Set wb = Workbooks.Open(datafile) Would I...
First. You do not need dos to make a list of your files. The FindFiles macro will make a list. The other macro will find the files, without making a list...
The wb.Close would replace the "Activate" and "Close" statements you currently have... Alternatively, you could do it with an already programmed solution. For...
If your workbooks only have one sheet each then try using Sheet1.Copy After:=Workbooks("20090101.xls").ActiveSheet or if the first sheet as you open ...
Hi Don The sheets are the first sheet on all the files. The names are all different and the number of files are 19500. ... FindFiles macro will make a list. ...
Hi Don I tried the macro you suggested. Below is what it looks like at the moment but when I run it nothing happens. Also the files are all in the same main...
Try this executed from your destination sheet. Change the name to suit. Change the path. Change the file extension. 19500 files. I can't even fathom that. It...
Something like these should work: =AVERAGE(RCHGetYahooHistory("MMM",,,,,,,,"A",0,,,10,1)) =AVERAGE(RCHGetYahooHistory("MMM",,,,,,,,"A",0,,,20,1)) But each one...
Is there an easy way to insert new rows into a spreadsheet that uses array formulas? I get a message that I cannot edit an array formula. My first thought was...
Unfortunately, there are several ways to interpret the question -- if I'm interpreting your question correctly based on the context, then: You can easily...
Hi Randy, Happy New Year! I have a query regarding pulling in 'scans' http://stockcharts.com/def/servlet/SC.scan from StockCharts.com For example, if we take...
I just joined the group after searching the net for some software programs. I've been using a program thats able to calculate relative strength for a group of...
When skipping rows, the RCHGetTableCell() function is set up to stop searching when the "pEnd" parameter is found. The default value for that is "</body" -- an...
The majority of the add-in is user-defined functions, so if you're comfortable with EXCEL you should do fine. However, it's hard to tell from your description...
The functions I would need to be able to calculate are Alpha & Relative Strength as defined by RSI. Does the add-in also have the ability to create/get charts...
You can always get the historical data and calculate them yourself if you can't find a source for the values on the Internet. But if you can pick them up off...
Hi. I am new to this group and I'm glad I found it. I did a lot of searching for a FREE program that would pull Yahoo! dividend history and I couldn't find...
Actually, that's pretty easy to do with the add-in. An array-entered formula like this: =RCHGetYahooHistory("MMM",,,,,,,"v") ...returns something like this: ...
Don, Here it is. I deleted the command buttons from the Stocks tab since I haven't fully implemented a general version yet. The "ticks" range on the Stocks...
Hi Randy: I am using the SMF Add-in and track about 25 stocks. The last couple of days, Morningstar gives me "premium" in the columns for Fair Value and...
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.
