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...
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...
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...
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...
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...
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...
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,...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...