Randy, I just downloaded this add in about a week ago. It's great. I don't understand if I am doing something wrong here or what. I open excel and type into a...
That function is returning high prices for each day in the period, not the highest price during the period. That is an array function, which means it is...
Randy, Great, it works! Thanks for the help. Great explanation. Rocky ... wrote: Randy, ... not ... which ... them. ... will ... range, ... just ... return ......
Randy, is there a reference on this group or the xlt group which will help me decide whether I should look at smf or RCH to figure out how to do what I want? ...
The past is catching up with me. When I first starting writing these functions for my own use, I used the RCH prefix so that the function names would be unique...
Interesting. As far as I can tell, it's a Yahoo problem. When I first tried retrieving element #944, I got the 15.34 you mention. However, I used the...
yeah, I see now that the value sometimes changes after a refresh. thanks for looking into it. how do you use smfForceRecalculation? ... From: Randy Harmelink...
I have it assigned to a keyboard shortcut (Ctrl-Shift-R). You could assign it to a button, a cell, or just execute it via the macro dialog (alt-F8). ...
Thanks, Randy, that answered my question but I should also have asked where to find out how to obtain and use the smf functions. Are they macros? Your answer...
On Morningstar page, http://quicktake.morningstar.com/FundNet/Snapshot.aspx?Country=USA&pgid=hetopquote&Symbol=vtsmx or http://tinyurl.com/277ckc I have been...
Everything I mentioned is within the add-in, which is in the files area of the group. Once you install it, all of those functions and macros should be...
Ron Replace the word "Fund" with the following: "+/-" have a nice day ... From: Ron Spruell <hashky@...> To: smf_addin <smf_addin@yahoogroups.com> Sent:...
Interesting. Replacing "Fund" with "+/-" or "S&P 500 TR" works, but replacing "Fund" with "+/- S&P 500 TR" does not. Can either of you give me a clue why not? ...
Well, if you look at the source code for the page, there are a LOT of characters between "+/-" and "S&P 500", including a line feed character. There's not...
Are you saying that if I want to send a workbook with a Yahoo History to someone who does not have the add-in, all I have to do is use smfGetYahooHistory()...
Yes and no. If you added the smfGetYahooHistory() module to the VB project for the workbook (and turned on any required reference libraries), then it wouldn't...
... You might take a look at Cross-Over Office: http://www.codeweavers.com/products/cxmac/ ... and if you try it ... please let us know how it goes. <g>...
this will work... although if you have an Intel based mac you are better off just running windows (via bootcamp or parallel) and using office in its native...
I maintain a list of a few hundred stocks in my basket and recently, I wrote a simple VBA script to add the MSN stockscouter current rating for each of them. ...
I would suspect you ran into the 1000-page storage limit. When the SMF functions are used, the source of the web page you are retrieving data from is stored in...
I'm not sure how I can help when you haven't given me any specifics. Which website? What function parameters? Version of EXCEL? Computer operating system?...
For some reason I started getting this Dialog Box from Internet Explorer. I get this Dialog Box when downloading data from the Internet into Excel. I have...
Sounds like you may have just installed or upgraded some Firewall software that monitors any access to the Internet. I've never seen such a message myself, so...
