Dear Randy, I am running rchgetwebdata and updating the values with smfforcerecalculation macro. But my excel workbook freezes while running...
9784
mdkumarz
Apr 1, 2010 9:22 am
Dear Randy, Also, When i run smfforcerecalculation macro through CTRL+SHIFT+r it does not freeze but when it's run through VBA using Application.Run...
9785
Pete
option2z
Apr 1, 2010 7:19 pm
Randy, I've been using your tools for several years. I watched with horror as the options symbology caused most of my software to require rethinking. I know...
9786
Randy Harmelink
rharmelink
Apr 1, 2010 7:51 pm
Check out the "Links" area of the group and you'll find several links to messages about retrieving options data from Yahoo, MSN, and OX. I'm close to giving up...
9787
Randy Harmelink
rharmelink
Apr 1, 2010 9:46 pm
Try just running the routine instead of using Application.Run. In any case, I'm not able to duplicate the results you're seeing....
9788
kitiany
Apr 1, 2010 11:22 pm
I learn something every day. I never knew you could run smfForceRecalculation() by typing CTRL+Shift+r How did you do that? Kumar, if you are calling up lots...
9789
Randy Harmelink
rharmelink
Apr 1, 2010 11:25 pm
You just assign a keyboard shortcut to the macro. http://office.microsoft.com/en-us/excel/HP052023061033.aspx I find it easier to assign it to a toolbar...
9790
kitiany
Apr 2, 2010 12:57 am
I knew about that in macros in worksheets, but did not know when you move those macro into add-ins, they retain those same features. Duh! The way I have been...
9791
Christopher Chang Sue
cchangsue
Apr 2, 2010 2:47 am
Hi Randy. Thanks for your help. What 2.0k beta version of the add-in should I install to get these formulas to work? Â I have tried the 02/15/2010 version,...
9792
Randy Harmelink
rharmelink
Apr 2, 2010 2:58 am
You should be using the current one, uploaded on March 23rd. The 02/15/2010 one is an archive of an earlier version. On Thu, Apr 1, 2010 at 7:47 PM,...
9793
Rajesh
maaress1
Apr 2, 2010 11:06 am
Hi Randy I can't find Raw Data for IBD Extract-Modified.xls in the "Requested Samples" folder. I am a member of IBD and I wanted to use this function to...
9794
Randy Harmelink
rharmelink
Apr 2, 2010 11:16 am
That file has been obsolete and hasn't been in the folder for some time. Instead, see: http://finance.groups.yahoo.com/group/smf_addin/message/8607 Note that...
9795
mdkumarz
Apr 2, 2010 1:53 pm
Dear Randy, The issue is solved. Smfforcerecalculation macro and smfgetwebdata functions are working just fine when i switched to a new OS+office on a new...
9796
joelfp2000
Apr 2, 2010 10:44 pm
Randy, I have noticed that element numbers 1513 and 1515 don't seem to always work. For instance Stock Charts show symbol PFF as a double top and #1513 shows...
9797
Randy Harmelink
rharmelink
Apr 2, 2010 10:57 pm
Those elements aren't externally defined. They are among the very small number of hard-coded extractions that the add-in does. The hard-coded extractions were...
9798
joelfp2000
Apr 3, 2010 12:11 am
Randy, Would you please check on symbols IWR, HYG, GLD, EFA, MBB, IAT. These are a few examples where elements #1513-1515 aren't always consistent. Joel...
9799
Adam Stockmeister
nyoe_schwab
Apr 3, 2010 12:28 am
Hey, Your add-in is awesome. I have a question about RCHGetCellTable command. What does the second value "RCHGetCellTable(u, v, w, x). Where u is the url for...
9800
Randy Harmelink
rharmelink
Apr 3, 2010 12:35 am
What I'm seeing is consistent with what I see on the web pages: Ticker 1513 1514 1515 PFF Bullish -- Double Top Breakout 82.50 Bullish IWR No P&F Pattern...
9801
Randy Harmelink
rharmelink
Apr 3, 2010 12:38 am
Check out the "Documentation" folder of the files area. You'll find the documentation for the function there. Many of the add-in functions are general in...
9802
latik26
Apr 3, 2010 3:43 am
Hello all I am trying toget stock data for nse stocks by using web string i excel import data. i get the data at 5 minutes interal,but its get updated in same...
9803
shabzog
Apr 3, 2010 9:23 pm
Hello, I am a recent user of this excellent add-in however I am getting errors with advfn. I need to use adfvn since it is the only provider that has quarterly...
9804
Randy Harmelink
rharmelink
Apr 3, 2010 9:38 pm
AdvFN changed their website in November, so I had to make changes to account for them. The 2.0k version of the add-in isn't officially released yet, but it is...
9805
kitiany
Apr 4, 2010 3:21 am
Randy, I was intrigued by elements 1513-1515 for StockChart P&F values after I read this thread. So I tried copying what you did and I got this instead. Ticker...
9806
Randy Harmelink
rharmelink
Apr 4, 2010 3:36 am
Those elements no longer work for version 2.0j of the add-in. StockCharts changed their website at the end of December, so I had to modify how the add-in...
9807
kitiany
Apr 4, 2010 4:05 am
This might also answer Joelfp200's problem. I vote that if you ever stop making updates to RCH_Stock_Market_Functions, there should be no further changes to...
9808
smortonm
Apr 4, 2010 3:06 pm
I just noticed that I can pull in option quotes from MSN Money by using the function: =RCHGetElementNumber(.QEL\10F19\5.0,"25") This yields the last price...
9809
Randy Harmelink
rharmelink
Apr 4, 2010 3:16 pm
Element numbers, no, but check out the "Links" area of the group. There are links to messages on extracting option quotes from Yahoo, MSN, and OX....
9810
jimcrum
Apr 4, 2010 4:50 pm
Hi Randy - I want to thank you very much for the wonderful work you are doing with this list. I have been re-energized in both my options trading and VBA...
9811
askyacros
Apr 4, 2010 5:59 pm
Hi, Does anyone know how to get the ValueEngine ratings (i.e. like the ones are gotten for Zacks)? Thank you....
