Hi, I'm not good at excel programming. Can anyone help me on this? Say I have the following link...
11640
Randy Harmelink
rharmelink
Oct 1, 2010 11:58 am
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...
11641
Jim Crum
jimcrum
Oct 1, 2010 12:28 pm
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...
11642
Randy Harmelink
rharmelink
Oct 1, 2010 2:20 pm
Hmmm. I only removed it from the array-entered functions, because I thought that was the only place it was a problem......
11643
D
dgsmith11
Oct 1, 2010 6:02 pm
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...
11644
BlueClaw
u1704141
Oct 1, 2010 8:41 pm
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?...
11645
Randy Harmelink
rharmelink
Oct 1, 2010 10:30 pm
Yahoo's recent "face lift" broke it. I just uploaded an updated version of the workbook....
11646
shadowemailclone
shadowemailc...
Oct 1, 2010 10:33 pm
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...
11647
makemerich76
gsterblue
Oct 1, 2010 11:31 pm
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...
11648
Randy Harmelink
rharmelink
Oct 1, 2010 11:37 pm
Check the answer to the last time you asked......
11649
eleen_lu
Oct 2, 2010 12:10 am
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...
11650
kblake@...
kim54blake
Oct 2, 2010 12:37 am
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...
11651
Randy Harmelink
rharmelink
Oct 2, 2010 1:37 am
You'd need to do it yourself. That's the way the data is provided by Yahoo....
11652
BlueClaw
u1704141
Oct 2, 2010 12:47 pm
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...
11653
PhillipG
philgiz_2000
Oct 2, 2010 1:56 pm
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...
11654
Randy Harmelink
rharmelink
Oct 2, 2010 2:07 pm
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 ...
11655
Randy Harmelink
rharmelink
Oct 2, 2010 2:12 pm
Hmmm. I just tried it with MSFT, XOM, and PFE. I got data from the future months for all of them....
11656
BlueClaw
u1704141
Oct 2, 2010 5:44 pm
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...
11657
Randy Harmelink
rharmelink
Oct 2, 2010 5:55 pm
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,...
11658
itchibang2001
Oct 2, 2010 6:45 pm
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...
11659
Randy Harmelink
rharmelink
Oct 2, 2010 6:56 pm
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...
11660
BlueClaw
u1704141
Oct 2, 2010 8:34 pm
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...
11661
rosen62
Oct 2, 2010 11:53 pm
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...
11662
Randy Harmelink
rharmelink
Oct 3, 2010 12:09 am
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,...
11663
Collin
moyac01
Oct 3, 2010 3:56 pm
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...
11664
D
dgsmith11
Oct 3, 2010 4:25 pm
Wondering if there are any additional commands available or just refer to the excel templates...straight forward but curious if other options exist. Thanks...
11665
Randy Harmelink
rharmelink
Oct 3, 2010 6:44 pm
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...
11666
Randy Harmelink
rharmelink
Oct 3, 2010 6:50 pm
About the only documentation is this message: http://finance.groups.yahoo.com/group/smf_addin/message/2818 Basically, just three parameters: -- First is the...
11667
D
dgsmith11
Oct 3, 2010 10:25 pm
thanks, this is perfect. appreciate it. take care...
11668
rosen62
Oct 4, 2010 4:09 am
Thank you. I see the "export" link now. I wasn't familiar with Finviz but just opened an account. What an awesome site....
