I am starting to realize the power of this addon and wanted to thank you Randy for your great work. Is there a way in Excel 2007 to suppress all refreshes...
... Yes. I know how to do it in excel 2003; I am confident it is similar in excel 2007: Go to Tools, the Options, then click on the Calculation tab, then ...
If it is taking a minute or two to recalculate EVERY time you make a change, you must be doing something in the functions to make them volatile. For example,...
I am using the RCHgetelement function and yes I guess it is only during column or row changes so that makes sense. I wasn't aware smfUpdateDownloadTable macro....
Really, the only supported macros are the smfUpdateDownloadTable and smfForceRecalculation macros, both of which I use frequently either via keyboard shortcut...
Thanks. Earnings.com doesn't appear to list the RY.TO common stock, just the US-listed version as well as all the Canadian preferred offerings. Certainly what...
Hi Randy (et al), Been a longtime user of SMF, it's one of the best pieces of freeware ever created. Thanks for your tireless work on it. I've recently been...
I'm gonna ramble a bit -- thinking out loud, so to speak -- because either you're not describing the situation correctly, I'm not understanding your ...
1. Thank you for your very useful program- it is great. I am a neophyte using this tool, but I find that YahooGetQuotes function with parameter "d" (for...
The add-in functions can only return what Yahoo reports. My assumption is that what the "d" is getting you is the 12-month trailing dividends -- which *IS*...
Ok, I'll try to get more specific about the error, cuz it just got weirder (but maybe narrower). 1.) The XML Library info I can't find anywhere, since there...
... Actually, I think we have the answer... 1.) The XML Library info I can't find anywhere, since there isn't a ... The Tools>Reference menu option is in the...
im wanting to pull all the annual financials from advfn into one big table. i know the advfn elements exist but i want all the data so grabbing the entire...
When using the function in VBA, you need to tell it the size of the array to return -- it defaults to a 10x10 array. For example, try something like: array1 =...
yes, randy you are correct it works as expected when run as macro. i don't understand why it won't work when called from my test function below. for example,...
Ahhh -- that's because the RCHGetHTMLTable() function uses the Application.Caller object to determine the size of the array to return. That is, it will use...
I'm trying to use the smfPricesBetween function to return the High Price from 2007-Present for a list of Tickers located from A2:A11. I have no problem if I'm...
Hi Randy et al Thanks for the excel sheets. I've used them to download quotes for a number of stocks i'm tracking and will update one as it's finalized. I set...
Just use the "refresh" parameter, as in: =RCHGetYahooQuotes(A2:A100,B1:M1,,NOW()) That makes the function volatile, so it will recalculate when you hit F9....
Hi Group, Does anyone have any idea how I would run a monte Carlo simulation the attached spread sheet were it would give me different market returns with the...
I created a Macro that deletes a column of unused cells on the far right side of the worksheet. As long as neither Internet Explorer or Outlook Express are...
... I didn't look your at speadsheet in datail, but one way to set this up that comes to mind would be to generate a large number of scenarios (say 1000) as...
that explains it. thanks! i have been struggling with this other problem for a couple days now. if i run this code without a watch it runs to completion...
randy thanks again. i should have specified the problem arises when i set the watch to "break when value changes" for each "test" variable. it works ok if...
It may have something to do with the fact that the watch variables are changing their nature in the middle of the process, going from a single variable item to...
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.
