Check out the "Links" area of the group -- one of the links there is to a message that discusses getting custom screening results from FinViz. Otherwise, the...
I am having problems with RCHGetTableCell() when using Excel 2010. I think it is the As Variant statement in the function. Do you have an intention to remove...
Hello All, Can anyone clarify how to interpret the trend output when you use the "t7" parameter. ex. RCHGetYahooQuotes(THD,"t7") the output in the cell looks...
Randy - I downloaded the subject .xls. I can't seem to get cells J6 and and B9, B10..... to populate a valid value. wondering if you have any ideas re this?...
This is just a general thank you to all the great people out there working on this platform. Utilizing this plugin we can do just about anything. This save...
Hi, Which function do I need to use to get the following information from this website - http://www.lse.co.uk/SharePrice.asp?shareprice=BARC Vol Sold Vol...
I use rchgetyahooquotes($C$13:$C$56,F9). The default format is text. For example, I get "232M", "3.4B", etc. Is there a way to transform it to numbers? Many...
Randy your patience and always accessible amazes me. I am sure I speak for everyone. Thank you for all your efforts and time! Sent from my BlackBerry device on...
Randy - thank you.. the .xls works but it only seems to fully work with selected stock tickers.. for example, when i use IBM, INTC, T the sheet is fully...
Hi Randy.. 2 comments.. 1) Your latest post suggests placing the addin in c:\smf addins yet your original documentation states the add in should be in...
The location confusion is because I currently have the add-in in the "C:\SMF Add-in" folder (because of Vista on my new machine). However, most of the ...
i reloaded the latest SMF add-in date 08 02 2010. still it's inconsistent on my end.. using excel 2007 on XP. after the new SMF add-in refresh.. now MSFT and...
I don't know what to tell you. Every ticker I've tried here has worked fine. Do you have automatic calculation turned off? When you get an error in cell D3,...
Thanks Randy. Is working! Btw, I got this problem where the sheet keep recalculates each time I modify a cell or something. Is there any discussion that you...
Most of the add-in functions are non-volatile, meaning they shouldn't recalculate unless one of their parameters is changing. However, inserting or deleting...
Randy - your patience is appreciated. strange but it doesn't surprise me. i rebooted and all tickers i tried now works for future months.. seems to be back in...
Thank you for this contribution. May I ask what does this screen points at? I see a list of 30 stocks but cannot figure out the basis for the screening except...
You just need to click on the original link to find out: http://www.finviz.com/screener.ashx?v=111&f=sh_curvol_o1000,sh_price_u4,sh_relvol_o2 If you go there,...
Your recommendation works perfectly. To take this a bit further and to gain some general knowledge for a future situation such as this, I want to ask how I...
Wondering if there are any additional commands available or just refer to the excel templates...straight forward but curious if other options exist. Thanks...
As I said before, I don't see a way to do that. In order to extract the data, the add-in needs a "bookmarkable" URL. I don't see a way to create a URL to...
About the only documentation is this message: http://finance.groups.yahoo.com/group/smf_addin/message/2818 Basically, just three parameters: -- First is the...
